Case Studies

Case Study: Data Analysis System for Entertainment Company

Client

The client, together with its subsidiaries and affiliates, is a leading diversified, international family entertainment and media enterprise with five business segments: media networks, parks and resorts, studio entertainment, consumer products, and interactive media.

 

Business Need

The client has a network of multimedia internet sites which display advertisement for their clients. Proprietary technology has been developed over years to support advertisement sales, execution of contracts, collecting actual ad impression data, and invoicing for the contracts. With the growth of the Internet in the last decade, systems began accumulating overwhelming amounts of business data in TB ranges, serving billions of ads a day.

Data rationalization projects have been created to:

  • Utilize modern BI and data analysis tools
  • Perform analysis and optimization of data schemas
  • Analyze the actual data quality

 

These projects help to identify corrections and changes needed in source systems to improve data usability by the business decisions makers.

As a result, the client required a system that could utilize modern BI and Data Analysis tools and perform better analysis and optimization of data schemas.

 

Solution

Although Akvelon’s strength is found in end-to-end development, they were asked to perform strong data analysis and come up with a system prototype. Once completed, the technology was presented to management and technology stakeholders, which was used to define a strategy for moving Analysis Services technology.

The prototype provides:

  • Framework for data transformations
  • Quality analysis
  • Key dimensions
  • Report prototypes

 

Benefits and Results

As a result of Akvelon’s data analysis and system prototype, the groundwork was laid for new analysis services technology that help to identify corrections and changes needed in source systems.

Akvelon delivered a framework and prototype for business decision makers to more effectively use data to move services.