O'Reilly logo

How Libraries Should Manage Data by Brian Cox

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

8

Moving beyond basic pivots

Normal pivot tables will meet many of your needs, however, when it comes to big data, you will need some more powerful tools. This chapter explains in lay terms the limitations in using normal pivot tables to interrogate relational data. The chapter starts by explaining what a relational database is using library examples, and then explains how such data can be interrogated using PowerPivot. The basic functions of PowerPivot are explained, including step-by-step instructions on how to link data to the PowerPivot model, how to create relationships within the model, what calculated columns and measures are, and how to create them. The chapter is written for readers who have never used PowerPivot.

Keywords

PowerPivot; big ...

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