Connect With Us

Content Hub

Get in Touch

Our Presence



Sony Digital Reporting Project

13 FEB 2018

 

Digital Reporting

Client

The client is a leading global media agency

Clients concocted a thought

The client is aiming to provide a tool to automate its customer, Sony Electronics’ data analysis capability for its advertisements on various web sites. In order to do this a sophisticated business Intelligence tool with data warehouse was essential. While it resulted in creation of a tool called Digibase by the Client, presenting the data to Dashboard required several manual manipulations. This had to be automated with necessary extensions to the application modules.

Challenges

While the existing application was functioning well on some parts, benchmarking and Dashboard functions were not well setup. To make extensions to existing application, clear architectural documentation was not available. Moreover, the new modules had to work with existing deployment of Digibase, which required thoroughly conceived and working modules for integration.

  • Data Ingestion: Existing modules were incomplete and undocumented
  • Benchmark Computations: Multi-year benchmarking of earlier data within system didn’t exist
  • Dashboard: Except basic set of reports there were no comparisons on multi-year benchmarks

What we proposed

The modules and automations were planned as extensions under the hood of existing Digibase application which had MS IIS webserver and MS SQL servers as underlying components. Existing source code of modules were analyzed and new extensions made to fit into this. Once tested in development environment, these were to be tested on a Staging environment to ensure its production capabilities.

  • Data Ingestion: Several source data files containing performance information were analyzed and existing modules were modified to populate them to application as desired.
  • Benchmark Computations: Based on several years of data, metrics were to be generated for use as benchmark. Existing application had almost no modules for benchmark computations.
  • Dashboard Development: Once multi-year benchmark computations were available, it had to be compared with current performance data and reported based on user needs.

Results & benefits obtained

The key benefits realized as a result of the successful project include:

  • High Quality modules allowing Client to minimize manual process to see the performance information on a Dashboard.

Our Recent Posts

Azure Inventory management Portal
Inventory Management Portal

Client Leading Manufacturing company in North America Clients concocted a thought The client was using legacy application for managing….

SharePoint
SharePoint Site Collection Management for Wealth Management Firm

Client Private American Wealth Management Firm. Clients concocted a thought The client had a setup of SharePoint 2010 and had a site collection….

Microfinance Institutions
Micro Finance – MF Core

Client Micro finance – MF core Clients concocted a thought Micro Banking organizations, especially Microfinance Institutions (MFIs)….

No Comments

Post A Comment