UPI Transactions Data Analysis Dashboard

Description

This project provides an interactive Power BI dashboard for analyzing UPI (Unified Payments Interface) transaction data. It aims to deliver insights into transaction patterns, user behavior, and financial trends through a variety of visualizations and interactive elements. The dashboard is designed to be highly flexible, allowing users to drill down into specific transaction details and explore various dimensions of the data.

Features

• Extensive Slicers:
  • Bank Name Sent: Filter transactions by the sending bank.
  • Bank Name Received: Filter transactions by the receiving bank.
  • City: Analyze transactions by city.
  • Device Type: Segment transactions by device (e.g., mobile, web).
  • Gender: Filter transactions by user gender.
  • Age Group: Segment transactions by user age group.
  • Merchant Name: Analyze transactions by merchant.
  • Payment Method: Filter transactions by payment method (e.g., UPI, wallet).
  • Purpose: Analyze transactions by their stated purpose.
  • Transaction Type: Filter transactions by type (e.g., credit, debit).
• Bookmark-Driven Charts (Page 1):
  • Transaction Amount by Month (Line Chart): Visualize monthly trends in transaction amounts.
  • Transaction Amount by Month (Column Chart): Alternative visualization of monthly transaction amount trends.
  • Balance by Month (Line Chart): Visualize monthly trends in user balance.
  • Balance by Month (Column Chart): Alternative visualization of monthly balance trends.
• Detailed Matrix Visual (Page 2):
  • Rows: Transaction Date
  • Columns: City, Currency
  • Values: Transaction Amount, Remaining Balance
• Clear Text Boxes: Providing relevant context and explanations throughout the dashboard.

Data Source

The data utilized in this project is an anonymized dataset comprising:

• UPI transaction details (date, amount, type, purpose).
• User demographic information (age, gender, city).
• Device and payment method details.
• Bank information.

Tools Used

• Power BI Desktop: For data modeling, visualization, and dashboard creation.

Key Insights

• Slicers: Enabled highly granular filtering, allowing for detailed analysis of specific transaction subsets.
• Bookmark-Driven Charts: Allowed for dynamic switching between different visualizations of monthly transaction and balance trends.
• Matrix Visual: Provided a comprehensive view of transaction amounts and remaining balances, broken down by date, city, and currency.
• Identified trends in transaction amounts and balance changes over time.
• Analyzed transaction patterns across different demographic groups and cities.
• Visualized transaction amounts and balances by month.
• Showed the distribution of transactions across various payment methods and devices.

Screenshots

• Dashboard Overview: Transaction Amount by Month (Line Chart)

• Dashboard Overview: Transaction Amount by Month (Column Chart)

• Dashboard Overview: Balance by Month (Line Chart)

• Dashboard Overview: Balance by Month (Column Chart)

• Matrix Visual