Microsoft PowerPivot for Excel 2010: Give Your Data Meaning
Microsoft Press; 1 edition (October 5, 2010) | English | ISBN-10: 0735640580 | 416 pages | 21,56 Mb

Book Description

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 SharePoint®.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O’Reilly Media’s Digital Distribution services. To download this content, please visit O’Reilly’s web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

From the Author

We have been working with PowerPivot since its early releases and, as all the new products, it requires some training to be used to its full potential. We wrote a book for end users who want to master PowerPivot, providing many examples and patterns to solve the typical business problems, which sometimes require solutions that are not easy to implement. You will be able to use this book both as a quick reference for common patterns and to learn how PowerPivot works and how to model your data in the good way.

About the Author

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 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.

Alberto and Marco recently co-authored “Expert Cube Development with Microsoft SQL Server® 2008 Analysis Services” published by Packt Publishing and the “SQLBI Methodology”. They are also the founders of SQLBI (sqlbi.com).



Xem Thêm :