Polski Światłowód Otwarty is a leading wholesale-only operator offering all retail operators, i.e. companies providing Internet services directly to end customers, open, non-discriminatory access to the broadband network in Poland. In 2023, as a result of the acquisition of UPC Polska's network infrastructure, PŚO became the owner of an access network reaching over 3.7 million households in Poland at that time (currently over 4.1 million).
The dynamic development of the network, driven both by its organic expansion and modernization, as well as strategic acquisitions and the need for data consolidation, has created challenges in the area of reporting and data analytics, especially for the Commercial Department, which is responsible for key operational and sales indicators.
Project objective: Following the merger of UPC Polska and Play, there was a need to integrate data from multiple heterogeneous source systems. The Commercial Department needed a centralized, daily updated report presenting key operational and sales indicators, which would allow for ongoing monitoring of budget implementation, management decision-making, and elimination of manual, time-consuming data processing.
Scope of work
Key actions:
- Building a dedicated, multi-layered data model using Google Cloud Dataform, including data acquisition, cleansing, transformation, and aggregation from multiple source systems. The process involved intensive workshops and consultations with the PŚO analytical and commercial team, detailed business and technical analysis of data sources, and implementation of a multi-layered data processing architecture in Dataform, covering the following stages: source (data acquisition), staging (cleaning), intermediate (advanced transformations), marts (thematic models), and reports (dedicated aggregations for reports).
- Implementation of a daily refreshed “Daily Operational Report” dashboard in Microsoft Power BI, with tabs tailored to the needs of the Commercial Department. The dashboard is based on an aggregated data model, prepared in the reports layer based on a multi-layer data model implemented in Google BigQuery.
- Joint clarification with the client of business logic, definitions of operational concepts, and definition and implementation of key metrics, KPIs, and indicators in line with the needs of the Commercial Department. The whole process was implemented in a data model and verified during intensive iterations with the client's team.
- Creating complete product documentation in Confluence, describing data modeling logic and indicator definitions, ensuring transparency and sustainability of project knowledge.
- Ensuring data refresh orchestration using Cloud Composer (Airflow), enabling stable and automatic data updates in reports using best practices for dependency management.
Results
Key results:
- A centralized, daily refreshed data source for the Commercial Department, based on a reusable data model (including a key fact table containing data on operations and their characteristics), providing the foundation for current reports and future analytical initiatives.
- Power BI dashboard enabling quick access to operational indicators.
- Transparency and standardization of business metric definitions.
Business value:
- Support for strategic management decisions based on reliable data.
- Enabling monitoring of budget implementation and business objectives.
- Saving analysts' time and eliminating manual data processing.
- Greater confidence in data thanks to documentation and transparency of processing logic, as well as ensuring proper orchestration.
- Quickly reaping the benefits after launching the report.
The project implemented by Alterdata has provided us with a tool that supports management and decision-making in the commercial department on a daily basis. Process transparency, accessibility, and data quality are crucial to our daily work.
The project implemented by Alterdata has provided us with a tool that supports management and decision-making in the commercial department on a daily basis. Process transparency, accessibility, and data quality are crucial to our daily work.
Summary
The implementation of the Daily Operational Report shows how combining Alterdata's analytics and data engineering expertise with modern tools (Dataform, BigQuery, Power BI) allows for the creation of comprehensive, stable, and flexible reporting environments. Partnership-based, iterative cooperation with the PŚO team has enabled the creation of an analytical foundation that not only supports today's reporting needs, but also provides a basis for future analytical developments within the organization.
