Ch 6.2 Data Warehouse Fundamentals{Comments Off on Ch 6.2 Data Warehouse Fundamentals}

by Geofroy L
The article I found is about Microsoft PowerPivot, one of the new Excel features included in Office 2010. The concept of this new tool is to help managers to build their own reports, and thus they become less dependent on the IT staff. It runs similarly as a table pivot, but it is able to pull the data out of other sources, and reorganize it quickly. However, thanks to Excel’s weaknesses, this easy to use could lead to a misuse of the data, compiled in out-of-date reports for example, and may not serve the company’s interest. What’s more, it doesn’t deal with data quality issue, such as deduplication. On the other hand, coupled with the benefits of a SharePoint repository, it could become a way of sharing informal reports and automatically kept up to date. Nonetheless, Microsoft PowerPivot won’t replace full-fledged BI platforms which offer more features, but could change some tasks of BI or IT professionals.

How this article relates to the chapter is that the access to multiple data stocked in data warehouse is vital to a company success, but it should be done in the fastest way. Besides, the quality of the data must be the best as possible. If a company chooses to use Microsoft PowerPivot, it opts for more efficiency from its managers, but needs to pay more attention about how the data is used with this tool.


Jackson, Joab. (2010, September 10). How Microsoft PowerPivot will disrupt BI. NetWorkWorld. Retrieved October 6, 2010.