This area often consumes significantly more time and effort than what is required to implement transformation and loading processes. Many warehouse projects, with especially dirty data sources, fail when they are unable to adequately address data quality problems within budget constraints. Ease of use is also critical to a user's willingness to use the data warehouse. Users must be able to quickly find the information they need, and data warehouses must accommodate a wide audience of users from sophisticated analysts who want to execute ad hoc queries, to users who have no interest in understanding the data and simply want standard reports. Given the usage of data warehouses, exception reporting and handling is key.
Simplification is key to success over the long term.
Companies must set the proper infrastructure from the beginning to ensure the warehouse remains simple to maintain, iterate and use, despite increasing complexity over time. Increasing complexity should be expected and planned for. Legacy systems are no longer restricted to mainframe operational systems. They could be other data warehouses that result from mergers and acquisitions or existing data warehouses. The closer the vendor's product is to the end user, the more beneficial it is to understand the customer's business.