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

955 ratings
192 reviews

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

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.

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.

Filter by:

76 - 100 of 182 Reviews for Data Warehouse Concepts, Design, and Data Integration

By Guillermo A A N

Mar 28, 2016

Excelente material

By Sebastian O M

Nov 21, 2015

Excelente Curso!!!

By Harni S

May 31, 2016

very good course

By Rodolfo B d S

Apr 8, 2016

Very good course

By André L B

Feb 28, 2016

Excelent course.

By Søren V

May 18, 2019

Great course :)

By Daniel M

Jan 3, 2016

Excelente curso


Jun 15, 2017

awesome course


Aug 26, 2020

great course.

By Alejandro R

Mar 20, 2016


By Ashish G

Jan 3, 2019

good course

By Andrés P

Apr 10, 2017


By karthik

Jun 15, 2016

ThankYou :)


Jun 2, 2016

Nice course

By saumya

Jan 28, 2019


By Maneesha R

Dec 18, 2018

very good


Jun 19, 2017


By Artem A

Apr 14, 2016


By Deleted A

Aug 26, 2021



Nov 3, 2020


By Ledon L

Feb 8, 2016


By Michael F

Dec 27, 2015


By Benjamin S

Aug 1, 2019

Good stuff. Not necessarily a beginner course...configuration of the required software packages requires some work and knowledge, but Mr. Mannino does the best job possible of explaining how that should work in most cases. Installing an Oracle SQL server on the local machine is tricky to get right, but the VirtualBox "Developer Day" package is easier, though requires a little work in, I would say no problem for beginners if there is some background in development or multi-OS support. Otherwise, prepare to spend some extra time learning. Was well worth it for me!

By Stefan K

Dec 28, 2015

Very nice introduction to databases and data warehouses. The lectures are not very engaging, the plus is there are practical assignments for every week, where you learn the most. First you submit your own solution and then you provide feedback to your peers. I like the format of the assignments. What I dislike (giving 4 stars instead of 5) is difficulty in setting up the environment for assignments to complete - it took me longer just to properly install the software needed for assignments 2 and 5 than to work out the assignments. The lectures could be also improved.

By Gerrit S D

Mar 22, 2016

quite challenging, high paced lectures. It seems like an easy course because the lectures are quite brief, but make no mistake, there is no repeating of concepts or endless bla bla. To succeed in the assignments one is very likely to watch lectures again. Without any previous knowledge in this subject it is almost impossible to grasp everything by just watching the videos due to the new vocabulary and the information density. The assignments definetly take more time than indicated.