Data Warehouse Concepts, Design, and Data Integration

开始时间: 04/22/2022 持续时间: Unknown

所在平台: CourseraArchive

课程类别: 其他类别

大学或机构: CourseraNew




第一个写评论        关注课程


This is the second course in the Data Warehousing for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will learn exciting concepts and skills for designing data warehouses and creating data integration workflows. These are fundamental skills for data warehouse developers and administrators. You will have hands-on experience for data warehouse design and use open source products for manipulating pivot tables and creating data integration workflows.You will also gain conceptual background about maturity models, architectures, multidimensional models, and management practices, providing an organizational perspective about data warehouse development. If you are currently a business or information technology professional and want to become a data warehouse designer or administrator, this course will give you the knowledge and skills to do that. By the end of the course, you will have the design experience, software background, and organizational context that prepares you to succeed with data warehouse development projects. In this course, you will create data warehouse designs and data integration workflows that satisfy the business intelligence needs of organizations. When you’re done with this course, you’ll be able to: * Evaluate an organization for data warehouse maturity and business architecture alignment; * Create a data warehouse design and reflect on alternative design methodologies and design goals; * Create data integration workflows using prominent open source software; * Reflect on the role of change data, refresh constraints, refresh frequency trade-offs, and data quality goals in data integration process design; and * Perform operations on pivot tables to satisfy typical business analysis requests using prominent open source software

数据仓库的概念,设计和数据集成:这是商业智能数据仓库专业中的第二门课程。理想情况下,课程应按顺序进行。 在本课程中,您将学习有关设计数据仓库和创建数据集成工作流的令人兴奋的概念和技巧。 这些是数据仓库开发人员和管理员的基本技能。您将拥有数据仓库设计的实践经验,并使用开源产品来操作数据透视表和创建数据集成工作流。还将获得有关成熟度模型,体系结构,多维模型和管理实践的概念背景,从而提供有关以下方面的组织观点:数据仓库开发。如果您当前是企业或信息技术专业人士,并且想成为数据仓库设计师或管理员,那么本课程将为您提供知识和技能。在课程结束时,您将拥有设计经验,软件背景和组织背景,为您成功进行数据仓库开发项目做准备。 在本课程中,您将创建满足组织业务智能需求的数据仓库设计和数据集成工作流。完成本课程后,您将能够:    *评估组织的数据仓库成熟度和业务架构一致性;    *创建数据仓库设计,并考虑替代设计方法和设计目标;    *使用著名的开源软件创建数据集成工作流;    *反映更改数据,刷新约束,刷新频率折衷和数据质量目标在数据集成过程设计中的作用;和    *使用出色的开源软件对数据透视表执行操作,以满足典型的业务分析要求


Module 1 introduces the course and covers concepts that provide a context for the remainder of this course. In the first two lessons, you’ll understand the objectives for the course and know what topics and assignments to expect. In the remaining lessons, you will learn about historical reasons for development of data warehouse technology, learning effects, business architectures, maturity models, project management issues, market trends, and employment opportunities. This informational module will ensure that you have the background for success in later modules that emphasize details and hands-on skills.You should also read about the software requirements in the lesson at the end of module 1. I recommend that you try to install the software this week before assignments begin in week 2.



This is the second course in the Data Warehousing for Business Intelligence specialization. Ideally,