An Overview of Analytics 360 Plus or A360 +

 

DURATION

224 HOURS

 

PRICE 

INR 39,492/- 

(PLUS 18% GST)

 

WHAT IT COVERS

  • ADVANCED EXCEL
  • SQL
  • R
  • TABLEAU
  • PYTHON
  • BASE ANALYTICS
  • ADVANCED ANALYTICS (INCLUDES ARTIFICIAL INTELLIGENCE USING MACHINE LEARNING)
  • DIGITAL ANALYTICS
 

CLASS DAYS

WEEKDAYS:

TUE TO FRIDAY

WEEKENDS:

SATURDAY/SUNDAY

 
 

ADDITIONAL FEATURES

LIFETIME ACCESS

COMPLIMENTARY ONLINE VIDEOS ON EXCEL, SQL, R, BASE ANALYTICS

COMPLIMENTARY GUEST LECTURES ON ANALYTICS

ELIGIBILITY TO APPLY TO RAP - INTERNSHIP PROGRAM IN ANALYTICS

 
 

Course Outline

ADVANCED EXCEL

DURATION: 24 HOURS

                                                  
Excel is by far the world's most popular spreadsheet, used pretty much everywhere you look in the business world, especially in areas where people are adding up numbers a lot, like marketing, business development, sales, finance, etc. Thus, Excel in its universality is now a must have skill in every business environment.

+ TOPIC 1: INTRODUCTION TO EXCEL


  • OVERVIEW
  • HOME TAB
  • CONDITIONAL FORMAT
  • PASTE SPECIAL
  • GO TO SPECIAL

+ TOPIC 2: DATA TAB


  • OVERVIEW
  • SIMPLE SORT AND FILTER
  • ADVANCED SORT AND FILTER
  • WHAT IF ANALYSIS
  • DATA VALIDATION

+ TOPIC 3: FUNCTIONS


  • TEXT FUNCTIONS LIKE CONCATENATE, TRIM, SEARCH AND SUBSTITUTE
  • LOGICAL FUNCTIONS LIKE IF, AND, OR
  • LOOKUP FUNCTIONS LIKE VLOOKUP, HLOOKUP, REFERENCE, INDEX AND MATCH
  • ADVANCED FUNCTIONS LIKE DCOUNT, DSUM

+ TOPIC 4: DYNAMIC CHARTS AND PIVOT TABLES


  • OVERVIEW
  • CREATING CHARTS AND USING DYNAMIC CHARTS
  • CONNECTING TO FORM CONTROLS
  • SIMPLE PIVOT TABLES AND FUNCTIONS IN PIVOT TABLES
  • INTEGRATING CHARTS WITH TABLES

+ TOPIC 5: VBA/MACROS


  • WRITING SUB ROUTINES
  • LOOPS
  • CONDITIONAL STATEMENTS
  • PRIVATE SUB ROUTINES
  • UDFS

+ TOPIC 6: USERFORMS


  • CREATING USERFORMS
  • USING SIMPLE VALIDATIONS
 

SQL

DURATION: 16 HOURS

Structured Query language (SQL) is a computer language used to access a database. It is used for updating data on a database.

 

+ TOPIC 1: INTRODUCTION TO SQL


  • WHAT IS SQL
  • WHY AND WHERE IS SQL USED
  • WHY SHOULD ONE LEARN SQL
  • DATABASE FUNDAMENTALS
  • WHAT IS A DATABASE
  • WHAT ARE THE DIFFERENT FEATURES IN A DATABASE (EG PRIMARY KEY, FOREIGN KEY AND CANDIDATE KEY)

+ TOPIC 2: BASIC RELATIONAL DATABASE MANAGEMENT CONCEPTS


  • HOW TO ACCESS ONE TABLE FROM ANOTHER
  • THE DIFFERENT RELATIONSHIPS POSSIBLE BETWEEN TWO TABLES
  • HOW TO USE SQL COMMANDS IN ACCESS
  • NORMALIZATION
  • 1NF, 2NF..BCN
  • MODEL A NORMALIZED DATABASE

+ TOPIC 3: INTRODUCTION TO THE CONCEPT OF TABLES


  • OVERVIEW
  • HOW TO CREATE A TABLE
  • HOW TO IMPORT DATA FROM EXCEL, TEXT FILES
  • HOW TO CHECK TABLES FOR CONSISTENCY
  • FUNCTIONS
  • THE SELECT FUNCTION - HOW, WHERE, WHY
  • THE INSERT, UPDATE, DELETE FUNCTION - HOW, WHERE, WHY

