Now that you know how to get data into the Power Pivot model, the next step is to understand what makes a good model. This is very important when dealing with data in Power Pivot. A good model will make Power Pivot perform amazingly fast and allow you to analyze the data in new and interesting ways. A bad model will cause Power Pivot to perform very slowly and at worst give misleading results when performing the data analysis. Traditional Excel pivot tables are based on a single table contained in an Excel sheet. Power Pivot tables are based off of multiple tables contained in the data model. This chapter ...
© Dan Clark 2017
Dan Clark, Beginning Power BI, 10.1007/978-1-4842-2577-6_4
4. Creating the Data Model
(1)Camp Hill, Pennsylvania, USA