Understand the basic difference between Measures/Facts and Attributes. Also learn the types of Facts/Measures available in Data Warehouse and how to differentiate between them.
If you missed the First Part of the video, check out — https://subhamkharwal.medium.com/data-warehouse-series-measures-attributes-part-i-529c6a78f287
Checkout the YouTube video to under with various examples
Please make sure to Like and Subscribe.
Checkout the Data Warehouse playlist on YouTube: https://youtube.com/playlist?list=PL2IsFZBGM_IE-EvpN9gaZZukj-ysFudag
Follow the EaseWithData YouTube Channel : https://www.youtube.com/@easewithdata
Follow my Personal blog: https://urlit.me/blog/
Understand the basic difference between Measures/Facts and Attributes. Also learn the types of Facts/Measures available in Data Warehouse.
Checkout the YouTube video to under with various examples
Please make sure to Like and Subscribe.
Checkout the Data Warehouse playlist on YouTube: https://youtube.com/playlist?list=PL2IsFZBGM_IE-EvpN9gaZZukj-ysFudag
Follow the EaseWithData YouTube Channel : https://www.youtube.com/@easewithdata
Follow my Personal blog: https://urlit.me/blog/
Understand the basic difference between ETL & ETL tools and in depth understanding of the different data loading strategies used for managing data warehouse.
Checkout the YouTube video to under with various examples
Please make sure to Like and Subscribe.
Checkout the Data Warehouse playlist on YouTube: https://youtube.com/playlist?list=PL2IsFZBGM_IE-EvpN9gaZZukj-ysFudag
Follow the EaseWithData YouTube Channel : https://www.youtube.com/@easewithdata
Follow my Personal blog: https://urlit.me/blog/
Introduction to OLAP system and describes why OLAP systems are used for Analytical queries?
Also explains the difference between OLTP and OLAP system.
Checkout the YouTube video to under with various examples
Please make sure to Like and Subscribe.
Checkout the Data Warehouse playlist on YouTube: https://youtube.com/playlist?list=PL2IsFZBGM_IE-EvpN9gaZZukj-ysFudag
Understand the basic difference between Data Lake vs Data Warehouse vs Data Mart.
Also look into the working of an OLTP (Online Transactional Processing) System, to understand how its different from Analytical Systems.
Checkout the YouTube video to under with various examples
Please make sure to Like and Subscribe.
Follow the EaseWithData YouTube Channel : https://www.youtube.com/@easewithdata
Follow my Personal blog: https://urlit.me/blog/
A Data Warehouse is a large, centralized repository of data that is specifically designed to support business intelligence (BI) activities, such as reporting, online analytical processing (OLAP), and data mining.
Data warehouses are typically used to store historical data, which can be analysed to gain insights and make informed decisions. The data in a data warehouse is typically organized in a way that makes it easy to retrieve and analyse, such as through the use of a star or snowflake schema.
Checkout the following YouTube video to understand in Simple terms with examples:
Please make sure to Like and Subscribe.
Follow the EaseWithData YouTube Channel : https://www.youtube.com/@easewithdata
Follow my Personal blog: https://urlit.me/blog/