Financial Data Analysis & Profit Prediction using Regression

This project focuses on analyzing financial data to uncover business insights and predict profit using regression techniques. It combines data analysis, statistical modeling, and data visualization to support data-driven decision-making.

📊 Objectives

• Perform exploratory data analysis (EDA) on financial data
• Analyze relationships between sales, cost (COGS), and profit
• Build a regression model to predict profit
• Visualize KPIs using interactive dashboards

🛠️ Tech Stack

• Python (Pandas, NumPy, Scikit-learn)
• Power BI
• SQL (optional)

📈 Key Features

• EDA on sales, profit, and cost across countries and segments
• Linear regression model for profit prediction
• Business insights on performance trends
• Interactive dashboard for KPI monitoring

📉 Model

Profit Prediction Formula: Profit = -543.10 + 0.15 × Sales

📊 Dashboard Insights

• Sales by segment (Government, Small Business, Enterprise, etc.)
• Profit by product and country
• Monthly sales and profit trends
• Impact of discount bands on sales

📁 Project Structure

• data/ → dataset files
• notebooks/ → EDA and regression analysis
• dashboard/ → Power BI screenshots
• README.md

🚀 Results

• Identified key drivers of profit and sales
• Built predictive model for business forecasting
• Delivered actionable insights for decision-making

📌 Status

✅ Completed