The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
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.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Designed and developed a modern SaaS web application for healthcare clinic management. The platform streamlines patient records, appointment scheduling with calendar view, doctor management, and billing operations.
Focused on building an intuitive, scalable interface with interactive dashboards, real-time notifications, and seamless user flows to improve daily clinic operations. Implemented features such as patient-doctor communication, activity tracking, and data-driven insights to support better decision-making and efficiency.
So clean!
Sales Performance Dashboard | Power BI
Designed and developed an interactive sales analytics dashboard to help stakeholders monitor revenue, customer growth, product performance, and regional sales trends in one centralized view.
Tools Used:
- Power BI
-Power Query
- DAX
- PowerPoint (wireframing and dashboard planning)
My Contributions:
- Imported and transformed raw sales data using Power Query.
- Built a star schema data model by creating relationships between fact and dimension tables.
Developed DAX measures for:
- Total Sales ($105M)
- Total Quantity Sold (6M units)
- Total Customers (9,191)
- Average Unit Price ($17.6)
- Created Previous Year (PY) metrics and Year-over-Year growth calculations for sales, quantity, and customers.
- Implemented conditional formatting with dynamic color indicators to highlight performance changes.
Dashboard Features:
- Geographic sales analysis using Shape Maps.
- Monthly trends for sales, quantity, pricing, and customer acquisition.
- Customer segment analysis using donut charts.
- Product and country performance rankings using stacked bar charts.
- Interactive filtering for business units and service plans.
Business Impact:
The dashboard provides decision-makers with a single source of truth for tracking sales performance, customer behavior, and regional trends, enabling faster and more informed business decisions.
Data VisualizationMicrosoft Power BIBusiness AnalysisData AnalysisMicrosoft ExcelMicrosoft PowerPoint
Title
Northline Films — Cinematic Portfolio for Visual Storytelling
Website Description
Northline Films is a premium portfolio website created for a commercial film director whose work is presented as the primary storytelling element. Rather than relying on decorative UI components, the website embraces a cinematic philosophy where large imagery, generous spacing, refined typography, and subtle motion establish an immersive viewing experience.
The design follows a dark editorial aesthetic inspired by luxury fashion campaigns, contemporary cinema, and award-winning creative studios. Every page is intentionally minimal, allowing visitors to focus entirely on the films. Smooth transitions, elegant hover interactions, and carefully balanced compositions provide a sophisticated browsing experience across desktop, tablet, and mobile devices.
Instead of functioning like a traditional corporate portfolio, the website feels like a digital exhibition—inviting visitors to explore visual narratives through carefully curated film projects.
Brief Content
Northline Films showcases a curated collection of commercial films, branded campaigns, fashion projects, and cinematic visual stories. The homepage highlights selected works with large hero visuals before leading visitors into an organized archive of projects. Each film includes dedicated pages containing high-resolution videos, production credits, short project descriptions, behind-the-scenes photography, storyboards, and additional creative materials.
A lightweight content management system allows the filmmaker to upload new work, rearrange featured projects, edit descriptions, and manage the portfolio independently without requiring technical knowledge. The entire experience is optimized for high-performance video playback, responsive mobile viewing, and modern SEO standards while maintaining a premium visual identity.
Image 1 — Film Archive
The first image presents the complete film library displayed as an elegant visual archive. Thirty-six cinematic projects are arranged within a carefully balanced grid, allowing visitors to browse the director's body of work without distraction. Every thumbnail serves as a visual teaser, using dramatic color grading, strong composition, and cinematic lighting to immediately communicate the tone of each project.
Minimal navigation and subtle category filters keep the interface clean while helping users quickly explore fashion, automotive, lifestyle, sport, music, and branded productions. Large typography, dark backgrounds, and generous spacing reinforce the luxury editorial aesthetic, making the archive feel more like an exhibition than a traditional project listing.
Image 2 — Homepage
The second image illustrates the homepage experience. A striking full-screen hero image immediately captures attention, accompanied by oversized typography that establishes a strong cinematic identity. Rather than competing with the photography, the interface remains intentionally restrained, allowing the visual storytelling to dominate the screen.
Below the hero section, featured projects introduce the director's most important work through carefully selected film stills. Smooth navigation, elegant transitions, and refined typography create a premium browsing experience that reflects the craftsmanship behind the films themselves. The responsive mobile layout maintains the same visual language, ensuring consistency across all devices while preserving fast loading times and immersive presentation.
Image 3 — Content Management Experience
The third image reveals the portfolio's content management workflow from the filmmaker's perspective. Viewed over the shoulder of a user, the interface demonstrates how featured projects can be selected through a simple and intuitive editing experience. The person's face remains hidden, placing full emphasis on the interaction between creator and portfolio.
Three cinematic film stills are being selected from the complete project archive to appear as featured works on the homepage. This visual communicates one of the website's core principles: enabling creative professionals to update, organize, and curate their portfolio without technical expertise. The warm studio lighting, dark interface, and minimalist controls reinforce the premium atmosphere while illustrating the simplicity of maintaining the website after launch.
Trending
Claude
Claude has entered the design space. How are you using Claude Design?
Contra University
Learn from expert creatives how to earn more using next-gen AI tools.
creativeaiflow
Creative AI workflows are evolving. What tools do you use, and what are their strengths and weaknesses?
freelancerlife
Freelancer life is wins, pivots, and everything in between. What’s yours right now?