Customer Relationship Management
Management Consultancy specialising in
Their associated databases normally contain multiple linked tables and the names of the fields, in which the various elements are stored, are not generally user friendly.
Most applications have a reporting facility but this is often very restrictive and unless you gain an intimate knowledge of the database structure, reporting can be very limited.
Reporting from a mail-line application has several drawbacks:
Data Warehousing - Why do I need it?
- You need an understanding of the data structures. Software version upgrades can often lead to changes in data structures.
- A significant amount of time can be wasted by users having to find the location of the data before producing a report.
- Linking numerous tables leads to errors if links are incorrect.
The benefits of a Data Warehouse
- The data structure is specifically designed for reporting purposes and is structured in such a way as to make it easy to interpret.
- The number of tables is kept to a minimum and the field names are more descriptive.
- Codes used in the application would be translated into a full description in the warehouse table thus making the reports more readable.
Application Data Warehouse
||Territory = Jane Smith |
| Country Code = CN
||Country = China |
| Option 3 = 21
||Rating = IP55 |
Group = 17
||Product Group = Tri-Cycles |
Which option would you rather work with to create a report?
Applications such as Accounts and ERP are designed for speed and ease of use.