edureka!

edureka!
Discover Learning

Data Analytics Masters Program

About Edureka
Edureka is one of the world’s largest and most effective online education platform for
technology professionals. In a span of 10 years, 100,000+ students from over 176 countries
have upskilled themselves with the help of our online courses. Since our inception, we have
been dedicated to helping technology professionals from all corners of the world learn
Programming, Data Science, Big Data, Cloud Computing, DevOps, Business Analytic, Java &
Mobile Technologies, Software Testing, Web Development, System Engineering, Project
Management, Digital Marketing, Business Intelligence, Cybersecurity, RPA and more.
We have an easy and affordable learning solution that is accessible to millions of learners. With
our learners spread across countries like the US, India, UK, Canada, Singapore, Australia, Middle
East, Brazil, and many others, we have built a community of over 1 million learners across the
globe.

About the Program

Edureka's Data Analytics Masters program, curated by industry experts, imparts a profound
understanding of data analytics principles and practices. You'll gain hands-on proficiency in
Python Programming, Statistical Analysis, Probability, Exploratory Analysis, Data Visualization,
Querying Data, Data Modeling, and delve into advanced topics like Data Visualization with
Tableau and Reporting using Microsoft Power BI, enriching your skill set. Our meticulously
designed curriculum equips you with the skills to excel as a data analyst. Enroll today to unlock
the potential of data analytics and accelerate your career in this thriving industry.

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

Index
1 Python Certification Training Course
2 Tableau Certification Training Course
3 Microsoft Power BI Certification Training Course
4 Statistics Essentials for Analytics (Self-paced)
5 Data Analytics with R Programming Certification Training (Self-paced)
6 AWS Data Analytics Course (Self-paced)

*Depending on industry requirements, Edureka may make changes to the course curriculum

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

edureka!
Discover Learning

Index
Python Certification Training Course
Course Curriculum

Course Outline

Module 1: Introduction to Python

Topics:

• Need for programming

• Advantages of programming
• Overview of python
• Organizations using python
• Python Applications in various domains
• Variables
• Operands and expressions
• Conditional statements
• Loops
• Structural pattern matching

Module 2: Sequences and File Operations

Topics:

• Accepting user input and eval function

• Files input/output functions
• Lists

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Tuples
• Strings manipulation
• Sets and set operations
• Python dictionary

Module 3: Functions and Object-oriented Programming

Topics:

• User-defined functions
• Function parameters
• Different types of arguments
• Global variables
• Global keyword
• Lambda functions
• Built-in functions
• Object-oriented concepts
• Public, protected and private attributes
• Class variable and instance variable
• Constructor and destructor
• Inheritance and its types
• Method resolution order
• Overloading and overriding
• Getter and setter methods

Module 4: Working with Modules and Handling Exceptions

Topics:

• Standard libraries
• Packages and import statements

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Reload function
• Creating a module
• Important modules in python
• Sys module
• OS module
• Math module
• Date-time module
• Random module
• JSON module
• Regular expression
• Exception handling

Module 5: Array Manipulation using NumPy

Topics:

• Basics of data analysis

• NumPy - Arrays
• Array operations
• Indexing, slicing, and Iterating
• NumPy array attributes
• Matrix product
• NumPy functions
• Array manipulation
• File handling using NumPy

Module 6: Data Manipulation using Pandas

Topics:

• Basics of data analysis

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• NumPy - Arrays
• Array operations
• Indexing, slicing, and Iterating
• NumPy array attributes
• Matrix product
• NumPy functions
• Array manipulation
• File handling using NumPy

Module 7: Data Visualization using Matplotlib and Seaborn

Topics:

• Why data visualization?

• Matplotlib library
• Seaborn
• Line plots
• Multiline plots
• Bar plot
• Histogram
• Pie chart
• Scatter plot
• Boxplot
• Saving charts
• Customizing visualizations
• Saving plots
• Grids
• Subplots
• Heatmaps

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

Module 8: GUI Programming

Topics:

