ANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY!

Use Microsoft’s free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time!

Simple, step-by-step instructions walk you through installing PowerPivot, importing data, using PivotTables with PowerPivot, using super-powerful DAX functions and measures, reporting to print or SharePoint, and a whole lot more.

Whatever your Excel data analysis experience, this book will help you use PowerPivot to get the right answers, right now—without IT’s help!

• Import and integrate data from spreadsheets, SQL Server, Access, Oracle, text files, Atom data feeds, and other sources


• Analyze multiple tables together, without complicated VLOOKUPs


• Format, sort, and filter data in the PowerPivot window


• Add calculated columns using new DAX functions


• Create powerful reports from PowerPivot data—and format them so executives instantly get your point


• Discover PivotTable tricks that work even better in PowerPivot


• Control multiple PivotTable elements on one worksheet, with one set of Excel 2010 Slicers


• Use DAX Measures to quickly perform tasks that were difficult or impossible with Calculated Fields


• Compare today’s sales to yesterday’s–or to sales from the parallel period last fiscal year.


• Use Named Sets to prepare asymmetric reports, show actuals for past months and plan for future months.