Course Participation, Engagement & Completion Dashboard

Overview

This project simulates the role of a Business Analyst at Dataquest, focusing on preparing and analyzing student engagement data from an online learning platform. The objective was to clean, model, and visualize the dataset to uncover insights into course participation, user satisfaction, and completion performance.

The final deliverable is an interactive Tableau dashboard that combines key performance indicators (KPIs) with a dual-axis visualization to support data-driven decision-making.

Link (https://public.tableau.com/app/profile/steven.tapscott/viz/Course-Engagement/Project1Dashboard?publish=yes)

---

Tools & Technologies

• Tableau Desktop
• Excel (data source)
• Tableau Relationships (data modeling)
• Calculated Fields
• Dual-Axis Charts
• Interactive Dashboard Design

---

Dataset Description

The dataset includes:

• User-level NPS (Net Promoter Score) responses
• Course identifiers (Mission)
• Engagement categories (Promoter, Passive, Detractor)
• Screen-level completion data (Completed, Students)

Data was structured across multiple tables and required proper relationship modeling to avoid aggregation issues.

---

Data Preparation & Modeling

Key Steps:

• Connected multiple tables in Tableau using relationships (not joins)
• Identified and handled granularity differences (user-level vs screen-level data)
• Filtered out null Mission values to ensure data integrity
• Standardized data types (dates, numeric fields)

Data Model:

• Central fact table: NPS (user-level data)
• Related table: Screen Completion (course-level metrics)
• Linked via: Mission (course ID)

---

Calculated Fields

The following calculated fields were created:

• Engagement Category

  • Categorizes users into Promoter, Passive, Detractor

• NPS Score

  • Measures overall user satisfaction per course

• Completion Rate

  • Completed / Students
  • Represents the percentage of students completing course content

---

Dashboard Features

1. KPI Section

• Total Students (COUNTD User Id)
• Average NPS Score
• Average Completion Rate (%)

2. Dual-Axis Chart

• Bar chart: User participation per course (stacked by engagement category)
• Overlay: Completion rate (%) per course

3. Interactivity

• Filters for:

  • Course (Mission)
  • Engagement Category

• Tooltips displaying multiple metrics

---

Key Insights

• High-performing course: Mission 312 shows the highest student participation along with strong completion rates and a high proportion of promoters.

• Engagement trends: Most high-participation courses have a dominant promoter base, indicating positive user experience.

• Completion rates: The majority of courses exceed 80% completion, though a few fall below this threshold, suggesting potential improvement areas.

• Low adoption courses: Several courses have significantly lower participation, indicating opportunities for increased visibility or redesign.

---

Business Value

This dashboard enables stakeholders to:

• Identify top-performing courses
• Detect courses with low engagement or completion
• Prioritize improvements based on user sentiment
• Monitor overall platform performance

---

Skills Demonstrated

• Data cleaning and preparation in Tableau
• Understanding and handling data granularity
• Data modeling using relationships
• Creating calculated fields for business metrics
• Designing dual-axis visualizations
• Building interactive dashboards

---

Conclusion

This project demonstrates the end-to-end workflow of transforming raw data into actionable insights using Tableau. It highlights the importance of proper data modeling, calculated metrics, and effective visualization in supporting business intelligence.

---