Chevron Left
Data Warehouse Concepts, Design, and Data Integration(으)로 돌아가기

콜로라도 대학교의 Data Warehouse Concepts, Design, and Data Integration 학습자 리뷰 및 피드백

991개의 평가
203개의 리뷰

강좌 소개

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

최상위 리뷰


2020년 9월 18일

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.


2015년 12월 15일

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.

필터링 기준:

Data Warehouse Concepts, Design, and Data Integration의 194개 리뷰 중 1~25

교육 기관: Nils K

2017년 11월 16일

The torture of having to identify which of the many combinations of Pentaho, Java and some freeware plugin actually works in the end has completely ruined this experience. I don't care if SOMEWHERE in the notes there is info I should install Version instead of 5.0.whatever, this is just plain laziness in the course design by picking software which might have worked in the past and then not updating the instructions while pocketing the student's money for years to come. I have about had it with spending my nights installing and re-installing this junk of software nobody uses anyways in a real business setting only to advance in this class.

교육 기관: Sebastian G

2017년 1월 2일

Personally I don't recommend this course. I really need to learn data warehousing for my job and I have no problem with learning by doing. This course gave me basics, but the learning was very stiff. I think it's just to theoretical here.

교육 기관: Александр К

2018년 11월 10일

The quality of assignments is awful

교육 기관: Gavin

2019년 11월 9일

Disgracefully outdated course that does not match with the technology that it claims to use -- dont bother with this one

교육 기관: sujay b s

2018년 1월 18일

Pentaho does not work, hence I was not able to complete week 2 assignment and the course.

교육 기관: Rochelle H

2017년 8월 19일

No guidance from instructors, and the assignments have nothing to do with the lectures. If I could get a refund, I would quit and get my money back. Not worth the frustration.

교육 기관: Mesum R H

2016년 12월 13일

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

교육 기관: Peter V

2020년 10월 11일

The course content is what saves this course from getting a really low score. I actually learned a lot about data warehousing so I can forgive a lot of the logistical problems that this course has, and these problems are not necessarily problems with this course but may be more widespread among coursera in general. Take this course if you are interested in data warehousing but are willing to be a completely independent learner. The course forums are full of people asking for their assignments to be graded which doesn't make sense because I never had to post anything, and mine were eventually graded. Module 2 has a bug where there are 2 assignments to choose from, but coursera thinks you have to complete both to pass the module.

The assignments are interesting and you will learn a lot if you actually complete them. From doing peer reviews I noticed a lot of people not even doing the assignment and hoping that people will just give them a passing grade. There is also a lot of plagiarism going on because I graded the exact same submission many times.

Aside form the issues above, I learned a lot, and I think it is actually worthwhile to take the course if you are patient and can self-teach.

교육 기관: Esteban R

2019년 10월 1일

good material but should update some videos since program versions have changed.

교육 기관: John P

2020년 10월 19일

5 stars for content and assignments; 2 for peer-reviewed grading

The content in this course is very good. You'll learn some good concrete skills, while completing some challenging assignments.

The peer reviewed assignments are problematic. Cheating is rampant. Your peers will often turn in empty assignments, I assume so they can get access to the answer file. I have had to review assignments that were blatantly plagiarizing the answer file. Another peer even plagiarized my own work as his. I have flagged multiple submissions as plagiarism, but I don't think Coursera does much of anything with these flagged submissions, since cheating is so commonplace throughout the platform. I just tell myself that I'm here for the learning; I can't stop others from stealing my own work. Seriously, who takes a MOOC just to cheat??

I suppose the integrity and honesty problems I mention above are more problems pertaining to the Coursera platform as a whole, but having your own work plagiarized definitely affects your experience and perception of a class. Furthermore, it should be up to the course designers to develop assignments that work in spite of Coursera's problems.

Despite all this, I will be continuing with the course series, as this is fascinating stuff.

교육 기관: Nelson F A

2018년 8월 24일

A very good course. It is challenging, especially the assignment in week 3, but extremely rewarding. Thanks to Coursera and the University of Colorado for creating this course. Really good to get an understanding of enterprise level data warehouses.

교육 기관: John F

2016년 2월 20일

Overall a great course mixing concepts, technical skills and self learning very well. I'd recommend this course for anyone who is looking to learn about building data warehouse from scratch with minimal starting knowledge.

교육 기관: Robert L J

2016년 3월 5일

Again, professor Michael Mannino presents a very well prepared course that achieves optimal results in limited time. This course provides the background and basic skills necessary understand and work with Data Warehouses.

교육 기관: Franklin P G

2016년 3월 25일

Excellent course in the way of preparation to be a Expert in Business Intelligence and Data Warehouses.

100 % recommended!

교육 기관: Jose A

2017년 6월 12일

I've learned lots from this course. I highly recommend it if you want to learn the concepts behind data warehouses.

교육 기관: Felix M

2017년 8월 2일

I love both the theoretical and practical nature of this course. Enough content is provided to ensure a smooth introduction to data warehouses and proficiency in the important concepts of Extraction, transformation and loading. The progression of content across the weeks is excellent and Michael is definitely the best instructor in the subject.

교육 기관: Gokay B

2021년 12월 13일

A​ pretty decent course; the topics covered are really interesting and I enjoyed learning more about data warehouse design concepts and principles!

H​owever I feel like the video lectures could have been better. There could have been more details and more examples illustrating the topics. I also think there is a lot of 'filler' in each video. Even for a 6 minute video lesson, the first minute is spent with the intro & lesson objectives, and the last minute is the summary. Do we really need this for a 4 minute lesson? I'd rather they have added more actual lesson materials instead of spending 2 minutes on every video with these intro-objective-summary parts.

A​lso the assignments could have been better. They are slightly more complicated than what was taught during the videos and I'd have again preferred some more detailed lessons illustrating more closer examples to what is asked during the assignments.

교육 기관: William J

2021년 2월 8일

The peer review should be more standardized. There is dramatically inconsistent grading where accurate submissions are failed without warrant causing frustration instead of continued learning. The actual course content is five stars for me. Just the peer review needs cleaning up in my opinion.

교육 기관: Jacob G

2021년 3월 24일

Content is lacking and final assignment was a nightmare; difficult to install multiple pieces of software only for a tedious assignment, that ended up not working the way they were supposed to leading to me not fully completing the work. Course videos are mostly wasted time - first introduce the topics that will be discussed, summarize points you should get from the lesson, followed by 2-5 minutes of actual content, then a summary of the minuscule amount of info you just heard.

Must not be a popular course, because peer grading often took a while, and there often were not other submissions for me to grade. Needed to go to discussion which solely consists of old posts from people needing grades

교육 기관: Bintang A S

2017년 1월 1일

I love this course! Especially with the practice exercises. This course has helped me significantly improve my understanding & the technical skills revolving data warehousing. It would be much better though, if this course has a lot more technical exercises, learning how to utilize essential data warehousing tools efficiently.

교육 기관: Deleted A

2018년 11월 30일

I just re-reviewed the 1 week and will re-review it within the day, prior to taking the exam. overall the presentor is very capable and has mastery of the subject which is very very good. I love this course and i hope I could have this re-reviewed once I get to have the paid subscription.

교육 기관: Nasheena

2019년 4월 3일

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.

교육 기관: Susan W

2016년 4월 16일

great course with hands on practice of the concepts. Getting the tools installed is a little frustrating but once you get past that part there are a lot of good exercises to apply what you are learning.

교육 기관: Konstantin P

2021년 6월 10일

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.

교육 기관: Liberto S

2020년 9월 19일

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.