One Metric, Two Revenue Models: Distinct Counting in DAX
Francesco Stara HomeHome ProjectsProgetti Head of BIHead of BI WeLearn · Commercial reportingWeLearn · Reporting commerciale Power BIDAXPower QueryCRMGoogle Sheets BusinessContesto An EdTech…
Blog
Read MoreOne Metric, Two Revenue Models: Distinct Counting in DAX
Operational Report for Transport Companies
Francesco Stara HomeHome ProjectsProgetti BI DeveloperBI Developer Freelance · Transport & fleetFreelance · Trasporti e flotte Power BIDAXData integration ProblemProblema Operational data scattered…
BI Wisdom Through History: WWII Survivorship Bias, Netflix’s Analytics & More
Introduction: The Hidden Risks in Your Spreadsheets Imagine an Allied bomber plane returning from WWII, riddled with bullet holes. At a first look,…
GenAI Business Intelligence: Complete Implementation Guide for Companies with 1-50 Employees
Most small business leaders make critical decisions with incomplete information. While enterprise organizations invest millions in predictive analytics platforms, businesses with 50 employees…
From Spreadsheets to Dashboards: 30-Day Guide for Accounting, Insurance, and Legal Firms
Introduction: When Experts Spend Their Week in Excel In accounting, insurance, and legal firms, the highest-paid people are often the ones buried in…
Build a Sales System That Works While You Sleep (Free Google Sheets + Zapier Flows Included)
Sarah’s marketing agency grew from £300K to £1.2 million in two years. Success should feel good, but every month-end brings the same problem:…
B2B SaaS Sales Ops: Automated Lead-to-Customer Tracking for 5 Reps and €950K ARR
When the COO of this fast-growing B2B SaaS company first called me, I could hear the tension in his voice. The company had…
The Hidden €131K Loss: A European Logistics Company’s Data Analysis Story
Francesco Stara HomeHome ProjectsProgetti BI Developer & AnalystBI Developer e Analyst Freelance · LogisticsFreelance · Logistica PythonPower BIDAXStar schema ProblemProblema Shipment data spread…
Generative AI in BI 2025: How AI is Transforming Power BI and Business Intelligence
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,…
From Google Sheets to Power BI: Building a Scalable Sales Funnel Dashboard
Francesco Stara HomeHome ProjectsProgetti BI DeveloperBI Developer Freelance · Sales operationsFreelance · Sales operations Power BIPower Query (M)DAXGoogle Sheets ProblemProblema An entire sales…
Databricks vs Snowflake: A Comprehensive BI Tools Showdown
In this article I will deep into the two leading cloud data platforms: Databricks and Snowflake, by examining what they are, their core…
Crafting the IBM HR Dashboard: From Data to Design
This is the third part of a 3 parts project, you can find the full project here. In the third part of the…