Skip to content

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.

License

Notifications You must be signed in to change notification settings

R01noq/Branch-Sales-Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

2 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“Š 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.

About

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.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages