Introduction to Power BI

• Welcome to Course

• Overview

• What is Dashboard

• Why Power BI

• Power BI vs Excel

• Download Power BI

• Install Power BI

• Community

• Set up Power BI (I)

• Set up Power BI (II)

• Introduce Power BI (I)

• Introduce Power BI (II)

• Get Data

• Best Practise (Importing data)

• Quiz: Quiz

Connect & Transform Data

• Workshop 1: Connect & Transform Data

• Workshop 1: Download Data Files

• Workshop 1: Import Data

• Power Query (I)

• Power Query (II)

• Quiz: Quiz

• Home tab

• Quiz: Quiz

• Merge and Append queries

• Append queries

• Merge queries

• Transform Data Format

• Text Column / Number Column

• Quiz: Quiz

• Solution

• Pivot Unpivot

• Quiz: Quiz

• Add Column

• Save file

Build Data Model

• Data Model (I)

• Data Model (II)

• Data Format

• Data Relationships

• Visualizations

• Get Information From Visual (I)

• Get Information From Visual (II)

• Quiz: Export Data

• Recap

Visualize & Analyze Data

• Workshop 2: Spotify Data

• Workshop 2: Download Data Files

• Workshop 2: Import Data

• Visualizations

• Create Card / Table / Metric

• Quiz: Quiz

• Scatter plot (I)

• Scatter plot (II)

• Quiz: Quiz

• Slicer (I)

• Slicer (II)

• Filter Pane (I)

• Filter Pane (II)

• Line Chart (I)

• Line Chart (II)

• Quiz: Quiz

• Bar Chart / Column Chart (I)

• Bar Chart / Column Chart (II)

• Grouping (I)

• Grouping (II)

• Quiz: Quiz

• Pie Chart / Donut Chart / Tree map (I)

• Pie Chart / Donut Chart / Tree map (II)

• Custom Visual

• Insert Image / Textbox

• Interaction

• DAX

• Quick Measure (I)

• Quick Measure (II)

Publish Reports for Team Collaboration

• Publish Report (I)

• Publish Report (II)

• Publish Report (III)

• Congrats