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,039 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:

201 - 206 of 206 Reviews for Data Warehouse Concepts, Design, and Data Integration

By Daniel X

•

Mar 8, 2018

Too academic, maybe normal for a University course. But really not a practical course for someone wanting to pick up the knowledge or skills. even though BI is a big concept. The tools are not very popular in the market, either highly enterprised Oracle or free tools. Really, those tools are good for doing a few excercise or playing some BI games.

By Fulvio C

•

Apr 14, 2020

This training course will drain your time on installing some freeware software instead focusing on make you acquire database skills. I waisted more than two weeks reading outdated guidelines. Save your time and avoid it

By Thomas L

•

Jan 14, 2018

totally unsufficient guidance on external tools needed. Forum is full of users asking for help and reporting problems with installation of neccessary software.

By Alexander K

•

Aug 29, 2019

I feel like the courses were shot in 1999.

By Win

•

Jun 8, 2020

So many mismatch subtitle

By LeoZhang

•

Dec 24, 2015

DULL