Technology Innovation Hub of

IIT Madras

Advanced Certification in

Data Analytics for

Business
Master Data Analytics skills and take your career to the

next level!

2 Million 1:1 Personlized 55% Average

Learners Mentorship Salary Hike

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

Advanced Certification in
Data Analytics for
Business
Jump-start your career in Data Science and Business Analytics through this

Advanced Certification in Data Analytics for Business by IITM Pravartak (A Technology

Innovation Hub of IIT Madras) and Intellipaat. Learn from IIT Madras faculty and industry
experts with 1:1 mentorship.

Technology Innovation Hub

of IIT Madras

Hottest Job of 21st Century

1.7 Million Job Postings Sk ill Development
There is a global estimate of 1.7 million job Data analysts are equipped with various
postings for data analytics roles by 2022 relevant skills, fetching lucrative job offers

G rowing Analytics Industry F uture-oriented Career

45.4% CAGR in Indian Analytics Industry Data Analytics is a budding field; a head start
will prove to be beneficial

o ular Degree
P p H ghi Demand
40% Data Analysts have a Master's By 2022, India & US will face a demand supply
Degree gap of 430,000 data analytics professionals

Our Credentials
2 Million+ 1,000+ 400+
Aspiring Active Students Industry-expert Instructors Hiring Partners

500+ 55% 155+

Corporates Upskilled Average Salary Hike Countries’ Learners

Page - 1

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

About Program
The program aims to help learners develop a strong skill set including business analytics,

descriptive statistics, probability distributions, predictive modeling, time series

forecasting, and data architecture strategies as well as master the domain knowledge
required to excel in this field.

Learning Format 7 Months Career Services IITM Pravartak

Online Bootcamp Live Classes By Intellipaat Certification

Key Highlights
400 Hrs of Applied Learning 50+ Industry Projects & Case Studies

218 Hrs of Self-paced Learning One-on-One with Industry Mentors

24*7 Support 50+ Live sessions for a period of 7 months

1:1 Mock Interview Learn from IIT Madras Faculty & Industry Practitioners

Placement Assistance Resume Preparation and LinkedIn Profile Review

No Cost EMI Option Designed for Working Professionals & Fresher's

2 Days campus immersion at IIT Madras

Program Pedagogy
Instructor-led Training Hackathons
Get trained by top industry experts Get a sense of how real projects are built

Dedicated Learning Management Peer Networking and Group Learning

Team Improve your professional network and learn from
To help you with your learning needs peers

Self-paced videos Gamified Learning

Learn at your own pace with Get involved in group activities to
world-class content solve real-world problems

Projects and Exercises 1:1 Personalized Learning

Get real-world experience through Hands-on exercises, project work,
projects quizzes, and capstone projects

Page - 2
IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com
Who Can Apply for the Course?
Individuals with a bachelor’s degree and a keen interest to learn Data Science and Business Analytics

IT professionals looking for a career transition to Data Scientists and Business Analysts

Professionals aiming to move ahead in their IT career

Data Science and Business Analysis professionals willing to validate and develop skills in the domain

Developers and Project Managers

Fresher’s who aspire to build their career in the field of Data Science and Business Analytics

Application Process
The application process consists of three simple steps. Candidates have to submit their application.

An offer of admission will be made to the selected candidates, and their application will be accepted

upon the payment of the admission fee.

SUBMIT APPLICATION
1
Tell us a bit about yourself and why you want to join

ADMISSION TEST & APPLICATION REVIEW

2 Clear the admission test and have a personal interview

with our interview panel

ADMISSION LETTER
3
Shortlisted candidates would be offered the admission letter

Page - 3

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

Learning Path

Live Courses Live Courses

Self-paced

Industry Expert
Academy Faculty

1
Start of the
Course
Preparatory

Sessions – Linux

2 3 4
SQL Python Statistics And
Probability

7 6 5
KNIME Business Problem Machine Learning
Solving, Insights and
Storytelling

8 9 10
Visualizations using Microsoft Excel Presto
PowerBI

