Course curriculum
-
-
Course Overview
-
Power BI Versions
-
Downloading Power BI Desktop
-
Important Power BI Settings
-
Power BI Interface Overview
-
-
-
Importing Data From Excel, SQL, Web and more
-
Power Query Editor
-
Basic Transformations in Power Query
-
Text Tools
-
Date & Time Tools
-
Numerical Transformations
-
Grouping
-
Pivot & Unpivot
-
Relationships
-
Merge Queries
-
File Path Error
-
Appending Queries
-
Case Study: Cleaning & Transforming Data
-
Bonus: Get More Datasets & Reports for Practice
-
-
-
Report View
-
Setting up a Dashboard
-
Inserting Elements
-
Creating Charts & Visuals
-
Adding Forecasts & Analytics
-
Creating Maps
-
Conditional Formatting
-
Tables & Matrices
-
Cards, Multicards & KPIs
-
Filters
-
Slicers
-
Buttons & Bookmarks
-
Case Study: Creating a Professional Dashboard Part 1
-
Case Study: Creating a Professional Dashboard Part 2
-
Leave us a review on Google!
-
AI Visuals: Decomposition Tree
-
AI Visual: Key Influencers
-
AI Visual: Q&A
-
Get More Visuals
-
-
-
Introduction to DAX (Data Analysis Expressions)
-
Dataset Overview & Upload
-
Creating Calculated Columns
-
Creating Measures
-
Measure Tools for Naming & Formatting
-
DAX Syntax and Creating Other Measures
-
Applying Other Measures
-
Basic Operators & Intermediate Measures
-
Adding Comments & Quick Measures
-
-
-
Logic Functions & Operators
-
CALCULATE Function
-
CALCULATE with ALL and FILTER Functions
-
RELATED function
-
Iterator Functions
-
SWITCH Function
-
Text Functions
-
Date Functions
-
Time Intelligence Functions
-
DAX Variables
-
DAX Measures Glossary & Measures Summary
-
-
-
Case Study Introduction
-
Data Cleaning Part 1
-
Data Cleaning Part 2
-
Relationships
-
Report Formatting
-
Slicers & KPIs
-
Area & Pie Charts
-
Country Breakdown Table
-
Map Chart
-
Manager Demographics
-
Grouping Age Brackets
-
Case Study Conclusion
-
About this course
- $189.00
- 97 lessons
- 7 hours of video content