Getting Started
  • What does the course cover?
  • Objectives: Getting Started
  • Getting set up
  • Power BI install from the Microsoft Store (March 2018+)
  • First look at the user interface
  • Assignment 1: Getting Started
  • Your first visualization
  • Styling the visualization
  • Assignment 2: Create a basic visualization
  • Summary: Getting Started
Creating professional dashboards
  • Objectives: Creating professional dashboards
  • Creating a dashboard
  • Adding interactivity to dashboards
  • Drill through features
  • Custom Visualisations
  • Dashboard design best practices
  • Assignment 3: Creating a well designed dashboard
  • Summary: Creating professional dashboards
Querying data from different sources
  • Objectives: Querying data from different sources
  • Querying a SQL Server database
  • Querying a text file
  • Querying web pages
  • Querying web API based data
  • Summary: Querying data from different sources
Cleaning & Transforming Data
  • Objectives: Cleaning & Transforming data
  • Cleaning up web data
  • Transforming data
  • Assignment 4: Querying and Cleaning data
  • Summary: Cleaning & Transforming Data
Publishing visualisations on Power BI.com
  • Objectives: Publishing Visualisations on Power BI.com
  • Publishing your visualisations
  • Refreshing data
  • Creating Content Packs
  • Assignment 5: Publishing and Sharing content
  • Summary: Publishing Visualisations on Power BI.com
Bonus Lectures
  • Creating a data model
  • Creating calculated columns to enrich the data model
  • Importing an Excel data model
New features as of Oct-16
  • Introduction to new features
  • Line Chart Drill Down
  • New Drill Down features
  • Slicer searching
  • Mobile Reporting