Reduce an internet provider's customer complaints

Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.

  • 90 minutes
  • 1.5 CPD/CPE Credits
Start Project

Project Steps

1. Turbo5G's customer complaints dilemma
2. Connect to multiple datasets
3. Create unpivoted datasets
4. Filter out unimportant data
5. Create a star schema data structure
6. Identify issue categories by urgency
7. Analyze complaint trends over time
8. Create revised customer service dashboard