📝 Why is the Data Collected?
The data is collected from an online learning platform to monitor and optimize key performance indicators like course completion rates, student engagement, revenue by category, and instructor performance.
❗ What is the Problem?
The platform is struggling with:
- Low completion rates
- Uneven revenue distribution among categories
- Instructors with poor engagement metrics
- Lack of data-driven decision-making for content planning and marketing
Get the Dataset Here : https://github.com/slidescope/data/blob/master/online_course_data_200_rows.csv
🎯 How Will the Dashboard Help?
The Power BI dashboard will help:
- Identify top-performing courses and instructors
- Spot trends in user behavior and drop-offs
- Guide content strategy by category performance
- Increase accountability through transparent metrics
- Optimize marketing spend based on revenue-generating courses
🔍 5 Questions to Solve Using Power BI Visuals
| Question | Recommended Visual |
|---|---|
| 1. Which course categories generate the most revenue? | Bar Chart or Treemap |
| 2. What is the average course completion rate by category and instructor? | Clustered Bar Chart |
| 3. How do student registrations trend monthly? | Line Chart or Area Chart |
| 4. What is the average rating and feedback score per instructor? | Scatter Plot or Table |
| 5. Which courses have the highest dropout rates? | Stacked Bar Chart or Funnel |
📂 Sample CSV File
Below is a sample CSV content. You can copy it into a file and name it online_course_data.csv:
CourseID,CourseName,Category,Instructor,StudentsEnrolled,StudentsCompleted,Revenue,Rating,FeedbackScore,Month
101,Excel for Beginners,Business,John Doe,150,100,3000,4.2,80,2025-01
102,Advanced Excel,Business,John Doe,120,85,4200,4.5,85,2025-02
103,Python for Data Science,Technology,Jane Smith,200,160,9000,4.8,92,2025-01
104,Machine Learning Basics,Technology,Jane Smith,180,140,11000,4.7,89,2025-02
105,Digital Marketing,Marketing,Alan Wu,100,60,3500,4.1,75,2025-01
106,SEO Fundamentals,Marketing,Alan Wu,90,50,2700,4.0,73,2025-02
107,Creative Writing,Arts,Susan Lee,70,60,2100,4.6,88,2025-01
108,Photography Masterclass,Arts,Susan Lee,80,70,2400,4.7,90,2025-02
✅ Next Steps
- Load
online_course_data.csvinto Power BI. - Use Power Query Editor to clean and transform data.
- Create visuals for each of the 5 questions above.
- Use slicers for filters by Month, Instructor, and Category.