watermark picture

Modern Data Platform - How to approach the architecture and setup of Azure & Power BI based platform

This training starts with understanding why we should switch from traditional data warehouses to a modern data platform. The training continues with an introduction to Azure Synapse.

More and more organizations are switching from traditional data warehouses to a modern data platform, serverless and without using databases. The traditional data warehouses lack the ability to add semi-structured and unstructured data, and SQL databases do not allow for a cost-optimized setup. And while decoupling data storage and processing is a good thing by itself, it adds significant complexity and unwanted delays because data is copied from one component to another. 

In this training 

  • you'll start with understanding why we should switch from traditional data warehouses to a modern data platform.
  • The training continues with an introduction to Azure Synapse. Hands on you will create your Azure Synapse data model/solution, and all best practices to take into account.
  • In the last part of the training, you will set up your Power BI platform and learn the best practices to load your data into Power BI.
  • The visualization of your data inside Power BI is not in scope of this training.
  • Other topics as cost-optimization, performance, incremental loading, security, documentation, governance,… will also be discussed briefly.

After this training 

  • you will learn the differences between traditional data warehouses and a modern data platform.
  • You will discover all capabilities of Azure Synapse.
  • Hands on, you will learn all best practices to load your data in Azure Synapse and Power BI.
  • You will be able to discuss your specific questions with our experienced data professionals.

This training is for 

  • Data engineers or developers that wish to develop their knowledge of Azure Synapse
  • Any data analyst working within an Microsoft environment
  • Data Team Manager that wishes to leverage new capabilities of the Microsoft stack.

Related cases

Related blogs

From Pitfalls to Power (BI): Top 3 Challenges We See Most Often

If your team has adopted Power BI in recent years, you've likely experienced its many advantages. However, the user-friendly nature of the tool can be a double-edged sword. In this article, we explore three common pitfalls we have seen organizations face when using Power BI. By addressing these pitfalls, organizations can maximize Power BI's potential to transform their data into meaningful insights and drive informed decision-making.

Read More

Self-Service BI: Blessing or Burden? Dive into Benefits, Challenges, and Solutions

Self-service BI allows business users to independently access, visualize, and analyse data. Although this sounds very promising for organizations, it also introduces challenges and potential pitfalls.

Read More

Hive vs Iceberg Tables in AWS Athena

Choosing the Best Option for Your Data Pipelines with dbt

Read More

How to build a cost-effective and robust streaming data pipeline

Envision a situation where you're tasked with managing clickstream data received via Snowplow. In this blog post, we'll guide you through our solution, step by step.

Read More