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