Customer Complaints Dashboard

In this Tableau project, I explore and analyze a comprehensive dataset on customer complaints, aiming to gain valuable insights into consumer grievances across various companies and products. The dataset encompasses essential information, including the company name, response provided, complaint ID, dates of receipt and submission, specific issue categories, product types (credit card, mortgage, other services), state of origin, submission channels (web, phone, referral), and zip codes. 

Step 1 : Creating KPIs (Key Performance Indicators)

I have grouped the services(products) into 5 different categories namely Bank Services, Checking/Savings Account, Credit Card, Mortgages and Other Services.

Step 2 : Calculating Total Number of Complaints

Step 3 : Enhancing the KPIs

Step 4 : Creating Bar Plots for Complaints Per Year

 (based on different categories)

Step 5 : Creating Bar Plots for knowing Distribution of Request Types

Step 6 : Plotting Number of Complaints by Year

Step 7 : Creating Maps to know Distribution of Complaints 

Step 8 : Building a Dashboard