Structure of a Data Warehouse

In the previous segment, you learnt about the basic concepts of data warehousing. Now, one of the primary methods of designing a data warehouse is dimensional modelling.

The two key elements of dimensional modelling include facts and dimensions, which are basically the different types of variables that are used to design a data warehouse. They are arranged in a specific manner, known as a schema diagram.So, in the following video, you will learn more about facts and dimensions.

So, essentially, facts are the numerical data in a data warehouse and dimensions are the metadata (that is, data explaining some other data) attached to the fact variables. Both facts and dimensions are equally important for generating actionable insights from a data set.

So, you have learnt about the structure of the data warehouse. In the next segment, you will get the idea about the star schema but before that let’s solve some topic related MCQs.

Report an error