Overview

Analysed Udemy's course database to help stakeholders increase quarterly earnings. Built an interactive Excel dashboard using VBA Macros, slicers, and Pivot Tables. Identified Web Development as the top revenue driver and recommended targeted pricing strategies.

Tools Used: Excel · Power Query · VBA & Macros · Pivot Tables · Data Storytelling

Timeline: 3 weeks

Original article: Read on Medium ↗

🌟 STAR Method Breakdown

Situation

Udemy has a database tracking subject performance and revenues across multiple course categories. Despite having this data, making decisions to increase business revenue was challenging because the data was spread across multiple sheets and lacked a consolidated view.

Task

The Udemy dataset was provided across separate subject sheets. The challenge was to append all subject data into a single sheet to identify patterns and trends. The goal: derive actionable insights to increase quarterly earnings.

Key questions from the CEO:

• How can Udemy increase next quarter's earnings?
• Would increasing Web Development prices also increase revenue?

Action

I created an interactive Excel dashboard to show the performance of all courses without clicking through multiple data sheets. Steps included:

1. Joined all subject sheets into one master sheet in Excel
2. Cleaned the data, handled inconsistencies, and formatting issues
3. Power Query added conditional columns and changed data types
4. Pivot Tables created to aggregate data by subject, level, and time