Disney Music Group Data Analyst Case — Soundtrack Launch and Catalog Streaming Optimization

This Disney Music Group (DMG) case mirrors real Disney data interviews by combining hands-on analysis with business storytelling around a high-profile soundtrack launch tied to a major Disney/Marvel/Lucasfilm/Pixar title. You will work with a realistic, multi-source data packet and present clear recommendations to both technical partners and creative/business leaders. What the case covers at Disney: - Business scenario: Advise DMG on pre-release forecasting and first-8-weeks performance optimization for a new soundtrack while also surfacing high-ROI opportunities in the catalog (e.g., Frozen, Moana, Guardians) ahead of seasonal/marketing beats. - Data packet provided: (1) Streaming events by platform and territory (Spotify, Apple Music, YouTube, Amazon), (2) Track/album metadata (ISRC, explicit flags, versions/mixes), (3) Playlist add logs and positions, (4) Social and UGC signals (TikTok sounds usage, YouTube views, Shazam, pre-saves), (5) Marketing calendar and spend, (6) E-commerce/DSPS pre-adds and pre-orders, (7) Light territory and partner targets from Label/Studio Marketing. - Core analytics tasks: Define Disney-relevant KPIs (daily stream velocity, 7-day retention, playlist conversion, pre-save→day-one streams, territory lift around release events); clean and join data; segment by partner/territory/version; forecast first-week and week 2–8 performance; identify anomalies (bot/playlist farming, metadata fragmentation between mixes); size catalog uplift opportunities linked to upcoming content drops or concert tours. - Case prompts you may receive: (a) Write/outline SQL to return top US tracks by first-week streams excluding remixes/duplicates; (b) Diagnose a sudden drop on one platform vs others and propose root causes; (c) Evaluate an A/B test on artwork/thumbnail or track sequencing; (d) Recommend a playlisting strategy and regional rollout plan; (e) Flag family-friendly curation considerations for Disney-branded playlists (explicit content handling) and discuss data privacy guardrails with partner data. - Deliverables: A concise, executive-style narrative (10–12 minutes) that tells the story of the data for label and studio stakeholders, plus a technical appendix (5 minutes) walking through methodology, assumptions, and query logic. Expect clarifying Q&A on trade-offs, data quality, and measurement rigor. - Evaluation criteria aligned to Disney culture: (1) Storytelling with data for a broad audience, (2) Craft and rigor (SQL, Excel/Python, experimentation, forecasting), (3) Judgment around brand integrity and family-friendly curation, (4) Collaboration mindset with Creative, Marketing, Publishing, and Legal, (5) Bias for guest/fan experience and long-term franchise value over short-term spikes.