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
