Alexis Senecal
Data Analyst
Data Analyst with a background in restaurant management. My transition into analytics was driven by a deep desire to unlock the answers hidden in messy restaurant data. I now help businesses find the actionable, data-driven insights I always wished I had access to.
Portfolio Project
Restaurant Dashboard — ELT to Forecasting
Data & Database PostgreSQL Supabase dbt SQL · Python pdfplumber Prophet psycopg2 pandas · Infrastructure & Visualization GitHub Actions Power BI
-
A production ELT pipeline built from scratch, from raw POS print files to a structured PostgreSQL database, fully automated with Python and GitHub Actions.
-
A full dbt transformation layer built on top of raw POS data, staging, feature engineering, and mart tables, where every business rule, threshold, and analytical decision is versioned in SQL and documented.
-
A three-model forecasting system built with Prophet, a weighted historical average, and hourly distribution logic, predicting weekly revenue, category mix, and hourly demand for a seasonal restaurant with limited historical data.Coming soon.
-
A seven-page Power BI dashboard built for a non-technical stakeholder, from weekly revenue forecasts and hourly heatmaps to staff performance and market basket analysis, with all business logic pre-computed in dbt and custom HTML panels where native visuals fell short.
Optimizing Restaurant Revenue : A Ticket Segmentation Strategy
Tools used: PostgreSQL, Tableau, Python, Excel
Upsell Champions : A data driven approach to server performance optimization
Tools used: PostgreSQL, Tableau, Python, Excel
Indie Market Strategy : Uncovering underserved genres for smart investment
Tools used: PostgreSQL, Power BI, Python, Excel