Executive Power BI dashboards for Novatek Fintech: Fraud detection, Chargeback analysis, and Revenue tracking across Nigeria, Ghana, and Kenya. Built with DAX, Power Query, and risk KPIs.
# Power-BI-Fraud-Analytics-Novatek-Fintech-Company
Executive Power BI dashboards for Novatek Fintech Company operating across Nigeria, Ghana, and Kenya.
Built to monitor fraud, chargebacks, and revenue performance to reduce financial risk and improve decision making.
Created with DAX, Power Query, and executive-level storytelling.
## 📊 Dashboards Included
### 1. **Executive Dashboard**
**Purpose**: C-Suite overview of fraud, revenue, and operational risk
**Key Metrics**: ₦50.28M Total Revenue, 19.94% Fraud Rate, 1994 Total Fraud Cases, 10K Transactions
**Insights**: Travel segment has highest chargebacks at 142 cases but lowest resolution rate @ 27.65%. Immediate focus area for risk team.
### 2. **Fraud Case Dashboard**
**Purpose**: Track fraud investigation and risk distribution across segments
**Key Metrics**: 1994 Total Fraud Cases, 50 Active Investigators, 19.94% Fraud Rate
**Insights**: Fraud concentrated in Travel and Technology. Channel exposure varies - Organic and Email highest risk.
### 3. **Revenue Dashboard**
**Purpose**: Revenue performance across countries, channels, and industries
**Key Metrics**: ₦50.28M Total Revenue, ₦4.11M Avg Monthly Revenue, 10K Transactions
**Insights**: Revenue balanced across Nigeria, Ghana, Kenya. Email and Organic channels drive highest revenue.
### 4. **Chargeback Dashboard**
**Purpose**: Monitor chargeback risk and operational exposure
**Key Metrics**: 495 Total Chargebacks, 4.95% Chargeback Rate, 38.38% Resolution Rate
**Insights**: Ghana leads in chargeback volume. 160 cases pending - operational bottleneck needs addressing.
### 5. **Chargeback Analysis Dashboard**
**Purpose**: Deep dive into chargeback drivers by industry, channel, and merchant
**Key Metrics**: Travel 142 cases, Technology 136 cases, Food 125 cases
**Insights**: Chargebacks concentrated in high-ticket industries. Email and Organic channels have highest exposure.
## 🛠 Tools & Skills Used
- **Power BI**: DAX, Power Query, Data Modeling, Risk …