|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/modeling-data-warehouse-with-data-vault-for-beginners/
课程评论:没有评论
课程摘要:数据金仓建模与数据仓库 2.0 本课程“数据金仓建模与数据仓库 2.0”将深入探讨由丹·林斯特德(Dan Linstedt)创造的创新数据建模技术——数据金仓(Data Vault)。该技术旨在简化来自多个来源的数据集成,提供审计能力和设计灵活性,以应对来自异构信息系统的数据,满足现代商业的各种需求。课程内容不仅涵盖数据建模的基础知识,为学员介绍核心概念,还有传统数据仓库方法的基本原理。 参与者将了解到目前在使用3NF或星型模式数据仓库时所面临的诸多问题及挑战,并学习数据金仓如何有效解决这些问题,提供创新的解决方案。课程的重点包括: 1. **数据金仓建模基础**:从核心概念到高级主题,涵盖架构和关键优势。 2. **模型结构**:深入理解Hubs(枢纽)、Links(链接)和Satellites(卫星)的建模方法。 3. **架构层次**:掌握数据金仓2.0的不同架构和建模层次,包括商业金仓和信息金仓,以及维度层的重要性。 4. **建模方法**:了解在何时使用3NF、维度模型或数据金仓。 5. **加载模式与架构**:学习如何处理数据金仓模型中的架构和粒度变化。 6. **敏捷方法论**:认识在可扩展数据仓库中敏捷方法的重要性。 7. **大数据术语**:对大数据相关术语及数据金仓方法论进行熟悉。 课程还包含一个实践案例研究,以帮助参与者熟悉原则和概念。通过本课程,学员将具备建设高效、灵活的数据仓库所需的知识和技能。
Data Vault is an innovative modeling technique invented by Dan Linstedt to simplify data integration from multiple sources, offers auditability and design flexibility to cope with data from the heterogeneous information systems which supports most business demands todayIt is designed to deliver an Enterprise Data Warehouse while solving many of the drawbacks of the 3NF (Inmon) and Dimensional Modelling(Kimball).In this course, you will Learn the basics of Data Modelling to become familiar with core conceptsUnderstand the fundamentals of traditional Data Warehouse approachesLearn many of today's Data Warehousing problems and issues with 3NF or Star SchemaUnderstand how Data Vault addresses these challenges and provide an innovative approachLearn the fundamentals of the Data Vault modeling approach from core concepts to advanced, and from architecture to key benefits Learn how to effectively model Hubs, Links and SatellitesUnderstand DV Modeling constructs in detailUnderstand the different architectural and modeling layers of DV 2.0Learn Business Vault, Information Vault and significance of Dimensional LayerUnderstand where to use 3NF, Dimensional Model or Data VaultUnderstand loading patterns and architectureLearn how to handle schema and grain changes on the Data Vault modelLearn why Agile Methodology is important for scalable Data Warehouses Get familiar with Big Data Terminologies along with Data Vault Methodology It also contains a hands-on case study to get participants familiar with the principles and concepts Footnote: Automatically created subtitles are corrected!