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.

caso de éxito empresa pública consultoría e ingeniería


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.


  • 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


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