Freelancers using Microsoft Power BI in BhiwandiFreelancers using Microsoft Power BI in Bhiwandi
I build AI-powered data apps and dashboards
6
Followers
I build AI-powered data apps and dashboards
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
14
"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
An Excel Expert - Specializing in Data Analysis
An Excel Expert - Specializing in Data Analysis
Data Analytics & Visualization Expert ๐ŸŽฏ
Data Analytics & Visualization Expert ๐ŸŽฏ
Executive Business Partner specializing in Executive support
New to Contra
Executive Business Partner specializing in Executive support