PowerPivot for the Data Analyst: Microsoft Excel 2010
Book Description
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
Continue Reading »
No comments:
Post a Comment