Drop us a line!

DS Program-1

MS Excel, SAS, Tableau 3 Months (Weekend Batches)
35,000(Inclusive of Taxes)

Modules Included

MS Excel 20 HRS
BASE & Advanced SAS 30 HRS
Tableau 10 HRS

Data Analytics with Excel

Relevance in industry & need of the hour
Types of analytics – Marketing, Risk, Operations, etc
Business & Technology drivers for analytics
Future of analytics & critical requirement
Types of problems and business objectives in various industries
Different phases of Analytics Project
Introduction to Excel
Working with Formulas and functions
Formating & Conditional Formating
Filtering, sorting, paste special etc
Functions (Logical & Text, Mathematical, Statistical etc)
Data Manipulation & Data Aggregation
Data Analysis using functions
Analyzing Data using Pivots
Descriptive Statistics
Creating Charts & Graphics
Data analytics tool (What -if analysis, Goal seek, Data Table, Solver)
Protecting Workbooks, worksheets and formulas
Working with VBE (Visual Basic Editor)
Introduction to Excel Object Model
Understanding of Sub and Function Procedures
Key Component of Programming Language
Understanding of If, Select Case, With End With Statements
Looping with VBA
User Defined Function
Some Commonly Used Macro Examples
Error Handling
Object and Memory Management in VBA
User Form Controls
ActiveX Controls
Communicating with Database MS Access through ADO - Exporting /Importing Data

BASE & Advanced SAS

Introduction to SAS, GUI
Concepts of Libraries, PDV, data execution etc
Building blocks of SAS (Data & Proc Steps - Statements & options)
Debugging SAS Codes
Importing different types of data & connecting to data bases
Data Understanding(Meta data, variable attributes(format, informat, length, label etc))
SAS Procedures for data import /export / understanding(Proc import/Proc contents/Proc print/Proc means/Proc feq)
Data Manipulation steps(Sorting, filtering, duplicates, merging, appending, subsetting, derived variables, sampling, Data type converstions, renaming, formatting, etc)
Data manipulation tools (Operators, Functions, Procedures, control structures, Loops, arrays etc)
SAS Functions (Text, numeric, date, utility functions)
SAS Procedures for data manipulation (Proc sort, proc format etc)
SAS Options (System Level, procedure level)
Introduction exploratory data analysis
Descriptive statistics, Frequency Tables and summarization
Univariate Analysis (Distribution of data & Graphical Analysis)
Bivariate Analysis(Cross Tabs, Distributions & Relationships, Graphical Analysis)
SAS Procedures for Data Analysis(proc freq/Proc means/proc summary/proc tabulate/Proc univariate etc)
SAS Procedures for Graphical Analysis (Proc Sgplot, proc gplot etc)
Introduction to Reporting
SAS Reporting Procedures (Proc print, Proc Report, Proc Tabulate etc)
Exporting data sets into different formats (Using proc export)
Concept of ODS (output delivery system)
ODS System - Exporting output into different formats
Introduction to Advanced SAS - Proc SQL & Macros
Understanding select statement (From, where, group by, having, order by etc)
Proc SQL - Data creation/extraction
Proc SQL - Data Manipulation steps
Proc SQL - Summarizing Data
Proc SQL - Concept of sub queries, indexes etc
SAS Macros - Creating/defining macro variables
SAS Macros - Defining/calling macros
SAS Macros- Concept of local/global variables
Introduction of Statistics
Descriptive and inferential statistics
Explanatory Versus Predictive Modeling
Population and samples
Uses of variable independent and dependent
Types of variables quantitative and categorical
Descriptive Statistics Introduction
Descriptive Statistics Introduction
Measures of shape skewness
Box Plots
Univariante Procedure
Statistical graphics procedures
The SGPLOT Procedure
ODS Graphics Output
Using SAS to picture your data
Confidence Intervals for the Mean Introduction
Distribution of sample means
Normality and the central limit theorem
Calculation of 95% confidence interval
Hypothesis Testing introduction
Decision Making Process
Steps in Hypothesis Testing
Types of error and power
The p value effect size and sample size
Statistical Hypothesis Test
the t statistic t distribution and two sided t test
Using proc univariate to generate a t statistic


Overview of Business Intelligence
Introduction to Tableau Desktop
Use and benefits of Tableau Desktop
Tableau's Offerings
Data Source Page
Worksheet Interface
Creating a Basic View
Data Types
Data Roles
Visual Cues for Fields
Data Preparation
Data Source optimization
Cross Database Joins
Data Blending
Joining vs. Blending
Creating Data Extracts
Writing Custom SQL
Filtering Data
Sorting Data
Creating Combined Fields
Creating Groups and Defining Aliases
Working with Sets and Combined Sets
Drilling and Hierarchy
Adding Grand Totals and Subtotals
Changing Aggregation Functions
Creating Bins
Cross Data Source Filter
Effectively use Titles, Captions, and Tooltips
Format Results with the Edit Axes
Formatting your View
Formatting results with Labels and Annotations
Enabling Legends per Measure
Use Strings, Date, Logical, and Arithmetic Calculations
Create Table Calculations
Discover Ad-hoc Analytics
Perform LOD Calculations
Creating Basic Charts such as Heat Map, Tree Map, Bullet Chart, and so on
Creating Advanced Chart as Waterfall, Pareto, Gantt, Market Basket
Dashboard Interface
Build Interactive Dashboards
Explore Dashboard Actions
Best Practices for Creating Effective Dashboards
Story Interface
Creating Stories
Share Your Work

What You Get?

Learn from our comprehensive collection of project case-studies, hand-picked by industry experts, to give you an in-depth understanding of how data science moves industries like telecom, transportation, e-commerce & more.
  1. Global Sales Store Data Analytics - WallMart
  2. Service Calls & Engineers Utilization Data Analytics – HCL Services
  3. Clinical Data Analytics of Cancer Patients Diagnosis & Medication – Global Health Care
  4. Data Analytics of Training & Development Program of Defense Forces – Indian Navy ...many more...
You will be having the opportunity of 10-15 Hrs e-learning exercises along with instructor-led-training which enable candidates to get the maximum out of the subjects and empowering them to build logics to hand any new requirement.
This program has been designed in collaboration with some of the most influential analytics leader and top academician in data science.

Final Outcome

Thanks to the digital revolution that is sweeping the world and India in particular, data scientists are now the most sought-after professionals by big corporations as well as startups. And companies across industries are rewarding good data analysts and scientists with desirable career growth and salaries.