Improving Power Pivot Data Models for Power BI

Power BI offers many tools to explore a data model created in Power Pivot, such as Excel, Power View and Q & A. You can improve the user experience and the accessibility of information by creating the data model in a proper way. In this session, you will learn the best practices in data modeling for Power Pivot in order to improve the browsing experience in Excel and Power View. You will see how important is to name tables in the correct way, to define the correct set of relationships and how to use good synonyms so that Q & A can provide the right answer to user’s questions. If you do not follow the best practices, you might end up with an approach that is good for Excel and Power View but that does not perform as well with Q & A. This session will clarify these issues and guide you to the correct set of choices.
Presented by Marco Russo at SQLBits XII
Tags (no tags)