返回到 Data Warehouse Concepts, Design, and Data Integration
University of Colorado System

Data Warehouse Concepts, Design, and Data Integration

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. In the data integration assignment, you can use either Oracle, MySQL, or PostgreSQL databases. 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

状态:Extract, Transform, Load
状态:Data Transformation
课程小时

精选评论

EG

4.0评论日期:May 31, 2016

Pretty nice course, although installation and pre-requisites could use a higher note before installing since there would be a couple of tries before getting them working.

SJ

5.0评论日期:Apr 12, 2017

I enjoyed learning this material and found that the Pentaho Kettle hands-on experience was a nice additional to skill set that I can provide my clients.

NM

5.0评论日期:Jan 22, 2016

This is a very well-structured and demanding course with an excellent professor.I'm looking forward to finishing the entire specialization!

AM

5.0评论日期:Jun 11, 2017

A great hands-on introduction to Pentaho. Gave me a very good insight into the capabilities of the product. I will start using the tool at work.

MH

5.0评论日期:Dec 12, 2016

Good learning for Data integration and ETL learning. How data from source to target table transform over the business requirement to be ready for processing

EK

5.0评论日期:Dec 15, 2015

Very nice class, well thought out and organized. The assignments are interesting and the practice assignments are relevant. Getting hands on on Pentaho was a big plus.

DL

4.0评论日期:Oct 28, 2021

Great introduction to DW concepts! Assignments are a little tedious and quizzes ask trivia questions sometimes but overall a solid syllabus.

HD

4.0评论日期:Jan 15, 2016

Solid class overall, however video lectures do not provide enough background info to complete some of the assignments. Expect to spend much more time than the estimated 30 mins to complete.

LS

5.0评论日期:Sep 18, 2020

Great course. It mimics real life case. However, the time required to complete assignments is much more than stated. The assignments are great though, I learned a lot from those.

DA

4.0评论日期:May 26, 2019

Very Well Explained and Guided Course. Pivot4j and web pivot tables have undergone some changes so an update might be required.

CV

4.0评论日期:Mar 23, 2020

Good course, good explanations.The assignments were good and instructive, but too many with respect to the length of the course.

KP

5.0评论日期:Jun 9, 2021

I liked the quality of lectures. Exceptional meterials to undrstand classic ETL/ELT process in a nutshell. I used this course to get basic knowledge on this thing before an interview.

所有审阅

显示:20/208

Nils Klann
1.0
评论日期:Nov 16, 2017
Sebastian Gläß
2.0
评论日期:Jan 2, 2017
Александр Карабельников
3.0
评论日期:Nov 10, 2018
Gavin
1.0
评论日期:Nov 9, 2019
Sujay Shah
1.0
评论日期:Jan 18, 2018
Deleted Account
2.0
评论日期:Aug 19, 2017
Mesum Raza Hemani
5.0
评论日期:Dec 13, 2016
Peter Vlasveld
3.0
评论日期:Oct 11, 2020
Esteban Rodas
4.0
评论日期:Oct 1, 2019
Nikos Simos
3.0
评论日期:May 29, 2022
John Pas
3.0
评论日期:Oct 19, 2020
Nelson Fleig
5.0
评论日期:Aug 24, 2018
John Fitzpatrick
5.0
评论日期:Feb 20, 2016
Robert Leon Johnson
5.0
评论日期:Mar 5, 2016
Montana Films RD
5.0
评论日期:Mar 25, 2016
Jose A
5.0
评论日期:Jun 12, 2017
Felix Munyoki
5.0
评论日期:Aug 1, 2017
Sherri Julien
5.0
评论日期:Apr 13, 2017
Gokay Bascillar
4.0
评论日期:Dec 13, 2021
William Jones
4.0
评论日期:Feb 8, 2021