Solutions30: building a centralized data platform for operational visibility and automated reporting

AWS

Airflow

Power BI

With 16.000 service engineers active in 10 countries, Solutions30 is the market leader in Europe in digital support solutions. Their clients include telecom operators for high-speed broadband installation services, utility companies for the installation of smart meters and retail companies for payment systems and POS terminals​.

The challenge

​Very diverse landscape of operational source systems without a central data platform, which means:​

  • Excel based reporting that where error prone and time consuming to maintain &update​
  • Data silo’s and no companywide view across processes​

As a result, bad decision making & overall low trust in dashboards & analytics. ​

Our solution

  • Data Integration: Combining data into single snowflake database ​
  • ​Automation: Utilizing Airflow​
  • Scalability and Flexibility: Leveraging AWS Cloud​
  • Visualization: Power BI integration

The business value

  • Improved Decision-Making​ because of the comprehensive, real-time view of the company’s operations.​
  • Efficiency Gains​: The automation of data processes reduced the time spent on manual updates.​
  • Improved data quality​ by ensuring that all reports and dashboards were based on the most up-to-date info.​
  • Operational Insight​: Identify and address operational inefficiencies more effectively.