Course Content
Introducing Power BI Desktop
0/4
How Learning Power BI Can Help You in Your Career?
07:06
Downloading Power BI
Adjusting Settings
04:19
Power BI Desktop Interface & Workflow
Extracting, Transformation and Loading ETL in Power Query
0/18
Power BI Front-End vs. Back-End
Types of Data Connectors
Exploring the Power Query Editor
Basic Table Transformations
Storage & Connection Modes
Data Quality Assurance & Profiling Tools
Text Tools
Numerical Tools
Date & Time Tools
Change Type with Locale
Conditional Columns
Grouping & Aggregating Data
Merging Queries
Appending Queries
Appending Files from a Folder
Data Source Settings
Dynamic Data Source using Parameters
Refreshing Queries
Data Modelling and Relationships
0/17
Understanding Database Normalization
Explaining Data Normalization (Need) in Excel
Expanded Tables
Context Transition
Evaluation Order
Fact vs Dimension Tables
Primary & Foreign Keys
Relationships vs. Merged Tables
Establishing Table Relationships
Managing & Editing Relationships
Star & Snowflake Schemas
Active & Inactive Relationships
Understanding Relationship Cardinality
Connecting Multiple Fact Tables
Hiding Fields from Report View
Data Formats & Categories
Creating Hierarchies
Calculated Columns with DAX
0/5
Intro to DAX Calculated Columns
Common Text Functions
Basic Date & Time Functions
Conditional & Logical Functions
The SWITCH Function
DAX Measures
0/8
Intro to DAX Measures
Implicit vs. Explicit Measures
Dedicated Measure Tables
Understanding Filter Context and Filter Flow
Step-by-Step DAX Measure Calculation
Common DAX Function Categories
Basic Math & Stats Functions
Joining Data with RELATED
Advanced DAX Measures
0/7
CALCULATE Function
ALL Function
FILTER Function
Iterator (X) Functions
TOPN Function
Variables
Variable Evaluation Order
Time Intelligence Functions
0/9
ISBLANK Function
DATEADD Function
DATESYTD Function
DATESQTD Function
DATESMTD Function
DATESINPERIOD Function
DATESBETWEEN Function
ENDOFMONTH Function
Formatting and Commenting Code
Data Visualization and Dashboard
0/23
Cards & Multi-Row Cards Visual
Building & Formatting Charts
Line Chart Visual
Trend Lines & Forecasts
KPI Cards Visual
Bar & Donut Chart Visuals
Basic Filtering Options
Table & Matrix Visuals
Conditional Formatting Techniques
Top N Filtering
Top N Text Cards
Map Visuals
Report Slicers
Gauge Chart Visual
Advanced Conditional Formatting
Area Chart Visual
Drill Up & Drill Down
Drillthrough Filters
Editing Report Interactions
Adding Bookmarks
Custom Navigation Buttons
Numeric Range and Field Parameters
Custom Tool Tips
Artificial Intelligence AI Visuals
0/5
Anomaly Detection for Data Quality
Implementing Smart Narratives
Q&A Visuals
Decomposition Trees
Key Influencers
Advanced Scalar and Logical Functions
0/5
Common Scalar Functions
Rounding Functions
Information Functions
Conversion Functions
COALESCE Function
Advanced CALCULATE Functionality
0/4
CALCULATE Modifiers
REMOVEFILTERS Function
KEEPFILTERS Function
Common CALCULATE Patterns
Table and Filter Functions
0/11
Common Table & Filter Functions in DAX
Reviewing Calculated Tables
DISTINCT Function
VALUES Function
SELECTEDVALUE Function
ALLEXCEPT Function
ALLSELECTED Function
SELECTCOLUMNS Function
ADDCOLUMNS Function
SUMMARIZE Function
Generating New Data with ROW, DATATABLE, and GENERATESERIES Functions
Table Joins in Power BI
0/4
CROSSJOIN Function
UNION Function
EXCEPT Function
INTERSECT Function
Relationship Functions
0/5
Physical vs. Virtual Relationships
RELATED Function
RELATEDTABLE Function
USERELATIONSHIPS Function
CROSSFILTER Function
Advanced Iterator Functions
0/2
RANKX Function
Dynamic TOP N Ranking using RANKX Iterator
Advanced Time Intelligence
0/12
Automatic Date Tables in DAX
Date Table Requirements
CALENDAR and CALENDARAUTO Function
Building a Reusable Date Table
Date Formatting
PARALLELPERIOD Function
PREVIOUSQUARTER Function
SAMEPERIODLASTYEAR Function
Week-based Calculations
Previous Fiscal Week
Fiscal Period to Date
Fiscal Previous Period
Project 02 – Maven Market (Analysis and Dashboard)
0/2
Maven Market (Analysis and Dashboard) – Part 01
Maven Market (Analysis and Dashboard) – Part 02
Project 03 – Oodles of Noodles (Analysis and Dashboard)
0/2
Oodles of Noodles (Analysis and Dashboard) – Part 01
Oodles of Noodles (Analysis and Dashboard) – Part 02
Project 04 – Market Mindz (Visualization and Designing)
0/2
Market Mindz (Visualization and Designing) – Parr 01
Market Mindz (Visualization and Designing) – Parr 02
Project 05 – Market Mindz Redesigning
Project 06 – Human Resource (Employee Performance Analysis)
0/2
Human Resource (Employee Performance Analysis) – Part 01
Human Resource (Employee Performance Analysis) – Part 02
Project 07 – Global Super Store (Multi-National Company – Analysis)
Mega Project – Industrial Project (Finance, Marketing, Supply Chain)
0/26
Finance View: Prepare a List of Metrics
Simplified: Calculate Function & Filter Context
Finance View: Creating Metrics
Finance View: Create P&L Table Structure
Finance View: Create Last Year (LY) Column
Finance View: Build an Ultimate DAX Measure for P & L Table Structure
Finance View: Create ‘Quarters’ & ‘YTD/YTG’ Slicers
Finance View: Create a Line chart to Show Performance Over Time
Finance View: Build Top Product, Market & Region Visuals
Intermediate Review: I Met Product Owner Abbas and He Gave this Feedback!
Finance View: Add Net Profit
Review Sales View Mockup
Sales View: Build Top Customers & Performance Matrix Visuals
Sales View: Build Product Performance & Unit Economics Visuals
Build Marketing View
Simplified: Supply Chain Basics
Supply Chain View: Review Mock Up
Supply Chain View: Build Key Measures
Supply Chain View: Build Visuals
Simplified: Dashboard vs Report
15 Design Rules for an Effective Dashboard
Finalize Page Layout Design
Create Home Page
Design Finance Dashboard
Add Key Elements to Finance Dashboard
Copy the Design to Sales, Marketing & Supply Chain Dashboard
Microsoft Power BI Certified Data Analyst 2024 (Beginner to Advanced)
Previous
Next
0% Complete