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

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

4.4
786 個評分
152 個審閱

課程概述

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

熱門審閱

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

篩選依據:

76 - 数据仓库的概念、设计与数据整合 的 100 個評論(共 141 個)

創建者 Søren V

May 18, 2019

Great course :)

創建者 Mayank M

May 19, 2019

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

創建者 Gargi D

Jun 06, 2019

Concepts get clear easily. Good course.

創建者 Jair F L M

Nov 30, 2018

Good course

創建者 karthik D

Jan 23, 2019

good

創建者 Mugdha G

Feb 25, 2019

Good course!

創建者 Dushyant S

Jan 18, 2019

Good course

創建者 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.

創建者 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.

創建者 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.

創建者 Torsten B

Jan 16, 2016

I enjoyed the first two courses. However, I would have liked to continue but as a Mac-only guy do not have access to an Oracle database, which seems to be a requirement for the assessments and the case study.

The first two courses went well on MySQL, so I'm afraid I have to leave here.

Thanks and bye. If the MySQL option gets added, I'll be back.

創建者 Santosh R

Oct 06, 2016

Great course

創建者 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

創建者 karandeep h

Feb 06, 2016

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

創建者 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.

創建者 Vinay B

Jan 04, 2016

Great course to learn DWH concepts.

創建者 Norbert v W

Feb 20, 2016

I like the course, and I learn a lot (having plenty of experience already). However, the assignments take far more time than the quoted 30 minutes, and a lot of time is spent installing and getting open-source tools to work - which I would have rather spent on actually hands on work on the subject-matter.

創建者 Gerrit S D

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

創建者 Mouhammad M

Feb 04, 2016

Hello,

Thank you for this well structured course. Exercises and tutorials are very useful to complement lectures and help increase our skills in the domain.

Tools deployment and connection (Oracle database on Virtual box and pentaho data integration) was a nightmare.

It would be great if you package all the tools needed for a given course into a predefined virtual machine image ready to be downloaded from the course.

Kind Regards,

Mouhammad Moustafa

創建者 Matt 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.

創建者 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.

創建者 Sagar T

May 01, 2016

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

創建者 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.

創建者 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.

創建者 Lin Y

May 26, 2016

useful information