Technology
SQL
Everything on this site involving SQL — projects, articles, research and tools.
Power BI Inventory Control Tower
An inventory dashboard built around the four decisions a stock controller makes each week, with a semantic model that stays fast on 40 million rows.
Microsoft Fabric Analytics Platform
An end-to-end Fabric implementation — lakehouse layering, incremental ingestion, dataflows, semantic model and deployment pipelines — with the decisions that are hard to reverse called out.
Laptop Data Platform
Ingestion, transformation, orchestration, testing and a BI layer — the full modern data stack, running locally on DuckDB, dbt and Dagster.
Fabric Starter Platform
A complete Microsoft Fabric reference implementation you can adapt: notebooks, semantic model, pipelines and the architecture decision record.
From Power BI to Microsoft Fabric
Move from building reports to building the platform reports sit on: lakehouse architecture, medallion layering, Direct Lake and deployment pipelines.
AI-Powered Business Analyst
Requirements, analysis, documentation and stakeholder communication — with AI doing the mechanical work and you keeping the reasoning.
30-Day AI Analyst Upgrade
Thirty days, one build per week, with review. Rebuild how you work as an analyst using AI where it genuinely helps.
Modern Data Engineering on Your Laptop
DuckDB, dbt and Dagster — ingestion, transformation, testing, orchestration and lineage without a cloud bill.
Data Analyst Interview Masterclass
SQL, statistics, case studies and behavioural rounds — worked through the way an interviewer evaluates them.
Power BI Developer to Fabric Engineer: A Roadmap
A staged plan for moving from report development into platform engineering on Microsoft Fabric — including an honest read on which existing skills carry over.
DuckDB vs pandas vs Polars: When Each One Wins
A practical decision guide based on workload shape rather than benchmark scores — because the fastest tool depends on what you are actually doing.
The Analytics Portfolio That Actually Gets Interviews
Three real projects beat thirty notebooks. What hiring managers screen for, and the structure that survives a five-minute skim.