Data Engineering
Medallion Architecture in Fabric (Part 1): Setting Up the Environment
Part 1 of the series: capacity, workspace, OneLake and lakehouse, the starting point for building the medallion architecture in Fabric.
Recent Articles
17 articles
Data Engineering
Medallion Architecture in Fabric (Part 2): Bronze Layer and the CSV File
Part 2 of the series: the bronze layer keeps data exactly as it arrived. We create lh_bronze and load vendas_raw.csv.
Data Engineering
Medallion Architecture in Fabric (Part 3): Silver with a Shortcut and Notebook
Part 3 of the series: a shortcut between lakehouses, a notebook attached to lh_silver and reading the CSV with PySpark, step by step with screenshots.
Data Engineering
Medallion Architecture in Fabric (Part 4): Cleaning the Data and Creating the Delta Table
Part 4 of the series: PySpark cleanup, saveAsTable, the anatomy of a Delta table (Parquet and Delta log) and the ACID properties.
Data Engineering
Medallion Architecture in Fabric (Part 5): Querying with the SQL Analytics Endpoint
Part 5 of the series: the SQL analytics endpoint queries Delta tables with T-SQL but does not change data. See a first analysis on fato_vendas.
Data Analysis
The “Rich Cousin” of dCalendar: Discover the Power of the Time Dimension in Power BI
dTime is dCalendar's “rich cousin”: it shows at what hour of the day things happen. See how to build it with M and DAX.
Data Engineering
How to Protect Your Databricks Code Without the Azure Premium Plan
A step-by-step to get keys out of your code: Secret Scopes via the Databricks CLI to mount Azure Data Lake, without the Premium plan.
Data Analysis
FILTER in DAX: The Secret to Precise, Custom Calculations in Power BI
How FILTER works in DAX, when to combine it with CALCULATE and how to keep it from slowing down your Power BI.
Data Analysis
REMOVEFILTERS in DAX: When Saying "No" to Filters Saves Your Report
REMOVEFILTERS in practice: ignoring region, product and region, a whole table or every filter, and how to avoid confusing report users.
Data Analysis
ALLEXCEPT in Action: Building Precise Calculations in Power BI
ALLEXCEPT in practice: total by category, average by department and total by category and region, preserving only the filters you need.
Data Analysis
Freeing Your Calculations with ALL: When to Use It and How to Avoid Pitfalls
The DAX ALL function in practice: grand total, ignoring a single column and percent of total, with performance cautions.
Certifications
AZ-900: Your Entry Point into a Cloud Technology Career
What AZ-900 covers (cloud concepts, Azure services, pricing and support, security and governance) and the material I used to prepare.
Data Analysis
Unlocking the CALCULATE Function: The Heart of DAX and Its Endless Possibilities
How CALCULATE modifies the filter context: category, previous year, grand total and cross filters, with DAX examples.
Data Analysis
Exploring the SUMX Function: When Summing Goes Way Beyond the Basics
SUMX in practice: row-by-row calculations, specific conditions, RELATED and the difference from SUM.
Data Analysis
How to Use SWITCH and VAR to Make Your DAX Measures More Readable and Efficient in Power BI
SWITCH(TRUE()) for readability and VAR for performance: two examples of nested IFs rewritten, with the same rule and clearer code.
Tools
How to Set Up SSH on Windows to Use with GitHub
ed25519 key, passphrase, ssh-agent on Windows, adding it to GitHub, testing with ssh -T and git clone, plus what to do on Permission denied.
Tools
How to Set Up Git on Windows: Installation and First Settings
From installation to git config: name, email, main branch, line endings and editor, plus the difference between Git and GitHub.