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.

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

Code README

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

Code README

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

Code README

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

Code README

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

Code README

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

Code README

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

Code README

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

Code README