Writing
Notes, tutorials and ideas about data analysis and data engineering.
6 JOIN Types Explained
Left, right, inner, full, left anti and right anti joins, each shown in Power Query and in SQL.
#sql #power-query #data-analysis
SCD Types Explained: Which Slowly Changing Dimension Fits Your Table
A practical breakdown of SCD Type 0 through Type 6, how each one works, what it costs, and which situations call for it.
#data-engineering #sql
Setting up a local SQL playground with DBeaver
How to set up two local databases, a SQLite file and a real running PostgreSQL server, so you can practice any SQL command without touching anything that actually matters.
#sql #database
Auto-Creating Star Schema Relationships in Tabular Editor 2
A Tabular Editor 2 script that scans fact tables for surrogate keys and wires up relationships to matching dimension tables automatically.
#power-bi #tabular-editor #data-modeling
A Tabular Editor Script for Bulk Measure Formatting
A C# script for Tabular Editor that batch-sets the correct format string, percent, currency, quantity or DAX-driven, on every selected measure.
#power-bi #tabular-editor
Removing All DAX Comments From a Model in One Pass
A Tabular Editor 2 script that strips every comment from a model's measures without touching text inside DAX strings.
#tabular-editor #dax #power-bi
Why your Power BI model is slow (and what a star schema fixes)
Most slow reports are not a DAX problem. They are a modelling problem, and the fix is older than Power BI itself.
#power-bi #modelling #dax
Window functions, explained without the jargon
Running totals, rankings and "compare each row to its group" — all without a self join.
#sql #tutorial
VLOOKUP, INDEX/MATCH, XLOOKUP — which to actually use
Three ways to do the same job, twenty years apart. Only one is worth learning today.
#excel #tutorial
dbt for people who already know SQL
If you can write a SELECT, you are most of the way there. The rest is file layout and two macros.
#dbt #sql #data-engineering