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.
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.
Explore the background of Microsoft Power View and PowerPivot and learn how to enhance collaborative business intelligence. Continue Reading
Business users can manipulate data in Excel workbooks by combining the capabilities of Microsoft PowerPivot, Excel and SharePoint. Continue Reading
Know your options when it comes to importing SQL Server data into Microsoft PowerPivot and take advantage of BI capabilities. Continue Reading
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
Learn the trick to using Excel in Microsoft SQL Azure -- the PowerPivot add-in -- and maximize business intelligence functionality. Continue Reading
To start using the reporting features of PowerPivot, get instructions in this article on how to populate and refine charts. Continue Reading
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.
Get expert advice on how to get started with SQL Server 2012's business intelligence tool for report building. Continue Reading
In this book excerpt, learn more about initiating Power View and Microsoft SQL Server Analysis Services. Continue Reading
Gain insights into the business and IT benefits of Power View from the four authors of a Power View how-to book. Continue Reading
Premium Excel users can take advantage of the three-dimensional mapping tool GeoFlow, which works with SQL Server on the back end. Continue Reading
An expert discusses the multiple ways to view data with Microsoft's BI tool and talks about its limitations as well. Continue Reading
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