Business Situation
- A leading American mass media and entertainment conglomerate wanted to overcome all obstacles in managing multiple disparate data sources.
- The conglomerate had fragmented data sources and needed a unified view to assess data quality comprehensively. It sought expertise to amalgamate these sources, identify missing data, resolve ambiguities, and ensure reliable information extraction.
SGA Approach
Technology
- Utilized Snowflake as the central data repository and leveraged Databricks for large-scale data transformation
- Implemented Tableau for data visualization and stakeholder access
AI
- Developed matching algorithms to produce automated, user-friendly insights and utilized Python libraries for advanced algorithm development
Data
- Consolidated data from various platforms through APIs and custom tools and processed and transformed large data sets using Python-based functions and Databricks
Key Takeways
- Established a unified data repository, enabling comprehensive telecast comparisons and reducing data processing time from 48 to 4 hours
- Empowered stakeholders with easily interpretable insights, with auto-generated insights in the weekly and monthly report generation
- Enhanced decision-making capabilities through improved analytics and faster data processing, significantly reducing the time needed for stakeholders to make business decisions
