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

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.

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.