+ TOPIC 4: DATABASE FUNCTIONS


  • "GROUP BY"OPTION - HOW, WHERE, WHY
  • "COUNT" OPTION - HOW, WHERE, WHY
  • "WHERE" OPTION - HOW, WHERE, WHY
  • MATHEMATICAL FUNCTIONS - AVG, SUM, MIN, MAX, FIRST, LAST
  • SCALAR FUNCTIONS - UCASE, LCASE, MID, LEN, NOW, ROUND, FORMAT
  • PRIMARY KEY COMSTRAINT
  • IN CLASS PROJECT AROUND FUNCTIONS
 

R

DURATION: 16 HOURS

The R tool is an open source framework, which grew as a result of a strong push by Google. Today, R is poised to overtake SAS as the most widely used tool in statistical analyses.With over 20,000 packages currently available, it has near limitless potential for business application.

 

 

+ TOPIC 1: BASIC R PROGRAMMING


  • R ENVIRONMENT AND WINDOWS SYSTEM
  • R OBKECTS, DATA PERMANENCY AND REMOVING OBJECTS
  • R HELP AND SEARCH WITH FUNCTIONS
  • R COMMANDS AND CASE SENSITIVITY
  • DATA IMPORT AND EXPORT
  • PACKAGES
  • R INSTALLATION
  • SIMPLE MANIPULATIONS: NUMBERS AND VECTORS
  • WRITING YOUR OWN FUNCTIONS

+ TOPIC 2: ADVANCED APPLICATIONS OF R


  • DATA MANIPULATION: MERGING, SORTING, FILTERING, DE-DUPING
  • USER DEFINED FUNCTIONS
  • VISUALIZATIONS: HISTOGRAM, BAR PLOT, BOX PLOT, MOSAICS PLOT, GEOGRAPHICS PLOT
 

TABLEAU

DURATION: 16 HOURS

Tableau helps people visualize and gather insights from their data. By presenting data visually one can discover surprising patterns and observations that were not apparent by looking at data in the form of numbers alone. Tableau also allows you to create striking and powerful presentations to help you and your management in decision making.

 

+ TOPIC 1: BASICS OF DATA VISUALIZATION


  • WHY DATA VISUALIZATION?
  • DIFFERENT TYPES OF VISUALIZATIONS
  • FEATURES OF A GOOD VISUALIZATION

+ TOPIC 2: GETTING STARTED WITH TABLEAU


  • TABLEAU OVERVIEW
  • INSTALLATION PROCESS
  • TABLEAU INTERFACE
  • WHAT IS TABLEAU DESKTOP, WORKBOOK, WORKSHEETS AND THEIR USAGE
  • TABLEAU OBJECTS

+ TOPIC 3: CONNECTING TO DATA


  • CONNECTING TO EXCEL, CSV AND TEXT FILES
  • CONNECTING TO DATABASES
  • EDITING DATA CONNECTIONS AND SOURCE
  • DATA BLENDING

+ TOPIC 4: FILTERS/PARAMETERS


  • WHAT ARE FILTERS
  • WAYS TO FILTER
  • USING FILTERS
  • WHAT IS A PARAMETER
  • USING PARAMETERS
  • PARAMETERS WITH FILTERS
  • SORTING, GROUPING AND DRILL DOWNS

+ TOPIC 5: BASIC VIEWS IN TABLEAU


  • TABLES AND TEXT TABLES
  • TYPES OF CHARTS - BAR, HISTOGRAM, LINE, PIE
  • SCATTER PLOTS
  • CIRCLE PLOTS

+ TOPIC 6: ADVANCED VIEWS IN TABLEAU


  • MAPS BASED VISUALIZATON
  • GEOCODING
  • ADVANCED CHARTING - AREA CHARTS, DUAL CHARTS, GANTT CHARTS, WATERFALL CHARTS
  • TREE MAPS
  • MOTION CHARTS
  • COMBINATION CHARTS

+ TOPIC 7: CUSTOMIZING VIEWS IN TABLEAU


  • HOW TO CUSTOMIZE VISUALIZATIONS USING FILTERS, PAGES, ROWS AND COLUMN SHELVES
  • ENHANCING VISUAL APPEAL THROUGH MAKRS CARD
  • SUMMARY CARD
  • HEADER AND AXES
  • TITLES, CAPTIONS, LABELS AND LEGENDS

