Multiple
Sources
Data is spread across geographic locations, multiple applications and employee desktops.
Some applications are line of business while others consist of operational support systems like HR, accounting and so on. Corporate decision making is often based on spreadsheets with information buried on desktop PCs. The problem that multiple location data creates is that users will report on different sets of numbers. Critical reporting is often based on information derived from partial exports, reports and calculations. It’s probable that others in the company are unable to recreate or verify these reports.
We strive to eliminate these problems. First of all we determine what information is needed to support strategic, tactical, and operational reporting. We then locate the data that is required, regardless of location or application. We then create extract procedures that clean, transform, and consolidate the data.
|