What you will do (learn from scratch)Collect and clean data from POS, online orders, deliveries, CRM, reservations and reviews.Form daily/weekly reports on sales, average check, peak hours and popular items.Create simple dashboards in Power BI / Google Datadash Studio / Excel for management: sales, inventory, ingredient costs, staff productivity.Analyze profitability of dishes, seasonal trends and demand for menu optimization.Help forecast the need for ingredients, minimize write-offs and contro
What you will do (learn from scratch)
- Collect and clean data from POS, online orders, deliveries, CRM, reservations and reviews.
- Form daily/weekly reports on sales, average check, peak hours and popular items.
- Create simple dashboards in Power BI / Google Datadash Studio / Excel for management: sales, inventory, ingredient costs, staff productivity.
- Analyze profitability of dishes, seasonal trends and demand for menu optimization.
- Help forecast the need for ingredients, minimize write-offs and control inventory.
- Support marketing and hall managers: analyze the effectiveness of promotions, delivery channels and loyalty programs.
- Do customer segmentation, analyze reviews and feedback NPS, look for points to improve the service.
- Automate routine reports through Excel/Google Sheets and basic SQL queries.
What we will teach
- SQL basics, building queries and working with databases.
- Building dashboards in Power BI / Google Data Studio.
- Methods of forecasting demand, analysis of product balances and menu calculation.
- Principles of A/B?testing promotions and interpretation of results.
- Presentation of analytics in simple words for management and staff.
What is more important than experience
- Analytical thinking, attention to details and love of numbers.
- Proactivity and desire to learn in practice.
- Basic skills in Excel (pivots, formulas) or willingness to learn quickly.
- Communication: able to explain conclusions to non-technical colleagues.
- Willingness to work in the office and use team.
We offer
- Stable salary + bonuses for successes/projects.
- Training from an experienced analyst and a development plan.
- Practical cases with real data and the opportunity to influence business? solutions.
- Career growth: junior > middle > analyst/head of analytics.
- Office hours: Mon-Fri from 9 a.m. to 5 p.m.