Statistical Analytical System
Day
Topics Covered What is SAS + uses of SAS SAS Data types + Libraries SAS Windows and Syntax Data Steps and Proc Steps Format & In format, Proc Print, Ptoc Contents Creating and Copying data set (s) Labeling + IF statement + Selecting variables and observation Sorting and finding frequency Appending and Merging + Overview Summarizing Data- Prco frequency, proc meand and proc summary ODS, Import - Export Functions Overview String Functions Conversion Functions Date Functions Mathematical Functions Importing Raw Data DSD DLM PAD Infile Missover :, @, @@ Operator Loops and Arrays Proc Report
Learning Outcomes
Day 1
Learn to create new variables and datasets Managing datasets through libraries Data Preparation
Day 2
Data Preparation Generating summary reports
Day 3
Cleaning Data using Functions
Day 4
Importing Raw Data
Day 5
Using loops and arrays to manage data effectively
Proc Format Proc SQL Joints + Sub - queries Summarizing Data Macros +Overview What are macro variables Sorting using macros Macros and Proc steps %let and %put Symput Case Study
Day 6
Learning to use SQL queries in SAS
Day 7
Wokring effectively with SAS and automation report generation
Day 8
Practical exposure
Excel Basics
Day
Topics Covered
Learning Outcomes
Day 1
Excel Options Basic shortcuts and tips Home Tab Data Tab Logical Functions Text Functions Count Functions Conditional summation Functions Lookup and Array Functions Dashboard Starts Pivot Tables Dynamic Charts Form Controls
Working quickly on excel using shortcuts
Day 2
Basics of cleaning and managing data and creating summarised reports
Day 3
Advance Data Cleaning and calculations to make a dynamic template
Day 4
Creating dynamic dashboard reports and basic dashbaords
Advance Excel
Day
Topics Covered Introduction to Programming Language Introduction to VBA and Macros Introduction to Objects in Excel Writing a Macro
Learning Outcomes
Day 1
Learning basics of Programming Language
Day 2
Data Types Recording and editing a Macro Learning to write Logic in programming language and Loops- IF, FOR, While, Do automating work using macros Until Defining User defined Functions Using Pre defined Functions to Customization as per requirments the user defined functions Pre defined events Customized events Working with events Userforms and ActiveX Controls Case Study
Day 3
Day 4
Automated running of macros on different pre defined actions
Day 5
Creating a user friendly application for data Entry Advanced Dashboard
Day 6
Advance Excel
Day
Topics Covered
Learning Outcomes
Day 1
Introduction to Analytics Industry Scales of Data Maesurement Descriptive Statistics
Overview of Analytics industry
Day 2
Probability Distribution Sampling - Central Limit Theorem Introduction to Hypothesis Testing Parametric Test One sample T - test Two Sample T test Anova Non- parametric Test Goodness of Fit test Test of Association/ Independence Correlation Karl Pearson's Correlation Spearman Correlation Introduction to Regression
Data Visualization
Day 3
Testing Business Assumptions
Day 4
Testing Business Assumptions
Day 5
Identifying Busines Relations
Day 6
OLS Regression
Predictive M odeling, build multiple regression business models Predictive Modeling, build propensity models Model Evaluation and Presentation Compression of data using KMeans & Hierachical methods Best practices followed in the industry
Day 7 Day 8
Logistic Regression - Part 1 Logistic Regression - Part 1 Cluster Analysis Factor Analysis Doubts clearing session and revision Best practices followed in the industry
Day 9
Day 10