Chevron Left
Zurück zu Data Warehouse Concepts, Design, and Data Integration

Data Warehouse Concepts, Design, and Data Integration, University of Colorado System

4.4
737 Bewertungen
142 Bewertungen

Über diesen Kurs

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

von EK

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.

von MH

Dec 13, 2016

Good learning for Data integration and ETL learning. How data from source to target table transform over the business requirement to be ready for processing

Filtern nach:

131 Bewertungen

von Jake Schroeder

May 21, 2019

Some very difficult exercises and the instruction was sometimes too abstract, but overall I feel I learned a lot.

von Mayank Maheshwari

May 19, 2019

very good course, after the course u will have a good understanding and grasp of data warehousing concept

von Søren Vilhelmsen

May 18, 2019

Great course :)

von Revanth Kota

Apr 04, 2019

Great Hands on experience!!

von Nasheena

Apr 03, 2019

Excellent course, you will learn how to use data warehouse tools, you will gain design experience and have organisational context to work in data warehouse development projects. My experience from this course is you need to be quite dedicated to pass.

von Talha Turan

Mar 05, 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.

von Mugdha Govilkar

Feb 25, 2019

Good course!

von 백승원

Feb 24, 2019

Great lecture for DW/BI

von Danielle Bourgondien

Feb 07, 2019

The course is very informative, but you have to work with a very slow website for an assignment and you need to install applications which are a lot of hassle and will cost you a lot of time. I still cannot get an application to work to finish the last assignment. Too bad for all the effort I put in so far and very frustrating.

von saumya

Jan 28, 2019

Excellent