DATA ANALYST

MASTER’S PROGRAM
In Collaboration with IBM

1 | www.simplilearn.com
 Contents

About the Course 03

Key Features 04

About IBM and Simplilearn in collaboration 05

Learning Path Visualization 06

Program Outcomes 07

Who Should Enroll 08

Courses 09

Step 1: Introduction to Data Analytics 09

Step 2: Statistics Essentials 11

Step 3: SQL Basics 13

Step 4: Business Analytics with Excel 15

Step 5: Tableau 17

Step 6: Power BI 19

Step 7: Programming Basics and Data Analytics with Python 21

Step 8: R Programming for Data Science 23

Step 9: Data Science with R 24

Step 10: Data Analyst Capstone 26

Electives 27

Certificates 28

Classroom-Level Immersion: Delivered Digitally 29

Advisory Board Member 30

Corporate training 31
About the Course

This Data Analyst Master’s Program, techniques, how to work with SQL
in collaboration with IBM, will databases, the languages of R and
transform you into a data analytics Python, and how to apply statistics
expert. In this course, you will and predictive analytics in a business
learn the latest analytics tools and environment.

3 | www.simplilearn.com
Key
Features

Industry-recognized certificate from

IBM(for IBM courses) and Simplilearn for
this unique collaboration program

Portfolio-worthy capstone demonstrating

mastered concepts

12+ real-life projects providing hands-on

industry training

30+ in-demand skills

Lifetime access to self-paced learning and

class recordings

4 | www.simplilearn.com
4 | www.simplilearn.com
About IBM and Simplilearn
collaboration

This joint partnership between offering a plethora of technology

Simplilearn and IBM introduces and consulting services. Each year,
students to an integrated Blending IBM invests $6 billion in research
Learning approach, making them and development and has achieved
experts in data analysis. This five Nobel Laureates, nine U.S.
program, in collaboration with IBM, National Medals of Technology, five
will help students become industry- U.S. National Medals of Science, six
ready for data analyst job roles. Turing Awards, and 10 inductions into
IBM is a leading cognitive solution the U.S. Inventors Hall of Fame.
and cloud platform company,

About Simplilearn
Simplilearn is the world’s #1 online at a fraction of the cost and time as
bootcamp provider that enables traditional approaches. Over one million
learners through rigorous and highly professionals and 2000 corporate training
specialized training. We focus on organizations have harnessed our award-
emerging technologies and processes winning programs to achieve their career
that are transforming the digital world, and business goals.

5 | www.simplilearn.com
Learning Path - Data Analyst

Introduction to
Data Analytics
(3.2 hours)

Statistics Essentials SQL Training

(4.3 hours) (7.1 hours)

Tableau Training Business Analytics with

(54.3 hours) Excel (8 hours)

Programming Basics
Power BI
and Data Analytics
(4.1 hours)
with Python (57 hours)

Data Science with R R Programming for

(74.6 hours) Data Science
(1.2 hours)

Data Analyst
Capstone (24 hours)

Electives
Programming Refresher
Industry Master Class - Data Analyst

6 | www.simplilearn.com
Data Analyst Master’s Program
Outcomes

Understand essential Learn how to interpret

statistical concepts, data in Python using
including measures of multi-dimensional arrays
central tendency, dispersion, in NumPy, manipulate
correlation, and regression DataFrames in Pandas,
use SciPy library of
mathematical routines, and
Master SQL concepts such execute machine learning
as Universal Query Tool and using Scikit-Learn
SQL command

Perform data analytics using

Write your first Python popular Python libraries
program by implementing
concepts of variables,
strings, functions, loops, and Gain an in-depth
conditions understanding of the basics
of R, learning how to write
your own R scripts
Understand the nuances
of lists, sets, dictionaries,
conditions and branching, Master R programming and
objects, and classes in understand how various
Python statements are executed in
R

Work with data in Python,

including reading and
writing files, loading,
working, and saving data
with Pandas

7 | www.simplilearn.com
Who Should Enroll in this Program?

