数据仓库的概念、设计与数据整合

Data Warehouse Concepts, Design, and Data Integration

本课程是Data Warehousing for Business Intelligence专项课程的其中一门课程(共 5 门课程)

科罗拉多大学系统

Coursera

计算机

难(高级)

19 小时

课程概况

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

你将学到什么

Extraction, Transformation And Loading (ETL)

Pentaho

Data Integration

Data Warehouse

课程大纲

周1
完成时间为 4 小时
Data Warehouse Concepts and Architectures
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.
8 个视频 (总计 53 分钟), 15 个阅读材料, 1 个测验

周2
完成时间为 7 小时
Multidimensional Data Representation and Manipulation
Now that you have the informational context for data warehouse development, you’ll start using data warehouse tools! In module 2, you will learn about the multidimensional representation of a data warehouse used by business analysts. You’ll apply what you’ve learned in practice and graded problems using WebPivotTable or Pivot4J, open source tools for manipulating pivot tables. At the end of this module, you will have solid background to communicate and assist business analysts who use a multidimensional representation of a data warehouse.
7 个视频 (总计 45 分钟), 9 个阅读材料, 2 个测验

周3
完成时间为 4 小时
Data Warehouse Design Practices and Methodologies
This module emphasizes data warehouse design skills. Now that you understand the multidimensional representation used by business analysts, you are ready to learn about data warehouse design using a relational database. In practice, the multidimensional representation used by business analysts must be derived from a data warehouse design using a relational DBMS.You will learn about design patterns, summarizability problems, and design methodologies. You will apply these concepts to mini case studies about data warehouse design. At the end of the module, you will have created data warehouse designs based on data sources and business needs of hypothetical organizations.
6 个视频 (总计 47 分钟), 8 个阅读材料, 2 个测验

周4
完成时间为 2 小时
Data Integration Concepts, Processes, and Techniques
Module 4 extends your background about data warehouse development. After learning about schema design concepts and practices, you are ready to learn about data integration processing to populate and refresh a data warehouse. The informational background in module 4 covers concepts about data sources, data integration processes, and techniques for pattern matching and inexact matching of text. Module 4 provides a context for the software skills that you will learn in module 5.

声明:MOOC中国发布之课程均源自下列机构,版权均归他们所有。本站仅作报道收录并尊重其著作权益,感谢他们对MOOC事业做出的贡献!(排名不分先后)
  • Coursera
  • edX
  • OpenLearning
  • FutureLearn
  • iversity
  • Udacity
  • NovoEd
  • Canvas
  • Open2Study
  • Google
  • ewant
  • FUN
  • IOC-Athlete-MOOC
  • World-Science-U
  • Codecademy
  • CourseSites
  • opencourseworld
  • ShareCourse
  • gacco
  • MiriadaX
  • JANUX
  • openhpi
  • Stanford-Open-Edx
  • 网易云课堂
  • 中国大学MOOC
  • 学堂在线
  • 顶你学堂
  • 华文慕课
  • 好大学在线CnMooc
  • 以及更多...

© 2008-2018 MOOC.CN 慕课改变你,你改变世界