💰 Smart Expense & Financial Behavior Analyzer

A SQL-based data analytics project that analyzes user spending behavior, detects budget overruns, and generates financial insights using Oracle SQL.

---

📌 Project Overview

This project simulates a real-world expense tracking system where users' spending is analyzed across different categories and compared against predefined budgets.

The goal is not just data storage, but financial behavior analysis using SQL queries.

---

🎯 Key Objectives

• Track user expenses across categories
• Compare actual spending with budgets
• Identify overspending patterns
• Generate financial insights using SQL
• Practice real-world data analysis logic

---

🛠️ Tech Stack

• Oracle SQL
• SQL (Joins, Aggregations, Subqueries, CASE statements)
• Database Design Concepts

---

🗂️ Database Schema

The project contains the following tables:

• users → stores user details
• categories → expense categories (Food, Travel, etc.)
• expenses → transaction records
• budgets → monthly budget limits per category

---

📊 Key Features / Queries

1. Total Spending per User

Calculates how much each user has spent overall.

2. Category-wise Spending

Breaks down expenses by category.

3. Budget vs Actual Analysis

Compares spending against budget limits.

4. Overspending Detection

Identifies users exceeding their budget.

5. Ranking Users by Spending

Finds top spenders using SQL ranking logic.

---

📈 Sample Insights

• Some users consistently exceed budget in Travel & Shopping
• Food category shows moderate but frequent spending
• Rent remains stable and predictable
• Overspending patterns help identify financial behavior trends

---

🚀 How to Use

1. Run schema.sql to create tables
2. Run sample_data.sql to insert sample data
3. Run analytics_queries.sql to generate insights

---

📚 What I Learned

• Database design fundamentals
• Writing complex SQL queries
• Using JOINs for relational analysis
• Aggregation and grouping logic
• Real-world financial data modeling

---

👨‍💻 Author

Akash
Student | Developer

---

⭐ Future Improvements

• Add Power BI dashboard for visualization
• Automate monthly expense reports
• Add alerts for budget exceedance
• Convert into full-stack web app