A career as a data analyst IT professionals

requires a foundation in
statistics and mathematics. Banking and finance
Aspiring professionals of any professionals
educational background with Marketing managers
an analytical frame of mind
are best suited to pursue the Supply chain network
Data Analyst Master’s Program, managers
including:
Beginners in the data
engineering domain

Students in UG/ PG
programs

8 | www.simplilearn.com
 S
T
E
Introduction to Data Analytics P
1
Simplilearn’s Introduction to Data Analytics course will give you insights 2
into applying data and analytics principles in your business. You will gain
an understanding of the complete data analytics lifecycle, from problem 3
definition to solution deployment. Through various industry-specific
examples and case studies, you will learn how analytics, data visualization,
4
and data science methodologies can be used to drive better business 5
decisions.
6
Key Learning Objectives 7
Understand how to solve analytical problems in real-world scenarios 8
Define effective objectives for analytics projects 9
Work with different types of data 10
Understand the importance of data visualization to help make more
effective business decisions

Understand charts, graphs, and tools used for analytics and

visualization and use them to derive meaningful insights

Create an analytics adoption framework

Identify upcoming trends in the data analytics field

9 | www.simplilearn.com
Course curriculum
Lesson 1 - Course Introduction

Lesson 2 - Data Analytics Overview

Lesson 3 - Dealing with Different Types of Data

Lesson 4 - Data Visualization for Decision making

Lesson 5 - Data Science, Data Analytics, and Machine Learning

Lesson 6 - Data Science Methodology

Lesson 7 - Data Analytics in Different Sectors

Lesson 8 - Analytics Framework and Latest trends

10 | www.simplilearn.com
 S
T
E
Statistics Essentials P
1
Statistics is the science of assigning a probability to an event based 2
on experiments. It is the application of quantitative principles to
the collection, analysis, and presentation of numerical data. Ace the 3
fundamentals of data science, statistics, and machine learning with this
course. It will enable you to define statistics and essential terms related to
4
it, explain measures of central tendency and dispersion, and comprehend 5
skewness, correlation, regression, and distribution. Additionally, you will
be able to make data-driven predictions through statistical inference. 6
7
Key Learning Objectives 8
Understand the fundamentals of statistics 9
Work with different types of data
10
Learn how to plot different types of data

Calculate the measures of central tendency, asymmetry, and variability

Calculate correlation and covariance

Distinguish and work with different types of distribution

Estimate confidence intervals

Perform hypothesis testing

Make data-driven decisions

Understand the mechanics of regression analysis

Carry out regression analysis

Use and understand dummy variables

Understand the concepts needed for data science, even with Python
and R

11 | www.simplilearn.com
Course curriculum
Lesson 1 - Introduction

Lesson 2 - Sample or Population Data?

Lesson 3 - The Fundamentals of Descriptive Statistics

Lesson 4 - Measures of Central Tendency, Asymmetry, and Variability

Lesson 5 - Practical Example: Descriptive Statistics

Lesson 6 - Distributions

Lesson 7 - Estimators and Estimates

Lesson 8 - Confidence Intervals: Advanced Topics

Lesson 9 - Practical Example: Inferential Statistics

Lesson 10 - Hypothesis Testing: Introduction

Lesson 11 - Hypothesis Testing: Let’s Start Testing!

Lesson 12 - Practical Example: Hypothesis Testing

Lesson 13 - The Fundamentals of Regression Analysis

Lesson 14 - Subtleties of Regression Analysis

Lesson 15 - Assumptions for Linear Regression Analysis

Lesson 16 - Dealing with Categorical Data

Lesson 17 - Practical Example: Regression Analysis

12 | www.simplilearn.com
 S
T
E
SQL Training P
1
This course gives you the information you need to successfully start 2
working with SQL databases and make use of the database in your
applications. Learn how to correctly structure your database, author 3
efficient SQL statements and clauses, and manage your SQL database for
scalable growth
4
5
Key Learning Objectives 6
Understand databases and relationships 7
Use common query tools and work with SQL commands 8
Understand transactions, creating tables and views 9
Comprehend and execute stored procedures
10

