Cinema Admission Monitoring Dashboard for Movie Performance and City Demand Analysis

Cinema Analytics · Admission Monitoring · Looker Studio · Dashboard Analytics

Cinema Admission Monitoring Dashboard for Movie Performance and Market Demand Analysis

This project focused on building an interactive cinema admission dashboard to monitor movie performance, compare tracked and estimated ticket sales, evaluate showtime allocation, and identify city-level and cinema-level demand patterns. The dashboard was designed as an analytical tool to support movie performance monitoring, market prioritization, and screening strategy evaluation.

Looker Studio BigQuery Cinema Analytics Admission Tracking Market Demand Analysis
Rhaya Flicks Admission Dashboard Preview

Rhaya Flicks Admission Dashboard preview showing movie comparison, estimated admissions, showtimes, admission trends, and city-level performance.

Project Overview

This dashboard was developed as a visualization and analysis layer for cinema admission data. The main goal was to transform raw admission tracking data into an interactive dashboard that could help users compare movie performance, evaluate screening efficiency, and understand audience demand across cities and cinema locations.

Instead of only displaying total admissions, the dashboard was designed to connect multiple analytical dimensions: tracked ticket sales, estimated ticket sales, showtimes, occupancy rate, city performance, cinema performance, underperforming locations, and demand intensity indicators.

Dashboard Scope

Analysis Focus

Admissions

Main Comparison

Movie Titles

Breakdown

City & Cinema

Decision Support

Demand Analysis

Business Problem

Movie admission performance can be difficult to evaluate when the data is spread across many titles, exhibitors, cities, cinemas, and show periods. A movie may receive a large number of showtimes but generate low admissions, while another movie may have fewer screenings but stronger audience demand in specific locations.

The challenge was to create a dashboard that could go beyond simple admission totals. The dashboard needed to help users understand whether movie performance was driven by strong demand, high showtime allocation, specific city performance, exhibitor contribution, or cinema-level behavior.

Key questions the dashboard needed to answer:

  • Which movie titles generated the highest tracked and estimated admissions?
  • Which movies received the highest number of showtimes?
  • Which movies had stronger occupancy rate compared to their showtime allocation?
  • Which cities and cinemas showed the strongest demand for each movie?
  • Which cities or cinemas were underperforming despite having available showtimes?
  • How did admission performance differ by show period and exhibitor?
  • Which markets should be prioritized for screening strategy or further monitoring?

Dashboard Objectives

  • Compare admission performance across multiple movie titles.
  • Monitor tracked and estimated ticket sales by movie.
  • Evaluate showtime allocation and estimated occupancy rate.
  • Identify top-performing cities and cinemas for each title.
  • Detect underperforming cities and cinemas with low admission output.
  • Evaluate audience demand intensity by city and cinema.
  • Support screening strategy, market prioritization, and movie performance monitoring.

Dashboard Structure

Two Main Dashboard Pages

📊

Comparison Page

A movie comparison dashboard used to compare multiple titles in one view based on admission, estimated admission, showtimes, occupancy rate, trend, and city-level distribution.

🎬

Individual Movie Page

A detailed movie dashboard used to analyze one selected title by show period, exhibitor, city, cinema, underperforming location, and demand intensity.

Dashboard Page Breakdown

The dashboard was simplified into two main analytical pages. The first page focuses on comparing multiple movies at once, while the second page focuses on drilling down into the performance of one selected movie.

Page 01

Movie Comparison Page

Movie Comparison Dashboard Screenshot

Screenshot of the movie comparison page showing admission comparison, estimated admission, showtime allocation, admission trend, and city-level comparison.

The comparison page was designed to help users evaluate multiple movie titles within the same selected date range or monitoring period. This page provides a high-level view of which movies were performing better, which titles received more showtimes, and how admissions were distributed across cities.

From an analytical perspective, this page helps compare movie performance using both demand-side indicators and supply-side indicators. Admission and estimated admission represent audience response, while showtimes represent screening allocation. By placing these metrics together, the dashboard helps identify whether high admissions were supported by high showtime allocation or whether a movie showed strong demand despite limited screenings.

Key analysis provided by this page:

  • Movie ranking: Compares movie titles based on tracked and estimated admissions.
  • Showtime allocation: Shows which movies received more screening slots.
  • Admission trend: Tracks how movie performance changed over time.
  • City comparison: Breaks down movie performance across different cities.
  • Screening efficiency: Helps compare admission performance against showtime allocation.

Page 02

Individual Movie Admission Page

Individual Movie Admission Dashboard Screenshot

Screenshot of the individual movie admission page showing detailed performance by show period, exhibitor, city, cinema, underperforming area, and demand intensity.

