The implementation methodology for the data warehouse and management information system is presented below. It includes three main phases.
Pre-project phase:
— Diagnostics;
— Preparation of business requirements;
— Consulting on strategy and business model;
— Consulting on management accounting methodology;
— Organization of the project.
Project phase:
— Analysis: business requirements, data sources, applications, IT-architecture;
— Design: a conceptual and logical data model and a new IT-architecture;
— Development: physical data model, mapping, data loading, calculations and BI reports;
— Testing: at each stage of data downloading and processing;
— Training: implementation teams;
— Project management, quality control of project management.
Post-project phase:
— User training;
— Documentation for production;
— Data governance processes.
Pre-project phase
We provide full service at the pre-project phase, which includes:
— Diagnostics;
— Preparation of business requirements;
— Consulting on strategy and business model;
— Consulting on management accounting methodology;
— Organization of the project.
Results
As a result, we present our findings to the management board or project steering committee:
— Report on diagnostics for the board of the bank;
— High level business requirements;
— Road map for a data warehouse and an information system;
— Recommendations on the organization of the implementation project.
Project phase
Our services at the project implementation phase include:
— Business analysis of requirements;
— Design of a conceptual and logical model;
— Project management quality assurance.
Results
Based on the data architecture of sources and business requirements, we create:
— Conceptual and logical model of detailed storage;
— The conceptual and logical models of the area date March.
In addition, we prepare the following reports quarterly:
— Report with recommendations on the quality of project management; ;
— Progress Report regarding data modeling;
— Presentation to the management board or project steering committee.
Post-project phase
After the implementation, we provide services for:
— User training;
— Documentation for production;
— Data governance processes implementation.
Results
As a result, we help the implementation team in creating:
— Training courses for users of the information system;
— Regulation of the data warehouse;
— Descriptions of data flows and data architecture of the information system.
The main focus is on the implementation of the new data governance processes, which includes:
— Creation of policies for a data governance and data quality;
— Organization and a description of the functions of the MIS unit;
— Introduction of new functions of data stewards to data owners.
#EXMACON.EN 