Case Study | Consulting and Engineering
Centralised data system
Public consulting and engineering company of reference in the field of Defense and Security of the AGE. Implementation of a multidimensional data warehouse and visualization with an intelligence system.
GOAL
Starting from different data sources, obtain a centralized system of scalable information to be analyzed with a business intelligence system.
This information infrastructure must be automated to generate an agile and reliable workflow, offering autonomy to users.
STRATEGY
- ETL de extracción de datos a Staging desde BBDD Oracle y ficheros Excel
- ETL data extraction to Staging from Oracle Database and Excel files
- Consolidation in the operational data warehouse
- Implementation of the Data Warehouse and creation of Tabular analytical model based on SSAS
- Model with 6 Datamarts
3 Dashboards in Power BI and 18 Reporting Services reports connected by Gateway
RESULTS
Centralized, standardized and 100% updated information.
Better tools for managing the portfolio and exploitation of information:
- Tracking help.
- Economic monitoring.
- Economic activity company.
- Economic concession.
- Company staff.
142.721 thousands of euros in turnover
6 data marts
>1.500 professionals
Other Case Studies
Discover what we can do for your business