This project analyzes service order failures in a dental care platform by examining failure rates across different doctor types and order categories (Aligner Types). Understanding the reasons behind failed or canceled orders helps guide operational improvements, reduce friction in the order fulfillment process, and enhance customer satisfaction.
The analysis focuses on key failure categories such as delays, missing information, technical issues, and customer cancellations.
🔗 View the full project on GitHub: Project Link Read the Full Summary and Key Insights : Link
Dental Aligner Dataset after cleaning and wrangling+ (pivot tables and analysis).xlsx
dashboard and key insights.xlsx
The dataset contains 199 service orders for dental aligner treatments. Each order includes details about status, doctor type, aligner category, delivery time, and more.
| Column Name | Description |
|---|---|
Order ID |
Unique ID for each order |
Order Date |
Date the order was placed |
Delivery Date |
Date of delivery (actual or expected) |
Status |
Completed, Cancelled, or Incomplete |
Cancel/Fail Reason |
Cause of failure/cancellation |
Country |
Country where the order was placed |
Doctor Type |
General Dentist or Orthodontist |
Aligner Type |
Full Set, Upper, or Lower |