Francesco Stara Home Projects Head of BI WeLearn · Commercial reporting Power BIDAXPower QueryCRMGoogle Sheets Business An EdTech scaleup taking a share of what its partner creators earn. Account managers each carry a book of creators and a quarterly revenue…
Introduction: The Hidden Risks in Your Spreadsheets Imagine an Allied bomber plane returning from WWII, riddled with bullet holes. At a first look, the obvious answer might be to armor the areas with most holes. But statistician Abraham Wald realized…
Most small business leaders make critical decisions with incomplete information. While enterprise organizations invest millions in predictive analytics platforms, businesses with 50 employees typically rely on manual reporting processes that deliver insights weeks after trends emerge. This timing gap has…
Introduction: When Experts Spend Their Week in Excel In accounting, insurance, and legal firms, the highest-paid people are often the ones buried in spreadsheets. Partners, directors, senior associates, spend 10+ hours every week: None of this time is billable. None…
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: her team spends entire days trying to figure out which leads are active, which projects are profitable,…
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 Home Projects BI Developer & Analyst Freelance · Logistics PythonPower BIDAXStar schema Problem Shipment data spread across 15+ Excel files, cost figures corrupted by decimal formatting errors, no unique route identifiers, and multi-country customer operations with no tracking.…
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.…
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 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…