Complete Data Analyst Bootcamp

Course content

Sections: 43

•

Activities: 1

•

Resources: 483

Announcements
1 What Does A Data Analyst Do and Its Roadmap

1 Getting Started With Google Colab
2 Installation Of Anaconda And Visual Studio Code

1 Getting Started With VS Code With Environments
2 Python Basics Syntax And Semantics
3 Variables In Python
4 Basic Data Types In Python
5 Operators In Python
7 Conditional Statementsifelifelse
8 Loops In Python
10 List And List Comprehrension In Python
12 Tuples In Python
14 Sets In Python
16 Dictionaries In Python
18 REal World Usecases Of List
19 Getting Started With Functions
20 More Coding Examples With Functions
21 Lambda functions
22 Map functions In Python
23 Filter Function In Python
25 Import Modules And Packages In Python
26 Standard Library Overview
27 File Operation In Python
28 Working With File Paths
29 Exception Handling With Try Except else finally blocks

1 Numpy In Python
2 Pandas DataFrame And Series
3 Data Manipulation With Pandas And Numpy
5 Reading Data From Various Data Source Using Pandas
6 Data Visulaization With Matplotlib
7 Data Visualization With Seaborn

1 Introduction To Statistics
2 Types Of Statistics
3 Population And Sample Data
4 Types Of Sampling Techniques
5 Types Of Data
6 Scales Of Measurement Of Data

1 Measure Of Central TendencyMeanMedian And Mode
2 Measures Of DispersionRangeVarianceStandard Deviation
3 Why Sample Variance is divided by n 1
4 Random Variables
5 Percentiles And Quartiles
6 5 Number Summary
7 Histogram And Skewness
8 Covariance And Correlation

1 Pdf PMF CDF
2 Types OF Probability Distribution
3 Bernoulli Distribution
4 Binomial Distribution
5 Poisson Distribution
6 Normal or Gaussian Distribution
7 Standard Normal Distribution
8 Uniform Distribution
9 Log Normal Distribution
10 10 Power Law Distribution
11 11 Pareto Distribution
12 Central Limit Theorem
13 Estimates

1 Hypothesis Testing And Mechanism
2 P value And Hypothesis Testing
3 Z test Hypothesis Testing
4 Student t Distribution
5 T stats With T Test and Hypothesis Testing
6 Z test vs T test
7 Type1 And Type 2 Error
8 Bayes Theorem
9 Confidence Interval And Margin Of Error
10 What is Chi Square Test
11 Chi Square Goodness Of Fitness
12 What is Anova
13 Assumptions Of Anova
14 Types Of Annova
15 Partioning OF Annova

1 Feature Engineering Handling Missing Data
2 Feature Engineering Handling Imbalanced Dataset
3 Feature Engineering SMOTE
4 Handling Outliers With Python
5 Data Encoding NominalOne Hot Encoding
6 Label And Ordinal Encoding
7 Target Guided Ordinal Encoding

1 Red Wine Dataset EDA
2 EDA Flight Price Dataset
3 Part 1 Data Cleaning Google Playstore Dataset
4 Part 2 EDA Google Play Store Dataset

1 SQL Course Introduction
2 SQL Overview
3 SQL Server Download Install

1 SQL Select Statement
2 SQL Select Distinct
3 SQL Temporary Tables
4 SQL Where Clause
5 SQL Order By Clause
6 SQL AND OR Operator
7 SQL NOT BETWEEN IN Operators
8 SQL Insert Into
9 SQL Null Operator
10 SQL Update Statement
11 Delete Drop Truncate
12 SQL Comments TOP N
13 SQL MAX Group BY
14 SQL MIN Function Group BY
15 SUM AVG COUNT Group BY
16 Group BY Concept
17 Group BY Example SQL Server
18 SQL Having Clause
19 SQL Where Having Clause Difference
20 Inner Join Concept
21 Inner Join Eample
22 Left Join Concept
23 Left Join Eample
24 Right Join Concept
25 Right Join Example
26 Left Right Anti Join
27 Left Right Anti Join Example
28 Full Outer Join
29 Self Join
30 Union Union All
31 SQL Like Operator
32 SQL Case in Select statement Order BY Clause
33 Nested CASE statement
34 SQL Data Types
35 SQL Create Table
36 Inserting Records into All Columns of the Table
37 Inserting Records into Certain Columns in a Table
38 Copying Data From One Table to Another
39 Sub Queries
40 Not Null Constraint
41 Unique Constraint
42 Check Constraint
43 Default Constraint
44 Primary Foreign Key Concept
45 Primary Key Constraint
46 Foreign Key Constraint
47 SQL Order of Execution

