Portfolio · Power BI Project
A live fraud monitoring dashboard connected directly to MySQL — three pages of KPI cards, charts and conditional formatting built with DAX measures.
← Back to HomePower BI · MySQL · DAX · Conditional Formatting
A three-page interactive Power BI dashboard connected live to a MySQL fraud detection database. The dashboard monitors transaction risk, flags suspicious activity, and tracks customer risk profiles using 6 DAX measures, conditional formatting rules, and 4 SQL views as data sources.
KES 2.60M of KES 7.24M total portfolio flagged as at-risk — a 35.9% exposure rate. 2 transactions exceed the KES 1M threshold. Account 1002 flagged for rapid transfers. Mombasa leads city hotspots at KES 2.02M.
DAX Measures Used
| Measure | Purpose |
|---|---|
| Total Transactions | Count of all transactions |
| Total Value | Sum of all transaction amounts |
| High Value Transactions | Count above KES 1M |
| Value at Risk | Total KES value flagged |
| High Risk Customers | Customers with score < 600 |
| Flagged Rate % | % of transactions flagged |
Dashboard Pages
Page 01
4 KPI cards, transaction value by city bar chart, type breakdown donut, city slicer.
Page 02
High-value transactions table, rapid transfer activity, high-risk customers, geographic hotspots.
Page 03
Risk score distribution chart, high risk KPI card, customer risk register with conditional formatting.