Advanced Certification in 11
Data Analytics for Business
Projects, Business Case
Study And Interview
Preparation

Self-paced Course
Analytics Using Spark

Page - 4

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

Program Curriculum

Module 1 Classification

SQL Clustering

Supervised Learning

Introduction to SQL

Unsupervised Learning

Database Normalization and Entity Relationship

Performance Metrics

Model(self-paced)

Time Series Forecasting

SQL Operators

Working with SQL: Join, Tables, and Variables

Module 6
Deep Dive into SQL Functions

Working with Subqueries

Business Problem Solving, Insights and Storytelling

SQL Views, Functions, and Stored Procedures
Business Domains

Deep Dive into User-defined Functions

Understanding the business problems and formulating
SQL Optimization and Performance
hypotheses

Advanced Topics
Exploratory Data Analysis to Gather insights

Managing Database Concurrency

Data Storytelling: Narrate stories in a memorable wayCase
Practice Session
Study
Case Study
Module 7
Module 2 KNIME
Microsoft Excel Introduction to KNIME

Excel Fundamentals
Working with data in KNIME

Excel For Data Analytics

Loops in KNIME

Data Visualization with Excel

Web scraping in KNIME

Ensuring Data and File Security

Feature Selection, Hyperparameter optimization in KNIME

Getting started with VBA Macros

Case Study:

Statistics with Excel

Module 8
Module 3 Data Modeling
Python Feature Selection

Introduction to Python and IDEs

Feature Engineering

Python Basics
Model Tuning
Data Manipulation with Numpy, Pandas, and Visualization

Module 9
Case Study
Data Warehousing
Module 4 Introduction to Data Warehouse

Statistics And Probability Architecture of Data Warehouse

Data Modeling Concepts

Descriptive Statistics

Data Normalization

Probability

Dimension and Fact Table

Inferential Statistics

SQL Parsing, Cubes and OLAP

Case Study

Module 10
Module 5
Visualizations using PowerBI
Machine Learning Power BI Basics

Introduction to Machine learning

DAX
Regression
Page - 5

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

Program Curriculum

Data Visualization with Analytics

Skills to Master
Case Study:
SQL
Advanced Statistics

Module 11 Data Wrangling

Data Mining

Analytics Using Spark (Self paced) Data Analysis

R Programming

Introduction to Spark
Prediction algorithms

Spark Basics

Data visualization

Spark SQL and Data Frames

Time Series

Module 12 Machine Learning

Presto PowerBI

Introduction to Presto

Data Transformation using Presto

Tools to Master
Module 13
Data Analytics Capstone Project

Problem Statement and Project Objectives

Approach for the Solution

Optimum Solutions

Evaluation Metrics

Gathering Actionable insights

Module 14
Business Case Studies

Customer Churn

Sales Forecasting

Census

Predictive Modeling

HR Analytics

Dimensionality Reduction

Housing

Customer Segmentation

Inventory Management

Disease Prediction

Page - 6

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

Course Projects

Projects cover the following industries:

Retail cial Media

So Supply Ch ain E ntrepreneurship E- commerce Banking H ealthcare Insurance

Beginner Beginner
Predicting class of a flower Fraud Detection
This project is made to predict the class of a flower. The project is to create a model which would help in
By analyzing the data about the petal and their detecting Credit Card fraud using Machine Learning
dimensions, the class of the flower would be subcategories like supervised, unsupervised, and
determined using a trained Machine Learning model reinforcement learning techniques like Neural
that has optimum accuracy. Network and Random Forest.

Beginner Intermediate
Data Analytics on Census dataset Pokemon Analysis
The project is meant to analyze and predict whether Select a pokemon whose primary type is “Grass”,
an individual has an annual income of more than Rs secondary type is “Poison” with the maximum speed.
50,000 or less using various machine learning It creates a model that predicts whether the selected
techniques, some of which are supervised and pokemon is Legendary or not using Machine
unsupervised learning. Learning and Data Analysis techniques.

Intermediate Intermediate

Analyzing impact factors in Telecom Stock Market Analysis

