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.