Till date many organisations have seen a mass proliferation of data extract programs and downloading of static data into Excel. This causes enormous problems, both technical and business related. The result of this process of continual download and manipulation is an ever expanding range of Excel spreadsheets. It is never clear from the Excel analysis how historical data based on numerous sources is handled. For example, what happens if the source systems are updated/restated as there is no link to the source data the end user is not alerted to the availability of refreshed data? As a result it is never clear which spreadsheet is the latest version. Most users create elaborate naming conventions to try and resolve this issue.
Did you find this white paper useful?
29 out of 50 users found this white paper useful
Related white papers
TechNet Webcast: 24 Hours of SQL Server 2008: Reporting Services Architecture Improvements (Level 200)
Contoso plans to provide employees with access to standard reports using Microsoft SQL Server 2008 Reporting Services. This webcast reviews the new features in Reporting Services that enable organizations to...
Confessions From a Performance Management Road Warrior
The presenter of this webcast explains why there is no single component of the Performance Management suite that drives improvement, but rather the synergy from their integration. The attendee will...
TechNet Webcast: 24 Hours of SQL Server 2008: AS Design and Performance Improvements (Level 200)
This webcast is designed for IT professionals and developers. To support high-performing ad hoc analysis, Contoso wants to develop a Microsoft SQL Server Analysis Services database. This webcast reviews the...
Predicting Customer Shopping Lists From Point-of-Sale Purchase Data
This paper considers the difficult and useful problem of predicting customer purchase decisions from transaction based individual purchase history. This problem is interesting from the perspective of the KDD and...
Avengers, Assemble! Marvel's first strategic IT plan comes from superpowered collaboration between the CIO and the lines of business
Read this Profit Magazine article to see how Marvel Entertainment is working to expand its existing Oracle footprint to merge and unify existing data with the ultimate goal of improving...
Chinese Taxation Authority Turns to Grid Computing to Improve Data Analysis
The State Administration of Taxation (SAT) is responsible for regulating taxation affairs under the State Council of China. Its vast territory and large population make tax administration in China an...
Janssen-Cilag SpA Advances Business Strategy With Flexible Business Intelligence Solution
Janssen-Cilag wanted to expand business intelligence capabilities to support business strategies and integrate multiple company functions in a single system, including sales and marketing, credit collection, medical direction, and product...
