Consumer Financial Complaints Analytics Dashboard

An interactive Power BI dashboard analyzing 1M+ consumer financial complaints to uncover trends, high-risk products, company performance, and response timeliness.

Overview

This project explores nationwide consumer complaints submitted to the Consumer Financial Protection Bureau (CFPB). The dashboard helps identify which financial products, companies, and regions experience the highest issues and evaluates how effectively companies resolve complaints. It provides regulators and financial institutions with transparent, data-driven insights into consumer protection.

Problem Statement

Financial institutions receive thousands of complaints each month, but stakeholders lack a clear understanding of:

• which products cause the most customer frustration,

• where complaints are rising,

• how quickly companies respond, and

• which issues impact consumers the most.

The goal was to analyze these patterns, benchmark company performance, and assist decision-makers in improving fairness and accountability in the financial ecosystem.

Dataset

• Source: Consumer Financial Protection Bureau (CFPB) Open Data

• Records: ~1M+ complaint entries

• Fields:

  • Date received / Date sent to company

  • Product & Sub-product

  • Issue & Sub-issue

  • Company & State

  • Consumer dispute flag

  • Timely response flag

  • Submission channel

Tools and Technologies

• Power BI – Visualization, Data Modeling, DAX

• Power Query – Data cleaning, transformations

• Excel – Initial exploration

• DAX Measures – KPIs, time intelligence

• Data Storytelling – Insight design and navigation

Methods

1. Data Cleaning & Preparation

• Removed duplicates and nulls

• Standardized product/issue labels

• Extracted date hierarchies

• Created a custom Date Table

2. Data Modeling

• Built star-schema relationships

• Created DAX measures for:

  • Complaint Count

  • Monthly Growth %

  • Timely Response %

  • Dispute Rate

  • Company Ranking

3. Analysis

• Time-series and seasonal trends

• Geo-analysis by state

• Company performance benchmarking

• Product–issue deep dive

4. Dashboard Design

• KPI cards for overall metrics

• Drill-through pages for detailed investigation

• Filters and bookmarks for report navigation

Key Insights

• Mortgage, credit reporting, and credit card products reported the highest complaints.

• Certain states consistently appeared as hotspots, showing persistent service issues.

• Some companies maintained 80%+ timely responses, while others lagged significantly.

• Issues such as incorrect information and billing disputes were the most common pain points.

• Complaints spiked in specific months, showing seasonal and regulatory-driven patterns.

• Online submissions resulted in faster company responses than other channels.

Dashboard / Model / Output

• Main KPI Page

  

• Product & Issue Breakdown

  

• State-wise Heatmap

  

• Company Performance Matrix

  

• Time Trend Charts

  

Results & Conclusion

This project provides a clear, actionable view of consumer complaints across the financial industry.
Regulators can use it to monitor risky areas, companies can benchmark their service performance, and users can understand common issues impacting consumers. The dashboard highlights patterns that can guide policy improvements, enhance customer response systems, and ultimately contribute to better financial fairness.