Microsoft PowerPivot for Excel 2010 Give Your Data Meaning

by Ferrari, Alberto; Russo, Marco

• ISBN13: 9780735640580
• ISBN10: 0735640580
• Edition: 1st
• Format: Paperback
• Copyright: 2010-10-05
• Publisher: Microsoft Press

Summary

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 and share your own BI solutions using software you already know and 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 and on-the-job results-no programming required. The book introduces you to PowerPivot functionality, then takes a pragmatic approach to understanding and 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 SharePointr.

Author Biography

Marco Russo is a software consultant and trainer based in Italy who focuses on Windows development and Business Intelligence solutions, including data warehouse relational and multidimensional design. He is the coauthor of Introducing Microsoft LINQ and Programming Microsoft LINQ (Microsoft Press), along with several other books about Microsoft .NET and SQL Server Analysis Services. ALBERTO FERRARI is a consultant and trainer who specializes in developing Microsoft Business Intelligence solutions, including guiding software organizations through the design of complex BI solutions. He is the coauthor of Expert Cube Development with Microsoft SQL Server 2008 Analysis Services and SQLBI Methodology (with Russo).

Alberto Ferrari ([e-mail]) is a consultant and trainer for the BI development area with the Microsoft suite for Business Intelligence. His main interests are in the methodological approaches to the BI development and works as a trainer for software houses that need to design complex BI solutions.

He previously recently co-authored "Expert Cube Development with Microsoft SQL Server® 2008 Analysis Services" published by Packt Publishing and the "SQLBI Methodology" with Marco Russo. Alberto is a founder of SQLBI (http://www.sqlbi.com) and his blog is available at http://sqlblog.com/blogs/alberto_ferrari.