Coffee Shop Data Analytics
Boosting Sales for A Local Cafe - L'espoir Coffee & Tea
Coffee Shop Data Analytics
Boosting Sales for A Local Cafe - L'espoir Coffee & Tea
Introduction
In collaboration with L'espoir Coffee & Tea, my team of 2 have worked on a project to enhance the business's performance during Q4 2023. Prior to our involvement, the cafe was facing significant challenges. Their financial performance was subpar, with consistent losses over an extended period. Operating in a traditional manner, they relied heavily on intuition and experience. As our team stepped in, we aimed to devise a more robust solution, guiding the cafe towards a data-driven approach that fostered long-term success.
Responsibilities
Partnering with Pham, the Marketing Planner, I have been in the role of a Finance Supervisor, catering key tasks as the following:
Monitor project progress and foster efficient teamwork
Discuss project goals, create a transparent timeline, and delegate tasks thoughtfullyÂ
Schedule regular meetings to review progress, celebrate wins, and address challenges
Streamline data management and reporting
Develop comprehensive relational databases to store and manage critical business data
Develop real-time dashboards to support stakeholders in monitoring business progress
Develop a semi-automated data pipeline to facilitate database and dashboard updates
Manage business financial health and contribute to strategic planning
Oversee daily cash flows and performance metrics, detect early warning signs, and maintain of high quality service standards
Perform in-depth analysis across multiple data sets, extracting actionable insights that empower business decision-making process
Cooperate with team to develop and implement strategic plans across operating, pricing, and marketing
Perform cost-benefit analysis for marketing campaigns, approve launches, and allocate optimal budgets
Deliver bi-weekly updates to stakeholders, pinpointing progress milestones, achievements, and any blockers hindering momentum
Deliverables
Fully functional databases and dashboards that monitor sales, expense, item, and customer metrics
A semi-automated data pipeline that facilitates daily updates of databases and dashboards
+50 resolved business decision-supporting queries that fueled a 25% revenue boost and a 25% sale volume increase
To explore further details, please click on PROJECT 101.
For confidentiality reasons, certain materials cannot be publicly disclosed.
Tools: Python, Looker Studio, Google Sheets