What is star and snowflake schemas in data analysis?
star schema in data analysis In this article, we will take a close look at the star schema and also touch upon the related snowflake schema when it comes to modeling data for Power BI. And while doing so, we will explore the topics of fact and dimension tables. And to understand this, we will need to make use of an example. Well, for that, let's consider this table containing sales transactions for various restaurants which are part of a restaurant chain. The first column is a Restaurant ID, and you'll see here that restaurants 1 and 2, each have recorded a single transaction here, but there are two transactions recorded for restaurant 3. The table also records the customer who made the purchase, the date of the transaction, and also the total bill amount. In a star or snowflake schema, this can be considered a fact table. Understanding fact tables and aggregations: So what exactly is a fact table? Well, you can think of this as one which contains data with regards to a freq...