Skip to content

Latest commit

ย 

History

11 Commits

Folders and files

NameName
Last commit message
Last commit date
ย 
ย 
ย 
ย 

Repository files navigation

PowerBi_Capstone_Project

This repository contains an interactive and insightful dashboard to analyze Amazon Prime video data. The project involved data cleaning, transformation, and visualization to support decision-making for content strategy.

Amazon Prime Data Analysis โ€“ Power BI Dashboard

๐Ÿ”นProject Overview

This project explores the Amazon Prime Movies & TV Shows dataset using Power BI to uncover trends and insights about the content available on the platform. The dashboard provides a visual summary of titles, genres, directors, and ratings, helping to understand the distribution and evolution of Amazon Primeโ€™s content library.

๐Ÿ”น Objectives

  • Analyze the distribution of movies vs. TV shows.
  • Identify trends in content release over the years.
  • Explore country-wise content availability.
  • Highlight most common genres and ratings.
  • Provide an interactive dashboard for quick insights.

๐Ÿ”น Key Features of Dashboard

  • Content Type Breakdown โ€“ Movies vs. TV Shows.
  • Geographic Insights โ€“ Top contributing countries.
  • Trend Analysis โ€“ Titles added per year and release year.
  • Genre Distribution โ€“ Popular categories of content.
  • Ratings Overview โ€“ Audience targeting (G, PG, R, etc.).

๐Ÿ”น Tools & Skills Used

Power BI โ€“ Interactive dashboards & visuals. Data Cleaning โ€“ Null handling, date formatting, splitting multiple values (Excel/Power Query). Visualization Techniques โ€“ donut,filters,bar/line/stacked charts, map.

๐Ÿ”น Insights Gained

Movies make up the majority of the Amazon Prime catalog. The US and India are the top content-producing countries. Significant growth in content addition post-2015. Drama, Comedy, and Action dominate as the most common genres. Rating distribution shows a focus on family-friendly and young adult audiences.

๐Ÿ”น How to Use

Download the .pbix file from this repository.

Open in Power BI Desktop.

Explore the interactive dashboard with available filters.

๐Ÿ”น Files in this Repo

AmazonPrimeDashboard.pbix โ†’ Power BI dashboard file.

README.md โ†’ Project documentation.

๐Ÿ”น Preview

image

Drillthrough concept:

image

๐Ÿ”น Dataset Source

Kaggle โ€“ Amazon Prime Movies and TV Shows Dataset

This project demonstrates my ability to transform raw datasets into meaningful insights using Power BI and communicate findings through interactive dashboards.

About

This repository contains an interactive and insightful dashboard to analyze Amazon Prime video data. The project involved data cleaning, transformation, and visualization to support decision-making for content strategy.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors