PowerBI Dashboard: Movie Dataset

About the project

This project aims to create an interactive multi-page PowerBI dashboard using the movie data extracted from themoviedb's API endpoint.

Project Goals

    1. Data Collection:

    - The movie data was collected from themoviedb's API endpoint. You can find the documentation for the API here.

    2. Perform feature engineering

    - This step involves creating new columns such as profits, ROI, year and day columns to enrich the dataset.

    3. Create the PowerBI dashboard:

    - Load the dataset into PowerBI and create an interactive multi-page PowerBI dashboard.

About the Dataset

The data extracted from themoviedb consists of the top 500 US-affiliated movies of each year, ranging from 2010 to 2022, and it is collected based on the vote counts from themoviedb.

PowerBI Dashboard Overview:

The dashboard contains 4 pages:

  • Main Page: A comprehensive overview of key metrics and trends.
  • Graphs: Visual representations of data trends, enabling in-depth analysis.
  • Movie Details: Dive into specifics with detailed information about each movie.
  • Key Influencers: Discover the factors influencing key aspects.

    • PowerBI Dashboard Features:

    Features added to make the Dashboard more interactive and user-friendly:

  • Sidebar Navigation: A user-friendly sidebar with buttons for easy page navigation.
  • Bookmarks: Seamlessly toggle between different states, such as showing or hiding the sidebar.
  • Field Parameters: Effortlessly filter visuals based on different fields, such as top movies by budget, popularity, and more.
  • Simple Slicers: Easily filter movies by release date and genres.
  • Drillthrough feature: Added Drillthrough capability for the movie details.
  • Key influencers analysis: Added key influencers tools to analyze factors that have the most impact on a particular outcome.

    • Dashboard showcase:

    • # Main Page:
      • main page

    Dashboard description:

    NumberDescription
    1Genre Filter button
    2Main Page navigation button
    3Graph Page Navigation
    4Movie Details Page Navigation
    5Key Influencers Page Navigation
    6Clear Slicer Settings
    7Year Slicer
    8Cards showing titles with Longest run-time, Highest ROI and Highest Profit
    9Bar Plot (based on selected metric)
    10Movie Information Table

    Download the Dashboard (pbix format)

    Check out my Github Repository for more info:

    View on Github

    ← Back to Projects

    Chat Assistant

    Hi! How can I help you today?