Book

Amazon links by country

Description

Amazon US

Amazon UK

Amazon Canada

Safari Books Online

PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library), by Bill Jelen (Author)

Paperback: 576 pages
Publisher: Que (July 24, 2010)
Language: English
ISBN-10: 0789743159
ISBN-13: 978-0789743152

Business intelligence (BI) tools make it possible for companies to gain deep, actionable insights for faster, better decision-making - and greater competitiveness. Until recently, however, access to BI has largely been restricted to experts using complex, specialized tools. With PowerPivot for Excel 2010, Microsoft has changed that. Together with SQL Server 2008 and Microsoft's new SharePoint Analysis Services, PowerPivot makes advanced business intelligence available to any mainstream business user working with Excel 2010. Of course, having the tools isn't enough: you must learn how to use them. That's where PowerPivot for the Data Analyst comes in. In this book, legendary Excel expert and instructor Bill Jelen shows exactly how to use PowerPivot to gain deep, actionable insights for more effective business decision-making. Using concrete examples and real-life scenarios, Jelen walks through setting up PowerPivot and integrating multiple data sources; creating and sharing dynamic dashboards; slicing and dicing to perform fast, interactive, ad hoc analyses; leveraging Excel's familiar features in advanced BI applications; and much more. This book is part of the new MrExcel Library series.

• The first book on PowerPivot, the breakthrough Microsoft technology that can extend business intelligence to any Excel user
• Use PowerPivot, SharePoint Analysis Services, and Microsoft SQL Server together, to slice and dice huge amounts of data, and create and share powerful business models
• Written by Microsoft MVP Bill Jelen ("MrExcel"), as part of his new MrExcel Library series

Review by Dan English

Amazon US

Amazon US Kindle

Amazon UK

Amazon Canada

Professional Microsoft PowerPivot for Excel and SharePoint (Paperback)
by Sivakumar Harinath, Ron Pihlgren, Denny Guang-Yeu Lee

SQL Server "Gemini" brings the power of Microsoft's business intelligence tools to the desktop

Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. If you're a business decision-maker who uses Microsoft Office or an IT professional responsible for deploying and managing your organization's business intelligence systems, this guide will help you make the most of SQL Server 2008 "Gemini".

Featuring insights and tips from the team that built the product, it offers a head start on mastering the features of "Gemini". The companion Web site includes all the sample applications and reports discussed.

• "Gemini" brings the power of Microsoft's business intelligence tools to Microsoft Office 2010
• This book uses the insight of the team that built the product to give business decision-makers and IT professionals the fast track to getting the most from the new technology
• Covers in-memory BI server technology, the Data Analytics eXpressions (DAX) language, Report Gallery, and automatic data updates from sources including SharePoint lists and Google Docs
• Walks you through examples that show how to leverage the power of self-service business intelligence

You'll learn to use Gemini with Excel and SharePoint to improve your business intelligence system.

• Paperback: 384 pages
• Publisher: Wrox (July 26, 2010)
• Language: English
• ISBN-10: 0470587377
• ISBN-13: 978-0470587379

Review by Dan English
Review by Teo Lachev
Review by Kasper de Jonge
Review by Rob Collie

Amazon US

Amazon UK

Amazon Canada

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 by Philo Janus

Building Integrated Business Intelligence Solutions with SQL Server 2008 R2 & Office 2010 explains how to use the entire Microsoft BI stack--SQL Server 2008 R2, SharePoint 2010, and Office 2010 components, including Excel/Gemini--to create integrated, practical, business intelligence solutions. An overview of SQL Server Analysis Services sets the stage for broad coverage of Excel as a front end for "self-service analysis," using SharePoint features for collaboration and workgroup BI, and leveraging Reporting Services for enterprise dashboards and reports. This practical guide focuses on building end-to-end BI solutions that solve real business data dilemmas.

Paperback: 512 pages
Publisher: McGraw-Hill Osborne Media; 1 edition (September 5, 2010)
Language: English
ISBN-10: 0071716734
ISBN-13: 978-0071716734

Amazon US

Amazon UK

Amazon Canada

Practical PowerPivot and DAX Queries for Excel 2010 (Paperback) by Art Tennick

Paperback: 512 pages
Publisher: Osborne/McGraw-Hill (October 1, 2010)
Language: English
ISBN-10: 0071746854
ISBN-13: 978-0071746854

Free ebook

PDF link

The book contains 10 chapters and 216 pages, like so:

PART I   Database Administration

CHAPTER 1   SQL Server 2008 R2 Editions and Enhancements 3
CHAPTER 2   Multi-Server Administration 21
CHAPTER 3   Data-Tier Applications 41
CHAPTER 4   High Availability and Virtualization Enhancements 63
CHAPTER 5   Consolidation and Monitoring 85

PART II   Business Intelligence Development

CHAPTER 6   Scalable Data Warehousing 109
CHAPTER 7   Master Data Services 125
CHAPTER 8   Complex Event Processing with StreamInsight 145
CHAPTER 9   Reporting Services Enhancements 165
CHAPTER 10   Self-Service Analysis with PowerPivot 189

Amazon US

Amazon UK

Amazon Canada

Microsoft PowerPivot for Excel 2010: Give Your Data Meaning (Paperback) by Marco Russo, Alberto Ferrari

Paperback: 368 pages
Publisher: Microsoft Press; 1 edition (September 15, 2010)
Language: English
ISBN-10: 0735640580
ISBN-13: 978-0735640580