BACKGROUND IMAGE: iSTOCK/GETTY IMAGES
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. Read Now
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.
1Power 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.
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. Read Now
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. Read Now