ATI All Courses

1. Analytics Training Institute

Analytics Training Institute
#406, 31
st
Cross, 8
th
B Main,
4
th
Block, Jayanagar, Bangalore 560011
Phone: [phone] 26555
Email- [email protected]
www.analyticstraining.in



Course Details

Statistical Analysis Software (SAS+):

Duration: 24 Hours + Practice session
Fee Structure: Rs. 8850/‐ (inc. of service tax of 10.3%)

 Introduction to Analytics
 Introduction to SAS, GUI
 Types of Libraries, Creating
 Variable Attributes
o Name, Type, Format, Informat, Label
 Introduction to Data steps and Proc steps
 DATA Understanding
o Reading, Importing, Exporting and Copying Data
 Conditional Statements (Where, If, If then Else)
 Appending, Merging and Sorting Datasets
 Proc steps like ‐ Proc Means, Proc Freq, Proc Sort
 Output Delivery System (ODS)
 SAS Functions and Options
 List Input, Delimiters, Reading missing Values, and non standard values
 Do loops
 Generating Data
o Execution
o Output Statements
o Nesting Do loops
o Do While and Do Until Statement
 Arrays:
o Dimensions
o Array elements and Range
o Proc report
 Introduction to Data base, Relational Data base concepts
 Proc SQL, Data integrity Constraints, Creating table and Inserting Values
 Proc SQL codes to
o Retrieve & Summarize data
o Group, Sort & Filter
o Using Joins
o Indexes
 Macros:
o Defining and calling a macro
o Macro Parameters and Variables
o Global and Local Variables

2. Analytics Training Institute

Analytics Training Institute
#406, 31
st
Cross, 8
th
B Main,
4
th
Block, Jayanagar, Bangalore 560011
Phone: [phone] 26555
Email- [email protected]
www.analyticstraining.in




Excel Programming (Excel +):

Duration: 24 Hours + Practice session
Fee Structure: Rs. 5,530/‐ (inc. of service tax of 10.3%)

 Navigating Through Excel
o Formatting, sorting, filter, subtotals, grouping and data validation.
 Basic Functions
o Text, Stat & Math Formulae and Logical
 Advanced Functions
o Reference ‐ Lookups, Match and Index
o Using Reference, Logical and Formulae functions in combination
 Pivot Tables and Charts
 Introduction to VBA
o Recording and running macros
o Basic concepts of VB
 Data Types, Variables, Procedures & Operators
 Range Selection
 Control Statements
o If… Then
o For… Next
o Do Loops
 Working with Controls
 Command Button, Text Box and Label, Combo Box, User Forms, Scroll Bar and Check Box
 User‐Defined Functions
 Error Handling and Debugging

3. Analytics Training Institute

Analytics Training Institute
#406, 31
st
Cross, 8
th
B Main,
4
th
Block, Jayanagar, Bangalore 560011
Phone: [phone] 26555
Email- [email protected]
www.analyticstraining.in




Advanced Analytics (Analytics+):

Prerequisite: SAS Course
Duration: 48Hours + Practice session
Fee Structure: Rs. 13,500/‐ (inc. of service tax of 10.3%)

 Introduction to statistics/ analytics
o Need for analytics
o Analytics use in different industries
o Challenges in adoption of analytics
o Overview of Course Contents
 Data understanding
o Data types (Nominal, Ordinal, Interval and Ratio)
 Descriptive statistics
o Tabular & Graphical Method
o Summary statistics
 Introduction to some statistical terminologies and inferences
o Population, Sample and Random variables
o Point and Interval Estimations
o Probability
o Discrete/Continuous Probability Distributions
 Hypothesis Testing
o Importance of formulating and validating the hypothesis
o Formulation of hypothesis (Null and alternate)
o Testing association and differences
o Statistical significance and test statistic
o Level of significance
 Z‐Test, T‐Test, Chi‐Square test, ANOVA
 Parametric & Non‐Parametric test
 Correlation & Regression
 Linear Regression
o Case Study on Multiple Regression
 Logistic Regression
o Case Study on Logistic Regression
 Cluster Analysis
o Case Study on Cluster Analysis
 Factor Analysis
o Case Study on Factor Analysis

4. Analytics Training Institute

Analytics Training Institute
#406, 31
st
Cross, 8
th
B Main,
4
th
Block, Jayanagar, Bangalore 560011
Phone: [phone] 26555
Email- [email protected]
www.analyticstraining.in




Excel for Financial Modeling (EFM+):

Duration: 24 Hours + Practice Sessions
Fees Structure: Rs. 8000/- (Inclusive of Service Tax of 10.3%)

Module 1

 Excel Basics & Modeling Techniques
 Financial Modeling: Introduction & Concepts
 Simple Interest & Compound Interest model using combo box, Vlook up function & scatter
