Blog

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 scaleup taking a share of what its partner creators earn. Account managers each carry a book of…

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 across 15+ Excel files, cost figures corrupted by decimal formatting errors, no unique route identifiers, and multi-country…

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 components, their key differences, market insights, and a simplified explanation for those new to the topic. Both…

Data Modeling: Start from here

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…