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 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

Spark your Infrastructure: Terraform to deploy AWS Glue Pyspark job

Tired of manually provisioning and managing your infrastructure? Well, then it's time to adopt best practices and treat your infrastructure as code. In this blog post, we’ll be diving into the world of Infrastructure as Code (IaC) using one of the most popular tools available - Terraform.

By the end of this post, you’ll have a better understanding of how to leverage Terraform to deploy your AWS Glue Pyspark jobs, giving you a more automated and scalable infrastructure. So, let’s get started and spark your infrastructure!

Read More

Why software engineering best practices matter so much in data projects

With the rise of modern data platforms and cloud-based solutions, BI has become just one part of a much larger data ecosystem. This evolution has presented data teams with a host of new challenges, primarily in terms of the skills and expertise to create and manage data products that meet the needs of data consumers.

Read More
From Data to Impact talks

From Data to Impact talks

More impact out of your data?