Introduction
  • Welcome to the Course!
  • What is Power BI?
  • Installing Power BI Desktop & Project Setup
  • Connecting Power BI Desktop to Source Files
  • Join our Online Learning Community
  • Working in the Query Editor
  • Understanding the Data Model & Creating Visuals
  • Course Outline - What's Inside the Course?
  • How To Get The Most Out Of This Course
  • Useful Resources & Links
Introducing Power BI Desktop
  • Module Introduction
  • Using the Attached Project Files
  • Understanding the Power BI Desktop Workflow
  • Exploring the Interface of the Data Model
  • Understanding the Query Editor Interface
  • Important! Creating the Project File & Recommended Settings
  • Course Slides 2020
  • Useful Resources & Links
Working in the Query Editor
  • Module Introduction
  • Connecting Power BI Desktop to Source Files
  • Keeping & Removing Rows
  • Working with Filters
  • Removing Empty Rows
  • Saving the Project Draft
  • Appending Queries
  • Working with Columns
  • Replacing Values
  • [Please Read]: Important Hint for the Next Lecture
  • Formatting Data & Handling Formatting Errors
  • Pivoting & Unpivoting Data
  • Splitting Columns
  • Creating Groups & Cleaning Up our Project
  • What we Achieved & How to Continue
  • Theory Time: The Star Schema
  • How we Use the Star Schema in our Project
  • Query Duplicates vs References
  • Creating the DIM-Region Table & Removing Duplicates
  • Creating Tables Manually
  • Theory Time: Merging Queries
  • Understanding "Join Kind"
  • Merging Queries Applied
  • Finishing the DIM-Region Table
  • The Next Steps
  • Creating the DIM-Age Table
  • Understanding "Extract"
  • Working with Conditional Columns
  • Creating the FACT-Table
  • Understanding Basic Mathematical Operations
  • Performance Optimization
  • Time to Practice - Query Editor
  • Wrap Up
  • Useful Resources & Links
Understanding the Data Model: Data & Relationship View
  • Module Introduction
  • Understanding Relationships
  • Cardinality: Many-to-One & One-to-One
  • Cross Filter Direction & Many-to-Many
  • Understanding Active Properties
  • M-Language vs DAX (Data Analysis Expressions)
  • M vs DAX - A Practical Example
  • Understanding the DAX Basics
  • The DAX Syntax
  • Supported DAX Data Types
  • Diving Into Operators
  • DAX Functions - An Overview
  • Understanding the CALENDAR Function
  • Applying the DAX Basics
  • Understanding IF & RELATED
  • Calculated Columns vs Measures
  • Creating our First Measures
  • Understanding CALCULATE & FILTER
  • Applying CALCULATE & FILTER in Measures
  • Creating Measures with Measures
  • Understanding "Data Category"
  • Time to Practice - Data Model & Relationships
  • Wrap Up
  • Useful Resources & Links
Creating Visuals in the Report View
  • Module Introduction
  • Understanding Basic Visual Concepts
  • Getting Started with Visuals & Reports
  • Creating our First Visuals
  • Understanding Tooltips & Interactions
  • Diving Intro Hierarchies & Drill Mode
  • Data Colors & Conditional Formatting
  • Formatting Report Pages
  • Formatting Visuals
  • Working with Report Themes
  • Using the Slicer
  • Understanding Default Summarization & Sorting
  • Working with Treemaps & Tables
  • Syncing Slicers
  • Understanding Filter Types (Visual, Page & Report)
  • Working with (Multi) Row Cards
  • Creating Combined Visuals & Waterfalls
  • Using Custom Visuals
  • Time to Practice - Visualizations