Skip to content

README.md

Latest commit

 

History

History
196 lines (141 loc) · 5.97 KB

README.md

File metadata and controls

196 lines (141 loc) · 5.97 KB
Raw

📊 Financial Consumer Complaints – Power BI Dashboard

A complete end-to-end data analytics project using Power BI, showcasing KPIs, trends, complaint insights, and a professional dashboard interface.

🗂️ Project Repository Structure

📌 Power BI Dashboard (Image Preview)
➡️ Dashboard Image

📌 YouTube Guidance Thumbnail
➡️ YouTube Guide Image

📌 Dataset Screenshot (.png)
➡️ Dataset Preview

📌 Problem Statement (Image)
➡️ Problem Statement

🖼️ Project Visual Layout (2×2 Preview Matrix)

1️⃣ Power BI Dashboard Preview 2️⃣ Dataset Screenshot
3️⃣ YouTube Guidance Image 4️⃣ Problem Statement

📝 Project Description

This project presents a Financial Consumer Complaints Dashboard built in Power BI, designed to help financial institutions:

  • Track complaint volume & trends
  • Analyze categories, issues & products
  • Monitor resolution performance
  • Understand disputed vs non-disputed cases
  • Identify high-complaint states
  • Improve customer satisfaction with data-driven insights

🎯 Objectives of the Project

  • Provide a consolidated view of all consumer complaints
  • Track KPIs such as Timely Response %, Disputed Rate & Resolved at No Cost
  • Explore complaint categories & product performance
  • Visualize state-wise complaint density
  • Build an easy-to-read, modern Power BI dashboard
  • Help stakeholders take quicker, more efficient decisions

📊 Key KPIs in the Dashboard

  • Total Complaints: 75,074+
  • Timely Response: 98.05%
  • In Progress Cases: 280
  • Disputed Rate: 9.71%
  • Resolved at No Cost: 84.50%

📂 Dataset Summary

Field Description
Company Financial organization name
Complaint ID Unique complaint identifier
Date Received / Submitted Timeline tracking
Issue / Sub-Issue Complaint type
Product / Sub-Product Financial category
State / ZIP Code Complaint location
Timely Response Yes/No
Consumer Disputed Dispute status

Data Includes:

  • Credit card, mortgage, savings, debt collection
  • Location & date-based data
  • Complaint categorization
  • Customer dispute information

⚙️ Project Workflow

1️⃣ Data Cleaning & Preparation

  • Removed duplicate and missing data
  • Standardized complaint categories
  • Cleaned date formats
  • Validated product & issue fields

2️⃣ Data Modeling (Power BI)

  • Built relationship model
  • Created Date dimension
  • Developed DAX Measures:
    • Total Complaints
    • Disputed %
    • Timely Response %
    • In Progress Count

3️⃣ Visualization & Dashboard Layout

  • KPI cards
  • Bar chart (Complaints by Issue)
  • Map visual (State-wise complaints)
  • Tree map (Product-wise complaints)
  • Monthly trend line chart
  • Donut chart (% Disputed)

4️⃣ UX Enhancements

  • Modern purple gradient design
  • Clean layout with consistent spacing
  • Interactive filters:
    • Date
    • Media
    • Product

🔍 Key Insights

🟣 Complaint Type Insights

  • Managing accounts, deposits, and payment issues dominate complaints
  • Identity theft is a rising concern

🔵 Product Insights

  • Credit Card & Checking/Savings account complaints are the highest
  • Mortgage-related complaints show significant volume

🟠 State Insights

  • East-coast states show high complaint concentrations
  • Helps identify regions where service improvements are needed

🟡 Timeline Trends

  • Monthly data highlights seasonal complaint fluctuations

🔴 Dispute Insights

  • Nearly 10% complaints disputed, indicating gaps in resolution quality

🧰 Tools & Skills Used

🛠 Tools

  • Power BI Desktop
  • Power Query
  • DAX
  • CSV/Excel

🧠 Skills

  • Data Cleaning
  • Data Modeling
  • Dashboard Design
  • KPI Analysis
  • Geo-Visualization
  • Trend Analysis

🖼️ Dashboard Preview

➡️ Full Dashboard PNG:
https://github.com/Ashwin18-Offcl/Financial_Complaint_Dashboard/blob/master/Dashboard%20Image.png

📘 Summary

This Power BI project provides a clear, visual, and interactive platform for analyzing financial consumer complaints, enabling organizations to:

  • Track performance
  • Identify bottlenecks
  • Improve complaint-handling processes
  • Make data-driven decisions

It demonstrates strong skills in Power BI, DAX, modeling, and storytelling with data.

🔖 Tags & Keywords

#PowerBI #Dashboard #DataAnalytics #BusinessIntelligence
#ConsumerComplaints #FinancialAnalytics #DataVisualization
#AnalyticsPortfolio #AshwinPanbude

📬 Contact Me

📧 Email: ashwinpanbude1220@gmail.com
🔗 LinkedIn: https://bit.ly/49pSuZJ
🐙 GitHub: Ashwin18-Offcl