PowerPivot for Excel / SharePoint and DAX books
|
Book
|
Amazon links by country
|
Description
|
 |
Amazon US
Amazon UK
Amazon Canada
|
Microsoft Excel 2013 - Building Data Models with PowerPivot by Alberto Ferrari and Marco Russo
Your guide to quickly turn data into results.
Transform your skills, data, and business—and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel® 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results—no programming required!
- Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI
- Extend your existing data-analysis skills to create your own BI solutions
- Quickly manipulate large data sets, often in millions of rows
- Perform simple-to-sophisticated calculations and what-if analysis
- Create complex reporting systems with data modeling and Data Analysis Expressions
- Share your results effortlessly across your organization using Microsoft SharePoint®
|
 |
Amazon US
Amazon UK
Amazon Canada
|
DAX Formulas for PowerPivot: The Excel Pro's Guide to Mastering DAX by Rob Collie
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the world’s foremost PowerPivot blogger and practitioner, the book’s concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce and include lessons on the difference between calculated columns and measures, how formulas can be reused across reports of completely different shapes, how to merge disjointed sets of data into unified reports, how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not, and how to create time-intelligent calculations in pivot tables such as “Year over Year” and “Moving Averages” whether they use a standard, fiscal, or a complete custom calendar. The “pattern-like” techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to within the pages of this easy-to-follow guide.
2012-11-17 Review by Dan English
2012-11-29 Review by Paul Turley
|
 |
Amazon US
Amazon UK
Amazon Canada
|
Microsoft PowerPivot for Excel 2010: Give Your Data Meaning (Paperback) by Marco Russo, Alberto Ferrari
Paperback: 416 pages
Publisher: Microsoft Press; 1 edition (October 10, 2010)
Language: English
ISBN-10: 0735640580
ISBN-13: 978-0735640580
Read interview with authors....
Read review by Rob Collie
Read review by Derek Comingore...
Read review by Teo Lachev...
Free chapter 2 available here...
|
 |
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
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 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
|
Free ebook: Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and Stacia Misner.
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
|
PowerPivot for Business Intelligence using Excel and SharePoint by Barry Ralston
PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for SharePoint. Data can be pulled in from any of the leading database platforms, as well as from spreadsheets and flat files.
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
What you’ll learn
- Install and verify the PowerPivot software
- Integrated existing, available data to deliver business intelligence
- Leverage Time Intelligence to report change over time
- Write Data Analysis Expressions (DAX) to create custom measures
- Identify and implement solutions for role-playing dimensions
- Recognize and work-around PowerPivot’s missing features
Who this book is for
PowerPivot Solutions for Excel and SharePoint is aimed at information workers and data analysts who typically use Excel to drive business decisions. The book shows how you can apply PowerPivot to problems typically addressed through complicated and arcane spreadsheet techniques. Business people without the time and interest in learning Excel arcane will especially appreciate how PowerPivot enables them to easily create models and perform analysis far in advance of anything they could do using Excel alone.
- Paperback: 300 pages
- Publisher: Apress (March 15, 2011)
- Language: English
- ISBN-10: 143023380X
- ISBN-13: 978-1430233800
|
 |
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
|
Getting Started With PowerPivot For Excel 2010, by Indera E Murphy
PowerPivot is a free new add-on for Excel 2010 that is used to enhance pivot tables and pivot charts. PowerPivot brings self-service business intelligence to the desktop by allowing you to connect to a variety of data sources. This functionality is used to enhance data analysis in Excel. The purpose of PowerPivot for Excel is to help Excel end users access data in multi-dimensional databases without having extensive training and knowledge of this type of data modeling. Additionally, PowerPivot has a new programming language called Data Analysis Expressions (DAX). This language adds data manipulation functionality to Excel formulas, including analysis and complex grouping that is above the formula capabilities that are available in Excel. DAX takes the formulas that you are use to creating for pivot tables and pivot charts in Excel to a whole new level. In a user friendly, step-by-step way, you will learn the following: How to use the Table Import Wizard, How to import data into PowerPivot, How to create pivot tables and pivot charts using data in PowerPivot, How to create DAX formulas and much more.
Paperback: 308 pages
Publisher: Tolana Publishing (January 1, 2011)
Language: English
ISBN-10: 1935208160
ISBN-13: 978-1935208167
|
 |
