Course Content
🎁 Bonus Modules (Integrated Throughout)
Data Analytics
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
0% Complete
WhatsApp Icon

Hi Instagram Fam!
Get a FREE Cheat Sheet on System Design.

Hi LinkedIn Fam!
Get a FREE Cheat Sheet on System Design

Loved Our YouTube Videos? Get a FREE Cheat Sheet on System Design.