• Ipywidgets package
• Numeric widgets
• Boolean widgets
• Selection widgets
• String widgets
• Date picker
• Color picker
• Container widgets
• Creating a GUI application

Module 9: Developing Web Maps and Representing Information using Plots (Self-paced)

Topics:

• Use of Folium library

• Use of Pandas library
• Flow Chart of web map application
• Developing web map using Folium and Pandas
• Reading Information from titanic dataset and represent It using plots

Module 10: Web Scraping and Computer Vision using OpenCV (Self-paced)

Topics:

• Beautiful Soup library

• Scrapy
• Requests library
• Scrap All hyperlinks from a webpage using Beautiful Soup and Requests

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Plotting charts using Bokeh

• Plotting scatterplots using Bokeh
• Image editing using OpenCV
• Face detection using OpenCV
• Motion detection and capturing video

Module 11: Database Integration with Python (Self-paced)

Topics:

• Basics of database management

• Python MySql
• Create database
• Create a table
• Insert into table
• Select query
• Where clause
• OrderBy clause
• Delete query
• Drop table
• Update query
• Limit clause
• Join and Self-Join
• MongoDB (Unstructured)
• Insert_one query
• Insert_many query
• Update_one query
• Update_many query
• Create_index query
• Drop_index query

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Delete and drop collections

• Limit query

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

edureka!
Discover Learning

Tableau Certification Training Course

*Depending on industry requirements, Edureka may make changes to the course curriculum

Course Curriculum

Course Outline

Module 1: Data Preparation using Tableau Prep

Topics:

• Data Visualization

• Business Intelligence tools

• Introduction to Tableau

• Tableau Architecture

• Tableau Server Architecture

• VizQL

• Introduction to Tableau Prep

• Tableau Prep Builder User Interface

• Data Preparation techniques using Tableau Prep Builder tool

Module 2: Data Connection with Tableau Desktop

Topics:

• Features of Tableau Desktop

• Connect to data from File and Database

• Types of Connections

• Joins and Unions

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Data Blending

• Tableau Desktop User Interface

• Basic project: Create a workbook and publish it

Module 3: Basic Visual Analytics

Topics:

• Visual Analytics

• Basic Charts: Bar Chart, Line Chart, and Pie Chart

• Hierarchies

• Data Granularity

• Highlighting

• Sorting

• Filtering

• Grouping

• Sets

Module 4: Calculations in Tableau

Topics:

• Types of Calculations

• Built-in Functions (Number, String, Date, Logical and Aggregate)

• Operators and Syntax Conventions

• Table Calculations

• Level Of Detail (LOD) Calculations

• Using R within Tableau for Calculations

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

Module 5: Advanced Visual Analytics

Topics:

• Parameters

• Tool tips

• Trend lines

• Reference lines

• Forecasting

• Clustering

Module 6: Level Of Detail (LOD) Expressions In Tableau

Topics:

• Use Case I - Count Customer by Order

• Use Case II - Profit per Business Day

• Use Case III - Comparative Sales

• Use Case IV - Profit Vs Target

• Use Case V - Finding the second order date.

• Use Case VI - Cohort Analysis

Module 7: Geographic Visualizations in Tableau

Topics:

• Introduction to Geographic Visualizations

• Manually assigning Geographical Locations

• Types of Maps

• Spatial Files

• Custom Geocoding

• Polygon Maps

• Web Map Services

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Background Images

Module 8: Advanced Charts in Tableau

Topics:

• Box and Whisker’s Plot

• Bullet Chart

• Bar in Bar Chart

• Gantt Chart

• Waterfall Chart

• Pareto Chart

• Control Chart

• Funnel Chart

• Bump Chart

• Step and Jump Lines

• Word Cloud

• Donut Chart

Module 9: Dashboards and Stories

Topics:

• Introduction to Dashboards

• The Dashboard Interface

• Dashboard Objects

• Building a Dashboard

• Dashboard Layouts and Formatting

• Interactive Dashboards with actions

• Designing Dashboards for devices

