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 9

image

PowerPivot Basics

You need one fundamental thing to create stunning visualizations—data. Specifically, you need data in PowerPivot, the Excel add-in that can handle many times the volumes of data that Excel can handle natively—tens of millions of rows if need be. So, to ensure that you are at ease when creating data sets in the Excel Data Model, data sets that are ready for modeling and extending in PowerPivot and for later analysis in Power View, this chapter will take you through the basics of PowerPivot, and will explain how to

  • Load data from external sources, specifically SQL Server databases and Excel
  • Follow the evolution of changes ...

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