🎄 Special Offer! 🎅🎁 Flat 40% OFF on all courses!
All Courses
Programming Courses
Python Certification Training Course
Trending
Python Django Certification Training Course
Node.js Certification Training Course
Java Certification Training Course
Best Seller
Spring Framework Certification Training Course
Spring Boot Certification Training Course
Trending
Hibernate Certification Training Course
Microsoft .NET Framework Certification Training Course
Data Analytics Certification Training Course
Trending
PHP MYSQL with MVC Certification Training Course
Advanced Java Certification Training
Go Language Certification Training
Flutter Certification Training
Get your free demo class
Call Us
Master Program
Full Stack Certification Training Course
Trending
DevOps Master Program Certification Training Course
New
Cloud Masters Program Certification Training Course
Popular
Data Science Master Program Certification Training Course
Popular
Software Testing Master Program Certification Training Course
Get your free demo class
Call Us
Cloud Computing
AWS Solution Architect Associate Certification Training
Trending
AWS Certified DevOps Engineer Professional Training
Popular
AWS Development Certification Training Course
New
Microsoft Azure Certification Training Course (AZ-104 & AZ-304)
Microsoft Azure DevOps Certification Training Course (AZ-400)
Microservices Certification Training Course
Salesforce Developer Certification Training Course
Salesforce Administrator Certification Training Course
Linux Certification Training Course
Get your free demo class
Call Us
DevOps
DevOps Certification Training Course
Trending
Kubernetes Certification Training Course
Docker Certification Training Course
Ansible Certification Training Course
Chef Certification Training Course
GIT Certification Training Course
DevSecOps Certification Training Course in Bangalore
Get your free demo class
Get now
Data science
DataScience with Python Certification Training Course
Best Seller
Machine Learning Certification Training Course
Deep Learning Certification Training Course
(AI) Artificial Intelligence Certification Training Course
Trending
Get your free demo class
Call Us
Big Data
Big Data Hadoop Certification Training Course
Trending
Apache Spark and Scala Certification Training Course
Apache Kafka Certification Training Course
Best Seller
Get Your Free Demo Class
Call Us
Software Testing
Selenium Certification Training Course
Trending
Selenium with Python Certification Training Course
New
Selenium with C# Certification Training Course
Manual Testing Certification Training Course
Get your free demo class
Call Us
Robotic Process Automation
RPA using UiPath Certification Training Course
Trending
RPA using Automation Anywhere Certification Training Course
RPA using Blue Prism Certification Training Course
Get your free demo class
Call Us
Frontend Development
Angular Certification Training Course
Trending
React JS Certification Training Course
Best Seller
Web Development Certification Training Course
MERN Stack Certification Training Course
Get your free demo class
Call Us
Databases
MySQL Certification Training Course
Oracle Certification Training Course
MongoDB Certification Training Course
Trending
Get your free demo class
Call Us
Mobile Development
Android Certification Training Course
Trending
Get your free demo class
Call Us
Home
Courses
Programming & Frameworks
DevOps
Data Science
Cloud Computing
Robotic Process Automation
Software Testing
Frontend Development
Master Program
Databases
Big Data
Mobile Development
About
FAQs
Blog
Gallery
Contact
X
Contact Us
Data Analytics Certification Training Course
Curriculum
18 Sections
307 Lessons
75 Days
Expand all sections
Collapse all sections
Introduction to Statistical Analysis
15
1.1
Introduction to Probability
1.2
Probability Addition Rule
1.3
Probability Multiplication Rule
1.4
Distributions
1.5
Correlation
1.6
Regression
1.7
Hypothesis Testing
1.8
ANOVA and Chi-Square Tests
1.9
Data Cleaning
1.10
Imputation Techniques
1.11
Measure Of central tendency, Measures of Dispersion
1.12
Graphical Techniques, Skewness & Kurtosis, Box Plot
1.13
Descriptive Stats
1.14
Central Limit Theorem, Confidence interval
1.15
Hands-On
Introduction to Data Analytics
10
2.1
Data Analytics Overview
2.2
Importance of Data Analytics
2.3
Types of Data Analytics
2.4
Descriptive Analytics
2.5
Diagnostic Analytics
2.6
Predictive Analytics
2.7
Prescriptive Analytics
2.8
Benefits of Data Analytics
2.9
Data Visualization for Decision Making
2.10
Hands-On
Excel: Basics to Advanced
82
3.1
Excel tutorial
3.2
Text to Columns
3.3
Concatenate
3.4
The Concatenate Function
3.5
The Right Function with Concatenation
3.6
Absolute Cell References
3.7
Data Validation
3.8
Time and Date Calculations
3.9
Conditional Formatting
3.10
Exploring Styles and Clearing Formatting
3.11
Using Conditional Formatting to Hide Cells
3.12
Using the IF Function
3.13
Changing the “Value if false” Condition to Text
3.14
Pivot Tables
3.15
Creating a Pivot Table
3.16
Specifying PivotTable Data
3.17
Changing a PivotTables Calculation
3.18
Filtering and Sorting a PivotTable
3.19
Creating a PivotChart
3.20
Grouping Items
3.21
Updating a PivotTable
3.22
Formatting a PivotTable
3.23
Using Slicers
3.24
Charts
3.25
Creating a Simple Chart
3.26
Charting Non-Adjacent Cells
3.27
Creating a Chart Using the Chart Wizard
3.28
Modifying Charts
3.29
Moving an Embedded Chart
3.30
Sizing an Embedded Chart
3.31
Changing the Chart Type
3.32
Chart Types
3.33
Changing the Way Data is Displayed
3.34
Moving the Legend
3.35
Formatting Charts
3.36
Adding Chart Items
3.37
Formatting All Text
3.38
Formatting and Aligning Numbers
3.39
Formatting the Plot Area
3.40
Formatting Data Markers
3.41
Pie Charts
3.42
Creating a Pie Chart
3.43
Moving the Pie Chart to its Own Sheet
3.44
Adding Data Labels
3.45
Exploding a Slice of a Pie Chart
3.46
Data Analysis − Overview
3.47
types of Data Analysis
3.48
Data Analysis Process
3.49
Working with Range Names
3.50
Copying Name using Formula Autocomplete
3.51
Range Name Syntax Rules
3.52
Creating Range Names
3.53
Creating Names for Constants
3.54
Managing Names
3.55
Scope of a Name
3.56
Editing Names
3.57
Applying Names
3.58
Using Names in a Formula
3.59
Viewing Names in a Workbook
3.60
Copying Formulas with Names
3.61
Difference between Tables and Ranges
3.62
Create Table
3.63
Table Name
3.64
Managing Names in a Table
3.65
Table Headers replacing Column Letters
3.66
Propagation of a Formula in a Table
3.67
Resize Table
3.68
Remove Duplicates
3.69
Convert to Range
3.70
Table Style Options
3.71
Table Styles
3.72
Cleaning Data with Text Functions
3.73
Removing Unwanted Characters from Text
3.74
Extracting Data Values from Text
3.75
Formatting Data with Text Functions
3.76
Date Formats
3.77
Conditional Formatting
3.78
Sorting
3.79
Filtering
3.80
Lookup Functions
3.81
Pivoting
3.82
Hands-On
SQL
14
4.1
Fundamentals of SQL Syntax and Statements
4.2
Data Filtering and Sorting Techniques
4.3
Utilization of Single-Row Functions
4.4
Aggregate and Group Functions
4.5
Analytical (Window) Functions
4.6
Data Definition Language (DDL) – Creating and Managing Schema Objects
4.7
Data Manipulation Language (DML) – Inserting, Updating, and Deleting Data
4.8
Implementation of Data Constraints
4.9
Set Operations – UNION, INTERSECT, and MINUS
4.10
Subqueries and Nested Queries
4.11
Joins and Multi-Table Queries
4.12
Transaction Control Language (TCL) – COMMIT, ROLLBACK, SAVEPOINT
4.13
Data Control Language (DCL) – GRANT and REVOKE Permissions
4.14
Hands-On
Tableau Course Material
11
5.1
Start Page
5.2
Show Me
5.3
Connecting to Excel Files
5.4
Connecting to Text Files
5.5
Connect to Microsoft SQL Server
5.6
Connecting to Microsoft Analysis Services
5.7
Creating and Removing Hierarchies
5.8
Bins
5.9
Joining Tables
5.10
Data Blending
5.11
Hands-On
Learn Tableau Basic Reports
12
6.1
Parameters
6.2
Grouping Example 1
6.3
Grouping Example 2
6.4
Edit Groups
6.5
Set
6.6
Combined Sets
6.7
Creating a First Report
6.8
Data Labels
6.9
Create Folders
6.10
Sorting Data
6.11
Add Totals, Sub Totals and Grand Totals to Report
6.12
Hands-On
Learn Tableau Charts
28
7.1
Area Chart
7.2
Bar Chart
7.3
Box Plot
7.4
Bubble Chart
7.5
Bump Chart
7.6
Bullet Graph
7.7
Circle Views
7.8
Dual Combination Chart
7.9
Dual Lines Chart
7.10
Funnel Chart
7.11
Traditional Funnel Charts
7.12
Gantt Chart
7.13
Grouped Bar or Side by Side Bars Chart
7.14
Heatmap
7.15
Highlight Table
7.16
Histogram
7.17
Cumulative Histogram
7.18
Line Chart
7.19
Lollipop Chart
7.20
Pareto Chart
7.21
Pie Chart
7.22
Scatter Plot
7.23
Stacked Bar Chart
7.24
Text Label
7.25
Tree Map
7.26
Word Cloud
7.27
Waterfall Chart
7.28
Hands-On
Learn Tableau Advanced Reports
12
8.1
Dual Axis Reports
8.2
Blended Axis
8.3
Individual Axis
8.4
Add Reference Lines
8.5
Reference Bands
8.6
Reference Distributions
8.7
Basic Maps
8.8
Symbol Map
8.9
Use Google Maps
8.10
Mapbox Maps as a Background Map
8.11
WMS Server Map as a Background Map
8.12
Hands-On
Learn Tableau Calculations & Filters
15
9.1
Calculated Fields
9.2
Basic Approach to Calculate Rank
9.3
Advanced Approach to Calculate Ra
9.4
Calculating Running Total
9.5
Filters Introduction
9.6
Quick Filters
9.7
Filters on Dimensions
9.8
Conditional Filters
9.9
Top and Bottom Filters
9.10
Filters on Measures
9.11
Context Filters
9.12
Slicing Filters
9.13
Data Source Filters
9.14
Extract Filters
9.15
Hands-On
Learn Tableau Dashboards
7
10.1
Create a Dashboard
10.2
Format Dashboard Layout
10.3
Create a Device Preview of a Dashboard
10.4
Create Filters on Dashboard
10.5
Dashboard Objects
10.6
Create a Story
10.7
Hands-On
Server
4
11.1
Tableau online
11.2
Overview of Tableau Server
11.3
Publishing Tableau objects and scheduling/subscription
11.4
Hands-On
Introduction to Power BI
11
12.1
Get Started with Power BI
12.2
Overview: Power BI concepts
12.3
Sign up for Power BI
12.4
Overview: Power BI data sources
12.5
Connect to a SaaS solution
12.6
Upload a local CSV file
12.7
Connect to Excel data that can be refreshed
12.8
Connect to a sample
12.9
Create a Report with Visualizations
12.10
Explore the Power BI portal
12.11
Hands-On
Viz and Tiles
11
13.1
Overview: Visualizations
13.2
Using visualizations
13.3
Create a new report
13.4
Create and arrange visualizations
13.5
Format a visualization
13.6
Create chart visualizations
13.7
Use text, map, and gauge visualizations and save a report
13.8
Use a slicer to filter visualizations
13.9
Sort, copy, and paste visualizations
13.10
Download and use a custom visual from the gallery
13.11
Hands-On
Reports and Dashboards
21
14.1
Modify and Print a Report
14.2
Rename and delete report pages
14.3
Add a filter to a page or report
14.4
Set visualization interactions
14.5
Print a report page
14.6
Send a report to PowerPoint
14.7
Create a Dashboard
14.8
Create and manage dashboards
14.9
Pin a report tile to a dashboard
14.10
Pin a live report page to a dashboard
14.11
Pin a tile from another dashboard
14.12
Pin an Excel element to a dashboard
14.13
Manage pinned elements in Excel
14.14
Add a tile to a dashboard
14.15
Build a dashboard with Quick Insights
14.16
Set a Featured (default) dashboard
14.17
Ask Questions about Your Data
14.18
Ask a question with Power BI Q&A
14.19
Tweak your dataset for Q&A
14.20
Enable Cortana for Power BI
14.21
Hands-On
Publishing Workbooks and Workspace
10
15.1
Share Data with Colleagues and Others
15.2
Publish a report to the web
15.3
Manage published reports
15.4
Share a dashboard
15.5
Create an app workspace and add users
15.6
Publish an app
15.7
Use an app workspace
15.8
Create a QR code to share a tile
15.9
Embed a report in SharePoint Online
15.10
Hands-On
Other Power BI Components and Table Relationship
14
16.1
Use Power BI Mobile Apps
16.2
Get Power BI for mobile
16.3
View reports and dashboards in the iPad app
16.4
Use workspaces in the mobile app
16.5
Use Power BI Desktop
16.6
Sharing from Power BI Mobile
16.7
Install and launch Power BI Desktop
16.8
Get data
16.9
Reduce data
16.10
Transform data
16.11
Relate tables
16.12
Get Power BI Desktop data with the Power BI service
16.13
Export a report from Power BI service to Desktop
16.14
Hands-On
DAX functions
10
17.1
New Dax functions
17.2
Date and time functions
17.3
Time intelligence functions
17.4
Filter functions
17.5
Information functions
17.6
Logical functions
17.7
Math & trig functions
17.8
Parent and child functions
17.9
Text functions
17.10
Hands-On
Python Basics
20
18.1
Python Installation and Environment Setup
18.2
Python Syntax and Code Structure
18.3
Variables and Data Types
18.4
Operators and Expressions
18.5
Conditional Statements (if, else, elif)
18.6
Looping Constructs (for, while)
18.7
Data Handling & Analysis in Python (For Data Analysts)
18.8
Introduction to NumPy for Numerical Operations
18.9
Data Manipulation with Pandas
18.10
Series and DataFramesData Selection and Filtering
18.11
Handling Missing DataData Aggregation and Grouping
18.12
Merging, Joining, and Concatenating DataFrames
18.13
Reading and Writing Data Files
18.14
CSV, Excel
18.15
Data Cleaning Techniques
18.16
Duplicates, Outliers
18.17
Exploratory Data Analysis (EDA) with Pandas
18.18
Data Visualization Basics
18.19
Using Matplotlib and Seaborn
18.20
Hands-On
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content