Advanced Certification in

Data Analytics
Master Data Analytics skills and take your career to the
next level!

10 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
Master the skills of Data Analytics with this Advanced Certification in Data Analytics by

iHUB DivyaSampark, a Technology Innovation Hub of IIT Roorkee and Intellipaat. Learn

from IIT Faculty and industry experts with 1:1 mentorship.

Hottest Job of 21st Century

. million Job Postings

1 2 Skill Development
According to a recent report by Indeed, Data Analysts are e quipped with
j
there were over 1.2 million ob postings for various relevant skill, fetching

data analytics in 2023 j

lucrative ob offer s

Growing Analytics Industry Future-oriented Career

The CA GR (compound annual growth Data Analytics is a budding field a ;
rate) for data analyst jobs is expected to head start will prove to be beneficial

be 13.5% from 2023 to 2030.

Popular Degree High Demand

40 % of the data analyst have According to a report by the Mc insey K
masters degree Global Institute, there will be a shortage
of 2.7 million data analytics

professionals by 2023

Our Credentials

10 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 data 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 Campus Immersion iHUB, IIT Roorkee

Online Bootcamp Live Classes at IIT Roorkee Certification

Key Highlights

400 Hrs of Applied Learning 50+ Live sessions across 7 months

218 Hrs of Self-Paced Learning Learn from IIT Faculty & Industry Practitioners

One-on-One with Industry Mentors 50+ Industry Projects & Case Studies

Placement Assistance Resume Preparation and LinkedIn Profile Review

24*7 Support Designed for Working Professionals & Freshers

1:1 Mock Interview No Cost EMI Option

2 Days campus immersion at IIT Roorkee

Pr gram
o Pedagog y
Instructor-led Training Hackathons

Get trained by industry experts from Get a sense of how real projects are built

Top Product Companies & Startups

Dedicated Learning Peer Networking and Group Learning

Management 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 Personali z ed 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 Data Analytics

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

Professionals aiming to move ahead in their IT career

Data Science and Data 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 Analysis and Data Science

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
SQL

2 3 4
Python Statistics And Machine
Probability Learning

7 6 5
Business Problem Time Series Performance
Solving, Insights Forecasting Metrics
and Storytelling

8 9 10
D ata Modeling Data Analytics Bu siness Case
Capstone Project Studies

Advanced 12 11
Certification in
Data Analytics Visualizations using Microsoft Excel
PowerBI (Elective) (Elective)

Self-paced Course
R Programming

Page - 4

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

Program Curriculum

Module 1 Module 5
SQL Performance Metrics
Introduction to SQL
Classification reports – To evaluate the model on various
Database Normalization and Entity Relationship metrics like recall, precision, f-support, etc.

Model(self-paced)
Confusion matrix – To evaluate the true positive/negative,
SQL Operators
false positive/negative outcomes in the model.

Working with SQL: Join, Tables, and Variables

r2, adjusted r2, mean squared error, etc.
Deep Dive into SQL Functions

Working with Subqueries

Module 6
SQL Views, Functions, and Stored Procedures
Time Series Forecasting
Deep Dive into User-defined Functions
Making use of time series data, gathering insights and useful
SQL Optimization and Performance
forecasting solutions using time series forecasting.
Advanced Topics

Managing Database Concurrency

Module 7
Practice Session
Business Problem Solving, Insights and Storytelling
Case Study Business Domains

Understanding the business problems and formulating

Module 2 hypotheses

Python Exploratory Data Analysis to Gather insights

Introduction to Python and IDEs

Data Storytelling: Narrate stories in a memorable way

Python Basics
Case Study
Data Manipulation with Numpy, Pandas, and Visualization

Case Study
Module 8
Data Modeling
Module 3 Feature Selection

Statistics And Probability Feature Engineering

Descriptive Statistics
Model Tuning
Probability

Inferential Statistics

Module 9
Case Study Data Analytics Capstone Project
Problem Statement and Project Objectives

Module 4 Approach for the Solution

Machine Learning Optimum Solutions

Evaluation Metrics

Introduction to Machine learning

Gathering Actionable insights

Regression

Classification

Module 10
Clustering

Supervised Learning

Business Case Studies

Unsupervised Learning
Customer Churn

Performance Metrics
Sales Forecasting

Time Series Forecasting Census

Predictive Modeling

HR Analytics

Dimensionality Reduction

Page - 5

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

Program Curriculum

Housing
Skills to Master
Customer Segmentation

Inventory Management
SQL
Advanced Statistics

Disease Prediction Data Wrangling

Data Mining

Data Analysis
R Programming

Elective Prediction algorithms

Module 11 Data visualization

Microsoft Excel Time Series

Excel Fundamentals
Machine Learning

Excel For Data Analytics

PowerBI

Data Visualization with Excel

Ensuring Data and File Security

Getting started with VBA Macros

Statistics with Excel

Tools to Master

Module 12
Visualizations using PowerBI
Power BI Basics

DAX

Data Visualization with Analytics

Case Study:

Job Readiness
Job Search Strategy

Resume Building

Linkedin Profile Creation

Interview Preparation Sessions by Industry Experts

Mock Interviews

Placement opportunities with 400+ hiring partners upon

clearing the Placement Readiness Test.

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

Manish Anand
CEO at iHUB IIT Roorkee
Manish Anand is an IIT Kanpur alumnus with an MBA in Technology and innovation management from
Korea Advanced Institute of Science and Technology (KAIST), Seoul. He currently heads iHUB DivyaSampark,
a Technology Innovation Hub hosted at IIT Roorkee.

Dr. Sudeb Das Gupta

