Problem
A Global Telecom Compay needed an efficient system to measure and analyze data from multiple sources, including AzureDevOps and GitHub, to enhance their business operations and decision-making processes. The challenge was to integrate these data sources into a centralized database and provide insightful reports through a user-friendly interface.
Solution
Working closely with Google Cloud, Closer developed an Efficiency Measurement solution. This solution involved integrating data from AzureDevOps, GitHub, and Excel files into Google Cloud’s BigQuery database using an automated ETL process. The data was then visualized using Qlik Sense reports. Google Cloud Platform provided the necessary infrastructure.
Results
The collaboration resulted in a robust system integrating multiple data sources into a centralized database. Automated ETL processes ensure timely, accurate data updates, reducing manual intervention and errors. The telecom group now accesses detailed Qlik Sense reports, providing valuable insights into operational efficiency and enabling informed decisions, enhancing the corporation ability to track performance metrics.