Chevron Left
Back to Data Warehouse Concepts, Design, and Data Integration

Learner Reviews & Feedback for Data Warehouse Concepts, Design, and Data Integration by University of Colorado System

4.4
stars
1,033 ratings

About the Course

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...

Top reviews

KP

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.

LS

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.

Filter by:

151 - 175 of 204 Reviews for Data Warehouse Concepts, Design, and Data Integration

By Dimitris P

Apr 8, 2017

It's a great course, with quality content. But I would like to see more practice videos for the tools.

By Rahat A S

Feb 8, 2016

Good course. Give basic concept and practical experience in data cube designing and data integration.

By Marek P

Sep 3, 2016

Great look to the integration problems, drawing and theoretical exercises was not as good.

By Jayadev A

Aug 18, 2021

Great course, however it would be nice if the confusion of Pivot4J was addressed properly.

By Sagar T

May 1, 2016

Week 3 wasn't taught well. And the assignment was too difficult. Other weeks were fine.

By Gerardo E S R

May 2, 2017

A lot of content...great concepts I hope we review a lot of this things in course 3

By Jahanzaib M

Oct 2, 2017

It helped me a lot in understanding data warehouse and data integration concepts

By Sawan V

Jun 23, 2021

Wish the optional reading had a free option or an alternate book

By Sai S G

Jan 21, 2016

Excellent structure of the course and very interesting

By Paolo F

Mar 4, 2018

High quality info for a well structured course

By PUNEETH M K

Nov 4, 2019

It's a nice opportunity to learn and

By Shivam S

Jun 21, 2017

Nice Lectures Documentations Overall

By Vinay B

Jan 4, 2016

Great course to learn DWH concepts.

By MIRASOL, S R (

Oct 29, 2020

Hard course but was worth it.

By Vaibhav B

Dec 25, 2016

The course was very helpful

By Lin Y

May 26, 2016

useful information

By Mugdha G

Feb 25, 2019

Good course!

By Santosh R

Oct 6, 2016

Great course

By Dushyant S

Jan 18, 2019

Good course

By Jair F L M

Nov 30, 2018

Good course

By Nikhil n

Jul 26, 2017

excellent

By Haripriya C

Mar 9, 2022

Good

By karthik D

Jan 23, 2019

good

By Minas-Marios V

Oct 17, 2020

This course has plenty room for improvement. On one hand, it provides a good understanding of the different data warehousing architectures and design principles, an essential foundation to anyone interested in the field. The material on data integration is also excellent, along with the associated assignment. On the other hand, the peer-graded assignment on data warehousing design is very demanding and isn't clearly described from the lectures and practice problems what the students ought to do to get a perfect grade. Installing the software and getting it to work is also a skill on its own, but it truly is something that a professional will encounter in their work!

By Jason L

May 7, 2016

Pros: Information is perfect for anyone looking at Business Intelligence as a career field, or already in the career field itself. I found the first week to challenge my on-the-job knowledge of a fuller set of concepts and general terminology.

Cons: The wording on the quiz questions, in some cases, seems much different than the PPT slides and the instructor's language. UPDATE: The wording is a significant challenge, even when advancing into the more complex topics. I have had many differences of opinions on the solutions based on wording in the requirements.