topic Re: Consumer Financial Complaints Dashboard in Data Stories Gallery

Consumer Financial Complaints Dashboard

Aleksei_Pr — Thu, 06 Nov 2025 17:28:18 GMT

I’d like to share my latest Power BI project built for the Consumer Financial Complaints Analytics Challenge.

The goal was to analyze over consumer complaints submitted to the CFPB and uncover patterns behind complaint volumes, geography, products, and company performance. The dashboard consists of five interactive pages:

Overview – key KPIs, complaint trends, and category breakdowns.
Geography – complaint distribution across states and metro areas.
Products – deep dive into complaint types and sub-products.
Companies – company-level performance, enforcement share, and benchmarking.
Factor Analysis – uncovering drivers behind complaint volume using ML.

What makes this project special is the integration of R models running directly in Power Query:

ARIMA for time-series forecasting of complaint counts,
Linear regression for factor analysis.

The combination of statistical modeling and interactive BI provides both explainability and actionable insight, bridging the gap between data science and business intelligence.

The process is described in detail on my Blog and on LinkedIn.

Would love to hear your thoughts, feedback, or ideas on how this approach could be improved or extended!

eyJrIjoiYzgwMmRmZTEtZWJiZi00NGIwLWE3YTUtNjJiMDFjZTg2NTU2IiwidCI6ImZmYzg3OTVlLTAxODUtNDg5Yi05ZGE2LTQ5MDI0MTJmMDNhMCIsImMiOjl9&pageName=70faebe9d3ce003a7e21

Re: Consumer Financial Complaints Dashboard

Nabha-Ahmed — Tue, 11 Nov 2025 06:10:19 GMT

I really like the colors and how the key metrics are highlighted, well done

Re: Consumer Financial Complaints Dashboard

Aleksei_Pr — Tue, 11 Nov 2025 07:29:03 GMT

I'm glad that you like it

Re: Consumer Financial Complaints Dashboard

Nabha-Ahmed — Tue, 11 Nov 2025 07:33:10 GMT

Keep going

Re: Consumer Financial Complaints Dashboard

dataflip — Wed, 19 Nov 2025 17:35:10 GMT

Good work.

Re: Consumer Financial Complaints Dashboard

Aleksei_Pr — Thu, 20 Nov 2025 18:35:19 GMT

Thank you!

Re: Consumer Financial Complaints Dashboard

MohamadJavith — Thu, 05 Feb 2026 17:12:24 GMT

Nice Dashboard

Re: Consumer Financial Complaints Dashboard

Aleksei_Pr — Mon, 09 Mar 2026 14:12:56 GMT

Thanks

Re: Consumer Financial Complaints Dashboard

Aleksei_Pr — Mon, 09 Mar 2026 15:44:55 GMT

Here's another one of my dashboards, integrating statistical modeling, forecasting, and simulations:

Credit Risk Simulation Dashboard (Power BI + R) - Microsoft Fabric Community

Re: Consumer Financial Complaints Dashboard

Aleksei_Pr — Thu, 26 Mar 2026 17:29:04 GMT

Here's the another one:

E‑Commerce Dashboard (Power BI and R)

Like, share, subscribe!