• Story Points

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

Module 10: Get Industry Ready

Topics:

• Tableau Tips and Tricks

• Choosing the right type of Chart

• Format Style

• Data Visualization best practices

• Prepare for Tableau Interview

Module 11: Exploring Tableau Online

Topics:

• Publishing Workbooks to Tableau Online

• Interacting with Content on Tableau Online

• Data Management through Tableau Catalog

• AI-Powered features in Tableau Online (Ask Data and Explain Data)

• Understand Scheduling

• Managing Permissions on Tableau Online

• Data Security with Filters in Tableau Online

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

edureka!
Discover Learning
*Depending on industry requirements, Edureka may make changes to the course curriculum

Microsoft Power BI Certification

Training Course
Course Curriculum

Course Outline

Module 1: Introduction to Power BI

Topics

• Introduction to Business Intelligence

• Self-Service Business Intelligence (SSBI)
• Introduction to Power BI
• Traditional BI vs. Power BI
• Power BI vs. Tableau vs. QlikView
• Uses of Power BI
• The Flow of Work in Power BI
• Working with Power BI
• Basic Components of Power BI
• Comparison of Power BI Version
• Introduction to Building Blocks of Power BI
• Data model and importance of Data Modeling

Module 2: Power BI Desktop and Data Transformation

Topics

• Data Sources in Power BI Desktop

• Loading Data in Power BI Desktop

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Views in Power BI Desktop

• Query Editor in Power BI
• Transform, Clean, Shape, and Model Data
• Manage Data Relationship
• Editing a Relationship
• Cross Filter Direction
• Saving Workfile
• Measures

Module 3: Data Analysis Expression (DAX)

Topics:

• Introduction to DAX
• Importance of DAX
• Data Types in DAX
• DAX Operators
• DAX Calculation Types
• Steps to Create Calculated Columns
• Steps to Create Calculated Tables
• Measures in DAX
• DAX Syntax
• DAX Functions
• DAX Tables and Filtering

Module 4: Data Visualization

Topics:

• Introduction to Visuals In Power BI

• Visualization Charts in Power BI

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Matrixes and Tables

• Slicers and Map Visualizations
• Gauges and Single Number Cards
• Modifying Colors in Charts And Visuals
• Shapes, Text Boxes, and Images
• Custom Visuals
• Page Layout and Formatting
• Bookmarks and Selection Pane
• KPI Visuals
• Z-order
• Grouping and Binning

Module 5: Power BI Service

Topics:

• Introduction to Power BI Service

• Creating a Dashboard
• Quick Insights in Power BI
• Configuring a Dashboard
• Power BI Q&A
• Ask Questions about your Data
• Power BI Embedded
• Bookmarks and buttons

Module 6: Connectivity Modes

Topics:

• Data Sources Supported in Power BI

• Exploring Live Connections to Data Sources

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Connecting Directly to SQL Azure

• Connecting Directly to SQL Server Analysis Services/My SQL
• Import Power View and Power Pivot
• Data Gateways
• Direct Query vs. Import Connectivity modes
• Connecting Power BI in Excel

Module 7: Power BI Report Server

Topics:

• What is Power BI Report Server?

• Key Features of Report Server
• The architecture of the Report Server
• Limitations of Report Server
• Power BI Report Server vs. Power BI Service
• Acquiring and Installing Power BI Report Server
• What is a Web Portal?
• Paginated Reports
• Row Level Security

Module 8: R & Python in Power BI

Topics:

• Brief concepts about R

• R Programming Concepts
• Create R Scripts for BI
• Python Programming
• Python Scripts in BI
• Python integration with Power BI

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

Module 9: Advance Analytics in Power BI

Topics:

• Use Parameters
• Create a data flow
• Introduction to Anomaly Detection
• Introduction to Smart Narrative
• Introduction to Sensitivity labels in Power BI
• Deployment Pipeline
• Hands-on:
• Connecting with Power BI service
• Creating Data flow
• Creating scorecard

