Azure fundamentals for BI Professionals

06
Feb 2025
 
07
Feb 2025
Training
06 February, 2025 to 07 February, 2025
09:00 to 17:00
2 days
Brussels element61 office
1.350 €

The cloud offers organizations access to (PaaS) platform-as-a-service components, pay-as-you-go cost models, flexibility, and scalability... but most of all cloud gives us innovation and rapid access to new features and functionalities. 

As a Data professional, you want to stay up-to-date about how BI and Data Science are running in the cloud, which features are new, and which components can help overcome current challenges in your on-premise BI & Data Science environment. With that ambition, we host a 2-day fundamentals training aimed to share and show what a BI professional should know about building BI and Analytics platforms in the Azure Cloud. 

Azure fundamentals for Data professionals

Training objective

The objective of this 2-day training is to learn the fundamentals of how to design, build, and run a BI platform in the Azure Cloud. Building on the concepts that BI professionals know (e.g. ETL, slowly changing dimensions, ...) we'll be transparent on what's similar but different in Azure and which components and concepts are new but very relevant (e.g. DevOps, parallelization, infrastructure as code). We'll train you on the fundamentals and give you a full perspective on what you should know, how to get started, and what skills to further grow.

Audience

  • You are an IT or BI manager, developer, or Data Scientist/Engineer interested in the cloud for data & analytic workloads
  • You are looking to know what's what in the Azure Cloud and get some practical tips (rather than reading online documentation)
  • You are familiar with the concepts of ETL and data warehousing

Agenda

The training will handle underneath modules/topics

Day 1

  • Introduction to the cloud & the Modern Data Platform (going from ETL to ELT)
  • Intro to Azure Fundamentals: portal, availability, SLA, and pricing
  • Intro to Azure Data Factory and its purpose for orchestrating tasks & ingesting data
  • Intro to Azure Data Lake Storage and the different types of storages for different use cases
  • Intro to Databricks and Fabric & their potential for data transformations (ELT)
  • A comparison of Databricks and Fabric to determine the building blocks of your modern data platform
  • Hands-on experience in deploying and building production-ready data factory pipelines for your data warehouse
  • How to use Databricks & Fabric to query data within your storage location of choice (Azure Data Lake Storage or Fabric OneLake)

Day 2:

  • Data Lakehouse Deep-Dive and the architectural layers for building a Modern Data Platform
  • Intro to visualization tools for analytics & operations
  • Overview of Azure DevOps and base concepts of Git & CICD to get you started on collaboration & versioning
  • Deep-Dive into Fabric & Databricks and real-time components for the Modern Data Platform
  • Exploring Security and Governance in Azure
  • Advanced hands-on sessions in Databricks, Data Factory, and Data Lake to build a Modern Data Platform
  • Practical tips and insights for the Modern Data Platform Journey + Inspiration to continue learning how to build your modern data platform
Databricks logo

  Azure fundamentals for Data professionalsAzure fundamentals for Data professionalsAzure fundamentals for Data professionals

Microsoft Fabric picto

These technologies will be covered in this course. Databricks, Azure Data Factory, Azure Data Lake, Azure DevOps, MS Fabric

Cost

  • 1350 € per participant for 2 days (fundamentals + hands-on)

More information or registration