I created a report using Looker Studio on the Sanremo Music Festival, covering the entire time span from 1951 to 2023.
The project involved analyzing the geographical origins of both hosts and winners to identify any recurring patterns or imbalances in territorial distribution over the years. It also explored the historical trends in TV audience and share, highlighting key moments of success or decline. To complete the analysis, data on the average age of winners and presenters for each edition was examined.

The project is available at the following link: "Festival di Sanremo".

As part of an analysis, I developed a report using Python in a Jupyter Notebook environment, based on the COVID-19 dataset curated by "Our World in Data".
The project involved an in-depth exploration of global health data, with both continental and national-level focus. For each continent, total recorded cases since the beginning of the pandemic were calculated, along with their percentage share of global cases, annual trends, and the progression of new cases. A boxplot was created to compare ICU patient trends in Italy, Germany, and France between May 2022 and April 2023. Additionally, the total number of hospitalized patients during 2021 was calculated and visualized—both numerically and graphically—for Italy, Germany, France, and Spain, in order to highlight potential differences between healthcare systems.

The project is available at the following link: "Covid19".

In this project, I designed and implemented a relational database using MySQL for ToysGroup, a company specializing in toy distribution.
Starting from domain analysis, I identified the main entities (Product, Region, and Sales) and defined the relationships and hierarchies among them, ensuring referential integrity and minimizing redundancy. The model was developed with a normalized structure and designed to support efficient sales analysis by geographic area and product category.

The project is available at the following link: "ToysGroup".

As part of a project for the Marche Region, I developed an interactive system for consulting and analyzing hospitality facilities across the regional territory.
The main goal was to create a dynamic Excel interface that allows users to select a specific facility via dropdown menus and automatically view all related information (city, address, email, etc.). Additionally, a second feature was implemented to display all facilities, filterable by city and category.

The project is available at the following link: "Strutture ricettive".

During a group project focused on Looker Studio, we received a messy and unstructured dataset containing Oscar related information, provided directly by the client. The file, a .zip archive full of unverified CSVs, required extensive cleaning and transformation.
As a team, we worked on normalizing the data and restructuring it into coherent tables. We then designed an interactive report that offers an in-depth analysis of two key Academy Awards categories, highlighting trends, recurring patterns, and cross-cutting insights useful for understanding the dynamics behind cinematic success.

The project is available at the following link: "Oscar ".

During the Build Week, we conducted a comparative analysis using Python between Vans and Converse, focusing on pricing, product categories, and gender segmentation. After collecting and cleaning the data, we developed an interactive report with charts and tables to highlight positioning differences, brand strengths, and areas for improvement.
We structured the dataset by extracting key information from product names (such as model, category, and price) and normalized the data related to pricing and gender. The results provided valuable insights into the commercial strategies of both brands and supported data-driven decision-making in the retail sector.

The project is available at the following link:"Calzature".

During a group project, we designed and implemented a relational database using MySQL for VendiCose SpA, a supermarket chain, with the goal of efficiently managing the flow of orders between warehouses and retail stores. The system tracks sales in stores, automatically updates warehouse stock levels, and triggers restocking when a product falls below a predefined threshold, specific to each category and warehouse.
The project required careful data modeling and the management of many-to-many relationships between warehouses and stores, ensuring consistency and real-time traceability of operations.

The project is available at the following link:"VendicoseSPA".

To support the strategic decisions of the pharmaceutical company XYFARMA, we developed an interactive Excel report aimed at analyzing the trends of COVID-19 cases, recoveries, deaths, and vaccinations in Italy from 2020 to the present. After collecting official data, we cleaned and transformed it using Power Query and built a data model in Power Pivot for dynamic analysis.
The report includes pivot tables and charts, an interactive dashboard for querying data by region, and visualizations focused on the relationship between infections and vaccinations. The project provided XYFARMA with a solid foundation for evaluating potential investment in a new vaccine.

The project is available at the following link:"Covid-19".