The project aims to find the most impacting factors in This project focuses on Machine Learning by creating
the preferences of the pre-paid model and to identify a predictive data model to predict the future stock
which variables are highly correlated with impacting prices. It also analyzes the current trends in the stock
factors. The goal of this project is to find the factors that market using algorithms like Linear Regression and
have the maximum impact on the preferences of the k-Nearest Neighbors.
pre-paid model.

Advance Advance

Comment Identity & Classification Loan Approval Prediction

Work on the comment dataset of Yelp to build a The project aims to analyze whether the applied loan
multi-headed model that can identify & categorize would be approved or not by identifying the
various types of toxic comments (obscenity, insults, variables correlated with impacting factors. It is
threats etc.). It must allow the user to find and select predicted using techniques such as Logistic
the required type Regression, Decision Tree and Random Forest.

Advance Advance

Book Recommender Recommendation Engine using Netflix prize

This project aims at building a book The recommendation engine is built using Netflix
recommendation engine based on past reading and prize dataset that will collect the data from various
buying history of an individual. It will analyze the sources of a user, anticipate their preferences and
dataset using Machine Learning techniques, R will recommend movies according to the user’s
programming and its various libraries. behavior and choices made earlier.

Page - 7

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

Course Advisors / Faculty

Dr. Arun K. Tangirala

Professor, IIT Madras
Dr. Tangirala is a professor at IIT Madras with expertise in Analytical Chemistry and a keen interest in the
fields of Controller Performance Monitoring, Time-Frequency Analysis of Processes, and Fuel cells, etc.

Dr. Nirav Bhatt

Assistant Professor, IIT Madras
He works as an assistant professor for the Biotech department at IIT Madras and holds a DSc from EPFL,
Switzerland. His research interests span from modelling and optimization of biological networks to Machine
Learning.

Prof. Babji Srinivasan

Associate Professor, IIT Madras
Prof.Babji is with IIT Madras as an assistant professor in the dept. of Applied Mechanics. He holds a Ph.D
from Texas Tech University and his research interests span from Behavioural Informatics to Cognitive
Systems Engineering.

Vinayak Panchaman
Business Intelligence Consultant at IKEA
Vinayak has over 13+ years of experience and specializes in Data Modeling preparing KPIs, SQL query,
Functional Dashboards with Qlik, Power BI, Sentiment Analysis, etc along with holding a CSM (Certified
Scrum Master) certification.

Prof. Shankar Narasimhan

Professor, IITM
A fellow of the Indian National Academy of Engg, his research area includes Data Mining, Process Design &
Optimization, FDD etc. He has co-authored several reconciliation papers, a book and a course ‘Data
Science for Engineers' on the NPTEL platform.

Mr. Suresh Ramadurai

Data Science Consultant
Having spent 25 years in the Data Science field, he has excelled in driving profitable brands using Research
& Analytics in Advertising , Market Research for companies like JWT, IBM etc. An alumnus of IIT Delhi & IIM
Bangalore, he currently teaches Analytics.

Muthusamy Manigandan
H ead Engineering, Amazon India
Manigandan has 16+ years of experience in cloud projects for Fortune 500 companies. He comes with a
strong background in architecture and implementation of AWS, Azure, GCP, along with hands-on
experience in DevOps tools.

Page - 8

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

Meet the Batch

Industries Our Learners Come From

12% - BFSI

50% Information Technology

5% - Healthcare

10% - Consulting

6% - Others

17% - BPO/ KPO

Work Experience

13%

12+ years Some of their current employers include

13%
15%

15% 9-12 years

25%

6-9 years
25%
27%

3-6 years

27%
20%

0-3 years

20%

Page - 9

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

Glimpse of our
Successful Transitions

4.6 4.5 4.38

Career Transitions
Gaurav Saboo From
 To

Senior Technical Associate Technical Analyst Senior Technical
Associate

From

Melwin Rodrigues Customer Service To

Data Scientist Agent Data Scientist

From
 To

D Rajesh Sahoo B.Tech - Civil Machine Learning
Machine Learning Engineer
Engineering Engineer

