PowerPivot Books

PowerPivot for Excel / Sharepoint and DAX books

User Rating: 2 / 5

Star ActiveStar ActiveStar InactiveStar InactiveStar Inactive
 

PowerPivot for Excel / SharePoint and DAX books

Book

Amazon links by country

Description

Microsoft Tabular Modeling Cookbook

Amazon US

Amazon UK

Amazon Canada

Microsoft Tabular Modeling Cookbook by Paul te Braak

Over 50 tips and tricks for analytical modeling using Business Intelligence Semantic Models with SQL Server 2012 and PowerPivot

Overview

  • Develop tabular models for personal use
  • Learn about the modeling techniques which are required to overcome commonly encountered problems and master advanced modeling scenarios
  • Understand the techniques required to promote personal models to corporate enterprise environments and manage the models in a corporate environment
  • Learn tips and tricks for querying tabular models and learn how to access the data within them for dynamic reporting including the development of interactive workbooks
Instant Creating Data Models with PowerPivot How-to

Amazon US

Amazon UK

Amazon Canada

Build better business intelligence with this practical guide to creating Excel data models with PowerPivot

Overview

 

  • Learn something new in an Instant! A short, fast, focused guide delivering immediate results
  • Detailed, step-by-step interactive tutorial guide to learning PowerPivot
  • Carefully organized topics for users of all levels
  • Learn how to make your data accessible and attractive

 

In Detail

Microsoft PowerPivot is a free software designed to enhance Microsoft Excel. It allows the user to make extensive use of his/her computer’s powers to draw data from various sources, do analysis across millions of rows of data, and present results in a very unique format.

Instant Creating Data Models with PowerPivot How-to to is a concise and to-the-point guide that helps you get a jump start on using this strong business intelligence tool, while still working in an environment similar to Excel. You will begin with data generation and manipulation, learning a new feature at each step by building onto the old file, and ultimately creating a comprehensive file.

Instant Creating Data Models with PowerPivot How-to to will guide the user through database installation, importing data from various sources, creating pivot charts and tables, utilizing a unique feature of PowerPivot called slicers,adding custom columns, and setting custom relationships between data to generate the ultimate customized dataset for analysis. By the end of the book and all the sections of Microsoft PowerPivot for Excel, the reader will be fully experienced and ready to utilize this powerful software.

What you will learn from this book

 

  • Install a database and import/export data freely
  • Collect and combine data across various sources and formats
  • Understand relationships between various data
  • Develop complex tables and models for future analysis
  • Design meaningful charts and tables easy for everyone to understand
  • Write custom codes to modify data to a required form
  • Extend PowerPivot with external programs for further collaboration

 

Building Data Model 2013

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®

 

DAX PowerPivot

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

 

pp-give-data-meaning

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

ms-bi-powerpivot

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

PowerPivot for Data Analyst

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

practical-powerpivot-dax

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

 

intro-sql2008r2

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

pp-for-bi

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

 

build-bi-sol

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

 

getting-started-pp

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

bi-in-sharepoint

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

sharepoint-bi-unleashed

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

 

 

2007-2015 VidasSoft Systems Inc.