📊 Sales Tracking Dashboard | Excel + Power BI Project Built an end-to-end interactive Sales Trac...📊 Sales Tracking Dashboard | Excel + Power BI Project Built an end-to-end interactive Sales Trac...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Manigandan's avatar
Manigandan Acharya
• Apr 3
📊 Sales Tracking Dashboard | Excel + Power BI Project
Built an end-to-end interactive Sales Tracking Dashboard covering 2021–2024 across the entire US market.
Top-Line Numbers: 💰 Total Sales: $19,28,888 📈 Total Profit: $2,47,962 👥 Total Customers: 8,314 across all years
What the dashboard reveals:
🏆 Best-selling sub-categories: Phones ($2,79,464) and Chairs ($2,77,058) lead the pack — together accounting for nearly 29% of all sales
📅 Profit growth year-on-year: → 2021: $49,556 → 2022: $61,618 → 2023: $81,786 — consistent upward trajectory across Furniture, Office Supplies & Technology
🗺️ Geographic concentration: California dominates at $3,90,145 in sales. New York ($2,46,517) and Texas ($1,51,436) follow. West Virginia sits at the bottom with just $536 — a clear signal for regional strategy review.
📦 Technology drives profit — highest-margin category across all 4 years, despite Furniture holding significant volume
🧾 Seasonal trends: Q4 is king — November ($2,34,013) and December ($2,41,464) are the strongest months. February dips to just $59,640 — opportunity for targeted campaigns.
👤 Top customer by profit: Tamara Chand at $8,981, followed by Raymond Buch ($6,939) and Sanjit Chand ($5,757)
Tools used: Microsoft Excel · Pivot Tables · Power Query · Charts & Slicers · Dashboard Design
This project sharpened my ability to turn raw transactional data into a clean, decision-ready visual — with filters for state, date, year, sub-category, and month.
Open to feedback! 👇
#Excel #DataAnalytics #SalesDashboard #DataVisualization #BusinessIntelligence #MicrosoftExcel #DashboardDesign
Completed work
Data AnalysisMicrosoft ExcelData Visualization
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started