Curriculum

8 Topics
Course Overview
Learner Files
Power BI Tools & Apps - Download
On-Object Interaction
Power BI Walkthrough
Power BI Overview
Retail Data Set Overview
Download Learner Files

13 Topics
Introduction - Power Query
What is Power Query
Import & Load Data
Transform Data - Store Details - Fill & Merge Columns
Transform Data - Store Details - Text Columns
Transform Data - Select Columns & Filter Rows
Transform Data - Unpivot Data
Transform Data - Change Data Types
Transform Data - Pivot Data
Add Columns
Manage Queries
Advanced Power Query
Load Queries to the Data Model

7 Topics
Introduction
Data Modeling & Database Normalization
Fact & Dimension Tables
Create Data Model
DAX & DAX Measures
Create Basic DAX Measures
Data Model Best Practices

1 Topic
Week 1 Challenge

13 Topics
Introduction
Visualizing With Context
Create Sales Column Chart
Create Sales Map & Ribbon Chart
DAX Calculated Columns
Create DAX Calculated Columns
Recreate Total Gross Margin with SUMX()
Date Dimension
Create Total Sales YTD with Quick Measures.
Create & Format Card Visual for DAX Measures
Filter Report with Slicers & Filter Pane
Cross Filter & Edit Chart Interactions
Use CALCULATE() to Filter Measures

8 Topics
Introduction
Add Retail Cost Fact Table
Create Basic DAX Measures - Retail Cost
Create Scatter Chart
Create KPI Card
Create Table Visual
Create Difference from Target DAX Measure
Add Date Slicer

11 Topics
Introduction
Sync Slicers Across Pages
Add Zoom Sliders to Visuals
Conditional Formatting - Data Bars & Icons
Conditional Formatting - Background Gradient & Rules
Conditional Formatting - % of Target
Reset Report Page with a Bookmark
Set a Bookmark to Highlight an Insight
Link a Bookmark to a Button
Drillthrough from Sales to Cost
Apply a Custom Theme

1 Topic
Week 2 Challenge

10 Topics
Introduction
Power BI Service Overview
Publish a Report to the Power BI Service
Workspaces & Apps
View a Report
Explore a Dataset
Create a Dashboard
Interact with Dashboard Q&A
Link a Scorecard to Report Metrics
Share Your Reports

1 Topic
Summary

1 Topic
Final Assessment

  Write a Review

Power BI Fundamentals

Go to Free Course