Case Study

Ministry of Mines and Energy Colombia

Data integration, interoperability project, and advanced data analytics of the Colombian Mining and Energy Sector.

Ministry of Mines and Energy Colombia


  • To achieve the proposed objective, a grouping of the information needs of the sector (Ministry and six attached entities) was carried out, which are identified as Sectoral Ambitions. 
  • Data sources are identified, mapped, and validated. 
  • The Architecture for the deployment of the ambitions is implemented. 
  • Cloud architecture with PAAS and IAAS. 
  • Infrastructure on Azure. 
  • Interoperability platform with Azure Logic Apps, Azure function, and API management. 
  • Data integration platform with Data Factory, Synapse analytics, Analysis services, API connections, and SQL Server 
  • Analytics platform with app service, Key vault, and powerBI. 
Process lifting: 
  • 69 use cases. 
  • 32 boards. 
  • 21 User Stories. 
  • 477 technical documents generated. 
  • 169 lifting sessions.
  • Three releases 
  • 18131 hours of development. 
  • Five months. 
  • 32 boards. 
  • 43 people on the team.


  • Information portal is defined to present the boards. 
  • The presentation of the boards is defined in two large groups: summary type and indicator type. 
  • The components of each dashboard are defined in a standard way: Title, date of last update, filters, graphics and maps area, indicators, and analysis card. 
Additional characteristics: 
  • Parallel development. 
  • Use of the AZURE platform. 
  • Standardization of information query methods.