PowerPivot for the Data Analyst: Microsoft Excel 2010

PowerPivot for the Data Analyst: Microsoft Excel 2010

Bill Jelen

ANALYZE large quantities of commercial info speedier, extra simply, AND extra adequately!


Use Microsoft’s loose PowerPivot add-in for Excel 2010 to research monstrous quantities of knowledge from any resource, practice state of the art company research way more simply, and make greater judgements in much less time!


Simple, step by step directions stroll you thru fitting PowerPivot, uploading information, utilizing PivotTables with PowerPivot, utilizing super-powerful DAX services and measures, reporting to print or SharePoint, and a complete lot extra.


Whatever your Excel facts research event, this publication can assist you utilize PowerPivot to get definitely the right solutions, correct now—without IT’s help!

  • Import and combine facts from spreadsheets, SQL Server, entry, Oracle, textual content records, Atom information feeds, and different sources
  • Analyze a number of tables jointly, with no complex VLOOKUPs
  • Format, type, and filter out facts within the PowerPivot window
  • Add calculated columns utilizing new DAX functions
  • Create robust studies from PowerPivot data—and layout them so executives immediately get your point
  • Discover PivotTable tips that paintings even higher in PowerPivot
  • Control a number of PivotTable components on one worksheet, with one set of Excel 2010 Slicers
  • Use DAX Measures to fast practice projects that have been tough or most unlikely with Calculated Fields
  • Compare today’s revenues to yesterday’s–or to revenues from the parallel interval final economic year.
  • Use Named units to organize uneven studies, convey actuals for previous months and plan for destiny months.

Show sample text content

Download sample