Disney+ Analysis

Project Overview

This project involves an in-depth analysis of Disney+ shows using Power BI. The analysis provides various insights into the total titles, directors, countries, ratings, genres, and more. The dashboard incorporates advanced features like DAX functionality, data modeling, Power Query for data validation, drill downs, drill throughs, page navigation buttons, bookmarks, and tooltips for enhanced interactivity.

Features

• DAX Functionality: Used for complex calculations and data analysis.
• Data Modeling: Structured data relationships for effective analysis.
• Power Query: Data extraction, transformation, and validation.
• Drill Downs and Drill Throughs: Detailed exploration of data subsets.
• Buttons for Page Navigation: Easy navigation across different reports.
• Bookmarks: Saved states of the report for quick access.
• Tooltips: Hover-over insights providing additional analysis in a pop-up window.

Tools and Technologies

• Data Visualization: Power BI
• Data Analysis Expressions (DAX): For calculations and data analysis
• Power Query: For data transformation and validation

Dashboard Overview

Disney+ Analysis Dashboard

The dashboard includes the following insights:

• Total Titles: The total number of shows available on Disney+.
• Total Directors: Number of unique directors.
• Total Countries: Number of countries producing shows.
• Average Duration: Average duration of the shows in minutes.
• Total Ratings: Different ratings the shows have received.
• Total Genres: Number of genres available.
• Total Shows by Country: Geographic distribution of shows.
• Total Shows by Release Year: Trend of shows released over the years.
• Genres by Total Shows: Distribution of shows across different genres.
• Ratings by Total Shows: Number of shows per rating category.
• Shows by Year: Yearly distribution of shows.

Usage

• Data Modeling and Transformation: Open the DisneyPlusAnalysis.pbix file in Power BI Desktop.
• Explore the Dashboard: Interact with the various visual elements, use drill downs and drill throughs for detailed insights.
• Tooltips and Navigation: Hover over elements to view tooltips and use navigation buttons to switch between pages.

Contributing

Contributions are welcome! Please fork the repository and create a pull request with your changes.