|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-data-warehousing-from-solution-architect/
课程评论：没有评论
**课程名称：** 从零开始学习数据仓库 — 来自解决方案架构师 **课程概述：** 本课程旨在帮助您掌握数据仓库的核心概念，并逐步成为一名经验丰富的专家。您将从解决方案架构师的视角，深入了解数据仓库项目的实施细节。课程内容涵盖从商业挑战、商业智能的必要性，到数据仓库的定义、行业应用及典型BI环境。 **核心概念：** * **OLTP vs OLAP：** 理解联机事务处理和联机分析处理的区别。 * **ODS, Data Marts：** 学习操作数据存储和数据市场的概念。 * **ETL：** 掌握数据抽取、转换和加载的流程。 * **Facts, Dimensions, SCD：** 深入理解事实、维度以及缓慢变化维度（SCD）的设计。 * **Surrogate Keys, Factless-Fact：** 学习代理键和无事实事实表的应用。 **两大主流思想：** * **Ralph Kimball 方法：** 了解星型模型、雪花模型的设计，以及总线架构和示例数据模型。 * **Bill Inmon 方法：** 学习第三范式设计，CIF 架构和示例数据模型。 **重点内容：** * **数据仓库应用：** 探讨数据仓库在各行业的应用。 * **数据仓库设备：** 介绍 Teradata、Netezza、Exadata 等主流数据仓库设备。 * **大数据：** 解释大数据的概念（4 V’s），以及大数据在BI领域的应用。 * **Hadoop：** 介绍 Hadoop，及其在大数据仓库中的作用，并提供 Hadoop 发行版的比较。 * **NoSQL：** 讲解 NoSQL 概念、SQL vs NoSQL 的区别以及不同类型的 NoSQL 数据库。 * **主要 BI 供应商：** 了解业界主要的商业智能供应商。 **课程特色：** * 提供 Hadoop 发行版比较表，帮助您根据各项参数选择合适的 Hadoop 发行版。 * 基于12年英国数据仓库项目实施经验，传授成功的项目实施精髓。 * 适合希望从零开始理解数据仓库基础知识，并渴望加入大数据革命的新手。 * 目标是通过扎实的教学，让学习者最终成为数据仓库领域的专家。 **加入我们，开启您的数据仓库专家之路！**
***** Added Hadoop Distributions Comparison sheet to let you choose the right Hadoop distribution based on several Parameters. ***** Do you want to master in Data warehousing, keen to become an expert ? Me being worked on several Data Warehousing implementation projects in last 12 years here in UK. I will give you the grain of what's needed to implement a successful Data Warehouse project. We've heard it all, big data and the intelligence to understand these chunks of data. Most persons have to start from scratch or meet mid-way to become an expert in business Intelligence domain. Course is meant for someone who wants to understand fundamentals of DW and various architectural pieces around it and eventually become a part of big data revolution. This course is built to get you the grain of the subject and give you what is essential for newbie to eventually become an expert at the end of the course. Come and Join the journey!! Course Highlights Introduction Business Challenge?Need for Business IntelligenceDefine Data warehouseIndustry UsingData warehousingTypical BI environment Data Warehousing Concepts OLTP ,OLAPODS, Data MartsETLFacts, Dimensions, SCDSurrogate Keys, Factless-Fact Two Major school of thoughts Are they at war ?Understand mythCase Studies Ralph Kimball How to design Start Schema, Snow FlakeBus ArchitectureSample Data ModelsBill Inmon How to design 3rd Normal FormCIF ArchitectureSample Data Models Data Warehouse Appliances TeradataNetezzaExadata Big Data What's the Buzz wordWhat are 4 V'sUnderstand Big Data in BI termsMajor Player What is HadoopHadoop in DW worldExample - Architecture NoSQl What it isSQL VS NoSQL Types of NoSQL DB's Major BI Vendors Wish you all the very best!
