Let’s get ready for the data analysis jobs!
power Bi Module
Learn essential SQL,
advanced querying, and
how to use Power BI.
Perfect your skills in
creating different visuals
and managing data.
Created by
Kanav Taneja
[Link]
Chapter 1
DATA LITERACY
01 What is Data Literacy
02 Definition of data
03 Finding your next client
04 Class of Variables
05 Nominal Data
06 Ordinal Data
Chapter 2
Chart Types in Power BI
01 Bar Chart, Line Chart
02 Stacked Bar Chart, Histogram
03 Heat maps, Tree Maps
04 Bullet Graph, Combo Charts
05 Scatter Plot, Cross-Tab
06 Map Visuals, Waterfall Chart
07 Table and Matrix Visuals
Chapter 3
Data Management
with Power Query
01 Planning Power BI Project
02 Power Query - Combining and Cleaning
03 Power Query - Transforming Data
Chapter 4
Introduction to
PowerBi
01 What is Power BI
02 Quick Tour of Power BI
03 Download Files & Important Course Info
Chapter 5
Create Your First
Power BI Report for
Knowledge Castle
(USA)
01 First Project Overview
02 Loading Data for Analysis
03 Creating a Data Model
Chapter 5
Create Your First
Power BI Report for
Knowledge Castle
(USA)
04 Exploring Visuals in Power BI
05 Filters and Slicers
06 Creating Quick Measures
Chapter 6
Dashboard Designing
01 Designing Report Layout (Theme & Draft)
02 Getting Started on our Dashboard
03 Sync Slicers & Edit Interactions between Visuals
04 Drill Down & Line Charts
05 Custom Hierarchies for Drill down
06 Adding Custom Visuals like Word Cloud
07 Artificial Intelligence Visuals – Smart Narrative
08 Artificial Intelligence Visuals –QA
Chapter 6
Dashboard Designing
09 Top N Filter & Conditional Formatting
10 Dynamic Card Titles with Conditional Formatting
11 Customize Tooltips & Analyze Data
12 Analytics Pane to add More Analysis to Visuals
13 Adding Page Navigation and Back Buttons
14 Challenge & Final Touches
15 Quiz
Chapter 7
Publishing Dashboard
01 Publishing and Exploring Report in Power BI Service
02 Create a Dashboard from your Report
03 Mobile Dashboard
04 Refreshing the Dataset in Power BI Desktop
05 Connect to a published Dataset
06 Quiz
07 Key Takeaways
_____________________________________
Congratulations for Completing the Fast Lane
_____________________________________
Chapter 8
Data Analysis with
DAX & Power Pivot
01 DAX Deep dive
02 Power Pivot
03 Calculation groups, dimension metrics
04 dynamic ranking measures
05 dynamic row-level security
06 Time intelligence patterns in Power BI
07 Performance testing
Chapter 9
Story telling with
Power BI
01 Report Tooltips
02 Conditional formats
03 Text commentary with DAX
04 Play Axis for scatter charts, Pulse chart
05 Analytics Pane
06 Quick Insights
07 Dimensional modeling with Power Query
Chapter 9
Story telling with
Power BI
08 Reference vs. Duplicate queries
09 Generating calendar tables
10 Data modeling with multiple fact tables
11 Measure development
12 Dashboard design and implementation
13 Qiiz
14 Key Takeways
Chapter 10
Executive
Dashboard-I
01 Part 1 – Report goals and design
02 Part 2 – Data Modeling and Measures
03 Part 3 – Business View with KPIs & forecast
04 Part 4 – Business View contd
05 Part 5 – Finance Department View with What-if analysis
Chapter 11
Executive
Dashboard-II
01 Creating a timeline of funded amounts
02 Creating a Bar chart for sector
03 Creating a pie chart of split by Gender
04 Action: Filter, Highlight
05 PowerBi Quiz
_____________________________________
Congratulations for Completing the Powerbi
_____________________________________
theknowledgecastle
Microsoft qualified institute
SQL
Module
Learn essential SQL, advanced querying, and
how to use Power BI. Perfect your skills in
creating different visuals and managing data.
Get ready for data analysis jobs!
Created by
Kanav Taneja
[Link]
Chapter 1
Introduction to databases
SQL and MySQL
01 Why SQL?
02 Why MySQL?
03 Introduction to databases
Chapter 2
SQL Theory
01 SQL as a declarative language
02 Data definition language (DDL)
03 SQL keywords
04 Data manipulation language (DML)
05 Data control language (DCL)
06 Transaction control language (TCL)
Chapter 3
Basic database
terminology
01 Relational database essentials
02 Databases vs spreadsheets
03 Database terminology
04 Relational schemas - Primary key
05 Relational schemas - Foreign key
06 Relational schemas - Unique key and null
Chapter 4
First steps in SQL
01 Creating a Database - Part I
02 SQL files
03 Introduction to data types
04 ü String data types
05 ü Integers
06 ü Fixed and floating-point data types
07 ü Other useful data types
08 Creating a table
Chapter 5
MySQL constraints
01 Primary Key Constraint
02 Foreign Key Constraint
03 Unique Constraint
04 Default Constraint
05 Not Null Constraint
Chapter 6
SQL Select Statement
01 Select From
02 Where
03 And, Or, Operator Precedence
04 In – Not in, Like - Not Like
05 Wildcard Characters
06 Between – And, Is Not Null – Is Null
07 Select Distinct
Chapter 7
Introduction to Aggregate
Functions
01 Order By
02 Group By
03 Using Aliases
04 Having
05 Where Vs Having
06 Limit
Chapter 8
SQL Insert Statement
01 The Insert Statement
02 Inserting data into a new Table
Chapter 9
SQL Update Statement
01 TCL’s Commit and Rollback
02 The Update Statement
03 Rollback
Chapter 10
SQL Delete Statement
01 Delete Statement
02 Drop
03 Truncate
04 Drop vs Truncate
Chapter 10
SQL Delete Statement
01 Delete Statement
02 Drop
03 Truncate
04 Drop vs Truncate
Chapter 11
Aggregate Functions
01 Count(), Sum()
02 Min() & Max()
03 Avg()
04 Round()
05 Coalesce()
06 Isnull() & Coalesce()
Chapter 12
SQL Joins
01 Introduction to Joins
02 Inner Join, Left, Right & Outer Join
03 Duplicate Records
04 Join & Where Used together
05 Cross Join
06 Aggregate Functions with Join
07 Join more than 2 tables and self join
08 Union vs Union All
Chapter 13
SQL Subqueries
01 SQL subqueries with in nested inside where
02 SQL subqueries nested in select & from
Chapter 14
Advanced SQL Topics
01 Views
02 MySQL Indexes
03 The Case Statement
04 MYSQL Triggers
05 Row_Num()
06 Rank()
_____________________________________
Congratulations for Completing the SQL
_____________________________________
CONNECTING
SQL &
POWERBI
Created by
Kanav Taneja
[Link]