Course curriculum
Lesson 1- Fundamentals SQL Statements

Lesson 2-Restore and Back-up

Lesson 3-Selection Commands: Filtering

Lesson 4-Selection Commands: Ordering

Lesson 5-Alias

13 | www.simplilearn.com
 Lesson 6-Aggregate Commands

Lesson 7-Group By Commands

Lesson 8-Conditional Statement

Lesson 9-Joins

Lesson 10-Subqueries

Lesson 11-Views and Index

Lesson 12-String Functions

Lesson 13-Mathematical Functions

Lesson 14-Date - Time Functions

Lesson 15-Pattern (String) Matching

Lesson 16-User Access Control Functions

14 | www.simplilearn.com
 S
T
E
Business Analytics with Excel P
1
Business Analytics with Excel training will boost your analytics career 2
with powerful new Microsoft Excel skills. This business analytics training
course will equip you with the concepts and hard skills required for a 3
strong analytics career. You’ll learn the basic concepts of data analysis
and statistics, helping promote data-driven decision making. Your new
4
knowledge of this commonly used tool combined with official business 5
analytics certification is guaranteed to ensure career success.
6
Key Learning Objectives 7
Understand the meaning of business analytics and its importance in 8
the industry
9
Grasp the fundamentals of Excel analytics functions and conditional
formatting 10
Learn how to analyze with complex datasets using pivot tables and
slicers

Solve stochastic and deterministic analytical problems using tools like

scenario manager, solver, and goal seek

Apply statistical tools and concepts like moving average, hypothesis

testing, ANOVA, and regression to data sets using Excel

Represent your findings using charts and dashboards

Get introduced to the latest Microsoft analytic and visualization tools,

such as Power BI

15 | www.simplilearn.com
Course curriculum
Lesson 1- Introduction to Business Analytics

Lesson 2- Formatting Conditional Formatting and Important Functions

Lesson 3- Analysing Data with Pivot Tables

Lesson 4- Dashboarding

Lesson 5- Business Analytics with Excel

Lesson 6- Data Analysis Using Statistics

Lesson 7- Power BI

16 | www.simplilearn.com
 S
T
E
Tableau P
1
This Tableau course helps you understand how to build visualizations, 2
organize data, and design charts and dashboards to empower more
meaningful business decisions. You’ll be exposed to the concepts of Data 3
Visualization, different combo charts, and stories, working with filters,
parameters, and sets, and building interactive dashboards.
4
5
Key Learning Objectives 6
Become an expert on visualization techniques such as heat map, 7
treemap, waterfall, Pareto
8
Understand metadata and its usage

Work with Filter, Parameters, and Sets

9
Master special field types and Tableau-generated fields and the
10
process of creating and using parameters

Learn how to build charts, interactive dashboards, story interfaces,

and how to share your work

Master the concepts of data blending, create data extracts and

organize and format data

Master arithmetic, logical, table, and LOD calculations

17 | www.simplilearn.com
Course curriculum
Lesson 01 - Getting Started with Tableau

Lesson 02 - Core Tableau in Topics

Lesson 03 - Creating Charts in Tableau

Lesson 04 - Working with Metadata

Lesson 05 - Filters in Tableau

Lesson 06 - Applying Analytics to the worksheet

Lesson 07 - Dashboard in Tableau

Lesson 08 - Modifications to Data Connections

Lesson 09 - Introduction to Level of Details in Tableau (LODS)

18 | www.simplilearn.com
 S
T
E
Power BI P
1
Microsoft Power BI is a suite of tools used to analyze your data and 2
extract business insights by building interactive dashboards. This Power
BI Training course will help you get the most out of Power BI, enabling 3
you to solve business problems and improve operations.
4
5
This Power BI Training course will help you master the development of
dashboards from published reports, discover greater insight from your 6
data with Quick Insights, and learn practical recipes for the various
tasks that you can do with Microsoft Power BI—from gathering your 7
data to analyzing it. This course also contains some handy recipes for
8
troubleshooting various issues in Power BI.
9
Key Learning Objectives 10
Create dashboards from published reports

