Synapse, Fabric & Warehouses

Once data has been gathered and cleaned, organisations want to ask questions of it quickly — “what did each region sell last quarter?” — and get answers in seconds, not minutes. That speed comes from a data warehouse, and in Azure the tools that provide it are Synapse and the newer Microsoft Fabric. These are the names you’ll hear whenever people talk about “the analytics platform”, so it’s worth knowing what each one is.

What a warehouse is — and how it differs from a lake

A data warehouse is a store of data that’s been cleaned, organised and arranged for fast questions. If a data lake (Module 2) is a huge reservoir holding water of every kind, a warehouse is the bottling plant: filtered, sorted and lined up neatly so you can grab exactly what you want in an instant. The lake is where data arrives and lives; the warehouse is where data is served up for reporting. A lake favours cheap, flexible storage of everything; a warehouse favours speed and tidiness for the questions the business actually asks. Most companies use both — the lake to hold it all, the warehouse to answer fast.

Synapse: the established analytics platform

Azure Synapse Analytics is Microsoft’s long-standing platform for building and running data warehouses at scale. Bring your data together, store it in an organised way, and run fast questions across very large volumes — that’s its job. Think of Synapse as a well-run distribution centre: data comes in, gets shelved logically, and can be retrieved at speed when a report needs it. It pulls several jobs under one roof — storing the warehouse, querying it, and connecting to the lake — so teams don’t stitch separate tools together. For years Synapse has been the default answer to “where do we build the warehouse?”, and plenty of organisations still run on it today.

A lake stores everything cheaply; a warehouse serves cleaned data fast. Synapse and Fabric are the tools that build the warehouse.

Microsoft Fabric: the all-in-one newer suite

Microsoft Fabric is Microsoft’s newer, all-in-one analytics suite, and it’s where much of the momentum now sits. Where the older approach meant assembling several separate services, Fabric bundles the whole journey — storing data, moving it, building the warehouse, and creating reports — into a single connected product. The selling point is simplicity: one place, one bill, one set of tools, with Power BI (the next module) built right in. If Synapse is a collection of well-run rooms you walk between, Fabric is the open-plan building where everything sits together. You’ll increasingly hear “we’re moving to Fabric” — it’s the direction Microsoft is steering customers.

OneLake: one store to rule them all

The idea at the heart of Fabric is OneLake. Picture the way every department in a company once kept its own filing cabinet, leading to duplicate, conflicting copies of the same information. OneLake is the fix: a single, shared data lake for the whole organisation, automatically built into Fabric, so every team works from the same copy of the data instead of their own. One source of truth, no shuffling files between systems. When someone praises Fabric for ending “data silos”, OneLake is what they mean — everyone drawing from one well rather than digging private ones.

Spot it: warehouse and platform concepts

Read each situation and decide for yourself, then tap a card to flip it and check your answer.

Sort the analytics platform concepts

Drag each item into the bucket it belongs to — or tap an item, then tap a bucket. Hit Check placement when you’re done.

How to use it

You won’t be choosing between these platforms, but you’ll hear them constantly, and now you can place each one. If a report runs fast, thank the warehouse behind it. If someone says “it’s all in Synapse”, you know that’s the established analytics platform doing the warehousing. If the conversation turns to “we’re moving to Fabric”, you understand it’s the newer all-in-one suite that bundles storage, pipelines, warehouse and reporting together. And if “OneLake” comes up, you can translate it instantly: one shared store so everyone uses the same data. Knowing that warehouses are about fast, tidy answers — and that Synapse and Fabric are the two tools that deliver them — is enough to follow any analytics-platform discussion.