Client Description

Group 1200 Media is a fully integrated next-generation independent entertainment studio. G1200 Media, the parent holding company of subsidiaries, FUNimation Entertainment, Giant Ape Media, and Group 1200 Consumer Products, is a market leader in the acquisition, creation, production, distribution, licensing and marketing of our wide-ranging Anime, TV and Movie slate. The studio uses our portfolio of brands to differentiate genres and unique audiences with curated content, services and consumer products. Our content is released across traditional and digital distribution channels, including theatrical exhibition, physical and digital home entertainment, pay and free television subscription on-demand services.

In July 2017  Sony Pictures Television Networks, the Culver City, California-based unit of the Japanese consumer electronics group, paid $143 million for a 95 percent stake in Funimation.

Challenge

Group1200 is a small sized media company, who wanted to replace their excel reporting by building analytical platform with bare minimum upfront investment without compromising on security.  With their minimal technical expertise, they didn’t want to be limited to excel/ad-hoc reporting, yet be able to analyze their subscribers, generate new leads, sell merchandise effectively, minimize churn rate and help users to make decisions on business processes with use of KPIs.

Solution

iOLAP architected data warehouse solutions using Amazon Web Services platform.  Customer, membership, product sales, viewership events data is pulled from NetSuite via API calls and pushed to S3 on a daily basis, then process into Redshift using Talend.  We setup file validation framework, where more than 100 flat files sources is processed via SQS queues and data quality functions, then sends out auto notification to responsible user for failure.  Domo is used for enterprise reporting and dashboard needs.  Facebook, twitter and other social media data is directly fed into Domo for customer sentiment analysis.

Benefits

Group1200’s analytical platform was up and running in no time, with the least upfront cost.  They are using some of the latest and greatest technologies without investing much to maintain them.  They are able to analyze data at atomic level in one place, which they can refer to a single source of truth, which is easily accessible and made available to them in timely manner.

  • Tools: Domo | EC2 | Redshift | S3 | Talend
  • Categories: Analytics, Big Data
  • Tags: Media