1 Questions Set 1
2 Questions Set 2
3 Questions Set 3 Joins
4 Questions Set 4 Joins

1 Rank Dense Rank Row Number Window Functions 1
2 Rank Dense Rank Row Number Window Functions 2
3 Window Functions Lead Function
4 Window Functions Lag Function
5 ISNULL Coalesce Functions
6 First_Value Window Function
7 Last_Value Window Function

1 Common Table Expressions 1
2 Common Table Expressions 2
3 Recursive Common Table Expressions
4 Stored Procedure in MS SQL Server
5 Views in MS SQL Server
6 Indexes in MS SQL Server
7 Clustered Index
8 Non Clustered Index

1 Nth Highest Salary
2 Reportee Manager Question
3 Deleting Duplicates Q1
4 Deleting Duplicates Q2

1 Microsoft Power BI Course Introduction

1 General Workflow Power BI
2 Downloading Installing Power BI Desktop
3 Creating a Free Power BI Account

1 Creating a Bar Chart
2 Creating a Column Chart
3 Creating a Pie a Donut Chart
4 Creating a Clustered Column Bar Chart
5 Creating a Line Area Chart
6 Creating a Ribbon Chart
7 Creating a line stacked column chart
8 Creating a Line Clustered Column Chart
9 Creating a Scatter Plot
10 Creating a Bubble Map Visual
11 Creating a Table Matrix Visual
12 Formatting Table Matrix Visual
13 Creating a Funnel Chart
14 Gauge chart KPI Visual
15 AI Visuals in Power BI

1 Detecting Data Types in Power BI Desktop
2 Data Profiling
3 Column Distribution Example
4 Appending Queries
5 Merge Inner Join
6 Left Outer Join
7 Right Outer Join
8 Left Right Anti Join
9 Full Outer Join
10 Group By in Power Query Editor
11 Pivot Unpivot Transpose
12 AddTransform Columns

1 DAX Lecture 1
2 DAX Lecture 2
3 DAX Lecture 3
4 DAX Lecture 4
5 DAX Lecture 5
6 DAX Lecture 6

1 Business Requirements
2 Loading Data to PBI Desktop
3 Data Profiling Data Transformations Part 1
4 Data Transformations Part 2
5 Primary Foreign Key
6 Cardinality
7 Star Schema
8 Data Model Overview
9 Different Types of Filters in Filters Pane
10 Top Bottom 5 Products By Sales Quantity and Profit
11 Sales Trends Over Time
12 Other Requirements
13 Requirement 4 DAX
14 Requirement 4 Edit Interactions
15 Other Remaining Requirements
16 Changing Filter Behaviour for Dimension Table Slicers

1 Downloading Installing MSSQL Server
2 Importing Data to MSSQL Server
3 Loading Data to Power BI Desktop
4 Table View Data Profiling
5 Adding Slicers Text
6 Adding New Card Visuals
7 Adding a Multi Row Card a Ribbon Chart
8 Adding a Bar a Line Chart
9 Adding a Donut Chart Matrix Visual
10 Publishing the Report to Power BI Service
11 Scheduling Refresh
12 Drill Through Filter
13 Testing Scheduled Refresh Publishing the updated report
14 Creating Testing Roles in PBI Desktop
15 Testing Implementing RLS in Power BI Service
16 Power BI Reports Dashboards
17 Sentiment Analysis Power Query
18 Sentiment Analysis Adding Visuals to the Report

