This project presents a comprehensive Prime Video Content Analysis Dashboard developed using Microsoft Power BI. The dashboard provides an in-depth exploration of Prime Video’s global content library, offering valuable insights into titles distribution, ratings classification, genre trends, country-wise availability, and release year growth patterns.
The objective of this project is to demonstrate strong data visualization, data modeling, DAX calculations, and business intelligence skills by transforming raw entertainment data into actionable insights.
- Total Titles: 9,655
- Total Ratings Categories: 25
- Total Genres: 519
- Total Directors: 5,771
- Content Timeline: 1920 – 2021
These KPI cards provide a quick snapshot of the Prime Video catalog scale and diversity.
An interactive world map visual displays the distribution of total shows across different countries, enabling geographical analysis of content production and availability.
A time-series analysis visual highlights:
- Growth of Movies vs TV Shows over decades
- Rapid expansion in content production after 2000
- Significant surge in recent years
This helps understand platform expansion and content investment strategy.
Top genres by total shows include:
- Drama
- Comedy
- Drama & Suspense
- Comedy & Drama
- Animation & Kids
- Documentary
This visualization helps identify audience-focused content categories.
A donut chart comparison between:
- Movies (80.82%)
- TV Shows (19.18%)
This clearly demonstrates Prime Video’s dominant content type.
The dashboard analyzes content distribution by rating categories such as:
- 13+
- 16+
- 18+
- PG-13
- Kids categories
This provides insight into target audience segmentation.
- Microsoft Power BI
- Power Query (Data Transformation)
- DAX (Data Analysis Expressions)
- Data Modeling (Star Schema Approach)
- Interactive Visualizations & KPI Cards
- Prime Video’s content library has significantly expanded post-2000.
- Movies dominate the platform compared to TV Shows.
- Drama and Comedy are the most produced genres.
- Content is globally distributed but concentrated in key production countries.
- A large portion of content falls under 13+ and 16+ rating categories.
✔ Data Cleaning & Transformation ✔ Data Modeling ✔ DAX Measures & Calculations ✔ Time Series Analysis ✔ Business Insight Generation ✔ Interactive Dashboard Design ✔ Data Storytelling
This project was built as part of my Data Analytics / Business Intelligence Portfolio to demonstrate my ability to:
- Work with large datasets
- Design executive-level dashboards
- Extract meaningful insights from raw data
- Present data in a professional and visually engaging manner