+ TOPIC 8: CALCULATIONS IN TABLEAU


  • TYPES OF CALCULATION FUNCTIONS
  • TABLE CALCULATIONS
  • CALCULATION SYNTAX
  • LEVEL OF DETAIL EXPRESSIONS
  • AGGREGATE CALCULATIONS
  • DATE CALCULATIONS
  • STRING CALCULATIONS
  • LOGIC CALCULATIONS
  • STATISTICS AND FORECASTING

+ TOPIC 9: FUNCTIONS IN TABLEAU


  • CALCULATED FIELDS, FUNCTIONS AND PARAMETERS
  • CALCULATED FIELDS - POWER TO ANSWER YOUR DIFFICULT QUESTIONS
  • CALCULATED FIELD OPERATORS
  • NUMERIC FUNCTIONS (SINGULAR)
  • CHARATER FUNCTIONS (MODIFY ITEMS)
  • CHARACTER FUNCTIONS (LOCATE VALUES IN STRING)
  • DATE FUNCTIONS
  • TYPE CONVERSION FUNCTIONS
  • LOGICAL FUNCTIONS (IF, THEN, ELSE)
  • AGGREGATE FUNCTIONS
  • TABLE CALCULATION FUNCTIONS
  • PARAMETERS AND ADDITIONAL CONTROL FOR YOUR ANALYSIS
  • ADVANCED MAPPING

+ TOPIC 10: DATA BLENDING


  • DATA BLENDING TO USE DATA FROM MULTIPLE SOURCES IN ONE VIEW
  • EXTRACTS TO ACCELERATE YOUR DATA EXPLORATION IN TABLEAU

+ TOPIC 11: DASHBOARDS


  • GETTING STARTED WITH DASHBOARDS AND STORIES
  • BUILDING A DASHBOARD
  • DASHBOARD LAYOUTS AND FORMATTING
  • INTERACTIVE DASHBOARDS THROUGH ACTIONS
  • BEST PRACTICES FOR A DASHBOARD
  • STORY POINTS

+ TOPIC 12: DEPLOY AND PUBLISH WORKBOOKS


  • TABLEAU PUBLIC
  • EXPORT IMAGES TO OTHER APPLICATIONS
  • EXPORT DATA TO OTHER APPLICATIONS OR BACK INTO TABLEAU
  • PRINT TO PDF
  • PACKAGED WORKBOOKS
  • TABLEAU READER
 

BASE ANALYTICS

DURATION: 48 HOURS

Analytics Base (AB) includes fundamental concepts of statistics, and guides in building predictive models using multiple linear and logistic regressions. All of this is taught using live case studies with data from 18 different industries, at ATI.

 

+ TOPIC 1: INTRODUCTION TO ANALYTICS


  • OVERVIEW
  • NEED FOR ANALYTICS
  • USE OF ANALYTICS ACROSS DIFFERENT INDUSTRIES
  • CHALLENGES IN ADOPTION OF ANALYTICS

+ TOPIC 2: DESCRIPTIVE ANALYTICS


  • OVERVIEW
  • UNDERSTANDING DIFFERENT OUTPUTS
  • TABULAR AND GRAPHICAL METHOD
  • SUMMARY STATISTICS

+ TOPIC 3: STATISTICAL TESTING


  • HYPOTHESIS TESTING
  • Z TEST, T TEST, CHI SQUARE TEST, ANOVA
  • PARAMETRIC AND NON PARAMETRIC TEST

+ TOPIC 4: REGRESSION AND CORRELATION


  • OVERVIEW
  • HOW TO CARRY OUT REGRESSION
  • TYPES OF REGRESSION - LOGISTIC AND LINEAR
  • CASE STUDIES

+ TOPIC 5: MODELING TECHNIQUES


  • OVERVIEW
  • CONCEPTS OF SEGMENTATION
  • USE OF SEGMENTATION
  • CLUSTER ANALYSIS FACTOR ANALYSIS
 

ADVANCED ANALYTICS

DURATION: 48 HOURS

With the aid of live projects, Advanced Analytics teaches you how to: 
-Make your data look good using data visualization
-Forecast using time series
-Find patterns in large amount of text using text analytics

- Machine Learning.

 

