🌟 Excited to share my recent experience from my internship at OESON, where I explored data analysis using advanced Excel techniques! 🌟
During this internship, I worked on a comprehensive project analyzing an e-commerce database. My tasks included formatting data, creating insightful tables, performing statistical analyses, and developing a detailed sales dashboard.
Key Insights & Conclusions:
Regional Focus: Strategies need improvement for the least profitable regions, such as Canada, the Caribbean, and Central Asia.
Seasonal Strategies: Implement discounts or combined offers during less profitable months (February, September, and November) to boost sales.
Dominant Category: Fashion is the top-performing product category, contributing significantly to both sales and profits.
Product Intervention: Adjust pricing or reduce costs for the least profitable products, including keyboards, watches, and mixers/juicers.
This project has been an incredible learning experience, allowing me to apply and enhance my data analysis skills with Excel. I’m grateful for the mentorship and support from Aritri Debnath (Ghosh) at OESON and Tanishq Chohan (Founder & CEO | OESON).
Eager to apply these insights to real-world scenarios and continue my journey in data analytics!
#OESON #OGTIP #DataAnalytics #Excel
Business Analyst |Data Analytics |Scrum Master | Storytelling | SAP S4 Hana SD & MM
9moGood Job Uzo