🎬 FILMAX CINEMAS — Ticket Sales Analysis Dashboard (Excel)

Filmax Cinemas Ticket Sales Analysis Interactive Dashboard — Light Mode

Filmax Cinemas Ticket Sales Analysis Interactive Dashboard — Dark Mode

Project Overview

Developed an interactive Microsoft Excel dashboard to analyze third-quarter ticket sales performance for Filmax Cinemas, a movie theatre chain operating across California, New York, Texas, and Florida.

The dashboard transforms transactional sales data into actionable insights, enabling management to monitor revenue trends, customer demand, movie performance, and operational efficiency.

Business Problem

Filmax Cinemas lacked detailed visibility into ticket sales performance, making it difficult for management to identify high-performing movies, profitable ticket categories, peak showtimes, and top-performing branches. As a result, scheduling, pricing, marketing, and operational decisions were often based on assumptions rather than data

About the Dataset

The analysis was performed using 2,000 ticket sales transactions collected during the third quarter (July–September).

Dataset included:

• Sales ID
• Movie Name
• Show Date
• Month & Weekday
• Showtime
• Ticket Category
• Tickets Sold
• Ticket Price
• Revenue
• Payment Method
• Cinema Branch

Key Metrics

• Total Revenue: $95,765
• Total Orders: 2,000
• Tickets Sold: 6,026

Data Preparation

To ensure accurate analysis, the dataset was cleaned and validated by:

• Removing duplicate records
• Verifying unique Sales IDs
• Checking for missing values
• Standardizing category names and date formats
• Validating data types
• Creating Month and Weekday fields for time-based analysis

Dashboard Features

The dashboard was built using:

• Pivot Tables
• Pivot Charts
• KPI Cards
• Bar Charts
• Doughnut Charts
• Geographic Map
• Interactive Slicers

The dashboard provides analysis across:

• Revenue Trends
• Movie Performance
• Branch Performance
• Ticket Category Performance
• Showtime Analysis
• Weekly Sales Trends

Key Insights

• Generated $95,765 in revenue from 2,000 transactions and 6,026 tickets sold.
• August recorded the highest monthly revenue before sales declined in September.
• Saturday and Sunday generated the strongest sales, indicating clear weekend demand.
• Guardians of the Galaxy Vol. 4 was the highest-grossing movie, while Fast X generated the lowest revenue.
• New York was the highest-performing branch, whereas Texas showed the greatest opportunity for growth.
• Regular tickets accounted for nearly 38% of total revenue.
• Evening screenings generated almost 49% of ticket sales, making them the most profitable showtime.

Business Recommendations

Based on the analysis, the following recommendations were made:

• Schedule blockbuster movies during high-demand evening and weekend showtimes.
• Introduce targeted promotions during slower weekdays and lower-performing months.
• Expand loyalty programs and Family/VIP packages to increase customer retention and average revenue.
• Increase localized marketing efforts in underperforming branches.
• Use historical sales trends to improve movie scheduling, staffing, and concession inventory planning.

Tools & Skills

Tools

• Microsoft Excel
• Pivot Tables
• Pivot Charts
• Dashboard Design
• Data Visualization

Skills Demonstrated

• Data Cleaning
• Data Analysis
• Dashboard Development
• Business Intelligence
• KPI Reporting
• Trend Analysis
• Business Storytelling
• Data-Driven Decision Making

Project Outcome

This dashboard transformed raw ticket sales data into an interactive reporting solution that enables management to monitor business performance, identify growth opportunities, and make informed decisions regarding pricing, scheduling, marketing, and operational planning. The project demonstrates how Excel can be used to deliver actionable business insights that support strategic decision-making.