Course outline

1. Power BI Introduction
   1. Get Power BI Tools
   2. Introduction to Tools and Terminology
   3. Dashboard in Minutes
   4. Refreshing Power BI Service Data
2. Getting and Transforming Data with Power BI Desktop
   1. Introduction to Power BI Desktop
   2. Getting Data: Excel vs Power BI Desktop & Service
   3. Data Structure for Q&A
   4. DirectQueryvs Import Data
3. Understanding Query Editor
   1. What is the Query Editor?
   2. Connecting Power BI Desktop to our Data Sources
   3. Editing Rows
   4. Understanding Append Queries
   5. Editing Columns
   6. Replacing Values
   7. Formatting Data
   8. Pivoting and Unpivoting Columns
   9. Splitting Columns
4. Data Modelling: Data & Relationship View
   1. Query Editor vs. Data Model
   2. Introducing and Understanding Relationships
   3. Editing Relationships
   4. Understanding Cardinality
   5. Cross Filter Selection and Many-To-Many Relationships

4. 6. Active Properties
   7. Understanding the differences between the M-Language and DAX
   8. M vs. DAX applied: Calculated Columns
   9. M vs. DAX: Conclusion
   10. DAX – Basic information
   11. DAX and Calculated Columns
   12. Calculated Columns vs. Measures
   13. Introducing DAX-Measures
   14. DAX-Measures Continued
   15. Categorizing Data
5. Power BI Desktop Visualizations
   1. Creating Visualizations
   2. Color Formatting
   3. Setting Sort Order
   4. Scatter & Bubble Charts & Play Axis
   5. Tooltips
   6. Slicers & Timeline Slicers
   7. Cross Filtering and Highlighting
   8. Visual, Page and Report Level Filters
   9. Drill Down/Up
   10. Hierarchies
   11. Reference/Constant Lines
   12. Tables, Matrices & Conditional Formatting
   13. KPI’s, Cards & Gauges
   14. Map Visualizations
   15. Custom Visuals
   16. Managing and Arranging