π 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.