Financial Performance Analytics

Project Overview

Financial Performance Analytics is an end-to-end business analytics project that analyzes financial transactions using Python, SQL, Pandas, and Matplotlib. The project evaluates sales, profit, gross sales, discounts, manufacturing costs, and product performance to generate actionable business insights for decision-makers.

---

Objectives

• Analyze revenue performance
• Evaluate profit trends
• Compare country-wise sales
• Analyze product performance
• Study customer segments
• Measure discount impact
• Evaluate yearly growth
• Generate executive KPIs
• Create business visualizations

---

Dataset

Microsoft Financial Sample Dataset

Main Columns

• Segment
• Country
• Product
• Discount Band
• Units Sold
• Manufacturing Price
• Sale Price
• Gross Sales
• Discounts
• Sales
• COGS
• Profit
• Date
• Month Number
• Month Name
• Year

---

Technologies Used

• Python
• Pandas
• Matplotlib
• SQL
• VS Code
• Git
• GitHub

---

Project Structure

Financial-Performance-Analytics/

│
├── data/
│   └── financial_data.csv
│
├── python/
│   └── financial_analysis.py
│
├── sql/
│   └── analysis.sql
│
├── screenshots/
│   ├── sales_by_country.png
│   ├── profit_by_country.png
│   ├── sales_by_product.png
│   ├── sales_by_segment.png
│   ├── profit_by_segment.png
│   ├── monthly_sales.png
│   ├── discount_band.png
│   ├── gross_sales_distribution.png
│   ├── profit_distribution.png
│   ├── units_sold_distribution.png
│   ├── top_products_profit.png
│   ├── year_sales.png
│   └── year_profit.png
│
├── README.md
│
└── Business_Insights.md

---

Python Analysis

The Python script performs

• Data Cleaning
• Missing Value Analysis
• Sales Analysis
• Profit Analysis
• Product Performance
• Country Analysis
• Segment Analysis
• Discount Analysis
• KPI Reporting
• Business Visualizations

---

SQL Analysis

SQL queries analyze

• Total Sales
• Total Profit
• Total COGS
• Average Sales
• Average Profit
• Product Performance
• Country Performance
• Segment Performance
• Discount Analysis
• Monthly Sales
• Yearly Sales
• Profit Margin

---

Business Questions Answered

• Which country generates the highest revenue?
• Which product earns the highest profit?
• Which customer segment performs best?
• How do discounts affect sales?
• What is the overall profit margin?
• Which year generated the highest revenue?

---

Key Performance Indicators (KPIs)

• Total Sales
• Total Profit
• Total COGS
• Average Sales
• Average Profit
• Profit Margin
• Total Units Sold

---

Visualizations

• Sales by Country
• Profit by Country
• Sales by Product
• Sales by Segment
• Profit by Segment
• Monthly Sales
• Discount Distribution
• Gross Sales Distribution
• Profit Distribution
• Units Sold Distribution
• Top Products by Profit
• Year-wise Sales
• Year-wise Profit

---

Future Improvements

• Power BI Dashboard
• Tableau Dashboard
• Forecasting
• Financial KPI Dashboard
• Machine Learning Revenue Prediction
• Executive Dashboard

---

Skills Demonstrated

• Financial Analytics
• Business Analytics
• SQL
• Python
• Pandas
• Data Cleaning
• Exploratory Data Analysis
• Data Visualization
• KPI Reporting
• Business Intelligence

---

Author

Aswanth K

MBA Business Analytics Portfolio