Turning Everyday Chaos into Clarity Most transport companies have data everywhere.Spreadsheets, invoices on the office desktop.Notes in WhatsApp.Toll receipts sitting on the passenger seat.GPS and fuel data stuck in separate apps.(That’s where data integration matters, connecting what you already track…
Introduction: When Experts Spend Their Week in Excel In accounting, insurance, and legal firms, the highest-paid people are often the ones buried in spreadsheets. Partners, directors, senior associates, spend 10+ hours every week: None of this time is billable. None…
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…