Power BI Technical

Creating a Rich Data Model Using Power BI Desktop

Thursday, May 11
8:00 AM - 9:30 AM
Room: Illinois Central

Format: Deep Dive


This sessions covers how to get started with the data modeling features available in Power BI Desktop. Attendees will learn how to design a data model by creating calculated columns and measures using DAX (Data Analysis Expression language). The session explains the differences between calculated columns and measures and discusses scenarios in which measures are preferred over calculated columns and vice versa. The module explains why and how to extend a data model with dimensional hierarchies and also introduces concepts and terms used when modeling a dataset using time dimensions. Attendees will learn why and how to create a dynamic calendar table using DAX to track time dimensions as well as how to write measures which take advantage of the Time Intelligence functions available in DAX. By the end of this session, attendees will learn how to write DAX expressions which provide rich analytic capabilities such as calculating year-to-date totals and rolling averages and to provide drill down capabilities to the level of month, week or day.

Ted Pattison

Instructor, Author and MVP
Critical Path Training

Ted Pattison is an author, instructor and owner of Critical Path Training, a company dedicated to in-depth technical education on Power BI and SharePoint technologies. Ted is currently a Power BI Microsoft MVP and a 13-time recipient of MVP award for his expertise and community contributions with PowerBI, SharePoint, Microsoft Auzre and Office 365.

Presentation(s):

Send Email for Ted Pattison


Assets

Creating a Rich Data Model Using Power BI Desktop



Attendees who have favorited this

Send Email for Creating a Rich Data Model Using Power BI Desktop