Microsoft PowerPivot for Excel 2010 384pages software manual

PowerPivot for Excel 2010 For Excel power users and business analysts
- Apply what you know about Excel formulas to DAX, the PowerPivot language
- Quickly import, sort, and filter massive data sets
- Master the fundamentals of data modeling and working with patterns
- Simplify year-to-date, closing balance, and other date-driven computations
- Calculate ratios, ranking, standard deviation, and Pareto analyses
- Express PowerPivot date in sophisticated PivotTables, reports, and charts
- Easily share - and update - your solutions through Microsoft SharePoint

Transform your skills, data, and business - with the power user's guide to PowerPivot for Excel.
Led by two business intelligence (BI) experts, you'll learn how to create & share your own BI solutions using software you already know & love: Microsoft Excel.
Discover how to extend your existing skills, using the PowerPivot add-in to quickly turn mass quantities of data into meaningful information & on-the-job results - no programming required.
The book introduces you to PowerPivot functionality, then takes a pragmatic approach to understanding & working with data models, data loading, data manipulation with Data Analysis Expressions (DAX), simple-to-sophisticated calculations, what-if analysis, and PowerPivot patterns. Learn how to create your own, "self-service" BI solutions, then share your results effortlessly across your organization using Microsoft SharePoint.

On the DVD-ROM:
- Workbook examples to study & customize;
- A Microsoft Access version of the book's sample database;
- Fully searchable eBook.