Thanks Brick and Landon for explaining how you've used medallion layers and how you involve stakeholders early in the model development, it's also nice to see how you push for proper up front design in BI projects. I also encounter lower engagement from stakeholders initially on design work, especially if they aren't familiar with data modeling, until you actually get some numbers in front of them that can be debated about... Then they seem to care intently and want to fix the model 😂
It is so true that data models become more interesting when the actual numbers are involved. Glad our process helped and that you enjoyed the episode! Let us know if there is anything else you would like us to cover.
@@thedashboardeffectpodcast Landon mentioned a single-copy Fabric data architecture via shortcuts that sounded interesting. I'm imagining raw source files are loaded into Delta tables in a Bronze lakehouse and then referenced via shortcuts into SQL views in Silver/Gold virtual layers, so an "ELT" approach. I haven't seen many reference designs using Fabric yet so I'm curious to hear more about that and what performance tradeoffs you've encountered. Or is he referring only to using shortcuts between Bronze and upstream source files?
Thanks Brick and Landon for explaining how you've used medallion layers and how you involve stakeholders early in the model development, it's also nice to see how you push for proper up front design in BI projects. I also encounter lower engagement from stakeholders initially on design work, especially if they aren't familiar with data modeling, until you actually get some numbers in front of them that can be debated about... Then they seem to care intently and want to fix the model 😂
It is so true that data models become more interesting when the actual numbers are involved. Glad our process helped and that you enjoyed the episode! Let us know if there is anything else you would like us to cover.
@@thedashboardeffectpodcast Landon mentioned a single-copy Fabric data architecture via shortcuts that sounded interesting.
I'm imagining raw source files are loaded into Delta tables in a Bronze lakehouse and then referenced via shortcuts into SQL views in Silver/Gold virtual layers, so an "ELT" approach. I haven't seen many reference designs using Fabric yet so I'm curious to hear more about that and what performance tradeoffs you've encountered. Or is he referring only to using shortcuts between Bronze and upstream source files?