The individual movie page was designed for deeper analysis of one selected movie title. This page helps users understand where a movie performed well, which cities and cinemas contributed the most admissions, which locations underperformed, and how audience demand was distributed across show periods and exhibitors.

From an analytical perspective, this page is useful for turning admission data into market-level insights. It does not only show how many tickets were sold, but also helps explain where the demand came from, whether the showtime allocation was efficient, and which cities or cinemas may need further evaluation.

Key analysis provided by this page:

  • Show period analysis: Identifies which show slots generated stronger admissions.
  • Exhibitor contribution: Compares admissions by cinema chain or exhibitor.
  • City performance: Highlights top cities based on tracked and estimated admissions.
  • Cinema performance: Identifies cinemas with stronger or weaker admission output.
  • Underperforming locations: Detects cities and cinemas with low admissions compared to available showtimes or capacity.
  • Demand intensity: Scores cities and cinemas to identify stronger market potential.

Analytical Side of the Project

The analytical value of this project comes from how the dashboard connects different cinema performance indicators into one decision-support view. The dashboard was not designed only to show charts, but to help users interpret movie performance from multiple angles: demand, allocation, efficiency, location, and underperformance.

Admission Comparison

Compares tracked and estimated admissions across multiple movies to identify stronger-performing titles.

Showtime Efficiency

Evaluates whether the number of showtimes is aligned with actual audience response and estimated occupancy rate.

City Demand Analysis

Identifies cities with stronger audience response and cities that may need further market evaluation.

Cinema Performance

Breaks down movie performance by cinema location to detect strong and weak screening points.

Underperformance Detection

Highlights cities and cinemas with low admissions despite available showtimes or capacity.

Demand Intensity Index

Uses scoring logic to identify cities and cinemas with stronger demand potential for each movie.

Key Metrics Used

Metric Purpose
Tracked Ticket Sold Represents actual tracked admission collected from available admission data.
Estimated Ticket Sold Estimates total admissions based on the available tracking and estimation logic.
Showtimes Counts the number of scheduled screenings for a movie.
Estimated Avg. OR Measures estimated average occupancy rate to evaluate screening efficiency.
Admission by Show Period Shows admission distribution across different show slots.
Admission by Exhibitor Compares admission contribution by cinema chain or exhibitor.
City Performance Breaks down admission performance by city.
Cinema Performance Breaks down admission performance by individual cinema location.
Underperforming City / Cinema Identifies locations with low admission compared to available capacity or showtimes.
Demand Intensity Index Scores city or cinema demand potential to support market prioritization.

Analytical Value

The dashboard provides analytical value by helping users move from descriptive monitoring to performance interpretation. It allows users to compare movies, evaluate whether showtimes are being used efficiently, identify stronger markets, and detect locations that may need screening or distribution review.

  • Helped compare movie performance across tracked and estimated admissions.
  • Connected admission results with showtime allocation and estimated occupancy rate.
  • Enabled city-level and cinema-level performance monitoring.
  • Supported screening strategy through show period and exhibitor analysis.
  • Provided visibility into underperforming cities and cinemas.
  • Used demand intensity indicators to identify stronger market potential.
  • Turned admission tracking data into an interactive decision-support dashboard.

Output and Impact

The final dashboard provided a centralized admission monitoring system for evaluating movie performance. It helped convert cinema admission data into a structured reporting tool that can support movie comparison, market analysis, and screening performance evaluation.

  • Created an interactive dashboard for daily movie admission monitoring.
  • Enabled comparison of multiple movie titles in one view.
  • Provided a detailed individual movie dashboard for city and cinema analysis.
  • Supported evaluation of tracked ticket sold, estimated ticket sold, showtimes, and occupancy rate.
  • Helped identify strong and weak markets based on city and cinema performance.
  • Provided a visualization layer for cinema admission analytics and screening strategy support.

Tools and Technologies

Looker Studio Google BigQuery SQL Dashboard Design Cinema Analytics Admission Tracking Data Visualization Market Analysis

Key Learnings

This project strengthened my understanding of how to design a dashboard as an analytical product, not only as a visualization page. The main challenge was making the dashboard useful for both high-level movie comparison and deeper title-specific market analysis.

  • Learned how to structure a dashboard into comparison and detail analysis pages.
  • Designed dashboard views that compare movie titles using consistent admission metrics.
  • Built city-level and cinema-level breakdowns to support market analysis.
  • Used estimated occupancy rate to evaluate showtime efficiency.
  • Created underperforming city and cinema sections to highlight low-performing locations.
  • Designed demand intensity indicators to help identify stronger city and cinema potential.