1 Loading Data into Power BI Desktop
2 Data Profiling
3 Size Position of slicers
4 Formatting the Slicers
5 Adding a Page Age Group Column
6 Adding a Line Chart
7 Adding a Matrix Visual
8 Syncing Slicers Applying Conditional Formatting
9 Adding Bookmarks for Transactions
10 Adding Bookmarks for Remaining Balance
11 Publishing the Report to Power BI Service

1 SQL Power BI Scenario based question 1
2 Power BI Scenario Based Question 2

1 Home Tab Font Group
2 Home Tab Alignment Group
3 Home Tab Number Group Part 1
4 Home Tab Number Group Part 2
5 Home Tab Styles Group Conditional Formatting 1
6 Home Tab Styles Group Conditional Formatting 2
7 Draw Tab Cell Styles
8 Excel Functions Video 1
9 Excel Functions Video 2
10 Excel Functions Video 3
11 Excel Functions Video 4
12 Excel Functions Video 5
13 Excel Functions Video 6
14 Excel Functions Video 7
15 Excel Functions Video 8
16 Excel Functions Video 9 VLookUp Function
17 Excel Functions Video 10 XLookUp Function

1 Pivot Tables Lecture 1
2 Pivot Tables Lecture 2
3 Creating Formatting the Column Chart
4 Creating Formatting the Bar Chart
5 Creating Formatting a Line Chart
6 Creating Formatting an Area Chart
7 Creating Formatting a Pie Chart
8 Creating the Dashboard

1 Data Understanding Cleansing
2 Data Transformation Removing Data Quality Issues using VLookUp Function
3 Adding Age Group Production Cost Per Unit Column
4 Adding a 3D Column Chart
5 Adding a 3D Bar Chart
6 Adding a 3D Line Chart
7 Adding a 3D Pie Chart
8 Creating the Dashboard

1 Data Profiling Column Distribution
2 Data Profiling Column Profile Column Quality
3 Combining Queries
4 Inner Join Concept
5 Inner Join Example
6 Left Join Concept
7 Left Join Example
8 Right Join Concept
9 Right Join Example
10 Full Outer Join Concept
11 Full Outer Join Example
12 Left Right Anti Join Concept
13 Right Left Anti Join Example
14 Nulls in SQL Server Power Query Editor
15 Appending two tables
16 Appending three tables
17 Power Query Editor Exercise 1
18 Power Query Editor Exercise 2
19 Power Query Editor Exercise 3
20 Power Query Editor Exercise 4
21 Power Query Editor Exercise 5

1 Importing Data to SQL Server
2 Importing Data to Excel From SQL Server
3 Data Understanding Creating the Pivot Table
4 Adding Category Slicer
5 Adding Other Slicers Formatting Slicers Pivot Table
6 Refreshing the Report

1 Work of a Data Analyst Story Telling
2 Downloading Installing Tableau Public
3 Loading Data into Tableau Public
4 Creating Column Bar Chart
5 Saving Your Work to Tableau Public
6 Horizontal Vertical Axis
7 Stacked 100 Stacked Column Chart
8 Stacked 100 Stacked Bar Chart
9 Creating an Area Chart
10 Creating a Line Chart
11 Creating a Scatter Plot
12 Creating Pie Chart Tree Map
13 Creating a Donut Chart
14 Creating a Lollipop Chart
15 Filters Shelf in Tableau 1
16 Filters Shelf in Tableau 2
17 Symbol Filled Map
18 Funnel Packed Bubble Chart
19 Sets in Tableau
20 Parameters in Tableau
21 Sets Parameters

1 Importing Data
2 Creating Formatting a Bar Chart
3 Creating Formatting a Pie Chart
4 Creating Formatting a Line Chart
5 Creating Formatting a Scatter Plot
6 Creating the Dashboard

1 Importing Data
2 Transactions by City
3 Number of Transactions by Age Group
4 Transactions by Payment Method Merchant Name
5 Adding Filters
6 Creating the Dashboard

