Case study | Enfo Rongo
Traffic Data Warehouse
The close collaboration between Enfo Rongo and JCommerce was established in order to develop the Business Intelligence system that has been used to analyze the business KPIs.
Business Intelligence solution
The aim of the project was the development of a data warehouse for a Business Intelligence system and analytical purposes. The tasks include the implementation of ETL processes, based on the key source systems using SQL Server Integration Services, the design of the analytical layer (OLAP in a tabular model and multidimensional model in Analysis Services for particular business areas), as well as the implementation of reports and dashboards for the end-users.
- Oracle 11 g database
- Microsoft Business Intelligence tools:
- Integration Services
- Multidimensional Analysis Services
- Tabular Analysis Services
- Reporting Services