Quickly generate visuals and dashboards with Quick Insights

Use natural language in the Q&A feature to quickly generate visuals

for actionable insight

Create and manage data alerts

Get report layout and data visualization best practices

Understand which charts/graphs to use depending on the question

being answered or the story being told

Use shapes to design, emphasize, and tell a story

See how to incorporate custom visuals into your reports and

dashboards

19 | www.simplilearn.com
 Share reports and dashboards, as well as the pros and cons of each

Complete a Power BI data analysis/visual project from start to finish

Improve team collaboration with Microsoft Teams

Know how to get and prepare your data for analysis and visualization

Learn how to create relationships between tables in your data model

Create calculated columns and measures using the DAX languag

Course curriculum
Lesson 1 - Get and Prep Data like a Super Nerd

Lesson 2 - Develop Your Data Nerd Prowess

Lesson 3 - Developing Reports and Dashboards

Lesson 4 - Tips, Tricks, and Capstone Project

20 | www.simplilearn.com
 S
T
E
Programming Basics and Data Analytics P
with Python 1
2
Learn how to analyze data in Python using multi-dimensional arrays 3
in NumPy, manipulate DataFrames in Pandas, use the SciPy library of
mathematical routines, and perform machine learning using scikit-learn. 4
This course will take you from the basics of Python to the many different
types of data. You will learn how to prepare data for analysis, perform
5
simple statistical analyses, create meaningful data visualizations, predict 6
future trends from data, and more.
7
Key Learning Objectives 8
Import data sets 9
Clean and prepare data for analysis 10
Manipulate Pandas DataFrame

Summarize data

Build machine learning models using scikit-learn

Build data pipelines

21 | www.simplilearn.com
Course curriculum
Lesson 1 Course Introduction

Lesson 2 Python Environment Setup and Essentials

Lesson 3 Python Programming Fundamentals

Lesson 4 Data Analytics Overview

Lesson 5 Statistical Computing

Lesson 6 Mathematical Computing using NumPy

Lesson 7 Data Manipulation with Pandas

Lesson 8 Data visualization with Python

Lesson 9 Intro to Model Building

22 | www.simplilearn.com
 S
T
E
R Programming for Data Science P
1
Gain insight into the R programming language with this introductory 2
course. An essential programming language for data analysis, R
programming is a fundamental key to becoming a successful data science 3
professional. In this course, you will learn how to write R code, learn about
R’s data structures, and create your own functions. After the completion 4
of this course, you will be fully able to begin your first data analysis.
5
6
Key Learning Objectives
7
Learn about math, variables, strings, vectors, factors, and vector
operations 8
Gain a fundamental knowledge of arrays and matrices, lists, and data
frames
9
Get an understanding of conditions and loops, functions in R, objects,
10
classes, and debugging

Learn how to accurately read text, CSV, and Excel files plus how to
write and save data objects in R to a file

Understand and learn how to work on strings and dates in R

Course curriculum
Lesson 1 - R Basics

Lesson 2 - Data Structures in R

Lesson 3 - R Programming Fundamentals

Lesson 4 - Working with Data in R

Lesson 5 - Strings and Dates in R

23 | www.simplilearn.com
 S
T
E
Data Science with R P
1
The next step to mastering data science is learning R—the most in-
demand open source technology in the field. R is an extremely powerful
2
data science and analytics language which has a steep learning curve 3
and a very vibrant community. This is why it is quickly becoming the
technology of choice for organizations who are adopting the power of 4
analytics for a competitive advantage.
5
Key Learning Objectives
6
Gain a foundational understanding of business analytics
7
Install R, R-studio, and workspace setup and learn about the various R
8
packages
9
Master R programming and understand how various statements are
executed in R 10
Gain an in-depth understanding of data structure used in R and learn
to import/export data in R

Define, understand, and use the various apply functions and DPYR
functions

