← All Case Studies
GRINTA
Complaints & Returns Intelligence
98.76%
Complaint resolution rate
Business Problem
Complaints and returns were operational records, but the business needed to connect root causes, resolution speed, warehouses, customers, and financial exposure.
What I Built
Created Power BI views for complaint resolution, issue reasons, closure time, warehouse and governorate patterns, returns, customer ratios, and return value.
Scale
12K+ complaints and 27K+ returns, including 21.56M in return amount and 438K returned units.
Outcome
Teams can identify the process or location creating customer friction, prioritize resolution bottlenecks, and quantify the commercial impact of returns.
Technology
Power BIDAXSQL
Project Screenshots
Figures, names, and other identifying details shown in these dashboard screenshots have been randomized for privacy.