Francesco Stara Home Projects BI Developer Freelance · Transport & fleet Power BIDAXData integration Problem Operational data scattered across spreadsheets, desktop invoices, messaging apps, paper toll receipts, and separate GPS and fuel systems — with no single view of what…
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…
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,…
Francesco Stara Home Projects BI Developer & Analyst Freelance · Logistics PythonPower BIDAXStar schema Problem Shipment data spread across 15+ Excel files, cost figures corrupted by decimal formatting errors, no unique route identifiers, and multi-country customer operations with no tracking.…
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.…
Francesco Stara Home Projects BI Developer Freelance · Sales operations Power BIPower Query (M)DAXGoogle Sheets Problem An entire sales pipeline tracked by hand across three disconnected Google Sheets — leads, deals, payments — with no relational integrity, repeated status columns…
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…