When the COO of this fast-growing B2B SaaS company first called me, I could hear the tension in his voice. The company had reached €950,000 in annual recurring revenue with five talented salespeople, which should have been a celebration. Instead,…
How I uncovered profit leaks, optimized routes, and transformed chaos into clarity using Power BI and strategic analysis The Challenge: When Success Hides Serious Problems The Investigation: What the Data Revealed Step 1: Data Archaeology Step 2: Building the Financial Picture Step…
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…
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 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…
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…