Automating management reports for a media company
Overview
Industry
Location
Media and entertainment
Poland
Technology Used
Apache Airflow
AWS Lambda
Microsoft Power BI
Microsoft PowerApps
Microsoft SharePoint
Snowflake
Project overview
Developing a reporting application that consistently presents financial results and media metrics. Delivering a solution that leverages standardized nomenclature, precise measurement definitions, and data from domain systems to enable stakeholders to make informed business decisions.
Its key features included comprehensive financial analysis across different time frames, multi-currency support (PLN and USD), and collaboration tools (in-report commenting and Excel-based forecasting and corrections via Microsoft Teams).
Client background
A leading media company in Poland which operates a diverse portfolio of television channels, digital platforms and streaming services and reaches millions of viewers and users daily. Our client is part of a multinational mass media and entertainment group.
Goals
Standardizing KPI definitions and identifying stakeholders and data sources to enable stakeholders to make informed business decisions. Automating the data collection process and migrating reports from Excel spreadsheets to MS Power BI platform (adding the capability to leave comments on the canvas).
Results
Increased efficiency through automation
Replacing manual tasks with an automated system saved time and reduced the potential for manual errors
Real-time data access
Providing access to data in real-time, so that management could see the most current information at any time
Enhanced analytical capabilities
Empowering stakeholders to make informed business decisions by automating a complete analysis of key financial KPIs and media metrics
We'd love to hear from you!
Fill out the form - we'll get back to you as soon as possible
