Long-term data warehouses operating in a dynamic environment can become rigid and unable to fulfill user needs fast enough due to changes within corporate management or at board level, or a merger with another entity, as well as changes in the market.
Enterprises also lose track of their data over time when data ownership is infrequently clearly set, when data quality is uncertain and ways of improving them are vague. There are times when organizations do not even know which data are available to users or where the data are ultimately accessible.
The Russian bank was in such a situation and requested an independent Data Warehouse Audit and Data Governance program.
Does your DWH fulfill the needs of its business users? Maybe it's time for a Data Warehouse Audit.
Adastra provided a complete Data Warehouse Audit for the bank including an audit of DWH content, architecture and usage. We also suggested methods to solve identified deficiencies. Each audited area was expertly evaluated in terms of the development of customer solution awareness in a particular region when compared with the ideal situation and with the state of the common market. Problems facing the existing solution were identified along with the means to eliminate them. The audit took the following guidelines into consideration:
Within a few weeks crucial shortcomings and problems relating to the existing situation were identified in the Data Warehouse Audit. The next phase was substantially longer and focused on confirming and developing all findings while designing the plan for future developments to eliminate the deficiencies. The overall project took roughly five months.
Processes within the scope of the project were mapped and new structures were designed in accordance with the level of each employee's responsibilities. We also defined the role of the BICC (Business Intelligence Competency Center) and Data Governance processes. Moreover, we delivered a detailed architecture of the new solution incl. the technical infrastructure, which effectively eliminated: problems related to the duplicate processing of data; the existence of several “versions of the truth” rather than a “single version of the truth”; and any inconsistent data in separate parts of the data warehouse. Additionally, we designed a proposal overseeing how to extend business areas and IT systems covered by the data warehouse, and provided detailed reports and outputs.
All realms of the design incorporate recommendations associated with the central challenges of the existing solution (including risks and limitations arising from it), and the proposed final state which eliminates those shortcomings. Special consideration was paid to the design of a gradual steps realization resulting in a target state reflecting all technological, financial and business priorities, and limitations. The bank accepted our proposal and began a gradual implementation.
Are data real assets at your company? This is a case study of how one customer, a leading Czech bank, started to fully realize the need to see and treat data as an asset and how to improve it. First, we identified the need to establish governance, i.e. to recognize administrative elements and assign them to the employees in question. In fact, it…