Chevron Left
返回到 数据仓库的概念、设计与数据整合

學生對 科罗拉多大学系统 提供的 数据仓库的概念、设计与数据整合 的評價和反饋

4.4
867 個評分
171 條評論

課程概述

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

熱門審閱

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.

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

篩選依據:

101 - 数据仓库的概念、设计与数据整合 的 125 個評論(共 160 個)

創建者 Zafir S

May 22, 2020

Great course overall! Some of the assignments were quite challenging, and it would have been more beneficial to have some guided tutorial videos to assist with some key concepts that weren't previously taught.

創建者 Uche G E

Jul 11, 2020

I enjoyed this course. I learnt a lot. My main difficulties were in navigating the installation of the softwares. I think a lot more has to be done to make the software navigation process a lot easier.

創建者 Justin K

May 27, 2020

Great course! The only issue, and the reason for 4 starts instead of 5, is that (1) the integration software was hard to install and get working correctly and (2) the course materials are out of date.

創建者 Matthew P L

Jun 12, 2017

Excellent instructor, content and application of tools. Written instructions can be over-wordy on unimportant instruction and confusing, but so is the nature of the state of data warehousing.

創建者 Emmanouil M

Jun 17, 2020

The course was very good but it felt a little rushed in the middle. There should be some more examples and explanation In the Data Warehouse design section. Overall great quality of material

創建者 Hadrien D

Jan 16, 2016

Solid class overall, however video lectures do not provide enough background info to complete some of the assignments. Expect to spend much more time than the estimated 30 mins to complete.

創建者 André G L

Mar 29, 2020

A great starting course for the subject of Data Warehouse, I was already practicing on the career and it was valuable to me to strenghten my core and learn new things along the way.

創建者 MAURICIO Q

Mar 08, 2016

I think this course is great, however weeks 2 and 3 should be restructured to ensure students acknowledge topics properly. I had a bad time solving those week's asignments.

創建者 Emilio M N G

Jun 01, 2016

Pretty nice course, although installation and pre-requisites could use a higher note before installing since there would be a couple of tries before getting them working.

創建者 Salil T

Aug 08, 2016

I love open source tools description. It is really good designed course to refresh your basic. Good job from instructor side to make this course enjoyable.

創建者 Talha T

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.

創建者 Claudio V

Mar 24, 2020

Good course, good explanations.

The assignments were good and instructive, but too many with respect to the length of the course.

創建者 Danish A

May 27, 2019

Very Well Explained and Guided Course. Pivot4j and web pivot tables have undergone some changes so an update might be required.

創建者 Suman O

May 23, 2017

Good introductory course. It is suitable for business analysts and folks getting started on their analytics journey.

創建者 Jake S

May 21, 2019

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

創建者 karandeep h

Feb 06, 2016

This course was not better than the first course. Not too much of practical included and mainly theoretical

創建者 Georgina T

May 29, 2017

This was a great course, but the software installation steps took a lot of my time for the assignments

創建者 Dimitris P

Apr 08, 2017

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

創建者 Rahat A S

Feb 08, 2016

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

創建者 Marek P

Sep 03, 2016

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

創建者 Sagar T

May 01, 2016

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

創建者 Gerardo E S R

May 02, 2017

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

創建者 Jahanzaib M

Oct 02, 2017

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

創建者 sai

Jan 21, 2016

Excellent structure of the course and very interesting

創建者 Paolo F

Mar 04, 2018

High quality info for a well structured course