+ TOPIC 1: TEXT ANALYTICS


  • PROBLEMS WITH UNSTRUCTURED DATA
  • TERMINOLOGY IN TEXT ANALYTICS: CORPUS, TDM, PARSING, STEMMING,STOPWORDS, CHUNKING ETC
  • CLASSIFICATION AND TAGGING
  • IN CLASS PROJECT: DOCUMENT CLASSIFIER AND SENTIMENT ANALYSIS

+ TOPIC 2: AUTOMATION IN TIME SERIES


  • TIME SERIES DECOMPOSITION
  • COMMON TECHNIQUES LIKE MOVING AVERAGES, SMOOTHING ETC
  • ARIMA
  • IN CLASS PROJECT TO AUTOMATE FORECASTING

+ TOPIC 3: MACHINE LEARNING


  • WHAT IS MACHINE LEARNING
  • TREE BASED LEARNING
  • COMMON LEARNERS: KNN, RANDOM FORESTS, GBM ETC
  • IN CLASS PROJECT

+ TOPIC 4: DATA VISUALIZATION


  • LANDSCAPE OF VISUALIZATION
  • THINKING VISUALLY
  • HOW TO CHOOSE APPROPRIATE VISUALS
  • STORYBOARDING
  • IN CLASS PROJECT
 

python

DURATION: 32 HOURS

Python is an open source scripting language, known for its simplicity. It is extremely powerful and can be used for almost any statistical or analytical operation. As it is widely used in web development, it acts as an ideal bridge to support analytics in web based applications.

 

+ TOPIC 1: INTRODUCTION TO PYTHON


  • ORIGIN AND GOALS OF PYTHON
  • OVERVIEW OF PYTHON FEATURES
  • GETTING AND INSTALLING PYTHON
  • ACCESSING PYTHON DOCUMENTATION: PYTHON ENHANCEMENT PROPOSALS (PEP)
  • USING PYTHON WITH OTHER PROGRAMMING LANGUAGES

+ TOPIC 2: USING PYTHON


  • EXECUTING PYTHON PROGRAMS FROM THE COMMAND LINE
  • CREATING AND EXECUTING PYTHON PROGRAMS USING IDLE
  • PYTHON COMMAND LINE OPTIONS
  • ENVIRONMENT VARIABLES THAT INFLUENCE PYTHON
  • CREATING PYTHON GUI APPLICATIONS
  • STANDALONE VS WEB ENABLED INTERFACES
  • THE PYTHON STANDARD LIBRARY

+ TOPIC 3: LANGUAGE FUNDAMENTALS


  • PYTHON'S LEXICAL ANALYZER
  • USING WHITESPACE TO STRUCTURE PROGRAMS
  • IDENTIFIERS AND KEYWORDS
  • PYTHON'S EXECUTION MODEL
  • NAMING OBJECTS AND BINDING
  • PYTHON'S DATA MODEL
  • IMMUTABLE AND MUTABLE OBJECTS
  • DATA TYPES
  • VARIABLES, EXPRESSIONS AND STATEMENTS

+ TOPIC 4: CONDITIONAL PROGRAMMING


  • IF/ELIF/ELSE STATEMENTS
  • CREATING LOOPS WITH WHILE AND FOR
  • LOOP MODIFICATION WITH BREAK AND CONTINUE
  • UNDERSTANDING ITERATORS
  • RETURNING VALUES WITH RETURN STATEMENTS
  • RETURNING GENERATOR ITERATORS WITH YIELD STATEMENT
  • RETRIEVING ITERATORS WITH NEXT ()

+ TOPIC 5: EXCEPTION HANDLING


  • EXCEPTION HANDLING
  • TYPES OF PYTHON EXCEPTIONS
  • HANDLING EXCEPTIOSN WITH TRY/EXCEPT/FINALLY
  • TRIGGERING EXCEPTIONS WITH RAISE
  • DEFINING NEW EXCEPTION TYPES
  • IMPLEMENTING EXCEPTION HANDLING IN FUNCTIONS, METHODS AND CLASSES
  • WORKING WITH THE REGULAR EXPRESSION ERROR EXCEPTION

+ TOPIC 6: HANDLING STRINGS


  • USING ASCII AND UNICODE STRINGS
  • MANIPULATING STRINGS WITH STRING METHODS
  • USING THE FORMAT () FUNCTION TO FORMAT STRINGS
  • USING THE ESCAPE SEQUENCES
  • WORKING WITH RAW STRINGS