Module 10: In-Class Project

Industry - 1: Retail Sector
Problem Statement:
Global Super Store is an online supergiant store that has worldwide operations. This store takes
orders, delivers products across the globe, and deals with all the major product categories like
furniture, office supplies & technology. As a sales manager for this store, you want to analyze
the sales of the products based on provided historical data; this analysis will help you to plan
your inventory and business processes accordingly. Also, to know the products & customers
behavior.

Topics:

• Power BI Service
• Row Level Security
• Visuals and Charts
• Power BI Desktop
• Handling Workspaces

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

Industry - 2: Sales and Finance

Problem Statement:
PEW Retail Inc. Ltd has subsidiaries across the globe, and they sell products to various
customers scattered in a different geography. They are looking to have a consolidated
dashboard.
Topics:

• Power BI Gateway
• Power BI Service
• Data Visualization
• Dashboard Management

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

edureka!
Discover Learning

Statistics Essentials
• Vectors, forusingAnalytics
and how to build them (Self
Arrays and Linked Lists -paced)
with Pointers

Course Curriculum

Course Outline

Module 1: Understanding the Data

Topics:

• Introduction to Data Types

• Numerical parameters to represent data.
a. Mean
b. Mode
c. Median
d. Sensitivity
e. Information Gain
f. Entropy
• Statistical parameters to represent data.

Module 2: Probability and its uses

Topics:

• Uses of probability
• Need of probability
• Bayesian Inference
• Density Concepts

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Normal Distribution Curve

Module 3: Statistical Inference

Topics:

• Point Estimation
• Confidence Margin
• Hypothesis Testing
• Levels of Hypothesis Testing

Module 4: Data Clustering

Topics:

• Association and Dependence

• Causation and Correlation
• Covariance
• Simpson’s Paradox
• Clustering Techniques

Module 5: Testing the Data

Topics:

• Parametric Test
• Parametric Test Types
• Non- Parametric Test
• Experimental Designing
• A/B testing

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

Module 6: Regression Modelling

Topics:

• Logistic and Regression Techniques

• Problem of Collinearity
• WOE and IV
• Residual Analysis
• Heteroscedasticity
• Homoscedasticity

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

edureka!
Discover Learning

Data Analytics with R programming Certification

*Depending on industry requirements, Edureka may make changes to the course curriculum

Training (Self-paced)
Course Curriculum

Course Outline

Module 1: Introduction to Data Analytics

Topics:

• Introduction to terms Business Intelligence, Business Analytics, Data, Information

• How information hierarchy can be improved/introduced

• Understanding Business Analytics and R

• Knowledge about the R language, its community, and its ecosystem.

• Understand the use of 'R' in the industry

• Compare R with other software in analytics

• Install R and the packages useful for the course

• Perform basic operations in R using the command line

• Learn the use of IDE R Studio and Various GUI

• Use the ‘R help’ feature in R

• Knowledge about the worldwide R community collaboration

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

Module 2: Introduction to R Programming

Topics:

• Various kinds of data types in R and their appropriate uses

• Built-in functions in R like seq(), cbind (), rbind(), merge().

• Knowledge of the various subsetting methods

• Summarize data by using functions like: str(), class(), length(), nrow(), ncol()

• Use of functions like head(), tail() for inspecting data

• Indulge in a class activity to summarize data

• dplyr package to perform SQL join in R

Module 3: Data Manipulation in R

Topics:

• Steps involved in Data Cleaning,

• Functions used in Data Inspection,

• Tackling the problems faced during Data Cleaning,

• Uses of the functions like grepl(), grep(), sub(), Coerce the data, uses of the apply()
functions

Module 4: Data Imports Techniques in R

Topics:

• Import data from spreadsheets and text files into R

• Import data from other statistical formats like sas7bdat and spss, packages

• Installation used for database import,

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Connect to RDBMS from R using ODBC

• Basic SQL queries in R

• Basics of Web Scraping

Module 5: Exploratory Data Analysis

Topics:

