Francesco Stara HomeHome ProjectsProgetti BI DeveloperBI Developer Freelance · Transport & fleetFreelance · Trasporti e flotte Power BIDAXData integration ProblemProblema Operational data scattered across spreadsheets, desktop invoices, messaging apps, paper toll receipts, and separate GPS and fuel systems — with…
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 HomeHome ProjectsProgetti BI Developer & AnalystBI Developer e Analyst Freelance · LogisticsFreelance · Logistica PythonPower BIDAXStar schema ProblemProblema Shipment data spread across 15+ Excel files, cost figures corrupted by decimal formatting errors, no unique route identifiers, and multi-country…
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 HomeHome ProjectsProgetti BI DeveloperBI Developer Freelance · Sales operationsFreelance · Sales operations Power BIPower Query (M)DAXGoogle Sheets ProblemProblema An entire sales pipeline tracked by hand across three disconnected Google Sheets — leads, deals, payments — with no relational…
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…