Amazon US
Amazon UK
Amazon Canada
|
Business Intelligence in Microsoft SharePoint 2010, by Norm Warren, Mariano Teixeira Neto, John Campbell, Stacia Misner
Dive into the business intelligence (BI) features in SharePoint 2010—and use the right combination of tools to deliver compelling solutions. This practical guide helps you explore several BI application services available in SharePoint 2010 and Microsoft SQL Server® 2008 R2. You’ll learn each technology with step-by-step instructions, and determine which ones work best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst.
- Choose the BI tools that meet your needs—and learn how they work together
- Examine the BI lifecycle, from determining key performance indicators to building dashboards
- Take Microsoft Excel® further—gain more control and functionality with web-based Excel Services
- Mash up data from multiple sources using PowerPivot for Excel 2010
- Create data visualizations with objects, context, and metrics using Microsoft Visio® Services
- Build dashboards, scorecards, and other monitoring and analysis tools with PerformancePoint® Services
- Use SharePoint to view BI reports side by side, no matter which tools were used to produced them
Note: 35 pages in this books charpter 5 "PowerPivot for Excel and Sharepoint" are about PowerPivot.
Paperback: 416 pages
Publisher: Microsoft Press; 1 edition (May 10, 2011)
Language: English
ISBN-10: 0735643407
ISBN-13: 978-0735643406
|
 |
Amazon US
Amazon UK
Amazon Canada
|
Microsoft SharePoint 2010 Business Intelligence Unleashed by Steven Mann, Chuck Rivel, Ray Barley, Jim Pletscher, Aneel Ismaily
SharePoint 2010 is today’s leading presentation and deployment system for Business Intelligence (BI) solutions based on Microsoft technologies. This book brings together all the information you need to successfully implement and use SharePoint 2010’s powerful BI capabilities. It reflects the unsurpassed real-world experience of five expert consultants at RDA, a Microsoft Gold Partner specializing in delivering advanced BI solutions with SharePoint.
You’ll first learn how to prepare SharePoint 2010 for the deployment of BI solutions. Next, the authors walk through integrating, configuring, and using Reporting Services, PerformancePoint Services, PowerPivot, Visio Services, and other key related technologies.
Building on what you’ve learned, you’ll walk step-by-step through constructing and integrating two end-to-end BI solutions. Finally, in a comprehensive troubleshooting section, the authors present today’s most common SharePoint BI issues, identify proven solutions, and teach effective problem-solving techniques.
- Get started fast, by using the Business Intelligence Center’s prebuilt site collection and template
- Build integrated, end-to-end SharePoint BI solutions
- Present business data to the enterprise through Excel Services
- Install, configure, and integrate Reporting Services and the Reporting Services Add-In for SharePoint
- Define document library content types and manage reports
- Use Report Viewer Web Parts to render reports on SharePoint web pages
- Build enterprise dashboards with PerformancePoint Services
- Secure dashboards via data source delegation, SharePoint permissions, and groups
- Analyze enormous datasets with PowerPivot for Excel and SharePoint
- Publish Visio 2010 data-driven web diagrams that integrate multiple data sources
- Utilize the fine-grained security available through Visio Graphics Service
- Troubleshoot problems with Reporting Services, PerformancePoint Services, PowerPivot, and Visio Services
Paperback: 352 pages
Publisher: Sams; 1 edition (May 11, 2011)
Language: English
ISBN-10: 0672335514
ISBN-13: 978-0672335518 |
|
