Microsoft addressed this tension between the business user tool of choice, Excel, and business intelligence (BI) experts dismissing it as too difficult to control with the introduction of PowerPivot, making it much easier to get data into Excel. Now, Excel is becoming the standard tool for transforming data into relevant and meaningful information. We see business solutions built on the Microsoft BI platform changing the role of enterprise data warehouses and data cubes. The new goal of a data warehouse should be to surface data for users to consume with PowerPivot.
By strategically planning for growth in users and content, you can build a solution that will meet the needs of the organization while still empowering your users. PowerPivot offers a place where the technical person and the business person can come together as equal partners in delivering BI solutions.
Authors: Chuck Whittemore, Steve Hughes
Technology: Microsoft Office Suite, PowerPivot for Excel, SharePoint 2013, SQL Server 2012, xVelocity
Back to Top ↑