June 2010
Beginner to intermediate
336 pages
8h 29m
English
Content preview from PowerPivot for the Data Analyst: Microsoft® Excel 2010Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Contents at a Glance
1. Downloading and Installing PowerPivot
3. Why Wouldn’t I Build Every Future Pivot Table in PowerPivot?
4. Getting Your Data into PowerPivot
5. Creating and Managing Relationships
8. Cool Tricks Native to Pivot Tables
9. Cool Tricks New with PowerPivot
10. Using DAX for Aggregate Functions
12. Named Sets, GetPivotData, and Cube Formulas
13. Final Formatting: Making the Report Not Look Like Excel