PRE-ASSESSMENT
+ SECTION 1 | INTRODUCTION - 6 MODULES
1. Welcome and Overview
2. What Is Power BI?
3. Install Power BI Desktop
4. A Tour of Power BI Desktop
5. Explore Commonly Used Power BI Options
6. Quiz
+ SECTION 2 | GETTING AND TRANSFORMING DATA - 7 MODULES
1. Import Files From a Folder Into Power BI Desktop
2. Get Data From Excel and Text Files
3. Reference Queries to Create Additional Lookup Tables
4. Merge Queries in Power Query
5. Prevent Queries From Loading Into Power BI Desktop
6. Practice Exercise
7. Quiz
+ SECTION 3 | DATA MODELING - 8 MODULES
1. Create Relationships Between Tables
2. Create a Dynamic List of Dates
3. Create Additional Date Columns for Analysis
4. Sort the Month and Weekday Names Correctly
5. Mark the Table as a Date Table
6. Hide Unnecessary Fields From Report View
7. Practice Exercise
8. Quiz
+ SECTION 4 | INTRODUCTION TO DAX MEASURES - 7 MODULES
1. Calculate the Total Revenue
2. Count the Total Rows of a Table
3. Use the CALCULATE Function
4. Calculate the Total Revenue Last Year
5. Difference Compared to Last Year
6. Practice Exercise
7. Quiz
+ SECTION 5 | ADDING VISUALIZATIONS TO YOUR REPORTS - 10 MODULES
1. Show Summary Information With Cards
2. Columns Charts to Compare Values
3. Map Visual to Plot Geographic Data
4. Slicers to Filter Your Reports
5. KPI Card to Measure Performance Against a Goal
6. Line Graphs to Visualize Trend
7. Show Detail With the Matrix
8. Top N Lists With the Table Visualization
9. Practice Exercise
10. Quiz
+ SECTION 6 | REPORT DESIGN - 5 MODULES
1. Adding Text Boxes and Shapes
2. Use Themes
3. Conditional Formatting
4. Practice Exercise
5. Quiz
+ SECTION 7 | EDITING INTERACTIONS AND FILTERS - 5 MODULES
1. Edit the Interactions Between Your Visualizations
2. The Filter Pane to Filter at Any Level
3. Drill Through to More Detail
4. Practice Exercise
5. Quiz
+ SECTION 8 | POWER BI SERVICE - 4 MODULES
1. Publish Your Report to the Power BI Service
2. Different Ways to Share Your Power BI Report
3. Practice Exercise
4. Quiz
+ SECTION 9 | CLOSING - 1 MODULE
FINAL ASSESSMENT