Insights / Tutorials

Tutorials — Data, Architecture & Cloud

Practical technical tutorials on Power BI, DAX, Azure, Databricks and much more.

All Azure (5) Azure AI & Machine Learning (5) Azure Data Factory (5) Azure Synapse Analytics (5) Databricks (5) DAX (5) Infraestrutura como Código & DevOps (5) Microsoft Copilot (5) Microsoft Fabric (5) Modelação de Dados (Kimball) (5) Power Apps / Power Platform (5) Power Automate (5) Power BI (5) PowerShell (5) SQL Server (5)

Azure Data Factory

Advanced parameterization in ADF: generic, reusable pipelines

Parameterized pipelines eliminate duplicate code in ADF. A single generic pipeline can ingest dozens of tables with con…

1 min 04 Jul 2025

Power Automate

Power Automate Desktop: RPA to automate legacy processes

Power Automate Desktop lets you automate Windows and web applications without an API. Ideal for legacy systems, old ERP…

2 min 25 Jun 2025

Microsoft Copilot

GitHub Copilot for data engineers: AI-assisted DAX, M and SQL

GitHub Copilot in VS Code speeds up writing DAX, Power Query M, T-SQL and Python for data. Learn prompting techniques a…

1 min 13 Jun 2025

SQL Server

Temporal Tables in SQL Server: automatic history without triggers

Temporal Tables add automatic history to any table with zero extra code. Query the state of data at any point in the pa…

2 min 06 Jun 2025

Databricks

Optimized PySpark: partitioning, caching and tuning for performance

PySpark code that works in development can be disastrous in production. Learn partitioning, caching and configuration t…

2 min 27 May 2025

Azure

Azure networking: VNets, subnets, peering and segmentation best practices

Network architecture is critical in Azure. Learn to design VNets, segment with subnets, connect networks with peering a…

2 min 16 May 2025

Microsoft Fabric

Pipelines in Fabric Data Factory: no-code data orchestration

Data Factory integrated in Fabric lets you build ETL/ELT pipelines with a visual interface. Learn to create your first …

2 min 07 May 2025

DAX

Time Intelligence in DAX with a custom date table

DAX Time Intelligence functions require a marked date table. Learn to build a robust table and use YTD, MTD and year-ov…

1 min 28 Apr 2025

Power BI

Reducing Power BI model size: how VertiPaq works

A bloated Power BI model causes slow refreshes and excessive memory use. Understand how the VertiPaq engine compresses …

2 min 18 Apr 2025

Infraestrutura como Código & DevOps

Terraform on Azure: state management, modules and workspaces

Terraform is the most widely used multi-cloud IaC tool. Learn to manage state in Azure Blob Storage, create reusable mo…

1 min 08 Apr 2025

Power Apps / Power Platform

Dataverse: the enterprise database of the Power Platform

Dataverse is much more than a SharePoint list. With rich data types, relationships, business logic and row-level securi…

2 min 28 Mar 2025

Modelação de Dados (Kimball)

Slowly Changing Dimensions Type 2: preserving history in the data warehouse

SCD Type 2 keeps the full history of changes in dimensions. Learn how to implement it in SQL Server and how to choose b…

2 min 20 Mar 2025

1 2 3 4 5 6 7

Need expert implementation?

Our team delivers end-to-end data projects — BI, cloud architecture and AI.

Book a free meeting →