LUCAS GARCIA

M2 Marketing Data Analytics

Lucas Garcia Download Resume (PDF)

About Me

I am a Master's student in Marketing Data Analytics at Montpellier Management, passionate about extracting meaningful insights from data. With a background in sales and technical skills in Python, SQL, and Power BI.

Currently looking for an apprentice contrat starting September 1, 2026.

Technical Skills

Python SQL (MySQL) Power BI Tableau Excel (Advanced) Google Analytics

Education

Master in Marketing Data Analytics
Montpellier Management - 2025 - 2027 (Expected)


Bachelor's Degree in Marketing and Sales
Montpellier Management - 2022 - 2025

My Projects

LoL Data Analysis

LoL Data Pipeline: ETL & Analysis

Extracted 700+ matches using Python and Riot API to create a dataset. Used SQL queries to analyze Key Performance Indicators (KPIs) such as Win Rate by Champion, Gold efficiency, and Early/Late game performance.

Insight: Analysis revealed a 15% higher Win Rate during morning sessions compared to late-night games.

Github Link
Spotify Analysis

Spotify Data Pipeline: ETL & Cleaning

Built a Python ETL pipeline to process a raw music dataset containing encoding errors. Used Pandas to clean text anomalies and standardize data formats before loading into MySQL.

Insight: SQL analysis identified Taylor Swift as the #1 artist, significantly outperforming viral trends in total streams.

Github Link
Sales Forecast

E-commerce Sales Forecasting (ML)

Analyzed the 'Superstore' dataset (real-world retail data). Built a Python pipeline to aggregate monthly trends and trained a Random Forest model to forecast future revenue.

Insight: Real data analysis showed strong seasonality, with Technology products driving 40% of total revenue during Q4.

Github Link