Freelancers using Microsoft Teams in LagosFreelancers using Microsoft Teams in Lagos
AI Voice Agents & Automation for Growing Businesses
5.0
Rating
48
Followers
AI Voice Agents & Automation for Growing Businesses
Product Designer | Mobile • Web • Dashboard Design
32
Followers
Product Designer | Mobile • Web • Dashboard Design
Products that look sharp and ship fast. Design + Framer
1x
Hired
5.0
Rating
8
Followers
Products that look sharp and ship fast. Design + Framer
Executive Assistant | Data Analyst | Brand Strategist
New to Contra
Executive Assistant | Data Analyst | Brand Strategist
Cover image for Netflix has a massive content
Netflix has a massive content library, but how well is it balanced? Are they meeting audience preferences? The client needed a clear, data-backed understanding of their content composition specifically, the ratio of movies to TV shows, genre distribution, regional availability, and content rating trends, to inform strategic decisions about future content acquisition and production. I conducted a comprehensive analysis of Netflix's content library using data sourced from Kaggle. My process and deliverables included: 1. Data Preparation (Excel): Cleaned and structured the raw dataset for analysis, ensuring data quality and consistency. 2. Data Querying (SQL): Wrote queries to extract key metrics—content count by type, genre distribution, rating categories, and country-wise availability. 3. Data Visualization (Tableau): Created interactive dashboards and visualizations to bring the data to life, including: i. Bar Charts: Showed the dominance of Drama, Documentaries, and Stand-up Comedy as top genres. ii. Map Visualization: Highlighted the USA (2,818 titles) and India (972 titles) as the countries with the most content. iii. Pie Chart: Visualized the 69.6% (movies) vs. 30.4% (TV shows) split. - Statistical Analysis (t-test): Performed a t-test confirming a statistically significant difference between movie and TV show uploads (t-value = 56.60, p-value = 0). - Trend Analysis: Identified the 2019 peak in content uploads and the subsequent decline in 2020–2021, correlating with the rise of competing platforms and the COVID-19 economic downturn. Strategic Recommendations: Provided actionable insights for Netflix: i. Increase TV show content to balance audience preferences. 2. Experiment with short-form content to attract broader audiences. 3. Conduct user surveys to align content strategy with viewer demand. 4. Study competitor patterns and emerging trends to stay ahead. A clear, data-driven analysis that provided Netflix with a comprehensive understanding of its content library and actionable recommendations to improve viewer engagement and retention.
1
119
Designing purposeful experiences with creativity and impact.
Designing purposeful experiences with creativity and impact.