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

Editor's note

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.