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.