A Python-based data analysis tool that reads sales data , performs core metrics calculations , and generates an automated visual summary dashboard.
--Data Processing: Parses Excel sales data using 'pandas'. -Automated Metrics: Calculates total revenue, average sales per product , top-performing products, and reveune percentage shares. --Visual Dashboard: Generates side-by-side visualization charts(Bar chart & Pie chart) using 'matplotlib'. -Export Capabilities: Automatically exports high-res charts ('sales_dashboard.png') and updated analytical spreadsheets ('sales_summary_output.xlsx').
-Language: Python -Libraries: Pandas,Matplotlib -IDE: Visual Studio Code
![Sales Dashboard]
(sales_dashboard.png)