+ TOPIC 7: ARRAYS, COLLECTIONS AND DICTIONARIES


  • SEQUENCED DATA STRUCTURES
  • ARRAYS
  • COLLECTIONS
  • DICTIONARIES
  • CREATING AND ACCESSING LISTS
  • MANIPULATING LISTS
  • CREATING AND ACCESSING TUPLES
  • UNDERSTANDING THE DIFFERENCES BETWEEN LISTS AND TUPLES
  • USING DICTIONARIES TO CREATE DATA RECORDS
  • MANIPULATING DICTIONARIES USING DICTIONARY METHODS
  • CREATING SETS AND PERFORMING SET OPERATIONS - UNION, INTERSECT, DIFFERENCE
  • DIFFERENCES BETWEEN SETS AND DICTIONARIES
  • USING GENERATORS TO RETURN ITERATORS

+ TOPIC 8: FUNCTIONS & ARGUMENTS


  • DEFINING AND CALLING FUNCTIONS
  • CREATING ANONYMOUS FUNCTIONS
  • ALTERING FUNCTION FUNCTIONALITY WITH DECORATOR FUNCTIONS
  • CREATING CLASSES WITH THE CLASS STATEMENT
  • CREATING OBJECTS AS CLASS INSTANCES
  • USING PRE EXISTING CLASSES AS THE BASIS OF A NEW CLASS
  • USING MODULES TO GROUP RELATED FUNCTIONS, CLASSES AND VARIABLES
  • LOCATING AND IMPORTING MODULES
  • USING PACKAGES TO GROUP MODULES TOGETHER
  • PASSING ARGUMENTS TO FUNCTIONS BY REFERENCE AND BY VALUE
  • DEFINING FUNCTIONS WITH REQUIRED ARGUMENTS
  • DEFINING FUNCTIONS WITH DEFAULT ARGUMENTS

+ TOPIC 9: I/O HANDLING


  • SENDING OUTPUT TO STDOUT USING THE PRINT () METHOD
  • READING INPUT WITH THE INPUT () METHOD
  • CREATING FILE OBJECTS WITH THE OPEN () METHOD
  • CONTROLLING FILE ACCESS MODES
  • WORKING WITH FILE OBJECT ATTRIBUTES
  • CLOSING FILE OBJECTS WITH THE CLOSE () METHOD
  • READING AND WRITING TO FILE OBJECTS WITH READ () AND WRITE ()
  • USING FILE PROCESSING FUNCTIONS FROM THE OS MODULE

+ TOPIC 10: REGULAR EXPRESSION


  • REGULAR EXPRESSION SYNTAX
  • USING REGULAR EXPRESSIONS IN PYTHON
  • ALTERING REGULAR EXPRESSON IN PROCESSING WITH REGULAR EXPRESSION
  • MODIFIERS
  • USING REGULAR EXPRESSION OPERATORS
  • SCANNING THROUGH STRINGS USING THE SEARCH () AND MATCH () METHODS
  • CREATING REUSABLE PATTERNS BY USING THE COMPILE () METHOD

+ TOPIC 11: PYTHON PACKAGES


BASED ON REQUEST

 

DIGITAL ANALYTICS

DURATION: 24 HOURS

With large number of transactions being increasingly carried out in the Digital sphere, targeting the right customers is critical. Digital Analytics enables organisations to target their relevant customer base through channels like Google, Facebook and the web.

 

+ TOPIC 1: INTRODUCTION TO GOOGLE ANALYTICS


  • INTRODUCTION TO THE AUDIENCE TAB
  • MEASURING SUCCESS
  • INTRODUCTION TO THE ACQUISITION TAB
  • INTRODUCTION TO THE BEHAVIOUR TAB
  • CREATING A CUSTOM DASHBOARD

+ TOPIC 2: CREATING A LEAD GENERATION CAMPAIGN


  • SETTING UP A GOOGLE SEARCH ONLY CAMPAIGN
  • MONITORING AND OPTIMIZING THE CAMPAIGN

+ TOPIC 3: CREATING A LEAD GENERATION CAMPAIGN ON FACEBOOK


  • SETTING UP THE AD CAMPAIGN
  • MONITORING THE CAMPAIGN
  • OPTIMIZING THE CAMPAIGN