Customer story
A leading global media agency wanted to automate performance-data analysis for its customer, Sony Electronics, across web advertisements — but Digibase, its business intelligence tool, still required heavy manual work to get data onto a dashboard. We extended Digibase with new data ingestion, multi-year benchmarking, and dashboard modules, cutting the manual work out of performance reporting.
Engagement facts
Client
Leading global media agency (reporting on ad performance for Sony Electronics)
Industry
Professional Services (media/advertising agency) — no exact match in the site’s current industry taxonomy
Region
Not specified in source article
Service
Business intelligence & digital reporting extension
Stack
MS IIS
MS SQL Server (built on the client’s existing Digibase application)
modules delivered — data ingestion, benchmarking, and dashboard
Multi-year
benchmarking added where none existed before
environments tested — development and staging
Manual → Automated
dashboard reporting process
The client
A leading global media agency
The client is a leading global media agency.
The need
Automating Sony Electronics' ad performance analysis
The client aimed to provide a tool to automate its customer Sony Electronics’ data analysis capability for its advertisements across various websites. This required a sophisticated business intelligence tool with a data warehouse. The result was a tool called Digibase, built by the client — but presenting that data on a dashboard still required several manual manipulations, which needed to be automated through extensions to the application’s modules.
The challenge
Undocumented modules and no multi-year benchmarking
While the existing application functioned well in some areas, its benchmarking and dashboard functions weren’t well set up. Clear architectural documentation wasn’t available to guide extensions to the existing application, and the new modules had to integrate cleanly with the existing Digibase deployment.
- Data Ingestion: existing modules were incomplete and undocumented
- Benchmark Computations: multi-year benchmarking of earlier data didn’t exist within the system
- Dashboard: aside from a basic set of reports, there were no multi-year benchmark comparisons
The solution
Extending Digibase with ingestion, benchmarking, and dashboard modules
The new modules and automations were planned as extensions under the hood of the existing Digibase application, which ran on MS IIS and MS SQL Server. The existing source code was analyzed and new extensions built to fit into it — tested first in a development environment, then in staging to confirm production readiness.
Data Ingestion
Analyzed several source data files containing performance information and modified existing modules to populate the application as required.
Benchmark Computations
Generated metrics from several years of data for use as a benchmark, where the existing application had almost no benchmarking modules.
Dashboard Development
Compared multi-year benchmark computations against current performance data and reported it based on user needs.
Benefits
What changed for the client
Less manual work
High-quality modules let the client minimize manual processes for viewing performance information on a dashboard.
Technology
What we used
Our consultants can help you extend your existing reporting tools with automated benchmarking and dashboards.
Your reporting
Still manually building performance dashboards?
Let’s plan your reporting solution. Talk to our consultants — no cost, no obligation.
More migration work
Related case studies
