Data Analytics Portfolio · Hospitality & F&B

Where the kitchen
meets the data.

Javiera Quezada

14 years on the floor of fine dining, cocktail bars and cafés — now turning that front-line instinct into decisions backed by data.

📍 Bordeaux, France
SQLPythonTableauExcelRestaurant AnalyticsHospitality AnalyticsWine & Spirits
Scroll to explore

Two case studies in hospitality,
two beyond.

Each project is rooted in a real problem faced in hospitality operations — reframed through data analytics to demonstrate both domain expertise and technical skill. Click any card for the full case study.

01
Commercial Diagnostics · Real Client

Artisan Bakery — Structural Sales Analysis

Exploratory data analysis of a confidential artisan bakery's full commercial year (2025). Mapped ticket architecture, product concentration, revenue vs. volume divergence, and product affinity patterns.

PythonExcelEDAReal Client
Key insights
79% of transactions contain only 1–2 products — growth lever is inside existing volume, not new customers
Top 3 products generate ~80% of total revenue — significant economic dependency on a small SKU core
+5% conversion from 1→2 products projected to add ~241K (local currency) annually (≈152 tickets/year)
View case study →
02
NEW
Menu Engineering

Restaurant Menu Profitability Analysis

Built an end-to-end restaurant profitability analysis to evaluate menu performance using pricing, food costs, and profitability metrics. The project combines Python for data preparation and feature engineering with Tableau for interactive dashboard development, providing business insights to support pricing strategies and menu optimization.

PythonTableauExcel
Key insights
Main courses generate the highest average unit profit ($14.24), making them the strongest revenue contributors
Beverages achieve the highest average profit margin (86.84%) thanks to their relatively low production costs
Overall average food cost percentage is 26.91%, staying within a healthy range for restaurant operations
A strong positive relationship exists between menu price and unit profit, meaning higher-priced items generally drive greater profitability
Vegetable Stir-Fry and Chicken Alfredo are the top-performing menu items by average unit profit
Food cost varies significantly across categories, highlighting opportunities to optimize pricing and ingredient management for main courses
View case study →

The method,
applied elsewhere.

Two projects outside hospitality — demonstrating that the analytical approach transfers across industries and data types.

The tools behind the work.

The languages, platforms, and tools I use day-to-day to turn raw operational data into clear, actionable decisions.

Python
Python
SQL
SQL
PostgreSQL
PostgreSQL
Excel
Excel
Power BI
Power BI
Tableau
Tableau
Jupyter
Jupyter
Streamlit
Streamlit
VS Code
VS Code
GitHub
GitHub
Google Drive
Google Drive
PowerPoint
PowerPoint

The analyst who has worked the pass.

14 years across fine dining, cocktail bars, and cafés — now channelling that operational precision into data analytics.

My career began in fine dining, cocktail bars, and café operations — 14 years managing covers, suppliers, menus, and margins in real time. I know what it costs when a dish underperforms. I know why a Friday fish order can go wrong.

Trained in Data Analytics at CareerFoundry, with a specialisation in data visualisation with Python. Currently completing an AI for Effective Professionals programme — building applied AI systems that make analytical work faster and more impactful.

Based in Bordeaux, France. Open to roles in France.

Expert
F&B Domain Knowledge
Advanced
Excel / Google Sheets
Intermediate
SQLPythonTableau

Start a conversation.

Whether it's a project, a role, or just a curious question about hospitality data — get in touch.