Case Studies: IMDB, Indigo Airlines
Case studies are essential in bridging theoretical concepts with real-world application. In this section, students will work on two practical case studies to understand how Excel’s analytical features can be applied to solve industry-specific challenges—one in the entertainment domain using IMDB data, and the other in the aviation sector using Indigo Airlines data.
IMDB Case Study: Understanding Audience Trends in Film Industry
Students will analyze a dataset containing movie metadata, including attributes like title, genre, release year, budget, box office revenue, and audience ratings. The goal is to identify patterns and insights that can guide content production, marketing strategies, or platform recommendations.
Key focus areas include:
- Filtering and sorting to find top-rated or most profitable films by genre or decade
- Using Pivot Tables to group data by genre or year and calculate average ratings or revenue
- Applying Conditional Formatting to highlight movies with exceptionally high or low ratings
- Scenario analysis to predict the impact of changes in budget on profitability
This exercise helps learners understand how data can support decisions in media production, distribution, and promotion.
Indigo Airlines Case Study: Operational and Customer Analysis
In this case, students will work with sample flight operation and booking data for Indigo Airlines. The data might include routes, flight durations, delays, ticket prices, passenger loads, and cancellation rates. The objective is to improve service delivery and customer satisfaction through better insights.
Key focus areas include:
- Analyzing peak travel times, popular routes, and average delays
- Creating dashboards with Pivot Charts and tables to visualize performance metrics
- Exploring reasons for delays or cancellations using filter logic and IF formulas
- Performing what-if analysis to forecast profits under different load and price conditions