These processes are still largely manual efforts, with many products focused on reducing implementation effort rather than reducing requirements gathering effort. Data quality is critical to a user's willingness to use the data warehouse. Attention to data quality often produces a side benefit of improving the data quality of the operational source systems as well. 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.