Projects

    Olist E-commerce Performance Analytics | PowerBI

I developed an interactive dashboard to analyze sales data from Olist Store (Brazil, 2016-2018), working with complex anonymized datasets. After optimizing the data with a star schema and calendar dimension, I created visualizations to track:

• Order and revenue trends with year-over-year comparisons, filterable by state/region

• Customer reviews and behavior patterns

• Performance by product category and geographic area

The UX-focused report combines dynamic filters, intuitive charts, and drill-through capabilities to uncover trends and anomalies, transforming raw data into strategic insights.

Technologies: Power BI, DAX, data modeling, UX design

    Sanremo Music Festival: Data Analysis | Looker Studio

I analyzed 70 years of Italy Sanremo Festival data (2051-2023) using Excel and Power Query to extract insights about artists, trends, and performances. After cleaning and processing the data, I created an interactive Looker Studio dashboard that reveals hidden patterns, such as the evolution of dominant music genres and the correlation between artists' age and competition success. This project demonstrates my ability to transform raw data into clear, actionable narratives with a detail-oriented analytical approach.

Technologies: Excel, Power Query, LookerStudio

    Covid-19 Data Analysis | Python

I conducted a comprehensive pandemic analysis using global data from Our World in Data, processed in Python via Jupyter Notebook. After initial exploratory analysis (EDA) including data cleaning, format transformation, and correlation studies, I created targeted visualizations to answer specific analytical questions.

 The analysis highlighted: infection rates by continent, Italy's case trends in 2022 (with temporal charts), ICU patient comparisons (Italy/Germany/France, May 2022-April 2023), and 2021 hospitalization rates for Italy, Germany, France, and Spain. Each phase included tailored data filters, numerical demonstrations, and critical trend interpretations.

Technologies: Python, Pandas, Matplotlib/Seaborn, Jupyter 

    ToysGroup Management  Database | MySQL

I designed and implemented a MySQL database for ToysGroup, a toy distributor operating across 25 countries in Europe and America. Starting from business requirements analysis, I built an optimized relational structure (Category, Product, RegionSales, CountrySales, Sales tables) with key relationships to track sales, products, and geographic areas.

The Sales table, as the core, records each transaction with order numbers, dates, quantities, and amounts, linking products and countries. I populated the database with demo data while ensuring referential integrity, and developed queries to analyze sales trends. The ER diagram clarifies entity relationships, while creation/dump scripts ensure replicability and maintainability.

Technologies: MySQL, Workbench, modellazione relazionale

    Hospitality Management System - Marche Region | Excel

I developed an Excel-based system to manage accommodations in Italy's Marche region, starting from raw datasets. After thorough data cleaning with Power Query (standardization, duplicate removal, and unique index creation), I built an interactive dashboard featuring:

• Dropdown menus for accommodation searches with automatic counters

• Filterable pivot tables by category and city

• Average price integration via Power Pivot

The result is an intuitive tool that transforms complex tourism data into ready-to-use insights, enabling local business to optimize their operations.

Technologies: Excel, Power Query, Power Pivot

    Business Intelligence Report: AdventureWorks | Power BI

I I collaborated on the development of a Business Intelligence solution for AdventureWorks, a leading retailer of bicycles and accessories. The project analyzed sales performance (2017-2021) through an optimized interactive report.

• Data Modeling & ETL: Consolidated factInternetSales and factResellerSales tables into a single Sales table and built product hierarchies (Product → Subcategory → Category) using Power Query to create an efficient and high-performance data model.

• Advanced DAX Measures: Implemented DAX measures to calculate prior-year revenue (SAMEPERIODLASTYEAR), transactions, units sold, and competitive averages to evaluate sales agents’ performance.

• Strategic Analysis: Identified temporal trends and COVID-19 impact: a 2020 decline offset by online sales, with Bikes as the main revenue driver and Accessories/Clothing achieving higher margins.

• Interactive Dashboard: Designed a multi-page report with drill-down/drill-up functionality and advanced visualizations (tree maps, time-based charts) to explore revenue by country, category, and product attributes.

