Fabric workspace layout for the Turner & Townsend Medallion platform. As-is on the left; target to-be on the right. The only structural change is Management Accounts moving from a Silver-consuming Gold-style build to a shortcut-mart pattern consuming from Gold, matching how Fee Flash already works.
As-Is
Management Accounts sits parallel to Gold with its own transformations off Silver.
BronzeRaw data
↓
SilverCleaned data
↓
GoldModelled data
↓
Fee FlashShortcut mart
Management AccountsGold-style build
To-Be
Management Accounts becomes a shortcut mart off Gold, aligning with Fee Flash.
BronzeRaw data
↓
SilverCleaned data
↓
GoldModelled data
↓
Fee FlashShortcut mart
Management AccountsShortcut mart
What’s changing
Management Accounts was originally built as a Gold-style workspace with its own notebooks, pipelines, and lakehouse consuming directly from Silver — the mart pattern hadn’t been established yet. In the to-be architecture, Management Accounts is refactored to a lightweight shortcut mart consuming from Gold, matching the pattern Fee Flash already follows. Repo D365-Fabric-Gold-ManagementAccounts loses its notebooks / pipelines / lakehouse and keeps only its shortcut config (like D365-Fabric-Gold-FeeFlash). Result: a single canonical dim/fact set in Gold, feeding all marts.
Environments
Each workspace above exists three times — one instance per environment. Workspace names carry an environment suffix (or the workspace is duplicated within the same Fabric tenant with the environment tag on the name).
Dev
Development and unit-level testing. Feature-branch work syncs here first via Fabric Git integration.
UAT
Integration and business acceptance testing. Deploys via
main branch after PR merge.
Prd
Production. Serves the live Fee Flash and Management Accounts reports to end users.