From
 To

Ankit Kumar B.com Graduate Data Scientist
Data Scientist

From

Mahesh Chowdary Aircraft Maintenance To

Data Scientist Engineer Data Scientist

From
 To

Jeanette Masso Computer Technical
Big Data Developer Big Data Developer
Specialist

From

Prosenjeet Saha Manager Analytics & To

Data Scientist Data Science Data Scientist

Nishchay Agrawal From
 To


Data Engineer Fresher Data Engineer

Page - 10

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

Intellipaat
Career Services
500+ 600+ 400+ 55%
Webinars Job Shares Hiring Partners Avg. Salary Hike*

What Makes Us Tick

Career-oriented Sessions Placement Assistance
Attend 10+ career-oriented sessions Placement opportunities are provided once
by industry mentors and prepare the learner is moved to the placement pool.
your career trajectory Get noticed by our 400+ hiring partners.**

Profile Building Dedicated Job Portal Access

Craft a Data Analytics resume and Get exclusive access to 200 job
LinkedIn profile to make an postings per month on Intellipaat’s
impression on top employers job portal

Mock Interview Preparation Job Fairs

Prepare with mock interviews Job fairs are conducted regularly to
including most asked questions by introduce learners to major
top employers
organizations

1:1 Mentoring Sessions Hackathons

Get 1:1 guidance at every step in Work in teams and get exclusive
your career transition to Data access to hackathons
Analytics

Learner Reviews
Manas Ranjan Afsana Zaman Vikrant Singh
Data Analyst at Amazon Analyst at American Electric Big Data Consultant at Amazon
Power
I am happy to have enrolled in this Great learning experience with this It was a wonderful learning
Data Science program. The syllabus course. The support team was experience to learn from the trainers
is organized and the course is well always available. The collaboration at Intellipaat. They were prompt and
designed. Best features are the 24*7 of practical with theoretical provided real-time scenarios.
support and trainers who are knowledge makes it highly suitable Intellipaat is the right place for
domain experts. for those who want to upskill. learning the latest technology.

* Past record is no guarantee of future job prospects | ** Placement Assistance doesn’t guarantee you a job Page - 11

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

 Program Partners

About Intellipaat

Intellipaat is one of the leading online training providers with more than 1.2 million learners in

over 155 countries. We are on a mission to democratize education as we believe that everyone

has the right to quality education.

We create courses in collaboration with top universities and MNCs for employability like IIT

Madras, University of Essex, University of Liverpool, IIT Roorkee, IIT Guwahati, SPJIMR, IBM, Microsoft,

etc.

Our courses are delivered by SMEs & our pedagogy enables quick learning of difficult topics.

24/7 technical support & career services help learners to jump-start their careers.

About II TM Pravartak
IITM Pravartak is hosted as the Technology Innovation Hub (TIH) by IIT Madras and is funded by
Technology Innovation Hub of IIT
Madras the Department of Science and Technology, Government of India. IITM Pravartak mission is aimed

at complete convergence with all stakeholders by establishing strong linkages between

academia, industry, Government, and International Organizations.

Upon the completion of this program, you will:

Receive an Advanced Certification in Data Science and BA from IITM Pravartak

Receive Live Lectures from IIT Madras Faculty & Industry Experts

Page - 12

IND: +91 7022374614 US: 1-800-216-8930 sales@intellipaat.com www.intellipaat.com

 2 Million Learners & 500+ Corporates across 155+ countries

upskilling on Intellipaat Platform

Contact Us
INDIA

AMR Tech Park 3, Ground Floor, Tower B, Hongasandra Village,
Bommanahalli, Hosur Road, Bangalore, Karnataka 560068, India

Phone No: +91-7022374614

UK

Flat 16 Bluepoint Court, 203 Station Road, Harrow,

Middlesex HA1 2TS, UK

USA

1219 E. Hillsdale Blvd. Suite 205, Foster City, CA 94404

Phone No: 1-800-216-8930

sales@intellipaat.com

www.intellipaat.com