Chevron Left
Retour à Data Warehouse Concepts, Design, and Data Integration

Avis et commentaires pour d'étudiants pour Data Warehouse Concepts, Design, and Data Integration par University of Colorado System

1,013 évaluations

À propos du cours

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

Meilleurs avis


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


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

Filtrer par :

151 - 175 sur 199 Avis pour Data Warehouse Concepts, Design, and Data Integration

par Gerardo E S R

2 mai 2017

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

par Jahanzaib M

2 oct. 2017

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

par Sawan V

23 juin 2021

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

par Sai S G

21 janv. 2016

Excellent structure of the course and very interesting

par Paolo F

4 mars 2018

High quality info for a well structured course


4 nov. 2019

It's a nice opportunity to learn and

par Shivam S

21 juin 2017

Nice Lectures Documentations Overall

par Vinay B

4 janv. 2016

Great course to learn DWH concepts.

par MIRASOL, S R (

29 oct. 2020

Hard course but was worth it.

par vaibhav b

25 déc. 2016

The course was very helpful

par Lin Y

26 mai 2016

useful information

par Mugdha G

25 févr. 2019

Good course!

par Santosh R

6 oct. 2016

Great course

par Dushyant S

18 janv. 2019

Good course

par Jair F L M

30 nov. 2018

Good course

par Nikhil n

26 juil. 2017


par Haripriya C

9 mars 2022


par karthik D

23 janv. 2019


par Minas-Marios V

17 oct. 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!

par Jason L

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

par Dragana S

13 nov. 2017

Really short lessons, and usually half of lesson is spent on introduction and talking about what will be in the lesson. Nevertheless, course is focused on theory, rather than the practice. I think it should be more detailed and with more practical assignments.

par Linda S

4 oct. 2016

Well organized lectures but the documentation is full of errors. This in combination with the lack of response on the a lack of responsiveness on the forums might make this class frustrating for some.

par Tom C

19 mars 2016

This course needs a cleanup of loose ends on some of the assignments. Some assignment requirements are very ambiguous and in some cases the solutions are not matching the requirements of what was due.

par srinivas

4 mars 2016

Real world data warehouse integrations are more complex than just inner joining the tables to drop those rows not found in the original tables. i wish more complex scenarios are covered.

par Shalmoli N

8 juin 2020

Assignments are very good, in fact excellent, but the material could be a bit more descriptive. And the practice exercise of assignment 5 had lots of discrepancy with the actual