1 Downloading Installing Tableau Prep Builder
2 Understanding the Dataset
3 Connecting to Text File Microsoft Excel
4 Removing Additional Columns
5 Cleaning Orders Central Table
6 Cleaning Orders East Table
7 Cleaning Orders West Table
8 Assigning Data Roles to Geographical Fields
9 Combining Different Tables
10 Cleaning Returns Table
11 Joining Tables
12 Cleaning Combined Table

1 Importing Data to SQL Server
2 Modifying Gender Column
3 Adding the Age Group Column
4 Column Distribution remaining columns
5 Adding Index Column Updating depression column
6 Downloading Installing Tableau Desktop
7 Bringing Data from SQL Server to Tableau Desktop
8 Academic Pressure Student Count
9 Financial Stress Student Count
10 Study Satisfaction Student Count
11 Sleep Duration Student Count
12 Study Hours Student Count
13 Creating the Student Count Analysis Dashboard
14 Publishing the report to Tableau Cloud

1 Creating Snowflake Free Trial Account
2 Creating a SQL Worksheet
3 Snowflake Architecture
4 Setting up a Warehouse in Snowflake
5 Signing up for an AWS Account
6 Creating S3 Bucket
7 Uploading Data to Amazon S3 Bucket
8 Creating Roles using IAM
9 Creating Integration Object
10 Loading Data
11 Creating Free Azure Account
12 Creating Storage Account in Azure
13 Creating Containers in Azure Loading Data in Containers
14 Creating Integration Object to Connect to Azure
15 Creating the stage area loading data in table in snowflake

1 Connecting Snowflake to Power BI
2 Connecting Snowflake to Tableau

1 Creating Amazon S3 Bucket Loading Data into it
2 Creating the Role
3 Creating the Integration Object Updating the Trust Policy
4 Loading Data into Snowflake
5 Understanding the Data
6 Data Transformation using Snowflake SQL
7 Adding Rainfall Groups Column
8 Importing Data into Power BI from Snowflake
9 Adding Rainfall Analysis page in the Power BI report
10 Adding Other Pages to the Power BI report
11 Publishing the report to Power BI Service

1 Creating Loading Data to S3 Bucket
2 Creating the Role
3 Creating the Integration Object updating the trust policy
4 Loading Data into Snowflake
5 Data Understanding
6 Data Transformation using Snowflake SQL
7 Connecting Snowflake to Tableau
8 Creating Charts for Monthly Usage Consumption
9 Creating Charts for Cost Savings
10 Creating the Dashboard
11 Publishing the workbook to Tableau Cloud

1 Downloading Installing Configuring Standard Mode Gateway
2 Downloading Installing Microsoft SQL Server
3 Importing Data to SQL Server
4 Creating the Dataflow using Power BI Service
5 Importing Data into Power BI Desktop from dataflow
6 Column definitions dataset description
7 Data Types Profiling in Power Query Editor
8 Renaming Inserting shape on Page 1
9 Loan Amount by Purpose DAX Used SUMX FILTER NOT ISBLANK
10 Average Income by Employment Type DAX Used CALCULATE AVERAGE ALLEXCEPT
11 Default Rate by Employment typeDAX ALLALLEXCEPTCOUNTROWSDIVIDEFILTER etc
12 Average Loan by Age Groups DAX Used AVERAGE AVERAGEX VALUES
13 Data Validation for Average Loan by Age Groups
14 Default Rate by Year DAX Used CALCULATE COUNTROWS ALLEXCEPT FILTER DIVIDE
15 Data Validation for Default Rate by Year
16 Median calculation validation using MEDIANX DAX Function
17 Median Loan Amount by credit score category
18 Adding Donut Chart to show Average Loan Amount by Age Group Marital Status
19 Data Validation Donut Chart
20 LoanAdults by credit categories DAX Used CALCULATEAVERAGEXSUM
21 Total Loan Middle Age Adults by have MortgageDependents
22 Data Validation Clustered Column Chart
23 Data Validation Loans by education type
24 Creating the YOY Loan amount DAX Measure
25 Creating YOY Default Loans change DAX Measure
26 Adding Line charts to represent YOY DAX Measures
27 YTD Loan amount by credit score bins marital status
28 Adding Decomposition Tree DAX Used SWITCH Function
29 Setting up Schedule Refresh for Dataflow
30 Setting up Incremental Refresh for Dataflow
31 Publishing the report to Power BI Service scheduling refresh for report
32 Sharing the Report

