Improving Power Pivot Data Models for Microsoft 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, learn the best practices in data modeling for Power Pivot in order to improve the browsing experience in Microsoft Excel and Power View. 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 clarifies these issues and guides you to the correct set of choices.



Enclose code in comments with <PRE></PRE> to preserve indentation.