The solution transformed complex data into immediate insights, supporting operational and strategic decisions for the company.

Technologies: Power BI, DAX, Power Query, Data Modeling, Time Intelligence, ETL, Team Collaboration

    Historical Oscars Analysis (1980-2023) | Looker Studio

   I collaborated on a retrospective analysis of the Academy Awards to support investment decisions in the film industry. The project transformed raw and fragmented data into an interactive strategic dashboard.

• Data Engineering: Unified and cleaned 40+ years of data using Python (regex for title cleaning, null value management) and Power Query (advanced filters, temporal index creation).

• Business Intelligence: Developed a report in Looker Studio to analyze critical categories (Visual Effects, Performance), budget/box office correlations, and the evolution of collaborations between production companies.

• Strategic Insights: Identified historical trends and success patterns, highlighting how technological innovation (VFX, sound) influenced wins.

• Data-Driven Storytelling: Created a clear narrative to guide investment choices, focusing on "defining moments" in Oscars history.

The project demonstrated how complex data can be transformed into concrete recommendations for producers and investors.

Technologies: Python, Pandas, Regex, Power Query, ETL, Looker Studio, Data Storytelling, Team Collaboration

    Competitive Analysis: VANS vs CONVERSE | Python

   I contributed to a competitive analysis between VANS and CONVERSE in the sneaker market using advanced web scraping and data engineering techniques.

• Automated Data Collection: Performed web scraping from e-commerce sites to extract product data, prices, categories, and availability, applying filters for gender and brand.

• Data Engineering: Cleaned and transformed the dataset using Python (Pandas): price conversion, attribute extraction (model, category, color) from product names, and handling missing values and duplicates.

• Strategic Analysis: Identified competitive differences in models and pricing strategies: VANS focused on model diversification, CONVERSE on color variety.

• Visualization & Insights: Created interactive charts to compare prices, gender segmentation, and positioning, supporting data-driven decisions for market strategies.

The analysis revealed hidden patterns in the brands’ offerings, providing actionable insights on pricing, assortment, and target audiences.

Technologies: Python, Pandas, Web Scraping, Data Cleaning, Matplotlib, Data Visualization, Team Collaboration

    Management Database for VendiCose SpA | MySQL

   I collaborated on the design and implementation of a relational database for VendiCose SpA, aimed at optimizing order management and stock control for a supermarket chain.

• Database Design: Designed a structured E/R schema with 6 main entities (Category, Product, Warehouses, Stores, Stocklevels, Sales) and relationships to connect warehouses and stores.

• Automation & Controls: Implemented SQL triggers (BEFORE INSERT) to validate sold quantities and ensure compliance with safety thresholds (e.g., blocking sales exceeding available stock).

• Dynamic Views: Developed views for real-time monitoring (daily_product_sales, daily_flag_restock, daily_total_sales) using functions like CURDATE() for automatic updates.

• Operational Optimization: Created a correlation table (Stocklevels) to dynamically track stock, with automatic alerts for product reordering.

The system transformed manual processes into an automated flow, reducing stock-out risks and improving operational efficiency.

Technologies: MySQL, SQL, Triggers, Views, E/R Modeling, DDL/DML, Team Collaborati

    COVID-19 Data Analysis for XYFARMA | Excel

   I contributed to the analysis of Italian COVID-19 data (2020–2024) to support XYFARMA in the strategic evaluation of a new vaccine.

• ETL & Data Cleaning: Managed data preparation via Power Query, standardizing region names, validating formats, and removing duplicates to ensure analytical consistency.

• Modeling & Calculations: Implemented a calculated column for the Vaccinated/Deceased ratiousing Power Pivot to measure vaccine effectiveness.

• Dashboard & Reports: Developed interactive reports with pivot tables and charts, filterable by region and quarter, to visualize temporal trends and relationships between infected, vaccinated, recovered, and deceased individuals.

Technologies: Excel, Power Query, Power Pivot, Data Modeling, Team Collaboration