Featured Projects

Here are some of the projects I have developed to practice and showcase my skills in data analysis, ETL, EDA, SQL and dashboards in Power BI.

Power BI Dashboards

powerbi_dashboards

Collection of practical Power BI dashboards focused on storytelling, KPIs and solid data modeling and DAX practices. Includes .pbix files and screenshots.

Power BI DAX Modeling
HR Analytics – ETL + EDA

etl_eda_dashboard_hr_analytics

Lean pipeline for an HR dataset (attrition): cleaning, standardization, EDA and creation of a curated dataset ready for visualization in Power BI, focused on employee turnover.

Python Pandas EDA
E-commerce SQL Database

ecommerce-logistics-sql-database

Relational modeling for an e-commerce database with separate schema, seed and check scripts. Includes logical diagram and constraints documentation to ensure data integrity.

SQL Modeling ER Diagram
COVID-19 ETL 2020

etl_covid19_2020

ETL pipeline for COVID-19 data (2020): ingestion, cleaning, date normalization and consolidation into an analytical dataset ready for exploration and visualization.

Python ETL Dates
Hospitality – ETL with JSON

etl_hospedagem_json

Processing of hospitality data in JSON format: batch reading, normalization of nested structures and tabular export ready to be used in BI tools.

Python JSON ETL
E-commerce Dashboard – SQL + Power BI

dashboard_ecommerce_db

End-to-end analysis project with SQL database and Power BI dashboard, showing sales, orders and performance by month, category and product.

Power BI SQL DAX
Salary Analysis Portugal 2015–2022

salary_analysis_portugal_2015_2022

Comprehensive analysis of salary evolution in Portugal from 2015 to 2022, including real-world ETL, detailed data cleaning, merging multiple public datasets from Pordata, exploratory data analysis and professional visualizations.

Python Pandas EDA Power BI
Streaming ETL & Dashboard

etl_dashboard_streaming_comparation

Complete ETL, EDA and dashboard project comparing streaming platforms, integrating public catalogs with IMDb. Includes clean pipeline, derived metrics, exploratory analysis and visual dashboards.

Python Pandas ETL Power BI