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

How we leveraged AWS SQS & Lambda to build a cost-effective and robust streaming data pipeline

Imagine a scenario where you get a requests for assistance in handling clickstream data received through Snowplow. This exactly what one of our clients, that handles huge amounts of customer data through their platform, was looking for. In this blog post, we go step by step through their request and how we handled it.

Read More

Is a Customer Data Platform the best solution for you?

As much as off-the-shelf Customer Data Platforms promise to offer a click-and-play solution, they cannot magically crack every intricate data engineering challenge compared to building an in-house solution on your own data stack. One thing is sure: the best choice will depend on an understanding of your organization.

Read More

How Hyperscale comes to the rescue when troubleshooting Azure SQL Server performance

What to do when facing performance issues with your ETL workflows processing data for loading your Data Warehouse in Azure SQL Server? Let’s dive into how we troubleshooted such performance issues and how Hyperscale came to the rescue.

Read More

Microsoft Fabric: The Game-Changer in Data Analytics?

Microsoft introduced Fabric this week. Possibly and probably the game-changing solution that can transform data analytics and integration. We dived into what Microsoft has unveiled with Microsoft Fabric and how this can impact Data Engineers, Analysts and Scientists. But we also have some open questions that we will answer once we are finished testing this exciting technology.

Read More