Global Entertainment Company:
Transforming Data into insights!

Client Overview  

The leading Global Entertainment company is a Los Angeles–based multiplatform media company specializing in the distribution, development, and production of films, television series, animation, and documentaries, with a strong focus on preserving and revitalizing popculture entertainment. The company is recognized as a leading independent distributor offering content through physical media formats like DVD and Bluray, as well as digital streaming via its own FAST streaming service.

The Challenge  

We have data coming from different layers of reports which need to be brought in with a lot of complex transformations, and sluggish query performance. Their data was scattered across multiple platforms such as Netsuite, Azure Cloud, SharePoint. The primary objective was to integrate data from these diverse sources to support daily reporting needs to track the revenue analysis and performance of the sales across channels like AVOD, TVOD, SVOD, FAST and Licensing.

Decision Foundry’s Approach  

DF adopted a structured and data-driven approach to tackle the client’s challenges:  

• Assessment and Planning: Conducted a comprehensive assessment of the existing data infrastructure to identify bottlenecks and areas for improvement.  
• Technology Selection: Chose industry-leading technologies, including, Azure Data Factory, Azure functions, and PowerBI, to build a robust data solution.  
• Integration Strategy: Developed a strategy to integrate data from various platforms into a centralized warehouse Azure Data Factory.  
• Optimization: Focused on optimizing tables and processes to enhance query performance and reliability.  
• Implementation Roadmap: Established a phased implementation plan to ensure minimal disruption to business operations.  

Solution Implementation  

The implementation of DF’s solution was characterized by several key steps:  

• Centralized Data Warehouse: Built a centralized data warehouse using Azure Data Factory, allowing for seamless data integration and improved data accessibility.  
• Daily Data Refresh: Implemented a daily refresh and mechanism to cross-check the data accuracy.
• Medallion Architecture: Leveraged a medallion architecture to streamline data processing and support dashboard functionalities.  
• Process Optimization: Optimized data tables and processes to handle gigabytes of data efficiently, improving overall system performance.  

Results and Impact  

The project delivered significant improvements and measurable outcomes:  

• Enhanced Reporting Reliability: Reports are now reliable and trusted by the client, eliminating the need for cumbersome Excel transformations.  
• Centralized Access: Provided centralized access to a comprehensive database, facilitating ad-hoc analytics and improving decision-making speed.  
• Business Overview: Enabled a holistic view of the business, supporting strategic insights and growth opportunities.  
• Client Expansion: The success of the project prompted ABC to express interest in automating ad-hoc analytics and exploring additional data sources.  

Client Testimonial  

“Great feedback; eager to include additional sources and suggested ideas where we can get more from the data we had. We are interested in automating ad-hoc analytics and keen to see more reports.” - Client

Key Takeaways  

• DF successfully integrated multiple data sources into a centralized warehouse, enhancing data reliability and accessibility.  
• The use of Azure Data Factory, and PowerBI optimized data processes, significantly improving query performance.  
• The project resulted in improved decision-making capabilities and strategic business insights for the client.  
• Positive client feedback and interest in expanding the scope of work underscore the project’s success.  

Summary  

• DF enabled the client to centralize their data infrastructure, enhancing reporting reliability.  
• Utilized Azure Data Factory to optimize data processes and improve performance.  
• Successfully integrated diverse data sources, supporting daily reporting and ad-hoc analysis.  
• Provided strategic business insights through a comprehensive and accessible data overview.  
• Client feedback highlighted increased trust in data and eagerness for further collaboration.   

By leveraging DF’s expertise in data consulting and partnerships with platforms like Snowflake, the client achieved a transformative upgrade to their data operations, paving the way for future growth and innovation.