diagram
 Various Financial Functions in Excel: DB, DDB, VDB, ISPMT, NPER, SLN, SYD, RATE,
etc.
 Time Value of Money & Annuity calculation in Excel
 Loan Repayment Model for Fixed & Floating interest rate using Excel
 Cash Flow Techniques in Investment Project Appraisal: IRR, PBP, NPV

Module 2

 Introduction to Financial Markets & Key Economic Concepts
 Introduction to securities and markets
 Equity, futures & options, Dividend Yield
 Portfolio Management using Excel
 Portfolio Rebalancing techniques using Excel
 Stock Market Functioning

Module 3

 Forecasting Balance Sheet, Income Statement, Cash Flow (using Excel)
 Company Valuation: DCF Modeling (using Excel)
 Relative Valuation & Peer Comparison Techniques
 Financial Statement Analysis (in Excel)
 Sector Overview & Revenue Metrics Identification
 Fixed Income Instruments
 Bond Valuation/YTM/YTC
 Introduction to ABS, MBS, RMBS, CLO, FSS, WBS

5. Analytics Training Institute

Analytics Training Institute
#406, 31
st
Cross, 8
th
B Main,
4
th
Block, Jayanagar, Bangalore 560011
Phone: [phone] 26555
Email- [email protected]
www.analyticstraining.in




Package Courses:
Package 1: SAS + Advanced Analytics: Rs. 16560/- (inc. of service tax of 10.3%)
Package 2: SAS + Advanced Analytics + Excel Programming: Rs. 20000/- (inc. of service tax of
10.3%)
Package 3: Excel Programming + Excel for Financial Modeling: Rs. 12000/-(inc. of service tax of
10.3%)
Package 4: Excel Programming + Advanced Analytics: Rs. 15000/- (inc. of service tax of 10.3%)
Package 5: SAS + Excel Programming: Rs. 12000/- (inc. of service tax of 10.3%)
Package 6: SAS + Advanced Analytics + Excel Programming + Excel for Financial Modeling:
Rs. 26560/- (inc. of service tax of 10.3%)

6. Analytics Training Institute

Analytics Training Institute
#406, 31
st
Cross, 8
th
B Main,
4
th
Block, Jayanagar, Bangalore 560011
Phone: [phone] 26555
Email- [email protected]
www.analyticstraining.in





Strategic Marketing Analytics:

Duration: 40 Hours + Practice Sessions
Fees Structure: Rs. 15,000/- (Inclusive of Service Tax of 10.3%)

Module 1: Marketing Analytics and Relationship with CRM
 Brief description about marketing and its various elements.
 Description about analytics
 Role of Analytics in Marketing
 How analytics can be beneficial for the Marketing of an organization (Business Examples
and case study)
 Market Basket Analysis

Module 2: Segmentation and Targeting
 Understanding Segmentation and its importance in creating marketing strategies
 Objectives and subjective segmentation
 Decision tress, CHAID/ CART Analysis, cluster & factor analysis (Business Examples and
Case studies)
 Cross-sell, up-sell and CHURN model

Module 3: Campaign Effectiveness
 Understanding Marketing Campaigns, and their effectiveness
 Different kind of campaign and their analysis
 Market Mix Modeling
 RoMI, Test and Learn, Creating Propensity Model to understand Campaign Effectiveness
(Business Example and Case Study)

Module 4: Branding & Customer Perception
 Introduction to Brand Management, Brand Measurement, Brand Positioning, Brand Metrics,
Brand Asset Valuation, Brand Vitality Assessment, Multi-dimensional Scaling (Business
Example and Case Study)
 Different kind of methodologies of survey in marketing, data collection, different types of
scales, data analyzing

Case Studies

7. Analytics Training Institute

Analytics Training Institute
#406, 31
st
Cross, 8
th
B Main,
4
th
Block, Jayanagar, Bangalore 560011
Phone: [phone] 26555
Email- [email protected]
www.analyticstraining.in



All topics/methodologies will be covered using case studies in various business scenarios. The
training will be conducted using SPSS/Statistica and R software.
Equity Research and Financial Modeling

Duration: 40 Hours
Fee Structure:
Online-INR 10,500/- (inclusive of Service Tax of 10.3%)
Classroom- INR 17,500/- (inclusive of Service Tax of 10.3%)

I) Selecting a Company
II) Fundamental Analysis
 Macroeconomic Factors
 Industry/Sector Analysis
 Company Business and Strategy Analysis – SWOT, Porters, BCG Matrix
 Market and Competitive Position Analysis Position
III) Financial Analysis
 Income Statement
 Balance Sheet
 Ratio Analysis
