Training » Course

Power BI for the Business Analyst

This two-day course empowers business analysts to design, develop and publish robust Power BI Desktop solutions. It focuses on import model development and solution-oriented DAX theory and practice.

Attendees will learn to:

  • Work productively with Power BI Desktop
  • Use Power Query to prepare and integrate data to load model tables
  • Configure model relationships
  • Enhance model designs with date tables, hierarchies, calculations and reporting properties
  • Use DAX to create common and useful model calculations
  • Use DAX and manually entered data to create model tables

Duration

2 days

Products

This course is based on the current offering of Microsoft Power BI, with a focus on business analyst experiences with Power BI Desktop for the Power BI service (or for Power BI Report Server).

This course does not cover report development, which is covered in the one-day Power BI for the Business User course.

Prerequisites

Attendees must have:

  • A general knowledge of data storage technologies and formats, including relational databases
  • An understanding of the Power BI service (or Power BI Report Server)
  • Power BI report development skills

Attendees are required to have their own computer that must meet minimum requirements:

  • A Windows 7 computer, or later, network-enabled for Internet access
  • Power BI Desktop, latest version—either 32- or 64-bit
  • Office 2013, or later—either 32- or 64-bit
  • A PDF viewer (like Adobe Acrobat Reader, or a web browser with a PDF add-in)
  • Internet access, to download the course resources and access cloud data sources and resources

Delivery Format

A classroom delivery includes:

  • Instructor presentation and demonstrations
  • Course book
  • Labs and activities

Course Outline

Module 01: Introducing Power BI Desktop

  • Introducing Power BI Desktop
  • Development Modes

Lab 01A – Creating the Power BI Desktop File

Module 02: Developing Model Tables

  • “Getting Data”
  • Introducing Power Query
  • Configuring Queries
  • Managing Queries
  • Recommended Practices

Lab 02A – Developing Model Queries (Part 1)
Lab 02B – Developing Model Queries (Part 2)
Lab 02C – Managing Queries

Module 03: Configuring Model Relationships

  • Describing Relationships
  • Configuring Relationships
  • Recommended Practices

Lab 03A – Configuring Model Relationships

Module 04: Enhancing Model Designs

  • Configuring the Model
  • Configuring Tables
  • Configuring Columns
  • Creating Hierarchies
  • Creating Calculations
  • Configuring Measures
  • Configuring Q&A
  • Recommended Practices

Lab 04A – Enhancing the Model Design

Lab 04B – Adding Advanced Model Features

Module 05: DAX Fundamentals

  • Power BI Desktop Review
  • DAX Fundamentals
  • Modeling Fundamentals
  • Describing Context
  • Manipulating Context
  • Working with Iterator Functions
  • Working with Time Intelligence
  • Advanced Scenarios

The class with progress through up to 23 intructor-led activities which have been designed to introduce and practice key theory. The pace of the activities will be set to one that is appropriate for the entire class, and so it may not be possible to complete all activities.

Certification

This course has not been designed to prepare attendees for Microsoft certification. However, the course content can serve as a useful resource for introducing theory, products, capabilities and recommended design practices that are assessed by Microsoft certification exams.

Cartoon depiction of a business analyst integrating different data formats

I like the activities and repetitiveness which helped me quickly come to grips with some challenging theory (DAX!). Great training! Absolutely loved it. Thank you!!

Ashleigh

Very technical. I could keep pace and found it engaging, but this course isn’t for those who won’t use Power BI Desktop. Looking forward to applying it to my own datasets!

Ben

It was very useful to learn about context, and with clarity on Power BI’s potential, limitations and functionality. I found this course quite intensive and enjoyed the pace. Invigorating!

Scott

Covered a number of items and techniques that will be directly applicable to my work.

Danielle