We adapted IBM’s approach to create business requirements for building information systems and data warehouses.
Scope of service
After the diagnostic, we help to form the high-level business requirements for the information system and data warehouse. We begin the work with the main participants of the implementation project — from key business users of reports to internal and external implementation teams, including developers of automated banking system and other key data sources.
The main task at this stage is to coordinate priorities among teams, perform business requirements, identify gaps in data sources, specify the functional gaps in the implementation team and to adjust the project road map.
During the five-day training workshop, we bring together key participants and initiate discussion of the main business tasks, help participants to understand each other, identify problems in data sources, evaluate the scope of work and approximate duration, agree on high-level priorities in the reporting.
The workshop program includes the following topics.
Data warehouse model based on the example of IBM Banking Data Warehouse:
— Business tasks and conceptual data model;
— Atomic Data Model or System of Records, SOR;
— Summary Area;
— Analysis Area;
— Dimensional Data Model for Data Marts;
— Reporting or Business Solution Templates, BST;
— Interfaces or Application Solution Templates, AST.
Selection and analysis of the main reports based on business tasks:
— Analysis of selected reports;
— Identification of the necessary application interfaces;
— Practical exercises on modeling SOR objects based on selected reports and interfaces.
Analysis of data gaps among data sources and SOR:
— Analysis of the main business objects in source systems;
— Analysis of Source to Target high-level mapping;
— Identification of gaps in data sources.
Analysis of business requirements and dimensional data model:
— High-level structure of data marts;
— Data analysis for building data marts;
— Design of data marts;
— A practical exercise on data cubes modeling.
The following documents will be prepared based on the work performed:
— Business requirements based on identified priorities;
— An adjusted road map based on identified limitations in methodology and data gaps in sources;
— Gaps in key roles of the implementation team;
— Training materials on modeling of atomic and dimensional models of data warehouse.