Hi, I'm Rodrigo Ferreira
Data analysis & engineering notes, tutorials, and things I build.
I'm a Lead Data consultant specializing in Microsoft Fabric and Databricks with over a decade of experience. This is where I write up what I work out along the way, showcase my work, and share the knowledge I have on managing data.
Latest writing
All posts →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
Projects
All projects →Fluxo — financial control for Brazilian companies
A SaaS that turns bank statements into a real financial dashboard for Brazilian companies, with AI categorizing every transaction as it comes in.
saas · fintech · ai · product
Monitoring every Fabric and Power BI item without being the admin
A PySpark-to-Power-BI pipeline giving a single, filterable view of every item I can see (owner, last refresh, status) with a one-click email to whoever owns something that's failing.
power-bi · microsoft-fabric · data-governance · power-automate
Regional sales dashboard
A Power BI report replacing a 40-tab spreadsheet that took two days a month to assemble by hand.
power-bi · dax · modelling
Pipeline monitoring without a monitoring product
Freshness and row-count checks written as dbt tests, surfaced on a single page. No new vendor.
dbt · data-engineering · sql
Cheat Sheets
All cheat sheets →VSCode Hotkeys I Actually Use Every Day
A short list of VSCode keyboard shortcuts worth memorizing, from searching every file at once to fixing a line that scrolls off screen.
vscode · productivity · tools
Pandas ↔ SQL
The same operation in both, side by side. For when you know one and are reaching for the other.
python · sql · pandas
DAX quick reference
The patterns that come up constantly — time intelligence, filter context, and the difference between the two X functions.
power-bi · dax
Git commands worth memorising
The dozen commands that cover almost everything, plus how to undo the three mistakes everyone makes.
git · tooling