1 Installing MYSQL Server MYSQL Workbench
2 Understanding the Test Environment Data Requirements
3 Importing the data in test environment in SQL Server
4 Applying Left Join in SQL Server to prepare the data to be used for reporting
5 Importing the Data to Power BI Desktop from Test Environment
6 Creating the DAX Measures KPIs for Page 1
7 Creating the DAX Measures KPIs for Page 2
8 Importing Data into Production Environment in SQL Server
9 Data Cleaning using SQL transitioning the report from test to Production
10 Downloading Installing the MYSQL Connector
11 Importing data into MYSQL Database
12 Creating Equivalent SQL Code in MYSQL Workbench to populate New Table
13 Creating Workspace Publishing SQL Server Data Sources report
14 Importing Data into Power BI Desktop from MYSQL Database
15 Transitioning the report using Advanced Editor in Power Query Editor
16 Data Validation Publishing New report to MYSQL Database Workspace

1 Creating Free Google Cloud Account
2 Loading Data into Google BigQuery connecting BigQuery to Power BI
3 Using SQL in BigQuery for Data understanding transformations
4 Understanding Cleaning the data using Power Query Editor
5 YOY Sales Growth Calculate Year MAX IF BLANK DAX Functions
6 Adding the Offer Price Column Scatter Plot
7 Using MEDIANX DAX Function to create median sales price change by region chart 0
8 Adding Units Sold CALCULATE DISTINCTCOUNT YEAR QUARTER MAX DAX Functions
9 Last 12 month Sales CALCULATE DATESINPERIOD SUM DAX functions
10 Creating the Sales performance page
11 Sales by Region CALCULATE SUM ALLEXCEPT DAX Function
12 Downloading Installing Microsoft SQL Server
13 TOTALYTD DAX Function table visual
14 Adding the donut chart on sales performance page
15 Adding Age column Key Influencers visual
16 Offer to SQM Price
17 Publishing the report to Power BI Service
18 Creating Publishing the report to New Workspace
19 Adding clustered bar chart to show Avg offerpurchase price comparison
20 Adding other visuals on House type analysis Publishing the report

1 Creating Free Azure Account
2 Loading Data to Azure SQL Database
3 Data Cleaning using Azure SQL
4 Connecting Power BI to Azure SQL Database using Database option in Power BI
5 Connecting to Azure SQL Database using Microsoft Account option in Power BI
6 Understanding the Data
7 Data Cleaning
8 Using DAX to create discount profit cost price column
9 Adding the Brands Overview Page
10 Adding Visuals from App Source to second report page
11 Adding Bar chart to represent top 5 brands by highest average discount
12 Adding Donut Chart to represent top 5 brands by variety count
13 Adding a ribbon chart to represent top 5 brands by average sales price
14 Adding an Area chart to show top 5 brands by highest average profit
15 Adding Circle graph to represent bottom 5 brands by profit publishing report
16 Sharing the report through Apps in Power BI Service

Enrolment options

Udemy - Complete Data Analyst Bootcamp From Basics To Advanced 2025-6

Course modified date: 5 July 2025

Enrolled students: There are no students enrolled in this course.

Guests cannot access this course. Please log in.

Udemy - Complete Data Analyst Bootcamp From Basics To Advanced 2025-6

About the course

Course content

Instructors

Enrolment options

Udemy - Complete Data Analyst Bootcamp From Basics To Advanced 2025-6

This course includes

Share this course