IV) Financial Modeling
 Getting Started- Data requirements and best practices for building a robust financial model
 Step by Step Building of a financial model for a company
 Revenue forecasting techniques
 Cost and margin analysis
 Interconnection between all three financial statements (Income Statement, Balance Sheet
and Cash Flows)
 Forecasting cash flows (depreciation, Capex and free cash flows)
V) Valuation Methodologies
 Time Value of money
 Key Valuation Metrics and Ratios
 Commonly Used Valuation Techniques
 Absolute Valuation Techniques

8. Analytics Training Institute

Analytics Training Institute
#406, 31
st
Cross, 8
th
B Main,
4
th
Block, Jayanagar, Bangalore 560011
Phone: [phone] 26555
Email- [email protected]
www.analyticstraining.in



 Relative Valuation Techniques


Coming Soon…
Excel Analytics:

Prerequisite: Excel Programming
Duration: 24 Hours + Practice session
Fee Structure: Rs. 10,000/‐ (inc. of service tax of 10.3%)

 Introduction to statistics/ analytics
o Need for analytics
o Analytics use in different industries
o Challenges in adoption of analytics
 Data understanding
o Data types (Nominal, Ordinal, Interval and Ratio)
 Descriptive statistics
o Tabular & Graphical Method
o Summary statistics
 Introduction to some statistical terminologies and inferences
o Population, Sample and Random variables
o Point and Interval Estimations
o Probability
o Discrete/Continuous Probability Distributions
 Hypothesis Testing
o Importance of formulating and validating the hypothesis
o Formulation of hypothesis (Null and alternate)
o Testing association and differences
o Statistical significance and test statistic
o Level of significance
 Z‐Test, T‐Test, Chi‐Square test, ANOVA
 Parametric & Non‐Parametric test
 Correlation and Regression

Post Advanced Analytics:

Prerequisite: Advanced Analytics
Duration: 24 Hours + Practice session
Fee Structure: Rs. 10,000/‐(inc. of service tax of 10.3%)

 Time Series Analysis: o ARIMA model, seasonality and trend analysis.
 Market Basket Analysis
o Association rules
 Market Mix Modeling

9. Analytics Training Institute

Analytics Training Institute
#406, 31
st
Cross, 8
th
B Main,
4
th
Block, Jayanagar, Bangalore 560011
Phone: [phone] 26555
Email- [email protected]
www.analyticstraining.in



 Neural Networks
 Application of Genetic algorithms in Analytics


MS Access:

Duration: 16 Hours + Practice session
Fee Structure: Rs. 5,530/‐ (inc. of service tax of 10.3%)

 Navigating Access and exploring ribbons and tool bar
 Designing a database
o Fields and primary key
 Relationships
o One to One, One to Many, Many to Many
 Building a database
o Database templates, creating and modifying table and building relational tables
 Work With Forms ‐ Creating and designing form and modifying properties
 Sort, Retrieve And Analyze Data
o Filter, queries to retrieve data, complex queries to modify data
 Work With Reports
 Creating and modifying reports
 Integrate Access With Other Applications
 Importing , creating external links and exporting data
 Manage An Access Database
 Database security and database splitter

SQL:

Duration: 16 Hours + Practice session
Fee Structure: Rs. 5,530/‐ (inc. of service tax of 10.3%)

 Introduction ‐ Database Fundamentals and Normalization
 SQL Overview and Features
 Checking Tables for Consistency
 Using SHOW and DESCRIBE
 Understanding SQL Storage
 Data Definition Language
 SQL Data Types
 The SELECT Statement
 SQL Expressions and Functions
 Updating Tables Using SQL and Joins
 Importing and Exporting Data

10. Analytics Training Institute

Analytics Training Institute
#406, 31
st
Cross, 8
th
B Main,
4
th
Block, Jayanagar, Bangalore 560011
Phone: [phone] 26555
Email- [email protected]
www.analyticstraining.in




R Statistical Software (R+):

Duration: 24 Hours + Practice session
Fee Structure: Rs. 10,000/‐ (inc. of service tax of 10.3%)

 Introduction to Statistics and R
o Data types (Nominal, Ordinal, Interval and Ratio)
 Descriptive statistics
o Tabular & Graphical Method
o Summary statistics
 Population models and Simulation
o Population, Sample and Random variables
o Discrete/Continuous Probability Distribution (definitions)
 Theoretical Distributions
o Binomial Distribution, Poisson Distribution, Normal Distribution
 Correlation and Regression
 Tests of Significance
o Importance of formulating and validating the hypothesis
o Formulation of hypothesis (Null and alternate)
o Binomial test
 Confidence intervals and Microarray
 Analysis of Variance
 Regression
o Multiple regressions
o Logistic Regression
 Clustering and Discrimination
 Case studies are given at the end of each class