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 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…
Data modeling is the process of creating a visual representation of an organization’s data and the relationships between different pieces of that data. For example, imagine a retail business that tracks sales, customers, and inventory – data modeling would illustrate…