PowerPivot for Business Intelligence Using Excel and SharePointAuthors:
- Barry Ralston
- …show all 1hide
ISBN: 978-1-4302-3380-0 (Print) 978-1-4302-3381-7 (Online)
Ralston, Barry
2011, 304 p.
A product of Apress
ISBN 978-1-4302-3380-0
Usually dispatched within 3 to 5 business days.
About this book
- Covers an exciting new technology that appeals strongly to Excel and SharePoint users. Author is a nominee to the Microsoft Business Intelligence Partner Advisory Council. Content is solution-oriented, showing readers how to perform specific analysis tasks.
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
Table of contents
- Getting Started with PowerPivot for Excel
- Hello World, PowerPivot Style
- Combining Data Sources
- Data Analysis Expressions
- A Method to the Madness
- Installing PowerPivot for SharePoint
- Collaboration, Version Control, and Management
- PowerPivot As a Data Source
- PowerPivot and SQL Server Reporting Services
- PowerPivot and Predictive Analytics
- Tips, Tricks, and Traps
- Authors & Editors
Barry Ralston is the chief architect for business intelligence with Birmingham-based ComFrame Software. Barry is also Microsoft’s Virtual Technical Specialist (VTS) for business intelligence, responsible for assisting in Alabama, Mississippi, and northwest Florida in sales efforts including customer meetings, software demonstrations and proof-of-concept efforts. Barry’s client successes include: American Cast Iron Pipe Company, Georgia Tech Research Institute, Bank of Hawaii, Honda Manufacturing of Alabama and Aflac.