Understand and use the various graphics in R for data visualization

Gain a basic understanding of various statistical concepts

Understand and use hypothesis testing method to drive business

decisions

Understand and learn how to use linear and non-linear regression

models and classification techniques for data analysis

Learn and use the various association rules and Apriori algorithm

Learn and use clustering methods including K-means, DBSCAN, and

hierarchical clustering

24 | www.simplilearn.com
Course curriculum
Lesson 1 - Introduction to Business Analytics

Lesson 2 - Introduction to R Programming

Lesson 3 - Data Structures

Lesson 4 - Data Visualization

Lesson 5 - Statistics for Data Science-I

Lesson 6 - Statistics for Data Science-II

Lesson 7 - Regression Analysis

Lesson 8 - Classification

Lesson 9 - Clustering

Lesson 10 - Association

25 | www.simplilearn.com
 S
T
E
Data Analyst Capstone P
1
This Data Analyst Capstone project will give you an opportunity to
implement the skills you learned throughout this program. Through
2
dedicated mentoring sessions, you’ll learn how to solve a real-world, 3
industry-aligned data science problem, from data processing and model
building to reporting your business results and insights. This project is 4
the final step in the learning path and will enable you to showcase your
expertise in data analytics to future employers. 5
6
7
8
9
10

26 | www.simplilearn.com
Elective Course

Programming Refresher
Programming is an increasingly important skill and this
course will establish your proficiency in handling basic
programming concepts. This course will cover the basics
of Java, Python, and C++. By the end of this program,
you will gain context into object-oriented programming
and understand the basic programming concepts like
data types, variables, strings, loops, and functions and
also software engineering concepts like multithreading
and multitasking.

27 | www.simplilearn.com
Certificates

C E R T I F I C AT E
O F AC H I E V E M E N T

DATA ANALYST

T H I S I S T O C E R T I F Y T H AT

JOHN DOE
Has successfully graduated from the <Course Name> Masters
Program summa cum laude having completed all mandated course
requirements and industry projects with distinction.

Date: __ / __ /2020

Krishna Kumar, CEO

Upon completion of this Master’s Program, you will receive certificates from
IBM and Simplilearn in the Data Analyst courses in the learning path. These
certificates will testify to your skills as an expert in data analysis. Upon program
completion, you will also receive an industry-recognized Master’s Certificate
from Simplilearn.

28 | www.simplilearn.com
Classroom-Level Immersion:
Delivered Digitally

Anywhere
Anytime
Access Online Enrollment and
Access on Web and Mobile

Online
Self-Learning Learner Watches Chapter-End
the Video Quizzes

Live,
Interactive
Classes Live Virtual Live Interaction
Classroom and Mentoring

Hands-On
Experience Final Project Virtual
Assessment Work Labs

Simplilearn Certification Criteria

85% Course
Completion + 80% Score on
Simulation Exam

+
Internal, and
External Project Submitted
Certification and Accepted

Final Exam and

Certification

29 | www.simplilearn.com
Advisory board member

Ronald Van Loon

Top 10 Big Data & Data Science Influencer,
Director of Adversitement

Named by Onalytica as one of the three most

influential people in big data, Ronald is also an
author for a number of leading big data and
data science websites, including Datafloq, Data
Science Central, and The Guardian. He also
regularly speaks at renowned events.

30 | www.simplilearn.com
Corporate Training

Top clients we work with:

Features of Corporate Training:

Tailored learning solutions

Flexible pricing options

Enterprise-grade learning management system (LMS)

Enterprise dashboards for individuals and teams

24X7 learner assistance and support

31 | www.simplilearn.com
USA

Simplilearn Americas, Inc.

201 Spear Street, Suite 1100, San Francisco, CA 94105
United States
Phone No: +1-844-532-7688

INDIA

Simplilearn Solutions Pvt Ltd.

# 53/1 C, Manoj Arcade, 24th Main, Harlkunte
2nd Sector, HSR Layout
Bangalore - 560102
Call us at: 1800-212-7688

www.simplilearn.com