Introduction

• Operationalize Data with Dashboards

• Benefits of Dashboards

• A Framework for Visual Analytics

Users

• Know your users

• User Empathy Map

• Problems, Reasons, Actions

• Case study

• Quiz

Content

• Good Content

• Measures

• Quiz

• 4 Aspects of Measures

• Dimensions

• Quiz

• Decision Value Chain

• Unifying Decision Value Chain

• Balanced View of Measures

• Quiz

• Measure Grid Design

• Quiz

• Aggregation

• Putting Together

• Summary

Presentation

• Good Presentation

• Visual Encoding

• Visual Encoding Example

• Relationship 1 (Scatter Plot)

• Relationship 2 (Bubble Chart)

• Relationship 3 (Heatmap)

• Quiz

• Comparison

• Composition

• Quiz

• Time-series

• Quiz

• Distribution

• Quiz

• Common mistake

• Tips

Navigation

• Principles 1 : Comparisons

• Principles 2 : Cause & Effect

• Principles 3 : Multivariate

• Principles 4 : Integration of Evidence

• Principles 5 : Documentation

• Interactive Dynamics 1

• Interactive Dynamics 2

• Example

Summary

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