ABOUT THE CLIENT: A global leader in entertainment, serving fans around the world with content that inspires, informs and entertains. Client delivers over 10,000 hours of original programming each year across deeply loved content genres.
THE PROBLEM: Client is leader in creating programming and contents, but back office is behind the curve when it comes to collecting and analyzing data. Client was looking for a solution where they could develop a solution to analyze cost associated with each line item of the programming, such as director, writer, logistics, supplies, crew, shooting, and etc. Finding a lowest possible cost of production was the goal.
THE SOLUTION: Cominfo was asked to develop a solution, which collects data from all over the world from different service providers and store in easily accessible format and create analytical report to analyze millions of data appoints. We developed a robust solution using MS SQL Server running on Azure, which ingest data from other relational databases, pdf, Excels, 3rd part applications, API and etc. using SQL Server Integration Services (SSIS) to Extract, Transform, and Load (ETL) data from these into single repository. Data was brought into Power BI reports. These reports were access from any web enabled devices around the world.
RESULTS: Our solution allowed client to compare production cost between similar programming such as what was the cost of shooting 10 episodes of 30 minutes in Australia. Solution also allowed client to pick and choose lowest acceptable possible cost of each line item to establish the budget for future programming. Solution also allowed client to engage and view availability of service providers to create programming for the client. Today client can produce programming by in most optimize manner resulting in increase in profit for the company.