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