Exploratory analysis and evaluation of data quality.
Data cleaning and transformation pipeline with Python.
Design of an analytical base in PostgreSQL with flat table and dimensional model (Star Schema).
Development of SQL queries to answer business questions and identify KPIs.
Creation of interactive dashboards with Plotly, Streamlit and Power BI.
Application of advanced analytics through customer segmentation (RFM and clustering), sales forecasting and anomaly detection.
Identification of improvement opportunities in the commercial strategy, including the impact of discounts, low-profit categories and seasonal sales patterns.