Questions answered in this chapter:
How do I read data into PowerPivot?
How do I use PowerPivot to create a PivotTable?
How can I use slicers with PowerPivot?
What are DAX functions?
Microsoft PowerPivot for Excel 2010 is an add-in that enables you to easily create PivotTables for large data sets—up to 100,000,000 rows of data! Most amazingly, the data can come from a variety of sources. For example, some of your data might come from a Microsoft Access database, some from a text file, some from several Excel files, and some from live data imported from a website. In this chapter, I provide an introduction to PowerPivot. For a more complete explanation of how PowerPivot works, I heartily recommend Microsoft PowerPivot for Excel ...