Business Intelligence, Data Warehouse and Data Lake

SQW06 Data Model Design and Optimization for Power BI


2:00pm - 3:15pm

Level: Intermediate

Ginger Grant

Principal Data Geek

Desert Isle Group

If you have designed a data model for a data warehouse, you know most of what you need to develop a data model for Power BI, but there are some important differences to improve the overall performance and maintenance of Power BI. In this session we will review the differences and include design patterns for Row Level Security, data aggregations, and DAX Development. We will also review different design patterns for Composite Models, Direct Query, Import and Dual modes and how to organize them for optimal Power BI environments.

You will learn:

  • Understand the differences between data warehousing and data modeling for Power BI
  • How and when to use the different data modeling options available in Power BI to build the most scalable solutions.
  • Improve Power BI performance and usability by the use of composite modeling and aggregations to improve the performance of Power BI reports in large data environments