Freelance Data Visualizers in Navi MumbaiFreelance Data Visualizers in Navi Mumbai
Data Specialist for Clean, Organized & Smart Reports
New to Contra
Data Specialist for Clean, Organized & Smart Reports
Cover image for πŸ“Š Sales Tracking Dashboard |
πŸ“Š 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
0
2
Data Analytics & Visualization Expert 🎯
Data Analytics & Visualization Expert 🎯
"From Data Chaos to Business Clarity."
"From Data Chaos to Business Clarity."
Next.js Full Stack Developer | Data Analyst
Next.js Full Stack Developer | Data Analyst
Data Analyst | ML Engineer | Fake News Detection | Dashboard
Data Analyst | ML Engineer | Fake News Detection | Dashboard
Data Visualization Expert
Data Visualization Expert