Post by Precious Akinluyi

Data Analyst | SQL β€’ Power BI β€’ Excel | Sales & Business Data Analysis | Dashboarding β€’ Reporting β€’ Insights

πŸš€ Day 7 β€” From Data to Decisions πŸ“Š What if your everyday food choices could help a business grow smarter? πŸ€”πŸ½οΈ As part of my capstone project at @TechCrush, my team and I analyzed a Nigerian restaurant dataset, transforming raw data into meaningful insights that can drive better business decisions πŸ“Šβœ¨ πŸ” Key Insights βœ… Popular meals like Egusi, Jollof, and Ofada Rice drive the majority of revenue βœ… Over 64% of customers customize their orders β€” showing how important personalization is βœ… Sales peak during weekends and late nights βœ… High demand doesn’t always equal high profit ⚠️ Key Challenges Heavy reliance on a few top-performing items Some high-selling meals have low or inconsistent profit margins Underperformance of high-margin categories like desserts and beverages Operational inefficiencies due to longer preparation times πŸ’‘ Recommendations πŸ‘‰ Introduce bundles and upselling strategies using add-ons πŸ‘‰ Optimize pricing to improve profitability πŸ‘‰ Promote underperforming categories through combos πŸ‘‰ Focus marketing efforts on peak sales periods πŸ‘‰ Improve operational efficiency for faster service πŸ‘©πŸ½β€πŸ’» My Contribution I contributed by: Analyzing sales trends and customer behavior Working with my team to build insight-driven dashboards Translating data into actionable business recommendations Working on this project strengthened my ability to collaborate, analyze data, and tell compelling data stories πŸ“ˆ Huge thanks to my amazing teammates for the collaboration and effort β€” we really brought this project to life together πŸ™Œβœ¨ πŸ“Š Swipe to see our dashboard and insights

Post contentPost contentPost content