In this video blog post I covered the serving layer step of building your Modern Data Warehouse in Azure. There are certainly some decisions to be made around how you want to structure your schema as you get it ready for presentation with whatever your business intelligence tool of choice, for this example I used Power BI, so I discuss some of the areas you should focus on:
- What is your schema type? Snowflake or Star, or something else?
- Where should you serve up the data? SQL Server, Synapse, ADLS, Databricks, or Something Else?
- What are your Service level agreements for the business? What are your data processing times?
- Can you save cost by using an option that’s less compute heavy?