One Metric, Two Revenue Models: Distinct Counting in DAX
Francesco Stara Home Projects Head of BI WeLearn · Commercial reporting Power BIDAXPower QueryCRMGoogle Sheets Business An EdTech scaleup taking a share of…
Blog
Read MoreOne Metric, Two Revenue Models: Distinct Counting in DAX
Operational Report for Transport Companies
Francesco Stara Home Projects BI Developer Freelance · Transport & fleet Power BIDAXData integration Problem Operational data scattered across spreadsheets, desktop invoices, messaging…
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 Home Projects BI Developer & Analyst Freelance · Logistics PythonPower BIDAXStar schema Problem Shipment data spread across 15+ Excel files, cost…
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 Home Projects BI Developer Freelance · Sales operations Power BIPower Query (M)DAXGoogle Sheets Problem An entire sales pipeline tracked by hand…
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…