analytics 360
DESCRIPTION
big data, statsTRANSCRIPT
Our Raison d'être
Identify major choice decision points Leverage Analytical Tools and Techniques to solve problems hindering these decision points Empowerment through Intelligence
ATI has empowered over 13,000
individuals and 120 Corporates
with better decision making
skills.
In house expertise with leading statistical software
ATI is the first and leading Analytics Training Organization in India
Industry Stalwarts with a combined experience of over 30 years
World class trainers who have imparted analytics capability and reporting capability
Our Education Credentials
Our Channels Of Empowerment
Classroom Training
From one of our fully equipped labs at Bangalore, Delhi & Hyderabad
Corporate Training
Customized courses for your workforce at your premises
Online Training
From any part of the world in the convenience of your home/ office
Analytics Discussion Forum Expert insights in a collegial atmosphere
Classroom Training
World class fleet of trainers with experience in solving business problems with analytics Three fully equipped Training Labs in Bangalore Comprehensive Training Packages for Beginners and Advanced Practitioners Extensive Case Studies and Practice Sessions Have conducted over 80,000 hours of training to date and counting…
Corporate Training
Training conducted on client’s premises Courses can be customized as per the client’s requirements Extensive Case Studies and Practice Sessions Expert Trainers who have conducted trainings at over 120 leading organizations
Some of our prominent and long serving clients include Infosys, Genpact, Accenture, HP, Capital One, ITC, PWC, UB Group, 24/7, Monnet Group, Citibank, Airtel etc.
Our Training Solutions
Analytics Techniques Statistical tools
Dash boarding and Reporting
Sector Independent Techniques
Analytics 360 Offers
R- Open source
Analytical tool
Analytics
Structured Query
Language
Microsoft Excel
Plus
Lifetime Access to our
Pre – Recorded Video
sessions for reference
8 Guest Lectures on
Trending Topics
• R environment and Windows system
• R Objects, Data permanency and removing objects
• R Help and search with Functions
• R commands and Case sensitivity
• Data Import and Export
• Packages
• R Studio Installation
• Simple Manipulations : Numbers and Vectors
• Writing your own functions
Module 1:
Basic R tool programming
Program schedule
• Data Manipulation: merging, sorting, filtering, de-duping
• User defined functions
• Visualizations: histogram, bar plot, box plot, mosaic plots, geographic plots, etc
• TM package
• Word cloud Package
Module 2:
Advanced Applications of R
Program schedule
• In Class Project
• Students do independent research
• Build your first sentiment analysis algorithm
• Combine solutions of students t showcase a final project
Module 3:
Hand on
Program schedule
Basic Excel- GUI
• Overview
• Home Tab
• Conditional Formatting
• Paste special
• Go to special
Module 1: Introduction to Excel
• Overview
• Simple sort and filter
• Advanced Sort and Filter
• What if Analysis
• Data Validation
• Consolidate
Module 2: Data Tab
Basic Excel- GUI
• Overview
• Text Functions like CONCATENATE, TRIM, SEARCH, SUBSTITUTE
• Logical Functions like IF, AND, OR
• Lookup Functions like VLOOKUP, HLOOKUP, REFERENCE, INDEX,MATCH
• Advanced Functions like DCOUNT, DSUM
Module 3: Functions
• Overview
• Create charts
• Use Dynamic charts
• Connecting to Form Controls
• Simple Pivot Tables
• Functions in Pivot Tables
• Integrating Charts with Tables
Module 4: Dynamic charts & Pivot Tables
Advanced Excel with VBA
• Introduction to programming language
• Introduction to object oriented programming
• Properties/ methods/ Events involved with an object
• Hierarchy: Objects/ Functions/ Methods
• Connections between Objects/ Functions/ Methods
Module 1: Introduction to VBA
• Data sets
• Overview
• Writing a simple code
• Making the code dynamic
• Standard format of writing a Macro
• Logical conditions in a Macro
• Writing a conditional statement
Module 2: Introduction to Macros
• Recording a Macro
• Limitation of recording a macro, overcoming this limitation
• Editing recorded codes
• Using short cut keys
Module 3: Recording / Editing Macros
• Introduction to Loops
• Types of Loops : For/While/Do
• Requirement and applicability of loops
• Manipulating loops
Module 4: Loops
• Using predefined functions
• Creating customized functions
• Using the customized functions
Module 5 : Predefined functions
Advanced Excel with VBA
• Predefined events
• Creating Customised Events
• Simple message box
• Customised message box
• Interactive message box
Module 6: Events and Message Boxes
• Write or record a global macro
• Utilizing the customised functions in all the workbooks
Module 8 : Global Macros
Advanced Excel with VBA
• Overview
• Need for analytics
• Analytics use in different industries
• Challenges in adoption of analytics
Module 1: Introduction to Analytics
• Overview
• Understanding different outputs
• Tabular & Graphical Method
• Summary statistics
Module 2: Descriptive Statistics
• Hypothesis Testing
• Z‐Test, T‐Test, Chi‐Square test, ANOVA
• Parametric & Non‐Parametric test
Module 3: Statistical Testing
Analytics
• Overview
• How to do regression
• Types of regression – logistic and linear
• Case Studies
Module 4: Regression & Correlation
• Overview
• Concepts of Segmentation
• Usage of Segmentation
• Cluster Analysis
• Factor Analysis
Module 5: Modeling Techniques
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
Module 1: Text Analytics
• Time series decomposition
• Common techniques like moving averages, smoothing etc.
• ARIMA
• In class project to automate forecasting
Module 2: Automation in time Series
Advanced Analytics
• What is machine learning?
• Tree based learning
• Common learners: KNN, random forests, GBM etc
• In class project
Module 3:Machine Learning
• Landscape of visualization
• Thinking visually
• How to choose appropriate visuals
• Story boarding
• In class project
Module 4:Data Visualization
Advanced Analytics
• Overview
• What is SQL
• Why and where is SQL used
• Why should one learn SQL
• Database fundamentals
• What is a database
• How to connect two databases
• What are the different features in a database (for example,
• primary key, foreign key and candidate key)
Module 1: introduction to SQL
• How to access one table from the other
• What are the different relationships possible between two tables
• How to use SQL commands in Access
• Normalization
• 1NF, 2NF..BCN
• Model a normalized database
Module 2: Basic Relational Database Management Concepts
SQL
• Overview
• How to create a table
• How to check the tables for consistency
• Functions
• How /Where/Why use the SELECT function
• How/Where/Why use the INSERT / UPDATE / DELETE function
Module 3: Introduction to the concept of Tables
• How/Where/Why use “GROUP BY” option
• How/Where/Why use “COUNT” option
• How/Where/Why use “WHERE” option
• Mathematical Functions: AVG, SUM, MIN, MAX, FIRST, LAST
• Scalar Functions: UCASE, LCASE, MID, LEN, NOW, ROUND, FORMAT
• Primary Key Constraint – ALTER
• In Class project using Functions
Module 4: Database Functions
SQL
• Overview
• Where is Access Used
• Database
• How to navigate through database
• How to design a database
• How to introduce relationships between tables
• Possible Errors due to relationship definition
• Forms
• Overview
• How to create a form
• How to call the form from a database
• Options available in form
• How to create split forms
• How to add multiple items in a form
Module 5: Introduction to Access Functionalities
SQL
• Variables
• What are the different variables available in Access
• How to create reports using different variables
• Variable error checking options
• Pivot Charts
• Import Excel data in Pivot Chart
• Create Pivot Chart in Access
• Import Data
• How to import data from excel
• Import data from ODBC
• Reports
• Overview
• How to create dynamic report
Module 6: Advanced Access Functionalities
SQL
• Macros
• How to run macros in Access
• Object Dependencies
• How to link tables using object dependencies
• Database Documenter
• How to use database documenter
• Different errors possible in database documenter
• Linking with other ODBCs
• Overview
• How to link Access with other ODBCs
• Module
• Different kinds of modules
• Error Handling in Access
Module 6: Advanced Access Functionalities(contd.)
SQL