Course Content
What Does A Data Analyst Do and Its Roadmap
Getting Started With Google Colab
Installation Of Anaconda And Visual Studio Code
Getting Started With VS Code With Environments
Python Basics-Syntax And Semantics
Variables In Python
Basic Data Types In Python
Operators In Python
Coding Excercise And Assignments
Conditional Statements(if,elif,else)
Loops In Python
Coding Excercise And Assignments
List And List Comprehrension In Python
List Practise Code And assignments
Tuples In Python
Tuple Assignment And Practise Code
Sets In Python
Sets Assignment and Practise Code
Dictionaries In Python
Dictionaries Assignments and Practise Questions
REal World Usecases Of List
Getting Started With Functions
More Coding Examples With Functions
Lambda functions
Map functions In Python
Filter Function In Python
Function Assignments With Solution
Import Modules And Packages In Python
Standard Library Overview
File Operation In Python
Working With File Paths
Exception Handling With Try Except else finally blocks
Numpy In Python
Pandas-DataFrame And Series
Data Manipulation With Pandas And Numpy
Numpy Assignments With solution
Reading Data From Various Data Source Using Pandas
Data Visulaization With Matplotlib
Data Visualization With Seaborn
Introduction To Statistics
Types Of Statistics
Population And Sample Data
Types Of Sampling Techniques
Types Of Data
Scales Of Measurement Of Data
Measure Of Central Tendency(Mean,Median And Mode)
Measures Of Dispersion(Range,Variance,Standard
Deviation)
Why Sample Variance is divided by n-1
Random Variables
Percentiles And Quartiles
5 Number Summary
Histogram And Skewness
Covariance And Correlation
Pdf, PMF, CDF
Types OF Probability Distribution
Bernoulli Distribution
Binomial Distribution
Poisson Distribution
Normal or Gaussian Distribution
Standard Normal Distribution
Uniform Distribution
Log Normal Distribution
10-Power Law Distribution
11-Pareto Distribution
Central Limit Theorem
Estimates
Hypothesis Testing And Mechanism
P value And Hypothesis Testing
Z test Hypothesis Testing
Student t Distribution
T stats With T Test and Hypothesis Testing
Z test vs T test
Type1 And Type 2 Error
Baye's Theorem
Confidence Interval And Margin Of Error
What is Chi Square Test
Chi Square Goodness Of Fitness
What is Anova
Assumptions Of Anova
Types Of Annova
Partioning OF Annova
Feature Engineering-Handling Missing Data
Feature Engineering-Handling Imbalanced Dataset
Feature Engineering-SMOTE
Handling Outliers With Python
Data Encoding-Nominal/One Hot Encoding
Label And Ordinal Encoding
Target Guided Ordinal Encoding
Red Wine Dataset EDA
EDA Flight Price Dataset
Part 1-Data Cleaning Google Playstore Dataset
Part 2-EDA Google Play Store Dataset
SQL Course Introduction
SQL Overview
SQL Server Download & Install
SQL Select Statement
SQL Select Distinct
SQL Temporary Tables
SQL Where Clause
SQL Order By Clause
SQL AND & OR Operator
SQL NOT, BETWEEN & IN Operators
SQL Insert Into
SQL Null Operator
SQL Update Statement
Delete, Drop & Truncate
SQL Comments & TOP N
SQL MAX & Group BY
SQL MIN Function & Group BY
SUM, AVG, COUNT & Group BY
Group BY Concept
Group BY Example SQL Server
SQL Having Clause
SQL Where & Having Clause Difference
Inner Join Concept
Inner Join Example
Left Join Concept
Left Join Example
Right Join Concept
Right Join Example
Left & Right Anti Join
Left & Right Anti Join Example
Full Outer Join
Self Join
Union & Union All
SQL Like Operator
SQL Case in Select statement & Order BY Clause
Nested CASE statement
SQL Data Types
SQL Create Table
Inserting Records into All Columns of the Table
Inserting Records into Certain Columns in a Table
Copying Data From One Table to Another
Sub Queries
Not Null Constraint
Unique Constraint
Check Constraint
Default Constraint
Primary & Foreign Key Concept
Primary Key Constraint
Foreign Key Constraint
SQL Order of Execution
Questions Set - 1
Questions Set - 2
Questions Set - 3 (Joins)
Questions Set - 4 (Joins)
SQL Assignment 1
5 questions
SQL Assignment 2
5 questions
SQL Assignment 3
5 questions
SQL Assignment 4
5 questions
SQL Assignment 5
5 questions
Rank, Dense Rank & Row Number Window Functions -
1
Rank, Dense Rank & Row Number Window Functions -
2
Window Functions - Lead Function
Window Functions - Lag Function
ISNULL & Coalesce Functions
First_Value() Window Function
Last_Value() Window Function
Common Table Expressions - 1
Common Table Expressions - 2
Recursive Common Table Expressions
Stored Procedure in MS SQL Server
Views in MS SQL Server
Indexes in MS SQL Server
Clustered Index
Non Clustered Index
Nth Highest Salary
Reportee & Manager Question
Deleting Duplicates Q1
Deleting Duplicates Q2
Microsoft Power BI Course Introduction
General Workflow Power BI
Downloading & Installing Power BI Desktop
Creating a Free Power BI Account
Creating a Bar Chart
Creating a Column Chart
Creating a Pie & a Donut Chart
Creating a Clustered Column & Bar Chart
Creating a Line & Area Chart
Creating a Ribbon Chart
Creating a line & stacked column chart
Creating a Line & Clustered Column Chart
Creating a Scatter Plot
Creating a Bubble Map Visual
Creating a Table & Matrix Visual
Formatting Table & Matrix Visual
Creating a Funnel Chart
Gauge chart & KPI Visual
AI Visuals in Power BI
Detecting Data Types in Power BI Desktop
Data Profiling
Column Distribution Example
Appending Queries
Merge Inner Join
Left Outer Join
Right Outer Join
Left & Right Anti Join
Full Outer Join
Group By in Power Query Editor
Pivot, Unpivot & Transpose
Add/Transform Columns
DAX Lecture 1
DAX Lecture 2
DAX Lecture 3
DAX Lecture 4
DAX Lecture 5
DAX Lecture 6
Business Requirements
Loading Data to PBI Desktop
Data Profiling & Data Transformations Part 1
Data Transformations Part 2
Primary & Foreign Key
Cardinality
Star Schema
Data Model Overview
Different Types of Filters in Filters Pane
Top Bottom 5 Products By Sales, Quantity and Profit
Sales Trends Over Time
Other Requirements
Requirement 4 DAX
Requirement 4 Edit Interactions
Other Remaining Requirements
Changing Filter Behaviour for Dimension Table Slicers
Downloading & Installing MSSQL Server
Importing Data to MSSQL Server
Loading Data to Power BI Desktop
Table View & Data Profiling
Adding Slicers & Text
Adding New Card Visuals
Adding a Multi Row Card & a Ribbon Chart
Adding a Bar & a Line Chart
Adding a Donut Chart & Matrix Visual
Publishing the Report to Power BI Service
Scheduling Refresh
Drill Through Filter
Testing Scheduled Refresh & Publishing the updated
report
Creating & Testing Roles in PBI Desktop
Testing & Implementing RLS in Power BI Service
Power BI Reports & Dashboards
Sentiment Analysis Power Query
Sentiment Analysis Adding Visuals to the Report
Loading Data into Power BI Desktop
Data Profiling
Size & Position of slicers
Formatting the Slicers
Adding a Page & Age Group Column
Adding a Line Chart
Adding a Matrix Visual
Syncing Slicers & Applying Conditional Formatting
Adding Bookmarks for Transactions
Adding Bookmarks for Remaining Balance
Publishing the Report to Power BI Service
SQL + Power BI Scenario based question - 1
Power BI Scenario Based Question - 2
Home Tab Font Group
Home Tab Alignment Group
Home Tab Number Group Part 1
Home Tab Number Group Part 2
Home Tab Styles Group Conditional Formatting 1
Home Tab Styles Group Conditional Formatting 2
Draw Tab & Cell Styles
Excel Functions Video 1
Excel Functions Video 2
Excel Functions Video 3
Excel Functions Video 4
Excel Functions Video 5
Excel Functions Video 6
Excel Functions Video 7
Excel Functions Video 8
Excel Functions Video 9 VLookUp Function
Excel Functions Video 10 XLookUp Function
Pivot Tables Lecture 1
Pivot Tables Lecture 2
Creating & Formatting the Column Chart
Creating & Formatting the Bar Chart
Creating & Formatting a Line Chart
Creating & Formatting an Area Chart
Creating & Formatting a Pie Chart
Creating the Dashboard
Data Understanding & Cleansing
Data Transformation (Removing Data Quality Issues
using VLookUp Function)
Adding Age Group & Production Cost Per Unit Column
Adding a 3D Column Chart
Adding a 3D Bar Chart
Adding a 3D Line Chart
Adding a 3D Pie Chart
Creating the Dashboard
Data Profiling (Column Distribution)
Data Profiling (Column Profile & Column Quality)
Combining Queries
Inner Join Concept
Inner Join Example
Left Join Concept
Left Join Example
Right Join Concept
Right Join Example
Full Outer Join Concept
Full Outer Join Example
Left & Right Anti Join Concept
Right & Left Anti Join Example
Nulls in SQL Server & Power Query Editor
Appending two tables
Appending three tables
Power Query Editor Exercise 1
Power Query Editor Exercise 2
Power Query Editor Exercise 3
Power Query Editor Exercise 4
Power Query Editor Exercise 5
Importing Data to SQL Server
Importing Data to Excel From SQL Server
Data Understanding & Creating the Pivot Table
Adding Category Slicer
Adding Other Slicers & Formatting Slicers & Pivot Table
Refreshing the Report
Work of a Data Analyst (Story Telling)
Downloading & Installing Tableau Public
Loading Data into Tableau Public
Creating Column & Bar Chart
Saving Your Work to Tableau Public
Horizontal & Vertical Axis
Stacked & 100% Stacked Column Chart
Stacked & 100 % Stacked Bar Chart
Creating an Area Chart
Creating a Line Chart
Creating a Scatter Plot
Creating Pie Chart & Tree Map
Creating a Donut Chart
Creating a Lollipop Chart
Filters Shelf in Tableau 1
Filters Shelf in Tableau 2
Symbol & Filled Map
Funnel & Packed Bubble Chart
Sets in Tableau
Parameters in Tableau
Sets & Parameters
Importing Data
Creating & Formatting a Bar Chart
Creating & Formatting a Pie Chart
Creating & Formatting a Line Chart
Creating & Formatting a Scatter Plot
Creating the Dashboard
Importing Data
Transactions by City
Number of Transactions by Age Group
Transactions by Payment Method & Merchant Name
Adding Filters
Creating the Dashboard
Downloading & Installing Tableau Prep Builder
Understanding the Dataset
Connecting to Text File & Microsoft Excel
Removing Additional Columns
Cleaning Orders Central Table
Cleaning Orders East Table
Cleaning Orders West Table
Assigning Data Roles to Geographical Fields
Combining Different Tables
Cleaning Returns Table
Joining Tables
Cleaning Combined Table
Importing Data to SQL Server
Modifying Gender Column
Adding the Age Group Column
Column Distribution remaining columns
Adding Index Column & Updating depression column
Downloading & Installing Tableau Desktop
Bringing Data from SQL Server to Tableau Desktop
Academic Pressure & Student Count
Financial Stress & Student Count
Study Satisfaction & Student Count
Sleep Duration & Student Count
Study Hours & Student Count
Creating the Student Count Analysis Dashboard
Publishing the report to Tableau Cloud
Creating Snowflake Free Trial Account
Creating a SQL Worksheet
Snowflake Architecture
Setting up a Warehouse in Snowflake
Signing up for an AWS Account
Creating S3 Bucket
Uploading Data to Amazon S3 Bucket
Creating Roles using IAM
Creating Integration Object
Loading Data
Creating Free Azure Account
Creating Storage Account in Azure
Creating Containers in Azure & Loading Data in
Containers
Creating Integration Object to Connect to Azure
Creating the stage area & loading data in table in
snowflake
Connecting Snowflake to Power BI
Connecting Snowflake to Tableau
Creating Amazon S3 Bucket & Loading Data into it
Creating the Role
Creating the Integration Object & Updating the Trust
Policy
Loading Data into Snowflake
Understanding the Data
Data Transformation using Snowflake SQL
Adding Rainfall Groups Column
Importing Data into Power BI from Snowflake
Adding Rainfall Analysis page in the Power BI report
Adding Other Pages to the Power BI report
Publishing the report to Power BI Service
Creating & Loading Data to S3 Bucket
Creating the Role
Creating the Integration Object & updating the trust
policy
Loading Data into Snowflake
Data Understanding
Data Transformation using Snowflake SQL
Connecting Snowflake to Tableau
Creating Charts for Monthly Usage Consumption
Creating Charts for Cost Savings
Creating the Dashboard
Publishing the workbook to Tableau Cloud
Downloading, Installing & Configuring Standard Mode
Gateway
Downloading & Installing Microsoft SQL Server
Importing Data to SQL Server
Creating the Dataflow using Power BI Service
Importing Data into Power BI Desktop from dataflow
Column definitions & dataset description
Data Types & Profiling in Power Query Editor
Renaming & Inserting shape on Page 1
Loan Amount by Purpose (DAX Used : SUMX, FILTER,
NOT, ISBLANK)
Average Income by Employment Type (DAX Used :
CALCULATE, AVERAGE & ALLEXCEPT)
Default Rate by Employment type(DAX :
ALL,ALLEXCEPT,COUNTROWS,DIVIDE,FILTER etc)
Average Loan by Age Groups (DAX Used : AVERAGE,
AVERAGEX & VALUES)
Data Validation for Average Loan by Age Groups
Default Rate by Year (DAX Used :CALCULATE,
COUNTROWS, ALLEXCEPT, FILTER, DIVIDE)
Data Validation for Default Rate by Year
Median calculation & validation using MEDIANX DAX
Function
Median Loan Amount by credit score category
Adding Donut Chart to show Average Loan Amount by
Age Group & Marital Status
Data Validation (Donut Chart)
Loan(Adults) by credit categories (DAX Used :
CALCULATE,AVERAGEX,SUM)
Total Loan (Middle Age Adults) by have
Mortgage/Dependents
Data Validation (Clustered Column Chart)
Data Validation & Loans by education type
Creating the YOY Loan amount DAX Measure
Creating YOY Default Loans change DAX Measure
Adding Line charts to represent YOY DAX Measures
YTD Loan amount by credit score bins & marital status
Adding Decomposition Tree (DAX Used : SWITCH
Function)
Setting up Schedule Refresh for Dataflow
Setting up Incremental Refresh for Dataflow
Publishing the report to Power BI Service & scheduling
refresh for report
Sharing the Report
Installing MYSQL Server & MYSQL Workbench
Understanding the Test Environment Data &
Requirements
Importing the data in test environment in SQL Server
Applying Left Join in SQL Server to prepare the data to
be used for reporting
Importing the Data to Power BI Desktop from Test
Environment
Creating the DAX Measures & KPIs for Page 1
Creating the DAX Measures & KPIs for Page 2
Importing Data into Production Environment in SQL
Server
Data Cleaning using SQL & transitioning the report
from test to Production
Downloading & Installing the MYSQL Connector
Importing data into MYSQL Database
Creating Equivalent SQL Code in MYSQL Workbench to
populate New Table
Creating Workspace & Publishing SQL Server Data
Source's report
Importing Data into Power BI Desktop from MYSQL
Database
Transitioning the report using Advanced Editor in
Power Query Editor
Data Validation & Publishing New report to MYSQL
Database Workspace
Creating Free Google Cloud Account
Loading Data into Google BigQuery & connecting
BigQuery to Power BI
Using SQL in BigQuery for Data understanding &
transformations
Understanding & Cleaning the data using Power Query
Editor
YOY Sales Growth (Calculate, Year, MAX, IF, BLANK DAX
Functions)
Adding the Offer Price Column & Scatter Plot
Using MEDIANX DAX Function to create median sales
price change by region chart 0
Adding Units Sold (CALCULATE, DISTINCTCOUNT, YEAR,
QUARTER, MAX DAX Functions)
Last 12 month Sales (CALCULATE, DATESINPERIOD &
SUM DAX functions)
Creating the Sales performance page
Sales by Region (CALCULATE, SUM & ALLEXCEPT DAX
Function)
Downloading & Installing Microsoft SQL Server
TOTALYTD DAX Function & table visual
Adding the donut chart on sales performance page
Adding Age column & Key Influencers visual
Offer to SQM Price
Publishing the report to Power BI Service
Creating & Publishing the report to New Workspace
Adding clustered bar chart to show Avg offer/purchase
price comparison
Adding other visuals on House type analysis &
Publishing the report
Creating Free Azure Account
Loading Data to Azure SQL Database
Data Cleaning using Azure SQL
Connecting Power BI to Azure SQL Database using
'Database' option in Power BI
Connecting to Azure SQL Database using Microsoft
Account option in Power BI
Understanding the Data
Data Cleaning
Using DAX to create discount %, profit % & cost price
column
Adding the Brands Overview Page
Adding Visuals from App Source to second report page
Adding Bar chart to represent top 5 brands by highest
average discount %
Adding Donut Chart to represent top 5 brands by
variety count
Adding a ribbon chart to represent top 5 brands by
average sales price
Adding an Area chart to show top 5 brands by highest
average profit %
Adding Circle graph to represent bottom 5 brands by
profit% & publishing report
Sharing the report through Apps in Power BI Service
Real Time Data Analysis Project Execution
Creating the data using SQL & Perplexity
Removing Inconsistencies from Date Column using SQL
& Perplexity
Combining Data From Three Tables Using SQL Joins
Loading Data into Power BI Desktop
KPI, Chart and DAX recommendation using Perplexity
Data Cleaning
Cleaning Other Date Columns
Number of Transactions by Type
Transactions by Month
Top 2 Transactions by Name
Total Balance by Account Type
Inactive Accounts by Year & Month
Customer Count by Gender
Number of Customers by Age Group
Creating & Formatting the Tree Map
Adding Remaining Charts
Publishing the Report to Power BI Service
Creating the GITHUB Account
Uploading Power BI Project to GITHUB Account
STATUS
Histogram And Skewness
Covariance And Correlation
Pdf, PMF, CDF
Types OF Probability Distribution
Bernoulli Distribution
Binomial Distribution
Poisson Distribution
Normal or Gaussian Distribution
Standard Normal Distribution
Uniform Distribution
Log Normal Distribution
10-Power Law Distribution
11-Pareto Distribution
Completed
Completed
Completed
Completed
Completed
Pending
Pending
Pending
Pending
Pending
Pending
Pending
Completed
Completed
Completed
Pending
Pending
Pending