Public Consulting and Engineering Company

0
Miles de euros en cifra de negocio
0 %
Datamarts
+ 0
Profesionales

Objetivo

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.

Estrategia

  • 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

Resultados

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.
bismart-aseguradorabismart-business-intelligence-3