๐ Branch Sales Analysis This project performs advanced analysis of sales data across different company branches. It includes data cleaning, calculation of revenue and profit metrics, and visual comparison between branches.
๐ Project Contents sales_branches.csv โ Sample dataset containing product sales across branches.
revenue_branche.png โ Bar chart comparing revenue and profit per branch.
LICENSE โ MIT open-source license.
analysis.ipynb (optional) โ Jupyter Notebook with full code and analysis steps (available upon request).
โ Key Features Handles missing values per product group.
Computes:
Revenue = Unit Price ร Quantity
Cost = Cost per Unit ร Quantity
Profit = Revenue โ Cost
Margin (%) = (Profit รท Revenue) ร 100
Identifies the branch with the highest total revenue.
Visualizes branch performance using bar charts.
Aggregates average daily revenue and profit.
๐ Output Example
๐ ๏ธ Tools & Libraries
Python
pandas
NumPy
Matplotlib
๐ License This project is licensed under the MIT License โ see the LICENSE file for details.