Analytics Alpha

In the digital world, everything has become data. Regardless of the type of industry, it is Business, accounting, education, science, engineering, healthcare, technology, energy sector, government, all rely on data analysis for decision making.

The demand for skilled data analysts is so high that job posting is higher than the availability of professionals in the field. With our Analytics Alpha program, you can learn the most important tools required to become a data scientist.

Suitable for freshers & Experienced

Analytics Alpha, 144 hrs

Advanced Excel, 24 hrs

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, 16 hrs

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, 24 hrs

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

Tableau, 16 hrs

Base Analytics, 32 hrs

Digital Analytics, 16 hrs

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

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

R, 16 hrs

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

Basic R programming
Advanced R programming