Study Case

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

Solution

Methodology: 
  • 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. 
 
Architecture: 
  • 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.

 

UX: 
  • 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.