There are many instances of failed attempts to build enterprise data warehouses, and companies struggle to figure out the reasons for failure. An enterprise data warehouse can be deemed as unsuccessful, if majority of businesses dont use the data from it. There can be several reasons for the failure, the following is an attempt to list a few.
Lack of data accessibility
Access criteria should be defined, communicated and managed to quickly reflect the organizational changes. Business users need the freedom to play with the data before they can define exact requirements. There should not be a lot of red taping to get access to explore data, and the process should be well defined.
Lack of data searchability
They should be able to quickly find the data elements that are of interest to them. There should be a user friendly data catalogue for searching data elements and their exact definitions.
Lack of data traceability
Data elements should be easily traced back to the source systems. This is necessary to check whether data elements are reflecting the reality, by studying the way data was captured in the source systems.
Lack of trust on data
The data governance activities associated with the data elements within the enterprise data warehouse should be well defined to ensure that the data quality and integrity issues can be easily communicated to the concerned teams for remediation.
Lack of responsiveness
Centralised applications tends to get unresponsive during phases of high demand. There are chances that few businesses get neglected while serving other requirements. Clear service level standards should be defined and any kind of friction associated with using enterprise data warehouse is removed.
Lack of customization
Centralized applications tend to lack the flexibility to customize solutions for specific business needs. An enterprise data warehouse should be a comprehensive collection of applications that serve each type of business requirement.
Lack of user feedback
Every business has very unique data requirements, and it is necessary to continuously engage with business users to communicate the value proposition offered by the enterprise data warehouse and take their feedback. The enterprise data warehouse should potentially solve their pain areas, and should be way better than other options available to businesses.
Lack of goodwill
Enterprise data warehouse should be seen by business users as a positive change, and any fears associated with data security, confidentiality and privacy should be addressed in a timely manner. Fears within employees associated with job loss, loss of control or loss of freedom should be handled delicately. Apprehensions associated with user discomfort and bureaucracy should be managed through regular communication.