Course Content
Real-Time End-to-End Data Analytic Project Pipelines
0/6
Project-1: Star Schema Data Model using SQL & Data Retrieval
Project-2: Data Ingestion into Python, ETL in Python & Storing in Data Warehouse & Analysis in Power BI/Tableau
Project-3: KPI Identification, Dashboard Creation with KPIs & Dashboard Deployment with Automatic Data Refresh
Project-4: ETL, SnowFlake DataWareHouse & Power BI KPI Dashboard Project Pipeline with Deployment
Project-5: End-to-End Data Analytics Project using Python
Project-6: End-to-End Statistics & Forecasting Based Data Analytics Project Using Python
Introduction to Data Analytics, Data Science, AI & ML
0/2
What is Data Analytics, Data Science, AI & ML
02:01:30
Interview Preparation Roadmap on Data Analytics, Data Science, AI & ML
01:26:51
Applied Statistics
Statistics is very important for Data Analyst & Data Scientist job positions. We will be discussing Applied Statistics and How we use them in Real-time with proper Pros and Cons behind every Statistics Topic with Mindmap Driven Approach.
0/43
What is Data, What is Random Variable, Types of Data?
01:08:31
Probability Distributions and Normal Distribution
01:29:44
Introduction to Statistics
Properties of Data
Sample vs Population
Types of Sampling Techniques
What is EDA
Analysing Data using EDA with Excel
Measures of Dispersion
Skewness & Normality
Correlation & Scatterplot
Barplot & Lineplot
Revision of Topics
Box & Whisker Plot
Outlier Identification
Treating Outliers
Types of Analytics
Statistical Analysis Consideration
Introduction to Inferential Statistics
Law of Large Numbers
Central Limit Theorem
Probability Distributions
Conditional Probability
Continuous Probability Distribution & Discrete Probability Distribution
PMF, CDF, PDF, PPF in Probability
Binomial Distribution
Poisson Distribution
Normal Distribution
Exponential Distribution
Laplace Distribution
Log-Normal Distribution
Standard Error
Confidence Interval Calculations
Z-Table for Confidence Interval
T-Table for Confidence Interval
Hypothesis Testing
Null & Alternate Hypothesis
Type-1 Error & Type-2 Error
2-Sample T Test
ANOVA Test
p-Value Calculations
Chi-Square Test
Project Demonstration using all the Statistical Techniques
Mastering Python[Zero to Hero]
0/30
Introduction to Python
01:02:54
Python Arithmetic Operators & Data Structures
01:04:10
Variables, Values, Data Types, Int in Python
01:01:53
List, Tuple, Set & Dict Commands in Python
57:16
Different List Methods
55:48
Different Tuple Methods
01:04:52
Different Set Methods
01:00:50
Different Dictionary & String Manipulations
50:56
Overview on Loops, IF, USD Functions, Escape Sequences, Lambda, Regular Exp
01:03:15
IF Statement, Types of Operators, Lambda, Python Modules
23:41
Loops, Break, Continue, Different Arguments
01:01:18
Functions, Escape Sequence & Lambda
52:23
Hackathon-1
54:32
Introduction to OOPS, POP vs OOP
16:16
Deep Dive into OOPS
56:53
Association, Composition, Polymorphism
50:02
OOPS Concept
36:29
Inheritance-Single, Multilevel, Hierarchical, Multiple, Encapsulation, Abstraction, Polymorphism [Brief] Basics
01:07:07
Encapsulation, Inheritance, Method Overriding, Method Overloading
53:59
Introduction to Pandas
01:05:22
Data Analysis with Pandas
01:34:29
Introduction to Numpy
57:26
Deep Into Numpy
01:03:00
Introduction to Data Visualisation
51:41
Matplotlib Deep Dive
01:00:20
Seaborn Commands
59:34
Plotly Data Visualisation
41:44
Why data Cleaning? Explanation with examples
47:05
Data Cleaning with Pandas
49:57
Regular Expression Basics
54:01
Tableau Data Analysis
0/11
Introduction to Tableau
01:14:02
Basics of Tableau
32:02
Different Types of Charts in Tableau
30:01
Table Calculations & Parameters
21:51
Waterfall Chart, Pareto Chart, Types of Filters
25:12
LOD Expressions & Pareto Chart
16:08
MySQL Connection with Tableau
12:10
End-to-End Project using Tableau
19:25
Connecting Tableau Desktop with Server
11:35
Tableau Server, Scheduling, Alerts, Comments
04:54
Tableau Interview Preparation Process
07:34
Mastering Power BI[Zero to Hero]
0/31
Introduction to Power Bi
04:33
Creating a Bar Plot
09:58
Creating Pie Chart
03:32
Creating Ribbon Chart
02:37
Creating Scatter Plot
04:10
Creating WaterFall Charts
04:41
Creating Funnel Chart
01:59
Creating Line Plot & Area Plot
05:12
Creating Matrix & Conditional Formatting
06:09
Creating Decomposition Tree
02:26
Creating KPI Card
03:13
Creating Gauge Card
04:21
Creating Slicers
03:22
Creating Animated Bar Plot
02:37
Creating Sunburst Chart
02:34
Different Filters in Power BI
04:07
Include & Exclude Operations in Power BI
02:37
Introduction to Power Query
06:11
Groupby & Replace in Power Query
01:52
Python Visualizations in Power Query
Merge and Append Operations
02:36
Prefix, Suffix, Length
02:43
Pivot in Power Query
03:51
Python Data Cleaning with Power Query
Introduction to DAX Expressions
03:05
Creating DAX Measures
03:06
Creating DAX Columns
03:06
YTD, YoY, MTD, QTD using DAX
More DAX Expressions
02:52
Publishing Power BI Visualizations
06:39
M-Language in Power Query
MySQL Deep Dive
0/10
Introduction to MySQL
23:29
Creating Database in MySQL
19:23
Understanding MySQL Interface
15:42
SELECT, UPDATE, DELETE, INSERT
29:03
Clauses in MYSQL Part-1
18:39
Clauses in MySQL Part-2
23:31
Clauses in MySQL Part-3
MySQL Data Handling Operations
41:21
MySQL Data Handling Operations-2
41:22
MySQL Aggregate Functions
Advanced MySQL
0/16
Data Integrity & Referential Integrity
Data Normalisation
First & Second Normal Form
Functional Dependency & Transitive Dependency
Boyce Codd Normal Form
Denormalization
Temporary Tables, CTE, Recursive CTE
When to Use Temporary Table, CTE, Recursive CTE
SubQuery in MySQL
Views in MySQL
Stored Functions
Stored Procedures
Triggers in MySQL
Create Events
In-depth DDL Commands
Different Functions in MySQL
Mastering Excel
0/22
Introduction to Excel
Basics of Excel Commands
Conditional Formatting in Excel
Different Calculations in Excel
Different Charts in Excel
Pivot Tables in Excel
Slicers in Excel
Filters in Excel
VlookUp, HLookup
Index & Match
Conditional Statements in Excel
SumIF & Count IF
Data Analysis Tool Kit
Forecasting in Excel
Correlation in Excel
Regression in Excel
What-If Analysis
Goal Seek
Data Tables
Scenario Manager
End-to-End Dashboard using Excel
Power Query in Excel
End-to-End Data Analysis using Power BI & MySQL
0/4
End-to-End Data Analytics using Power BI
01:43:44
Data Analysis using MySQL
01:45:33
Data Analysis using MySQL & DAX Calculations in Power BI
01:18:27
How to Prepare for Data Analytics Interviews
57:30
End-to-End Data Analytics using Excel
0/1
End-to-End Data Analytics using Excel
03:31:41
End-to-End Data Analytics using Tableau
0/2
Assignments
End-to-End Data Analytics using Tableau
03:12:00
Course Files
0/1
Course Files
Data Analytics Career Transition Program with Snowflake & Fabric
About Lesson