Chapter 2PowerPivot: Overview
Chapter 1 was a very quick introduction to PowerPivot for Excel. It concentrated on importing data from SQL Server. This chapter takes a more detailed look at importing data from SQL Server. It also shows how to import data from Access, Excel, and data feeds. You are shown relationships between PowerPivot tables and how to set them up, if they are missing. Data Analysis eXpressions (DAX) is used to create both calculated columns in PowerPivot tables and measures in PowerPivot pivot tables in Excel. In addition, a measure is added through the GUI, without the need for DAX. You get to construct a sophisticated pivot table and a pivot chart linked to the pivot table. Various ways of filtering data in a pivot report ...
Get Practical PowerPivot & DAX Formulas for Excel 2010 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.
