Medallion Architecture Deployment in Microsoft Fabric

Medallion Architecture Deployment in Microsoft Fabric: Designing a Single Source of Truth

Most organisations do not have a shortage of data. They have a shortage of data they can trust. Reports disagree, definitions differ between teams, and every new request seems to start from scratch. Medallion architecture offers a proven way out: data is organised in progressive layers, from raw (bronze) through cleansed (silver) to business-ready (gold), so everyone works from the same trusted foundation.

This 1-day course introduces medallion architecture for designing lakehouse and data warehouse solutions in Microsoft Fabric. You will learn how to build a single source of truth for all your business reporting, analytics and data science needs. The day covers when to choose a lakehouse, a warehouse or a hybrid of the two, the main implementation models, and how to ingest and process data through the bronze and silver layers using the core Fabric tools.

Develop Medallion Architecture Skills:

• What a single source of truth is, and why it matters for reporting, analytics and data science.

• How to decide between a lakehouse, a data warehouse or a hybrid approach.

• What medallion architecture is, and the implementation models available.

• How to implement a lakehouse, and a hybrid lakehouse and warehouse solution, using medallion architecture.

• How to ingest bronze data and process it through the bronze and silver layers.

• How OneLake and lakehouse architecture fit together.

• The basics of Data Factory pipelines, Dataflows Gen2 and notebooks, and when to use each.

• How to use Microsoft Fabric task flows to organise and visualise your solution.

Learn Medallion Architecture Your Way, Training Tailored to Your Needs

This course is delivered as a virtual, instructor-led session and can be tailored to your needs. If you already have a lakehouse or warehouse in place, or a particular reporting problem to solve, let us know and we can focus the day on the areas that matter most to you.

Solve Your Data Architecture Struggles with Expert Training

Whether you are a BI developer, data engineer, data architect or BI lead, those who come to PTR for this course are usually asking:

• How do I create one trusted version of the data for the whole business?

• Do we need a lakehouse, a data warehouse or both?

• How should we structure our data so it is easy to maintain and reuse?

• Which Fabric tool should we use to ingest and transform each type of data?

• How do we make our data ready for reporting, analytics and AI?

If this sounds familiar, this is the course for you. We will walk you through practical answers to each of these, using the Fabric tools you will work with in your own environment.

Delegates should have some experience of business intelligence and reporting, and a familiarity with data warehouse concepts such as fact and dimension tables, and loading and transforming data.

No specific Microsoft Fabric knowledge is required, as the tools used on the course are introduced during the day.