Back To Schedule
Wednesday, May 23 • 08:00 - 17:00
Academy - Power BI - Become a Hero in a Day! ($149)

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Note:  Academy classes require a separate registration - Click here to register today!

This is a hands-on course so please ensure you have the latest version of Power BI Desktop installed on your machine.  If you don't have a laptop it will not be a problem as you will still easily be able to follow along.  Click here to download Power BI Desktop.

Hands-on files (1 x PBIX and 3 x XLSX files) and the PowerPoint file are available to download (see the bottom of this page).  Please download the Hands-On files before the session.

  • Why do we need BI?
  • Traditional BI vs Agile BI
  • Overview of BI Tools
  • Components of BI (data prep, data modelling, data visualisation)
Data Prep
  • How and Why?
  • Power Query Editor
  • Hands On – Connecting to Data (SQL DB, Web, Excel, CSV)
  • Hands On – Cleaning Data
  • Hands On – Combining Data
  • Hands On – Creating a Date / Calendar Table using underlying data date range
  • Hands On – Working with Nulls
  • Hands On – Working with Date Locales
  • Power Query Common Pitfalls
Data Modelling
  • Understanding Data / FACT tables and Lookup / DIM tables
  • Understanding Relationships
  • Understanding Evaluation Context
  • What is DAX?
  • Hands On – Working with Columns
  • Hands On – Basic and Intermediate Measures
  • Hands On – Quick Measures
Data Visualisation
  • Drilling Up / Down
  • Filtering and Cross Filtering
  • Visual, Page, Report Filters
  • Working with Dates incl. Relative Date filter
  • Formatting tables and graphs
  • Bookmarking / Storytelling / Spotlight / Buttons
  • Working with Maps
  • Custom Visuals
Sharing / Publishing
  • Reports vs Dashboards
  • Apps and Workspaces
  • PBI Service, PBI Embedded, PBI Report Server
  • Email Subscriptions
  • Data Alerts

avatar for Sven Vosse

Sven Vosse

Director, mavenBI
I'm the lead consultant at mavenBI, a BI Consulting and Training company focusing on Microsoft BI solutions for medium-sized companies.

Wednesday May 23, 2018 08:00 - 17:00 SAST
Training Room 2 The Canvas Riversands

Attendees (3)