Media

Sweet.tv

Reporting automation for media streaming provider: real-time business intelligence at scale

70%

Reduction in manual reporting time

+95%

Data accuracy achieved

30%

Cost savings on legacy reporting infrastructure

Case Studies

Transforming data chaos into clarity with automated cloud-based reporting – reducing costs and scaling analytics.

Check Testimonial

Media & Entertainment

Industry

Ukraine

Location

Data Architecture Design, Legacy System Audit, SQL Performance Optimization

Services

$45,000 – $60,000

Budget

Thanks to their open management style, they had an exceptional partnership that resulted in success.

Serhii 
Ivanets

CTO, VAN Group
Challenge

Leading online media streaming platform, was grappling with siloed on-premises data, outdated reporting flows, and overwhelming manual SQL operations.

See what we can do for you
Outcomes We Deliver

Solution

We delivered a modern, cloud-native BI infrastructure centered on a robust Enterprise Data Warehouse (EDW) hosted on Google Cloud. The result: business teams could instantly access insights – without writing SQL -while DevOps maintained a scalable, cost-efficient architecture.

Let’s talk about what’s possible
Dalriada
Tech Stack

To develop acloud-native BI infrastructure, Blackthorn AI applied a production-grade tech stack including:

Python
Google Cloud Platform
Terraform
Apache Airflow
Roadmap

Project duration

01–04 Weeks

Discovery & System Analysis

Deep dive into the existing reporting system, design new analytical architecture and ETL structure

05–08 Weeks

Project & Infrastructure Setup

Setup Google Cloud Platform services, configure environments for development & testing

09–40 Weeks

Core System Development

Build new automated pipelines with Apache Airflow & Dataflow Create scalable BigQuery-based DWH, iterate based on team feedback and stakeholder reviews

41–44 Weeks

Infrastructure Provisioning & Cost Optimization

Automate infrastructure management using Terraform, ensure scalability and serverless execution for peak loads, implement cost monitoring and optimization practices

45–48 Weeks

Final Release & Knowledge Transfer

Prepare documentation and system manuals, release fully automated cloud-based BI system to production

Team Size

5 team members from Blackthorn.ai
1 x Solutions Architect
1 x Senior Data Architect
1 x Data Engineer
1 x BI Engineer
1 x DevOps

Delivering Impact

Beyond the values already highlighted, there’s even more to discover. Our commitment to innovation, client success, and impactful results sets us apart

Book a Meeting

30%

Cost savings

On legacy reporting infrastructure

+95%

Data accuracy achieved

Automated ETL pipelines eliminated common human errors in CSV/Excel-based reporting workflows

+40

Internal users

Onboarded in first month

Faster access

To financial and performance metrics

70%

Reduction

In manual reporting time