Back to 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

Status: Business Intelligence
Status: Database Design
Course62 hours

Featured reviews

AM

5.0Reviewed Jun 12, 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.

DL

4.0Reviewed Oct 29, 2021

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

AN

5.0Reviewed May 30, 2016

For me this course is one of the most important in BI. We had good teachers that helped us to understand the important issues.

MR

5.0Reviewed Mar 26, 2016

Excellent course in the way of preparation to be a Expert in Business Intelligence and Data Warehouses.100 % recommended!

ST

4.0Reviewed Aug 8, 2016

I love open source tools description. It is really good designed course to refresh your basic. Good job from instructor side to make this course enjoyable.

KP

5.0Reviewed Jun 10, 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.

EK

5.0Reviewed Dec 16, 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.

TT

4.0Reviewed Mar 5, 2019

The course could be less-detailed. Besides open source ETL tools, other big players (e.g. Informatica, SAP DI, etc.) should be mentioned as well.

NM

5.0Reviewed Jan 23, 2016

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

LS

5.0Reviewed Sep 19, 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.

SJ

5.0Reviewed Apr 13, 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.

JA

5.0Reviewed Jun 12, 2017

I've learned lots from this course. I highly recommend it if you want to learn the concepts behind data warehouses.

All reviews

Showing: 20 of 208

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