PhonePe Transaction Insights

An end-to-end data analysis and visualization project that explores digital payment trends in India using data from the PhonePe Pulse GitHub repository. This includes data extraction, transformation, SQL integration, and interactive dashboards using Streamlit and Power BI.

Project Objectives

The PhonePe Transaction Analysis project focuses on understanding digital payment behaviors across India by:

• Extracting structured data from PhonePe Pulse JSON files
• Creating SQL-compatible datasets for efficient querying and analysis
• Building interactive dashboards to provide real-time and historical insights
• Delivering insights on:
• Transaction volumes and values
• User adoption and activity levels
• Geographical trends across states and districts
• Payment categories like recharge, bills, merchant payments, etc.

Tech Stack

• Python – Data extraction and processing
• Pandas/JSON – Data transformation
• SQL (MySQL) – Database handling
• Streamlit – Web app for visualization
• Power BI – Business intelligence dashboards
• Git & GitHub – Version control

Project Structure

• Data Extraction
• Datasets
• Database
• Streamlit
• PowerBI

How to Run

Prerequisites

• Python 3.8+
• MySQL or PostgreSQL
• Streamlit
• Power BI Desktop (optional for .pbix files)

Clone the Repo

git clone https://github.com/yourusername/phonepe-transaction-insights.git
cd phonepe-transaction-insights