Dimensional modelling for Data Warehouse. A data warehouse is a large and complex data set. To be successful, you need to identify the objects, months, days, hours, etc., in the data set and model them using Dimensional modelling. This guide will teach you how to do Dimensional modelling for the first time. You will also understand facts and dimensions. Differences between star and snowflake schema design. Advantages and disadvantages of star and snowflake design. Performance of data warehouse and tuning tips. Differences between data warehouse and data lake. Detailed information about data mining and data marts. >>END. Introduction to Dimensional modelling 1) What is a data warehouse? 2) How is Dimensional modelling used in data stores? 3) Its advantages and disadvantages? 4) How does Dimensional modelling be used for data mining? 5) How does Dimensional modelling help in meeting goals of data stores? 6) Disadvantages of star and snowflake schema design? 7) How can you use...
Technology Blog by Rohan Suresh