O'Reilly logo

High Impact Data Visualization with Power View, Power Map, and Power BI by Adam Aspin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 10

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required