Dinesh Madhavan | Portfolio
Prime Video Analytics Dashboard
Power BI
Power Query
Geographic Map
Summary
Analysed Prime Video’s content up to 2021: cleaned country/genre data, standardized ratings, then visualized:
Data Transformation
- Filled missing country via distribution analysis → default “USA”.
- Selected first genre for multi-genre rows.
- Standardized “RATE_18” / “18+” → “18+”.
Key Visuals
- Genre Bar Chart: Drama, Action, Comedy breakdown.
- Map: Top-producing countries (USA leads).
- Content Growth Line: Releases over decades.
- Ratings Bar Chart: Audience segmentation.