Big Data Warehouse & Digital Advertising Analytics for Media Conglomerate
The client wanted eSage Group to bring our extensive business domain knowledge and system analysis/design skills to perform a detailed deep-dive review of the current in-house system and develop a replacement system based on the latest Big Data Hadoop technologies and the FreeWheel Advertising Management Platform.
The existing data set and business logic was largely undocumented and there were limited resources available to provide insight into the data, requiring the eSage team to do detailed discovery and technical analysis.
The system review included detailed analysis of various business use cases, requirements, existing advertising system, associated data model/feeds, business logic and reporting.
eSage Group then got to work on the design and development of the replacement system that included the FreeWheel Advertising Management solution and an associated Big Data platform to store and manage all the underlying data.
eSage Group then assisted with the design and development of a Big Data platform and FreeWheel system migration. eSage Group leveraged our deep knowledge of the advertising system and extensive Big Data design and implementation skills to perform this task. This effort included design and development of included ETL’s, an OLAP data cube to store the associated data and utilization of the Hadoop Map reduce framework to managing the large distributed data sets. Data from various websites, digital advertising sources, sales and financial systems were integrated and stored within the new Hadoop based Big Data repository.
With eSage Group’s help, the Ads Migration hit a very aggressive schedule and allowed the business units to move off the older and inefficient in-house ads system onto the new FreeWheel based advertising management platform with new Big Data repository.
- Technical Analysis and Architecture
- Database Design, ETL routines & OLAP Analytics Cube
- Design and Development of new Hadoop Big Data platform
- Data migration to FreeWheel Ad Management Platform