PowerPivot comprises 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 (OLAP) solutions using PowerPivot for Excel,
and then share those solutions with other users via PowerPivot for
SharePoint. Data can be pulled in from any of the leading database
platforms, as well as from spreadsheets and flat files.
PowerPivot for Business Intelligence Using Excel and SharePoint is
your key to mastering PowerPivot. 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 in the book is focused on a specific challenge
that you'll encounter when using PowerPivot. Each chapter takes you
through a solution technique that's been proven in the real world.
- Covers the leading technology for bringing data analytics to the
desktop
- Presents real-world solutions to real-world scenarios
- Written by a Microsoft Virtual Technical Specialist (VTS) for business
intelligence