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