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…
In 2025, generative AI (GenAI) is changing the field of business intelligence (BI). Modern BI tools are no longer just static dashboards and manual reports, but they’re evolving into intelligent assistants that help users analyze data, generate insights, and even automate tasks.…
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…