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)

SQL Server

Advanced T-SQL: CTEs, window functions and APPLY for complex analysis

Recursive CTEs, window functions and the APPLY operator are the most powerful T-SQL tools for complex analysis. Master …

2 min 30 Oct 2025

Databricks

Databricks Workflows: end-to-end data pipeline orchestration

Databricks Workflows replace external orchestration tools for Spark pipelines. Learn to create multi-task jobs with dep…

2 min 20 Oct 2025

Azure

Managed Identities in Azure: authentication without passwords or secrets

Managed Identities remove the need to manage credentials in Azure applications and pipelines. Learn to configure and us…

2 min 10 Oct 2025

Microsoft Fabric

Direct Lake in Power BI Fabric: maximum performance without Import or DirectQuery

Direct Lake mode is exclusive to Microsoft Fabric and combines the speed of Import with the data freshness of DirectQue…

2 min 30 Sep 2025

DAX

Variables in DAX: more readable and faster measures

Using variables with VAR/RETURN is one of the most impactful improvements you can make to your DAX code, boosting reada…

2 min 19 Sep 2025

Power BI

Field Parameters in Power BI: dynamic switching without duplicating visuals

Field Parameters let the end user choose which measure or dimension is shown in a visual, eliminating the need for dupl…

2 min 11 Sep 2025

Infraestrutura como Código & DevOps

Azure DevOps Pipelines for data: CI/CD of notebooks and ADF pipelines

Automating the deploy of Databricks notebooks, ADF pipelines and Power BI models with Azure DevOps ensures every change…

1 min 01 Sep 2025

Power Apps / Power Platform

Power Apps Component Framework (PCF): custom React components

PCF lets you create custom visual controls and datasets in TypeScript/React for Canvas Apps and Model-driven Apps, over…

1 min 22 Aug 2025

Modelação de Dados (Kimball)

Data Vault 2.0: flexibility and traceability for modern warehouses

Data Vault 2.0 is an alternative to Kimball for environments with unstable data sources and demanding audit requirement…

1 min 13 Aug 2025

Azure AI & Machine Learning

Azure AI Document Intelligence: automatic data extraction from documents

Document Intelligence (formerly Form Recognizer) extracts structured data from invoices, receipts and forms with prebui…

2 min 01 Aug 2025

PowerShell

PowerShell and REST APIs: consume and automate external services

Invoke-RestMethod turns PowerShell into a complete HTTP client. Learn to authenticate with OAuth2, paginate results and…

1 min 24 Jul 2025

Azure Synapse Analytics

Synapse Link for Cosmos DB: operational analytics without ETL

Synapse Link creates a channel for direct analysis of operational Cosmos DB data into Synapse, with no ETL pipelines an…

1 min 15 Jul 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 →