Essential Guide

Maximizing the benefits of Excel add-ins: PowerPivot and Power View

Learn more about Excel add-ins and how they can make data work for you. This guide examines PowerPivot and Power View in close detail, exploring benefits and limitations.

Introduction

In an effort to be more user-centric, Microsoft has evolved its approach to business intelligence, offering user-friendly Excel add-ins such as PowerPivot and Power View. One advantage of putting more power into the hands of business end users is that these are the individuals who are most familiar with the data and stand to gain the most by learning from it. Excel is a useful tool for numerous purposes, but it has limitations, particularly when working with large sets of data.

PowerPivot is an add-in tool that enables improved data collection, aggregation and analysis, allowing users to find more detailed business intelligence information within Excel. With Power View, business users can build reports with a variety of data visualization options, facilitating collaboration and information sharing. However, both of these plug-ins have limitations to consider.

This guide offers insights and perspectives into getting started with Excel add-ins and capitalizing on the capabilities of the tools to yield helpful, in-depth business intelligence information.

1PowerPivot-

What PowerPivot can do for you

PowerPivot is an add-in that works with Excel to help it organize and analyze large data sets. In the articles in this section, learn about the capabilities of PowerPivot and get insider tips for using it.

Feature

Book excerpt: How Microsoft PowerPivot works with Microsoft Excel

Explore the background of Microsoft Power View and PowerPivot and learn how to enhance collaborative business intelligence. Continue Reading

Tip

Mapping data flow from PowerPivot components to Excel

Business users can manipulate data in Excel workbooks by combining the capabilities of Microsoft PowerPivot, Excel and SharePoint. Continue Reading

Feature

How to import SQL Server data into PowerPivot for Excel

Know your options when it comes to importing SQL Server data into Microsoft PowerPivot and take advantage of BI capabilities. Continue Reading

Feature

Expanding the reach of BI in PowerPivot with DAX formulas

Learn how to use Data Analysis Expressions (DAX) formulas in PowerPivot to work with large data sets and perform sophisticated analytics in Excel. Continue Reading

Tip

What's the secret to using Excel in Microsoft SQL Azure PowerPivot?

Learn the trick to using Excel in Microsoft SQL Azure -- the PowerPivot add-in -- and maximize business intelligence functionality. Continue Reading

Feature

Create charts in PowerPivot and make data work for you

To start using the reporting features of PowerPivot, get instructions in this article on how to populate and refine charts. Continue Reading

2Power View-

Power View: A closer look at data

Microsoft Power View offers user-centric business intelligence workbooks, changing the dynamic between IT and business users. The articles in this section offer expert insights into how to begin with Power View and how Power View is a game changer for BI reporting.

Tip

Business intelligence reporting simplified with Power View

Get expert advice on how to get started with SQL Server 2012's business intelligence tool for report building. Continue Reading

Feature

Authors introduce Power View and SQL Server Analysis Services

In this book excerpt, learn more about initiating Power View and Microsoft SQL Server Analysis Services. Continue Reading

Feature

Exploring the advantages of Microsoft Power View: Q&A

Gain insights into the business and IT benefits of Power View from the four authors of a Power View how-to book. Continue Reading

News

Microsoft GeoFlow 3-D mapping tool amps up visuals

Premium Excel users can take advantage of the three-dimensional mapping tool GeoFlow, which works with SQL Server on the back end. Continue Reading

Tip

See SQL Server business intelligence in many different ways with Power View

An expert discusses the multiple ways to view data with Microsoft's BI tool and talks about its limitations as well. Continue Reading

Tip

SQL Server 2012 offers BI capabilities for users and IT

Industry analysts discuss the BI capabilities offered by Microsoft SQL Server 2012, as well as its features, including Power View and master data management. Continue Reading