Professor at IIT Roorkee
Dr. Sudeb Dasgupta is currently working as Professor at IIT Roorkee. He has completed his PhD
from Banaras Hindu University in Electronics Engineering and has more than 20 years of
teaching experience.

Dr. Balasubramanian R
Professor at IIT Roorkee
Dr. Balasubramanian R, is currently working as Professor at IIT Roorkee. He has completed his PhD from IIT
Madras in Mathematics and Computer Science and has more than 20 years of teaching experience. HIs
areas of interest include computer vision, machine learning, pattern recognition, deep learning, etc.

Mr. Rupesh Nasre

Associate Professor at IIT Madras
Mr Rupesh Nasre is currently working as an associate professor in the CSE Department at IIT
Madras. He holds a PhD from IISc Bangalore, and Post-Doctoral Fellowship from the University of
Texas at Austin.

Dr. Sushanta Karmakar

Associate Professor at IIT Guwahati
Dr. Sushanta Karmakar is currently working as Associate Professor, at IIT Guwahati. He has completed his
PhD from IIT Kharagpur from the Computer Science and Engineering department and has over 15 years of
teaching experience.

Nishkam Shivam
Senior Data Scientist at Bristlecone
A Senior Data Scientist in the field of Analytics and AI, Mr. Nishkam Shivam is presently working at
Bristlecone. He has 9+ years of experience in this particular field and has also worked in renowned
companies like Accenture, Walmart, Emeritus, and many more.

Madhu Babu Cherukuri

Sr. Data Scientist at Intel Corporation
He carries over 15 years of expertise in handling various analytics projects, using several types of ML
algorithms in multiple business domains. He also comes with extensive knowledge in SAS, SQL, R, Python
and is proficient in Big Data Environment.

Page - 8

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

Course Advisors / Faculty

Phaneendra Akula
Senior Manager, Data Science at Sunrise Systems
Mr. Akula is presently working at Sunrise Biztech Systems Private Limited. He has 9+ years of experience in
the field of Data Science and has worked in many prestigious companies like Genpact, TCS, and Tesco. He
is also a research scholar and a speaker.

Vishwath Parthasarathy
Data Scientist-III at InMobi
Mr. Parthasarathy is currently working as a Data Scientist-III at InMobi. He has also worked at Amazon and
PipeCandy. His expertise extends to Machine Learning, Deep Learning, MLOps, and Algorithmic Trading. He
has been working since 2017 as a Data Scientist.

Anurag Singh
Principal AI Architect at Schneider Electric Hub
Mr. Singh works at Schneider Electric Hub as a Principal AI Architect. He started as a Software Engineer in
2007 and has been working as Data Scientist since 2018. He specializes in Big Data, Data Science, Machine
Learning, and AI System Architecture.

Muthusamy Manigandan
Data Science Consultant, Ex- Apple
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 - 9

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%

9-12 years
15%

25%

6-9 years

25%

27%

3-6 years

27%

20%

0-3 years

20%

Page - 10

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

From

Shubham Shinde To

Business Intelligence
Data Analyst | India Data Analyst
Specialist

Kiran Kulkarni From
 To


Sr. Data Analyst | India BPO Associate Sr. Data Analyst

From

Aditya Ahuja To

Software Test
Data Analyst | India Data Analyst
Engineer

From

Lucky Bajetha To

Human Resource
Data Analyst | India Data Analyst
Executive

Shehzin Mulla From
 To


Research Analyst Data Analyst Research Analyst

From
 To

Jeanette Masso
Computer Technical Big Data Developer
Big Data Developer
Specialist

From
 To

Prosenjeet Saha
Manager Analytics & Data Scientist
Data Scientist
Data Science

From
 To

Pratik Kumar
Marketing Manager Product Manager
Product Manager

Page - 11

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 the
by industry mentors and prepare learner is moved to the placement pool upon
your career trajectory clearing Placement Readiness Test (PRT)**

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
Pradeep P k M o it Hin ar
h w
S ub am upta
h h G

Senior Programmer Analyst III eam Leader (Data Analyst) at

ata Science & Analytics
T

at Hubbell Incorporated Ziff Davis

D

Enthusiast

The Data Science and Machine I am happy to be able to complete this Intellipaat provides a great learning
Learning course from Intellipaat was certification from Intellipaat. I environment inclusive of new-age
taught from the basics. The trainers appreciate the entire team for technologies. I worked on many Data
are knowledgeable with clarity of providing me with amazing learning Science tools through live training and
practical concepts. The support experience through real-time projects self-paced videos. The trainers are very
team is prompt with the response. and case studies. supportive.

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

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 10 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 EICT IIT
Roorkee, EICT IIT Guwahati, IITM Pravartak, IIM Ranchi, IIT Jammu, IU, LSBU, University of Essex, University
of Liverpool, 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 iHUB DivyaSampark, IIT Roorkee

iHUB DivyaSampark, IIT Roorkee aims to enable an innovative ecosystem in new-age technologies like
AI, ML, Drones, Robots, and data analytics (often called CPS technologies). It aims to do this by
promoting and enhancing core competencies, capacity building, and manpower training to provide
solutions for national strategic sectors and become a significant contributor to Digital India.

Achievements – IIT Roorkee:

Ranked 7th ‘Overall’ and 6th in ‘Engineering’ in India as declared by NIRF 2022

Ranked 175th in the world for ‘Engineering and Technology’ by QS World University Rankings 2023

Ranked as the 369th best institute in the world by QS World University Rankings 2023

Ranked as the 114th best institute in Asia by QS World University Rankings 2023

Upon the completion of this program, you will get:

Certification from iHUB DivyaSampark, IIT Roorkee

Page - 13

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

 10 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

USA

100 Church Street, New York City, NY

sales@intellipaat.com

www.intellipaat.com