Lakehouse in a day
2023TL; DR
In this training session you will build a full fletched green field Lakehouse architecture based on best practices! You will be guided by experts in the field to learn about the key components & how to build it in the most dynamic & performant way!
Session Details
Are you looking into the Lakehouse architecture and want to know where to start? Want to get hands-on experience with all the different Azure components you can use to achieve this?
Well then, we have a treat for you!
During this full day training session, you will build a new green field Lakehouse under the support of experts in the field!
We will start of the day with a general introduction to the Lakehouse concept and give a brief overview of all the components that you can use.
After that it is up to you to decide what you want to build and how you are going to build it based on the requirements you received!
During the exercises we will be having some OLTP sources you will need to import in a dynamic and incremental way, guided by the best practices the coaches provide you. This will tackle the bronze layer and all the things you need to know about it.
After getting that data in your bronze layer, you will build out the silver layer based on a few real requirements! During this part, you will learn how to incrementally load data to your silver layer and make sure your cleansing is done right and in an effective and dynamic way!
Of course, there is no Lakehouse without a gold layer which serves the business needs of your company. Together with us, we will build out a robust gold layer focused on performance & business needs!
If you do not know where to start, don’t worry, during this day we will also be providing you with loads of sample scripts based on the best practices seen at most customers!
The technologies that will be used during this training day are Azure Synapse Analytics, Azure Databricks, Delta Lake, Power BI, Serverless SQL Pools, Azure Data Lake, Spark Notebooks, Synapse Integrate Pipelines & Azure Data Factory!
Well then, we have a treat for you!
During this full day training session, you will build a new green field Lakehouse under the support of experts in the field!
We will start of the day with a general introduction to the Lakehouse concept and give a brief overview of all the components that you can use.
After that it is up to you to decide what you want to build and how you are going to build it based on the requirements you received!
During the exercises we will be having some OLTP sources you will need to import in a dynamic and incremental way, guided by the best practices the coaches provide you. This will tackle the bronze layer and all the things you need to know about it.
After getting that data in your bronze layer, you will build out the silver layer based on a few real requirements! During this part, you will learn how to incrementally load data to your silver layer and make sure your cleansing is done right and in an effective and dynamic way!
Of course, there is no Lakehouse without a gold layer which serves the business needs of your company. Together with us, we will build out a robust gold layer focused on performance & business needs!
If you do not know where to start, don’t worry, during this day we will also be providing you with loads of sample scripts based on the best practices seen at most customers!
The technologies that will be used during this training day are Azure Synapse Analytics, Azure Databricks, Delta Lake, Power BI, Serverless SQL Pools, Azure Data Lake, Spark Notebooks, Synapse Integrate Pipelines & Azure Data Factory!
3 things you'll get out of this session
They will learn to actually build a Lakehouse using all the best practices guided by experts in the field. They will have a working example of a Lakehouse to play with and loads of sample scripts provided by the team.
Speakers
Mark Pryce-Maher's other proposed sessions for 2026
New in Microsoft Fabric: The Warehouse and the SQL Analytics Endpoint - 2026
SQL vs. Fabric? Why Not Both! A Practical and Entertaining Guide for All - 2026
Mark Pryce-Maher's previous sessions
From Beginner to Certified: A Fabric Analytics Engineer Workshop
In this full day workshop, we’ll cover the skills and tasks required for a career as a Microsoft Fabric Analytics Engineer and prepare you for the DP-600 Certification Exam.
Nose-Dive Narratives: Slide Karaoke 2024
Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!
Fabric Product Group - Ask us Anything
Come and join the Fabric Product Group for one of our fireside chats. Bring your questions because we have all the answers!!
Fabric Power Hour
The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!
A Deep Dive into Microsoft Fabric Data Warehouse
Deep Dive into Data Warehousing in Microsoft Fabric. Explore the intricacies of Microsoft Fabric Data Warehouse, unraveling its capabilities and demonstrating effective strategies for its utilization.
Synapse Q&A with PG
SQLBits' has brought members of the Azure Synapse Program Group to Wales to ask YOUR questions. Bring your questions for: Dedicated SQL Pools, Serverless SQL Pools, Spark Pools, Pipelines, Kusto and everything else Synapse related.
Lightning Talks
5 minute lightning talks from your favourite speakers
Dedicated SQL Pools : How some stuff 'really' works
Session covering table distributions, partitioning , RSC and materialised views.
Reporting on 1.4B rows with Serverless SQL Pools
Building a dashboard using Serverless SQL Pools in a performant way
Azure Synapse Analytics: Evolving Azure SQL Data Warehouse
In this session we explore Azure Synapse Analytics, we will dive into this limitless analytics service and explore how it brings together enterprise data warehousing and Big Data analytics.
Modernizing & Migrating Your Data Warehouse w/ Azure Synapse
This session will dive into how to successfully migrate to Azure Synapse, all the way from code conversion to enterprise grade developer tooling, with real customer examples for product and migration experts.
Azure Machine Learning from the ground up
Azure Machine Learning is a fully managed cloud service for predictive analytics.
In this 1hour session, we will run through;
ML Studio,using data, Creating and running Experiments, visualising results, R , publishing and using experiments.
Building a SSMS Add-in; The Agony and Ecstasy
We will travel back in time a bit to SQL 2005 to see how SSMS Add-ins worked, then jump forward to the present day were we will go through the process of writing a SSMS Add-in for R2.
Stijn Wynants
sql-stijn.com
Stijn Wynants's other proposed sessions for 2026
OneLake Security: A Deep Dive - 2026
Stijn Wynants's previous sessions
Synapse Q&A with PG
SQLBits' has brought members of the Azure Synapse Program Group to Wales to ask YOUR questions. Bring your questions for: Dedicated SQL Pools, Serverless SQL Pools, Spark Pools, Pipelines, Kusto and everything else Synapse related.
What's New and Cool in Azure Synapse Analytics
Azure Synapse Analytics is a unified platform for end-to-end analytics. Join this session to find out about recently announced updates to Azure Synapse and to see the new features in action and learn in which scenarios and how you can use them.
Reporting on 1.4B rows with Serverless SQL Pools
Building a dashboard using Serverless SQL Pools in a performant way
Azure DW and Power BI, reporting at the speed of light!
In this action-packed demo full session, we will be showing you how to combine Azure DW and Power BI to get optimal performance for running your day to day reports.
Simon Whiteley
advancinganalytics.co.uk/blog
Simon Whiteley's previous sessions
Behind the Hype - Architecture Trends in Data
Seasoned Data Engineer and YouTube grumbler Simon Whiteley takes us on a journey through the current industry trends and buzzwords, carving through the hype to get at the underlying ideals. Which is going to last and which is a sales gimmick? Which bandwagon might actually take you in the right strategic direction?
Nose-Dive Narratives: Slide Karaoke 2024
Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!
Behind the Hype - Architecture Trends in Data
In this session, seasoned data engineer and youtube grumbler Simon Whiteley takes us on a journey through the current industry trends and buzzwords, carving through the hype to get at the underlying ideals.
Building a Lakehouse on the Microsoft Intelligent Data Platform
This session session aims to give you that context. We'll look at how spark-based engines work and how we can use them within Synapse Analytics. We'll dig into Delta, the underlying file format that enables the Lakehouse, and take a tour of how the Synapse compute engines interact with it. Finally, we'll draw out our whole Lakehouse architecture
Bringing Data Lakes to your Purview
A short, fast dive into the specific elements of Azure Purview that work well with Data Lakes, and how you implement them yourselves
Value-Driven Analytics Development
Ever spent an age releasing a data model, only to find no-one uses it? There's a better way of working, driven by both technology & agile working practices, let me tell you about Value Driven Development & DataOps
Databricks, Delta Lake and You
Databricks, Lakes & Parquet are a match made in heaven, but explode with extra power when using Delta Lake. This session will dive into the details of how Databricks Delta works and how to make the most of it.
The Azure Spark Showdown - Databricks VS Synapse Analytics
Azure now has two slick, platform-as-a-service spark offerings, but which one should you choose? A separate specialist tools or a one-size-fits-all solution? Join Simon as he compares and contrasts the spark offerings.
Azure SQL DataWarehouse: 0-100 (DWUs)
Azure SQLDW - WHAT, WHERE, WHEN and HOW to use it.