SBS Knowledge Services

SBS also provides in-house industry relevant courses on Data Analytics, Advanced Analytics, Web Analytics & Research Analytics that have attracted professionals from leading corporate houses and students from elite colleges ,Universities and B-Schools.

Course Details are:

1/ SAS Analytics ( Hrs)
Introduction to SAS & Data Processing, SAS Data steps
SAS Functions
Types of variables, Variable Formats
SAS procedures including Proc SQL
SAS Macros
Statistical Modeling Concepts and Practical Assignments

2/ Data Reporting and Presentation using Advanced Excel ( Hrs)
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 & Number Formatting, Conditional Formatting
Worksheet & Workbook Reference, Hyperlink
Smart Printing Options
Logical Functions IF
Data Validation
Linear Programming using Solver.
Macros and Visual Basics
Text Function
Individual Projects

3/ Database Concepts using SQL and MS- ACCESS ( Hrs)
Refresher on the Fundamentals of Relational Database Management System.
Designing the Relational Database Management Models.
Exporting/Importing databases using MS-ACCESS
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 Statements

4/Workshop on Resume Development
Workshop on Personal Interview