Analytics Alpha+

Covering vast topics and tools, our Analytics Alpha+ program is a comprehensive training to help you achieve your dream of becoming an expert in data analytics.

Imagine being the person top-level executives turn to before they make any major business decision.

Imagine the top industry pay and wider opportunities.

Advanced Analytics is the first step towards such an exciting career.

Syllabus

Advanced Excel

Introduction to advanced excel
Data tab(advanced sort & filter, what if analysis, data validation)
Functions(Text, logical, look-up & advanced functions)
Dynamic charts and Pivot tables
VBA/Macros(Sub routines, Loops, UDFS)
User forms

SQL

Introduction to SQL
Basic relational database management concepts (SQL commands, Normalisation, 1NF, 2NF..)
Concept of table(create, import, check tables & select, insert, update, Delete function)
Data-base functions(group by, count, where option, mathematical and scalar functions, primary key constraint)

Python

Introduction to Python
Using Python – The basics
Plotting data
Numpy
Pandas
Data Wrangling
Data Aggregations and group Operations

Tableau

Basics of data visualization
Getting started with Tableau
Connecting to data
Filters/Parameters
Basic views
Advanced view
Customising views
Calculations
Functions
Data Blending
Dashboards
Deploy and Publish workbooks

Base Analytics

Introduction to Analytics
Descriptive analytics
Statistical testing
Regression and correlation
Modelling techniques

R

Basic R Programming
Advanced applications of R

Power BI

Introduction to Power BI
Query editor
Transforming data
Filters and slicers
Charts and concepts
Creating reports
Dax functions
Creating datasets
Sharing and exploring power BI dashboards

Advanced Analytics

Text Analytics
Automation time series
Machine learning
Data visualization

Digital Analytics

Introduction to Google Analytics
Creating a lead generation campaign
Creating a lead generation campaign on Facebook

Deep Learning using Python

Advanced Python & Calculus concept
Tensorflow
Neural networks

Analytics Infrastructure

Real time analytics
Performance optimization