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.
