Design and implementation of an enterprise data warehouse with a unified analytical and management reporting system
- Customer
- UzbekInvest
- Project manager on the customer side
-
- IT Provider
- GlowByte
- Year of project completion
- 2024
- Project timeline
- September, 2023 - November, 2024
- Project scope
- 10000 man-hours
- Goals
-
- Improving the quality, completeness, accuracy, reliability, timeliness, and consistency of data.
- Reducing the number of manual and routine data processing operations.
- Enhancing the timeliness of data access.
- Creating a single source of data for reporting.
- Standardizing and expanding the range of analytical information.
- Developing analytical and management reporting.
- Increasing the quality and depth of analysis.
- Enhancing the efficiency of data utilization, including for managerial decision-making.
- Providing a foundation for self-service analytics by business users without involving IT department.
- Project Results
-
The main technical outcomes of the project include:
- Collecting data from all of the company's accounting systems.
- Preparing and storing data in formats optimal for tracking historical changes in information.
- Creating business data objects with unified and reliable information.
- Providing access to business data through BI tools.
The main business outcomes of the project include:
- Offering a single, reliable version of business data to all departments.
- Providing management, financial, and analytical reporting to business users for analyzing company activities, developing and improving products, and making management decisions.
The uniqueness of the project
The uniqueness of the project lies in it being the first comprehensive data platform implementation in Uzbekistan's insurance sector, comprising a data warehouse, data integration and modification tools, visual analysis, and platform development process automation tools. As a result of the project's implementation, "Uzbekinvest" became one of the first companies in Uzbekistan, and particularly among insurance companies, to adopt a data-driven culture for managerial and strategic decision-making.
In addition to addressing the tasks of centralized historical data accumulation, creating a unified snapshot of business metrics, and providing data through BI visualizations, the solution is designed and adapted to significantly expand the capabilities for applying advanced data analysis methods and artificial intelligence.
- Used software
- The project was implemented using technological tools such as Oracle Database, Oracle Business Intelligence, Apache AirFlow, DBT, and GitLab CI.
- Difficulty of implementation
-
The organizational challenge of the project was the implementation of a new methodology for working with data and automated approaches for its processing and use. This required deep involvement in the modernization of existing processes by both the top management and business units.
The main technical difficulty was the integration and collection of data from an accounting system that did not support direct access to source data. To resolve this issue, specialized modules were developed on the accounting system's side to facilitate data export to the data warehouse.
- Project Description
-
At the start of the project, the company lacked a unified source of corporate data for analytical and management reporting, as well as tools to enable business units to work effectively with reports and use data for prompt decision-making. During the project implementation, the necessary technology stack was deployed, and processes for the collection, processing, storage, and provision of data were established.
- Project geography
- Uzbekistan