📊 Financial Analytics Dashboard (SQL + Excel)

🚀 Project Overview

This project focuses on extracting, aggregating, and analysing financial data to uncover trends in revenue, expenses, and profitability.

🛠️ Tools Used

• MySQL (Data Extraction & Aggregation)
• Excel (Dashboard & Visualisation)

📌 Key Features

• Total revenue, expense, and profit analysis
• Monthly revenue vs expense trend
• Profit trend analysis
• Category-wise profit margin
• Budget vs actual comparison

📈 Key Insights

• Revenue remained stable with a slight increase toward year-end
• Profit dipped mid-year due to higher expenses
• Student Services showed highest profitability (~92%)
• Budget analysis revealed overspending in multiple months

📂 Project Structure

• dashboard.xlsx → Final dashboard
• data/ → Raw datasets
• sql/ → SQL queries used

💡 Skills Demonstrated

• SQL aggregation and joins
• Data cleaning and transformation
• Business analysis
• Dashboard design in Excel