Francesco Stara HomeHome ProjectsProgetti BI Developer & AnalystBI Developer e Analyst Freelance · LogisticsFreelance · Logistica PythonPower BIDAXStar schema ProblemProblema Shipment data spread across 15+ Excel files, cost figures corrupted by decimal formatting errors, no unique route identifiers, and multi-country…
This project focuses on the analysis of gas stations across all provinces in Spain, using a dataset extracted from the official Spanish government portal dedicated to energy infrastructures. The data was obtained in September 2024 from the Gas Stations Geoportal,…
Exploratory Data Analysis (EDA) is the first and most important step in the data analysis workflow. It allows analysts and scientists to understand the patterns, relationships, and anomalies within the data, making it ready for a deeper analysis or the…
In this weather data analysis project, I analysed daily meteorological data from Warsaw, Poland from 1993 to 2022. I used Python for initial data preprocessing, Exploratory Data Analysis (EDA), statistical analysis and I created a Machine Learning model to see…
Francesco Stara HomeHome ProjectsProgetti Data AnalystData Analyst Transactional analysis · E-commerceAnalisi transazionale · E-commerce PythonSQLPower BI ProblemProblema Raw transactional data needing full exploration and cleaning before any reporting was possible: missing values, negative quantities, and outliers distorting every aggregate.Dati transazionali…
This project presents an exploratory data analysis (EDA) and an interactive dashboard idea centered around a unique dataset from five different vending machines scattered between four various strategic locations in Central New Jersey, USA. The dataset originates from vending machines…
In this project with healthcare data, I will explore deeply into the health of Pima Indian women.
Using Python, I first cleaned and explored the data. After, I used statistical methods and data visualization techniques to reveal hidden patterns, correlations, and insights within the data. This analysis cleared the path for predictive modeling. So, with machine learning, I took on the role of a predictor, trying to forecast possible diabetes diagnoses.