Data Warehouse Schemas- Star, Snowflake, Fact Constellation | Lecture #11 | Data Warehouse Tutorial

Описание: In this tutorial we are going to discuss about what is Schemas in Data Warehouse along with its different types such as Star Schema, Snowflake Schema, Fact Constellation Schema (Galaxy Schema) with their architecture, advantages and disadvantages.

In the last topic we have covered what is Multidimensional OLAP as well as Relational OLAP, their definition, important points to remember, advantages, disadvantages along with their differences (Multidimensional OLAP vs Relational OLAP) with some simple examples.



Data Warehouse full course playlist-
   • Data Warehouse Full Course  


A data warehouse is collection of organizational data used to help an organization to make important decisions and improve business.


We will be covering all the Data Warehouse concepts with easy to understand tutorials which will help you master conceptual knowledge of Data Warehousing.


But first, you should be aware of Structured Query Language (SQL) which we have already covered. Please find the link for FULL COURSE OF SQL.



SQL Full Course Playlist-
   • SQL Full Course  




PYTHON Full Course Playlist-
   • Python Full Course  


Description
AmpCode provides you e-learning platform with a mission of making education accessible to every student. AmpCode will provide you tutorials, full courses of some of the best technologies in the world today.

By subscribing to this channel, you will never miss out on high quality videos on trending topics in the areas of Big Data & Hadoop, DevOps, Machine Learning, Artificial Intelligence, Angular, Data Science, Apache Spark, Python, Selenium, Tableau, AWS , Digital Marketing and many more


#data_warehouse #data_warehouse_tutorial #data_warehouse_architecture
#database #sql #data_analytics #data_science #schemas