Post by Shivam .

Name: 📊 From Data to Dashboard – Excel Data Analysis Project After analyzing an Online Retail dataset us
Uploaded: 2026-04-19T07:49:20.978Z
Channel: Shivam .
Description: 📊 From Data to Dashboard – Excel Data Analysis Project After analyzing an Online Retail dataset using SQL, I built an interactive Excel dashboard to visualize key business insights. 🔍 What I built

📊 From Data to Dashboard – Excel Data Analysis Project After analyzing an Online Retail dataset using SQL, I built an interactive Excel dashboard to visualize key business insights. 🔍 What I built: Cleaned and transformed raw data Created Pivot Tables for analysis Designed an interactive dashboard using slicers and charts 📈 Key Insights: 💰 Total Revenue: £10.6M 📦 Total Orders: 24,447 👥 Total Customers: 4,373 🛒 Average Order Value: £435.41 ❌ Cancellation Rate: 15.69% 📊 Dashboard Highlights: 📈 Monthly Revenue & Orders Trends (clear growth towards year-end) 🛍️ Top Products by Revenue and Quantity 📉 Stable AOV with slight decline in later months 🚚 ~95% orders delivered successfully 🧠 What I learned: Importance of structuring data before visualization Handling duplicates and distinct counts in Excel Building clean and readable dashboards 🚀 Next step: Recreating this dashboard in Tableau with more advanced visuals #Excel #DataAnalytics #Dashboard #DataAnalyst #LearningInPublic #Projects

Video Content