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)

Infraestrutura como Código & DevOps

Bicep: Azure infrastructure as code — from zero to production

Bicep is the native Azure IaC language, compiled to ARM templates. Learn to declare resources, use modules and deploy w…

1 min 13 Nov 2024

Power Apps / Power Platform

Canvas Apps in Power Apps: build a data entry application

From a blank Canvas App to a working data entry application connected to SharePoint or Dataverse. Learn the essential c…

1 min 04 Nov 2024

Modelação de Dados (Kimball)

Kimball dimensional modeling: a practical guide to facts and dimensions

The Kimball methodology for data warehousing defines fact and dimension patterns that have stood the test of time. Lear…

2 min 25 Oct 2024

Azure AI & Machine Learning

Azure OpenAI Service: implement RAG with Azure AI Search

The RAG (Retrieval-Augmented Generation) pattern combines Azure OpenAI with AI Search to build assistants that answer b…

1 min 15 Oct 2024

PowerShell

PowerShell for Azure: automate resources with the Az module

The PowerShell Az module covers all Azure services with consistent cmdlets. Learn to authenticate, create resources and…

1 min 04 Oct 2024

Azure Synapse Analytics

Serverless SQL in Synapse: query the Data Lake without infrastructure

The serverless SQL pool lets you query Parquet, CSV and JSON files directly on ADLS Gen2 with standard T-SQL, without p…

1 min 26 Sep 2024

Azure Data Factory

Incremental ingestion patterns in Azure Data Factory with Watermark

Incremental ingestion is more efficient than loading the whole table. The Watermark pattern uses a control table to tra…

1 min 16 Sep 2024

Power Automate

Power Automate: automate approvals with structured workflows

Power Automate approval flows integrate with Teams, email and SharePoint to create no-code approval processes. Learn to…

1 min 06 Sep 2024

Microsoft Copilot

Microsoft Copilot in Power BI: natural language questions to your model

Copilot in Power BI lets you create visuals, summaries and narratives just by describing what you want. Learn how to en…

2 min 27 Aug 2024

SQL Server

Indexes in SQL Server: columnstore vs rowstore for analytics and OLTP

Choosing the right index type is the most impactful decision in SQL Server. Learn when to use clustered columnstore, ro…

2 min 16 Aug 2024

Databricks

Delta Lake in Databricks: ACID transactions for data at scale

Delta Lake turns a simple Data Lake into a transactional system with ACID, time travel and schema enforcement. Learn th…

2 min 08 Aug 2024

Azure

Anatomy of an Azure Landing Zone: the foundation of enterprise cloud

A well-designed Landing Zone defines governance, networking and security before any workload. Learn the essential compo…

2 min 29 Jul 2024

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 →