CHAPTER 11

image

PowerPivot for Self-Service BI

After reading the last two chapters you now understand how to create a valid PowerPivot data model. This data set will allow you to slice and dice your data in many different ways and can be used as-is with many tools such as Excel pivot tables and, of course, Power View.

Indeed, there is little to prevent you now from starting to use the data model that you have created in pivot tables or, better still, to deliver stunning Power View visualizations. However, while we are on the subject of finalizing the data model, there are a handful of tweaks that you may want to apply to the tables in the data set. ...

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.