• Exploratory Data Analysis(EDA)

• Implementation of EDA on various datasets,

• Boxplots.

• Understanding the cor() in R,

• EDA functions like summarize(), llist(),

• Multiple packages in R for data analysis,

• Fancy plots like the Segment plot, and HC plot in R

Module 6: Data Visualization in R

Topics:

• Data Visualization

• Graphical functions present in R

• Plot various graphs like tableplot, histogram, and Boxplot

• Customizing Graphical Parameters to improvise plots

• Understanding GUIs like Deducer and R Commander

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Introduction to Spatial Analysis

Module 7: Data Mining: Clustering Techniques

Topics:

• Introduction to Data Mining

• Understanding Machine Learning

• Supervised and Unsupervised Machine Learning Algorithms

• K-means Clustering

Module 8: Data Mining-Association Rule Mining and Collaborative Filtering

Topics:

• Association Rule Mining

• User Based Collaborative Filtering (UBCF)

• Item Based Collaborative Filtering (IBCF)

Module 9: Linear and Logistic Regression

Topics:

• Linear Regression

• Logistic Regression

Module 10: Anova and Sentiment Analysis

Topics:

• Analysis of Variance (Anova) Technique

• Sentiment Analysis: fetch, extract and mine live data from Twitter

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

Module 11: Decision Trees and Random Forest

Topics:

• Decision Tree

• Entropy

• Gini Index

• Pruning and Information Gain

• Algorithm for creating Decision Trees

• Bagging of Regression and Classification Trees,

• Random Forest,

• Working on Random Forest,

• Features of Random Forest, among others

Module 12: Decision Trees and Random Forest

Topics:

• Analyze census data to predict insights on the income of the people based on the
factors like age, education, work class, and occupation using Decision Trees,

• Logistic Regression and Random Forest.

• Analyze the Sentiment of Twitter data, where the data to be analyzed is streamed live
from Twitter, and sentiment analysis is performed on the same.

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

edureka!
Discover Learning

AWS Data Analytics Course (Self-paced)

Course Curriculum

Course Outline

Module 1: AWS Storage Services

Topics:
• Traditional Storage
• Need to Move to Cloud Storage
• Traditional vs. Cloud Storage Cost
• Cloud Storage
• Different Storage Options Available on AWS
• Simple Storage Service (S3) and Its Components
• Working of S3
• Bucket Policy
• Access Control List (ACL)
• Versioning
• S3 Replicate
• Cross-Region Replication (CRR) and Its Use Case
• Amazon S3 Transfer Acceleration
• Choice of Storage Classes on S3
• Lifecycle Policy of S3 Bucket
• AWS Backup

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• Storage Gateway

Module 2: AWS Database Services - Part I

Topics:
• Database
• AWS Database Services – Use Cases
• Amazon RDS
• Read Replica
• IAM in Amazon RDS
• Difference Between SQL and NoSQL Databases
• Amazon DynamoDB and its Data Structure

Module 3: AWS Database Services - Part II

Topics:
• Amazon ElastiCache
• Memcached vs. Redis
• Aurora Database
• Connection Management in Aurora
• Amazon Aurora Reliability
• Amazon Aurora Global Database
• Amazon Aurora Serverless
• Amazon Keyspaces
• Apache Cassandra

Module 4: Data Warehousing and Big Data Processing on AWS

Topics:

• Amazon RedShift and its features

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.

 edureka!

• AWS Redshift Architecture

• Introduction to Amazon EMR (Elastic MapReduce)
• How to use Amazon Elastic MapReduce (EMR)?
• AWS Lake Formation

Module 5: Data Analytics using AWS

Topics:
• What is Cloud Analytics?
• AWS Analytics Services
• Amazon Athena
• Amazon Kinesis
• Visualize Web Traffic Using Kinesis Data Stream

Module 6: Data Visualization using AWS

Topics:

• Amazon Elasticsearch (OpenSearch)

• Amazon QuickSight
• AWS Glue

www.edureka.co © Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.