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 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,…
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,…