SBS also provides in-house industry relevant courses on Data Analytics, Advanced Analytic, Web Analytics and Research Analytic that have attracted professionals from leading corporate houses and students from elite colleges ,Universities and B-Schools.
Course Details are:
1/ SAS Analytics (30 Hours)
Introduction to SAS and Data Processing, SAS Data steps
Types of variables, Variable Formats
SAS procedures including Proc SQL
Statistical Modeling Concepts and Practical Assignments
2/ Data Reporting and Presentation using Advanced Excel ( 30 Hours)
Introduction to MS Excel, Basic Functions and Usage
Sorting, Filtering, Advance Filtering, Subtotal
Pivot Tables and Charts, Inserting Formula and Functions.
Data Entry Forms
What if Functions – Data Tables, Scenario Management, Goal Seeking
Charts Graphs – Which one to use under which situation
Vlookup, Hlookup, Match, Index
Style and Number Formatting, Conditional Formatting
Worksheet and Workbook Reference, Hyperlink
Smart Printing Options
Logical Functions – IF
Linear Programming using Solver.
Macros and Visual Basics
3/ Database Concepts using SQL and MS- ACCESS ( 18 Hours)
Refresher on the Fundamentals of Relational Database Management System.
Designing the Relational Database Management Models.
Exporting/Importing databases using MS-ACCESS 2007
Introduction to SQL and types of SQL Statements.
Steps to write SQL Queries.
Creating SQL Queries like Joining, Ordering, Grouping etc.
Solving Cases using SQL Statements
Assignments and Projects using SQL
4/ Workshop on Resume Development
Workshop on Personal Interview