Training » Course

Power BI for the Enterprise Modeler

This one-day course empowers business analysts and IT Pros to develop enterprise models with Power BI Desktop. It focuses on advanced model design techniques, and DirectQuery and Composite model development.

Attendees learn to:

  • Apply Star Schema design practices to optimize model designs
  • Develop DirectQuery models
  • Develop Composite models
  • Enforce row-level security to deliver the right data to report users
  • Compare benefits and limitations to determine the appropriate model type

Duration

1 day

Products

This course is based on the current offering of Microsoft Power BI, with a focus on enterprise modeling experiences with the Power BI service. It also describes Power BI Premium features, although it is not a requirement that you work with the Power BI Premium subscription.

This course does not cover Power BI import modeling, or DAX foundational skills. These topics are covered in the two-day Power BI for the Business Analyst course, which is considered prerequisite training.

Prerequisites

Ideally, attendees have:

  • Power BI Desktop skills to develop import data models
  • 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
  • The latest version of Power BI Desktop, 32- or 64-bit
  • A PDF viewer (like Adobe Acrobat Reader, or a web browser)

Delivery Format

A classroom delivery includes:

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

Course Outline

Module 01: Introducing Power BI Premium

  • Introducing Power BI Premium
  • Describing Enterprise Features

Module 02: Data Modeling Theory

  • Tabular Modeling Architecture
  • Introducing Star Schema Design

Module 03: Developing DirectQuery Models

  • Introducing DirectQuery Modeling
  • Query Considerations
  • Modeling Considerations
  • Designing Aggregations
  • Reporting Considerations
  • Recommended Practices

Lab 03A – Developing a DirectQuery Model

Module 04: Developing Composite Models

  • Introducing Composite Modeling
  • Query Considerations
  • Modeling Considerations
  • Reporting Considerations
  • Recommended Practices

Lab 04A – Developing a Composite Model

Module 05: Enforcing Row-level Security

  • Describing Security
  • Creating Roles
  • Validating Roles
  • Configuring Data-driven Security
  • Adding Members to Roles
  • Recommended Practices

Lab 05A – Enforcing Row-level Security

Module 06: Advanced DAX

  • Advanced Time Intelligence
  • DAX Path Functions

Time permitting, other topics relevant to the class can be explored.

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 software developer debugging code

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