CHAPTER 10
Extending the Excel Data Model Using PowerPivot
This chapter further develops the data tables that you imported in the previous chapter. You will discover how to take the data tables that you loaded and convert them into a coherent data set in the Excel Data Model using PowerPivot. This data set will enable you to deliver information, insight, and analysis from the data the tables contain.
Once you have loaded the source data into Power View tables there are essentially three steps to follow to mold the tables into a cohesive whole.
- Establish relationships between the tables so that PowerPivot understands how the data in one table ...
Get High Impact Data Visualization with Power View, Power Map, and Power BI now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
