O’Reilly news

Microsoft PowerPivot for Excel 2010: Give Your Data Meaning--New from Microsoft Press

October 19, 2010

Microsoft PowerPivot for Excel 2010
Request Review copy

Sebastopol, CA—Extend your data-analysis skills—and increase your impact—by creating your own business intelligence solutions, right from Excel. No programming required. Guided by expert authors, Marco Russo and Alberto Ferrari, Microsoft® PowerPivot for Excel® 2010 (Microsoft Press, $34.99 USD) shows you how to use the PowerPivot add-in to manipulate millions of rows of data—for critical new business insights and on-the-job results.

"PowerPivot is a powerful tool for self-service business intelligence. It can aggregate huge volumes of data, it's fast and it's easy to start with," say authors Russo and Ferrari. "However, when it comes to perform complex analysis you definitely need to learn both the DAX programming language and how to model your data so that queries run fast. This doesn't mean that PowerPivot is hard to learn. But to exploit the full power of PowerPivot, it's necessary to study it and this book provides all the topics needed to become a real PowerPivot master."

Microsoft® PowerPivot for Excel® 2010 shows you how to build your own business intelligence with PowerPivot, including how to:

  • Apply what you know about Excel formulas to DAX, the PowerPivot language
  • Quickly import, sort, and filter massive data sets
  • Master the fundamentals of data modeling and working with patterns
  • Simplify year-to-date, closing balance, and other date-drivevn computations
  • Calculate ratios, ranking, standard deviation, and Pareto analyses
  • Express PowerPivot data in sophisticated PivotTables, reports, and charts
  • Easily share—and update—your solutions through Microsoft SharePoint®

For a review copy or more information please email maryr@oreilly.com. Please include your delivery address and contact information.

About the Authors

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.

View Marco Russo's full profile page.

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

View Alberto Ferrari's full profile page.

Additional Resources
For more information about the book, including table of contents, index, author bios, and cover graphic, see: http://oreilly.com/catalog/9780735650947

Microsoft? PowerPivot for Excel? 2010 Microsoft? PowerPivot for Excel? 2010
Publisher: Microsoft Press
Marco Russo, Alberto Ferrari
ISBN: 9780735640580, 416 pages
Print Price: $34.99   Ebook Price: $27.99  

Request Review copy

About Microsoft Press
Microsoft Press is a division of Microsoft Corporation. Established in 1985, Microsoft Press publishes self-paced learning materials on Microsoft products and associated technologies. Microsoft Press products are available in a variety of formats for individual users, IT professionals, and developers. Since 2009, Microsoft and O'Reilly Media have shared the editorial direction and development of Microsoft Press products. O'Reilly also handles sales, distribution, customer service, and some administrative functions.

About O’Reilly

O’Reilly Media spreads the knowledge of innovators through its books, online services, magazines, and conferences. Since 1978, O’Reilly Media has been a chronicler and catalyst of cutting-edge development, homing in on the technology trends that really matter and spurring their adoption by amplifying “faint signals” from the alpha geeks who are creating the future. An active participant in the technology community, the company has a long history of advocacy, meme-making, and evangelism.

Email a link to this press release