Skip to content

anushreebiswas/Credit-Cards-Complaints-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 

Repository files navigation

Credit-Card-Complaints-Dashboard

Tableau Public Dashboard Project

Domain
Tech
Project Type

Overview

Credit Card Complaints Dashboard is an interactive Tableau project built using a synthetic dataset representing consumer credit card complaints across the United States. The goal of this dashboard is to explore trends in complaint volume, response timeliness, issue categories, and submission channels, providing insights into consumer dissatisfaction patterns over time.

The dataset captures multiple attributes such as complaint issues, state-wise distribution, method of submission, and company response types, enabling a multi-dimensional understanding of financial service performance and consumer experience.


Technologies & Tools Used

  • Tableau – For dashboard development and analytics
  • Maps & Heatmaps – For geospatial and temporal visualizations
  • Interactive Filters – For slicing by state, company, year, and submission method
  • Calculated Fields – Used for closed/in-progress complaint rates and response breakdowns

Project Goals

  • Analyze the total volume of complaints and rolling 12-month trends
  • Measure how timely companies respond to customer issues
  • Identify the most frequently reported problems like billing disputes and fraud
  • Visualize complaint distribution across U.S. states
  • Understand consumer behavior in terms of how complaints are submitted (web, phone, referral, etc.)
  • Display daily complaint patterns with calendar heatmaps

Dashboard Sections

  1. KPIs

    • Total Complaints
    • Timely Response %
    • Complaints Still In Progress
  2. Trend Analysis

    • Monthly/Weekly/Quarterly/Yearly filters for tracking complaint patterns over time
  3. Geographic Insights

    • U.S. State map showing relative complaint volume
  4. Submission Channels

    • Breakdown by Web, Phone, Referral, Mail, Fax, and Email
  5. Top Complaint Issues

    • Ranking of the most common complaint topics (e.g., Billing Disputes, Identity Theft)
  6. Company Response Types

    • Distribution of responses: closed with explanation, monetary relief, or no action
  7. Daily Complaint Heatmap

    • Calendar view of complaints by day of week and month

Business Impact

  1. Consumer Protection Monitoring – Helps regulatory bodies assess how institutions handle credit card complaints.

  2. Performance Insights – Assists financial service providers in identifying gaps in their support workflows.

  3. Customer Behavior Understanding – Reveals user-preferred complaint submission methods and recurring issues.

  4. Complaint Reduction Strategy – Enables teams to focus on high-frequency issues and reduce resolution time.


View the Dashboard

🔗 Click to View on Tableau Public