This is how I transformed a chaotic spreadsheet into a clean, automated BI system that tracks revenue, conversion rates, and reps performance in real time. The client was tracking their entire sales pipeline manually in Google Sheets with three different…
This is the third part of a 3 parts project, you can find the full project here. In the third part of the IBM HR Dashboard project, I want to guide you through the process of transforming raw data into…
This is the second part of a 3 parts project, you can find the full project here. In the first part of this series, we built a robust Power BI data model to analyze employee attrition and satisfaction trends. Now,…
This is the first part of a 3 parts project, you can find the full project here. Building a robust data model is the foundation of effective analytics. In this step-by-step guide, we’ll use the IBM HR Analytics dataset (found…
In today’s data-driven world, organizations rely on analytics tools like Power BI to derive actionable insights from vast datasets. However, the accessibility of this data comes with a critical challenge: ensuring that users can only view the data they are…
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,…
In this project, I worked on a comprehensive examination of online transactional data, of an e-commerce. I utilized Python for preliminary exploration, SQL for investigation and querying the data, and Power BI for visualization, this work showcases a blend of…
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…