Public consulting and engineering company
Public consulting and engineering company
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 data extraction to Staging from Oracle Database and Excel files
- Consolidation in the operational data warehouse
- Implementation of the DataWarehouse 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 datamarts
