Project Overview

This project builds an end-to-end business intelligence dashboard for a fictional digital wallet platform.The goal is to analyze customer behavior, segment users by revenue contribution, and detect fraud patterns across 10 countries and 8 merchant categories.

The project covers:

• Data storage and transformation in SQL Server
• Interactive dashboard built in Power BI Desktop

Dataset Size

• 7,500 Users
• 75,000 Transactions
• 10 Countries
• 8 Merchant Categories
• 500 Unique Merchants

Key Results

• $59.72M Total Revenue identified
• $54.35M Net Revenue (after refunds)
• 2% Fraud Rate detected
• Platinum users generate highest revenue per user
• Mobile + Wallet = highest fraud vector

Process — Step by Step:

Step 1 — SQL Server Database Setup

Created database UserSegmentationDB with two core tables and a foreign key relationship: