Getting Started

• Understanding the Power BI Tools
• Initial Project 1/3: Installing Power BI Desktop and Connecting to Data
• Initial Project 2/3: Working in the Query Editor
• Initial Project 3/3: Working in the Data Model and Creating a Visualization
• How to use the Attached Project Files

An Introduction to Power BI Desktop

• An Overview of the Workflow in Power BI Desktop
• Introducing the Different Views of the Data Model
• Taking a Closer Look at the Query Editor Interface
• Important! Before we Dive Deeper: Required Power BI Settings

An Introduction to the Query Editor

• Just to be sure: What is the Query Editor?
• Before we Start – About the Attached Project Files
• Connecting Power BI Desktop to our Data Sources
• Editing Rows
• Understanding Append Queries
• Editing Columns
• Replacing Values
• Formatting Data
• Pivoting and Unpivoting Columns
• Splitting Columns
• Creating a New Group for our Queries
• What we Achieved until Now and How to Continue
• Introducing the Star Schema
• Duplicating and Referencing Queries
• Creating the DIM Region Table
• Entering Data Manually
• Merging Queries
• Finishing the DIM Region Table
• Introducing the DIM AgeGroup Table
• Creating an Index Column
• Duplicating Columns and Extracting Information
• Creating Conditional Columns
• Creating the FACT Population Table
• Performing Basic Mathematical Operations
• Improving Performance and Loading Data into the Data Model

Working on our Data Model: Data & Relationship View

• Query Editor vs. Data Model
• Introducing and Understanding Relationships
• Editing Relationships
• Understanding Cardinality
• Cross Filter Selection and Many-To-Many Relationships
• Active Properties
• Understanding the differences between the M-Language and DAX
• M vs. DAX applied: Calculated Columns
• M vs. DAX: Conclusion
• DAX – Basic information
• DAX and Calculated Columns
• Calculated Columns vs. Measures
• Introducing DAX-Measures
• DAX-Measures Continued
• Categorizing Data 

Working in the Report View to Visualize our Results 

• Understanding the Interface of the Report View
• Creating our First Visualizations
• Editing Interactions and Adding Tooltips
• Adding Data Colors
• Understanding Hierarchies and Adding Drill-Down
• Formatting Charts and Sorting
• About the Slicer
• Introducing Slicers
• Adding Treemaps and Tables
• Applying different Filter Types
• Creating (Multi-Row) Cards
• Understanding Combined Visualizations and Waterfalls 

Power BI Service & Power BI Mobile

• Continuing our Work and why we need Power BI Service
• Comparing Power BI Free, Pro and Premium
• Logging in to Power BI Service
• Understanding the Interface
• Importing our Data from Power BI Desktop to Power BI Service
• Understanding the Dataset Menu
• Working on Reports
• Introducing Dashboards
• Exploring our Workspace
• Understanding Gateways
• Comparing Personal and On-Premise Gateway and Installing a Gateway
• Working alone or Collaborating with Colleagues
• Collaborating in App Workspaces
• Sharing the Results
• Publishing the App
• Content Packs from Online Services
• Power BI Mobile: Installing and Understanding the Mobile App
• Excluding Datasets from Sharing

Other Data Sources

• Importing JSON Data
• Importing Data from REST APIs
• Preparation: Setting up a MySQL Server
• Importing Data from a MySQL Server (and other SQL Servers) 

Creating Custom Visuals (Power BI for Developers)

• Developer Prerequisites
• Module Introduction
• How do Custom Visuals Work?
• Using Data Driven Documents (D3)
• Please Read – Creating & Installing a Certificate
• Creating and Using a Visual
• Installing an IDE (Code Editor)
• Understanding the visuals.ts File
• Understanding the Project Structure
• Installing d3.js (Data Driven Documents)
• Adding a First Shape
• Connecting Shapes to Data
• Scaling Shapes
• Managing Visual Capabilities to Allow Data Input
• Starting the Data Extraction
• Limiting the Data Input
• Extracting Data
• Displaying the User Data
• Optimizing the Code
• Adding Dynamic Coloring
• Making Bars Selectable (Cross-Visual)
• Adding X-Axis Labels
• Adding Custom Visuals Settings
• Extracting the Visual Configuration
• Informing Power BI About the Custom Configuration