PowerPivot for Business Intelligence Using Excel and SharePoint

'PowerPivot for Business Intelligence Using Excel and SharePoint' is your key to mastering PowerPivot- a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled from any of the leading database platforms, as well as from spreadsheets and flat files.

'PowerPivot for Business Intelligence Using Excel and SharePoint' shows you how:
- Install and verify the PowerPivot software
- Integrated existing, available data to deliver business intelligence
- Leverage Time Intelligence to report change over time
- Write Data Analysis Expressions (DAX) to create custom measures
- Identify and implement solutions for role-playing dimensions
- Recognize and work-around PowerPivot's missing features

The book takes a scenario-based approach to showing you how to collect data to mine that data through insightful analysis, and to draw conclusions that drive business performance. Each chapter is focused om a specific challenge that you'll encounter when using PowerPivot. Chapters present real-world solutions to real-world scenarios, helping you take advantage of Microsoft's new leading technology for bringing data analysis to the desktop.