Analyzing and Visualizing Data with Power BI (1 day)

After completing this course, students will be able to:

• Perform Power BI desktop data transformation.
• Describe Power BI desktop modelling.
• Create a Power BI desktop visualization.

Module 1: Load and Transform data

Lessons

• Introduce Power Query Editor
• Shaping data
• Combining data

Lab:

• Accessing Data
• Adding additional data
• Data Preparation
• Renaming tables
• Using Fill feature
• Using Split feature
• Using Rename Column feature
• Using Column from Examples feature
• Using Add/Remove Rows feature
• Using Transpose feature
• Using Append and Conditional Column feature

Module 2: Data Modeling

Lessons

• Relationships
• Introduce DAX
• Calculated columns and measures

Lab:

• Create relationships
• Create calculated columns within table
• Create measures:
  • Simple aggregations: SUM(), AVERAGE()
  • Filter functions: CALCULATE(), ALL(), ALLEXPECT()
  • Time Intelligence functions: PREVIOUSYEAR()

Module 3: Data Visualization

Lessons

• Creating Power BI reports with visual
• Formatting visuals

Lab:

• Building Power BI reports
• Drill through