Mastering Data Analysis in Excel(으)로 돌아가기

별점

3,688개의 평가

•

886개의 리뷰

Important: The focus of this course is on math - specifically, data-analysis concepts and methods - not on Excel for its own sake. We use Excel to do our calculations, and all math formulas are given as Excel Spreadsheets, but we do not attempt to cover Excel Macros, Visual Basic, Pivot Tables, or other intermediate-to-advanced Excel functionality.
This course will prepare you to design and implement realistic predictive models based on data. In the Final Project (module 6) you will assume the role of a business data analyst for a bank, and develop two different predictive models to determine which applicants for credit cards should be accepted and which rejected. Your first model will focus on minimizing default risk, and your second on maximizing bank profits. The two models should demonstrate to you in a practical, hands-on way the idea that your choice of business metric drives your choice of an optimal model.
The second big idea this course seeks to demonstrate is that your data-analysis results cannot and should not aim to eliminate all uncertainty. Your role as a data-analyst is to reduce uncertainty for decision-makers by a financially valuable increment, while quantifying how much uncertainty remains. You will learn to calculate and apply to real-world examples the most important uncertainty measures used in business, including classification error rates, entropy of information, and confidence intervals for linear regression.
All the data you need is provided within the course, all assignments are designed to be done in MS Excel, and you will learn enough Excel to complete all assignments. The course will give you enough practice with Excel to become fluent in its most commonly used business functions, and you’ll be ready to learn any other Excel functionality you might need in the future (module 1).
The course does not cover Visual Basic or Pivot Tables and you will not need them to complete the assignments. All advanced concepts are demonstrated in individual Excel spreadsheet templates that you can use to answer relevant questions. You will emerge with substantial vocabulary and practical knowledge of how to apply business data analysis methods based on binary classification (module 2), information theory and entropy measures (module 3), and linear regression (module 4 and 5), all using no software tools more complex than Excel....

JE

2015년 10월 30일

The course deserves a 5-star rating because: (1) content is relevant, (2) the professor is concise and possesses great teaching skills, and (3) the learning modules are applicable to daily problems.

PW

2020년 10월 13일

The course was excellent. A little difficult and overwhelming at times but as long as you stayed the course the professors gave you every opportunity to succeed. Thank you for your time professor.

필터링 기준:

교육 기관: Steven T

•2015년 12월 2일

Sad.

교육 기관: Paul J H L

•2016년 2월 24일

This is my first Coursera course and I wasn't sure what to expect. I was hoping for a good experience but preparing myself for mediocrity.

I finished the course at 2am on Monday morning and I've been really impressed, both with the Coursera "infrastructure" and with the quality of the teaching from Daniel Egger and his team. I live in South Africa where tertiary educational standards vary widely, and appear to be on the decline. More and more, we are going to need MOOCs like this from the best universities in the world.

More specifically, relating to this course, I found the video lectures well presented and the quizzes thoughtfully prepared. The Excel models really helped with grasping the concepts and practice.

A couple of suggestions:

a) The course FAQ makes light of the background knowledge necessary to cope with the course. It needs to be more honest about the need for mathematics and statistics. Linear regression is not for sissies, in my opinion.

b) Please tell us at the START of the course that we should attack the project week by week. This advice isn't (unless I missed something) given until you open the week 6 project. Ahem... it's too late by then! I spent a very frantic 4 nights last week crunching the project work, 4 quizzes and the assignment. I got to bed at 2.30am, and i'm not a night owl.

Overwhelmingly though, a really interesting course. I'm already starting the next one.

교육 기관: Deleted A

•2016년 9월 30일

I read some of the other reviews and feel I should comment on some of their criticisms.

The material, objectives and tuition are top-notch. Yes there are things that are unclear and difficult and I you will need to read around the subjects introduced from other sources and persevere.

But that is how you will learn and remember.

So far I have yet to complete the course, I am about to start my 4th attempt, but I get a little further each time and the next presentation acts as revision initially. Daniel Eggar introduces key concepts that you need to master, this course is not spoon fed, but is better for it.

If I have a criticism, perhaps the course is badly named, maybe it should be called "Core statistical concepts for data science using Excel"

교육 기관: Adrian B

•2020년 7월 16일

I learned so much in this course. Already had prior Excel and took a few probability and statistics courses in University, and this course helped me understand the applicability and the usefulness of those concepts in business. I also did the Data Science Math Skills course (Free) to prepare for this course which helped alot. I've recently started the Tableau course that's part of the specialization as well which I will say is more engaging - the presentation slides seem to be done better and the content itself keeps my interest longer. Maybe it's because it's related to dogs and future salary...

교육 기관: Jonathan E

•2015년 10월 31일

The course deserves a 5-star rating because: (1) content is relevant, (2) the professor is concise and possesses great teaching skills, and (3) the learning modules are applicable to daily problems.

교육 기관: Hardik M

•2019년 3월 4일

The course is great as it allows you to apply all the concepts taught in scenarios that are really practical. The resources supplied with the course are extremely useful,and all in all the course is good for anyone trying to understand data analytics.

교육 기관: Patrick W

•2020년 10월 14일

The course was excellent. A little difficult and overwhelming at times but as long as you stayed the course the professors gave you every opportunity to succeed. Thank you for your time professor.

교육 기관: NGUYEN D C

•2016년 12월 20일

Overall, the course material is good with many example. Need a general knowledge with mathematical and statistical from the beginning to pass the exam, because course slide is a little bit fast.

교육 기관: Marek Z

•2015년 12월 24일

For me a great course that tackle basics of data analysis that is usually done in much more advanced software.

Thanks to Excel "transparency" it is very easy to understand those concepts.

교육 기관: Yinghuai L

•2020년 7월 22일

From ROC to Regression, the course is very carefully and smartly designed, step by step, progress and achievement made with interested topic! the discussion forum is also very useful.

교육 기관: Achmad R A

•2019년 5월 21일

its a good course but maybe in the future you can add another case for participants to build another model beside bank credit model

교육 기관: Soukaina K

•2019년 5월 2일

Excellent course, I learnt a lot and really enjoyed it. Definitely recommend !

교육 기관: valentine M

•2019년 4월 12일

Great course improves data analysis insight

교육 기관: Eddie M

•2018년 11월 16일

The course is quite challenging and therefore worth doing. The materials provided are excellent and the video tutorials and Professor are excellent - but make sure you pay attention!

However, I was a bit disappointed with some of the quizzes particularly those in the final project. The penultimate quiz and peer assignment quiz do have problems. The penultimate quiz answers are not accurate and do not match the actual correct answers. You therefore need to be careful when responding and choose the answer that is closest to your result. On the peer review problem setting there are certain aspects required in your answer that are not defined in the problem. Indeed the way the problem is set out it appears that you can choose between predictive linear regression OR binary classification. Beware.

Also I would strongly recommend finishing the course work for week 3 AND 4 BEFORE taking the quiz on probability and distributions.

교육 기관: Kenneth W

•2018년 10월 11일

Great course. My one caveat would be that, as other reviews have stated, the name of the course is misleading. In my opinion, this course isn't nearly about Excel as much as it is about probability and statistical analysis. If you haven't taken classes and don't have any experience with these, you will be in for a very rough ride. However, Professor Eggers does a good job of guiding you through it and gives you the resources you need to succeed. It will undoubtedly be tough, but if you are persistent and believe in yourself, you will succeed. And you will come out on the other side better for the wear. Cheers!

교육 기관: Doug J

•2019년 4월 29일

Very comprehensive. Lot of theory and practical. My request would be to add a week focusing on a couple models and a couple methods to select metrics and validate confidence.

교육 기관: Santiago H

•2019년 6월 30일

The exercises, resources and quizzes were really good. I felt they were putting to you to the test to see if you had applicable Excel knowledge.

The videos I believe were not that helpful. Too focused on the arithmetics of statistics, while lacking a stronger explanation behind the logic and the importance of certain concepts such as conditional probability, CLT, etc. The arithmetics you will i) forget ii) can easily look them up. But the logic not so much.

I do think the course should have shown how to run regressions with the Data Add-In. This is a helpful tool, makes more sense than forcing you to do everything manually.

교육 기관: Ethan h

•2020년 12월 13일

Sloppy. There's a lot of good material in there, and well presented in general, but the quizzes and assignments are just plain sloppy. It's painfully obvious from grading peers that most people don't get the material at all, which isn't surprising. But I don't like being put in the position of having to peer review people when they don't seem to have put the effort into learning this material on their own, where the assignments didn't make it clear to them. The forums are basically ghost towns. This should be a free course, not paid. If you want to charge people for this, clean it up please.

교육 기관: Matthew T

•2019년 4월 30일

There were a lot of holes in the teaching of this class. We covered more statistics content than I did in my full-time MBA statistics class over a few 10 minute YouTube videos. Additionally, there is some calculus which I have not studied in 10 years or so. I would have liked to see more excel functionalities explained to add to my tool bag. With all that being said, I learned from the class and enjoyed some of the spreadsheets that were provided. I expected to be challenged since the course is done through a prestigious university and definitely was.

교육 기관: Christopher A

•2020년 3월 18일

The material ramped up in difficulty very quickly. It was a miracle that I completed the final project after initially giving up hope. There were no examples in Excel for how to do many of the stat problems despite the course being about excel. If it was not for the Discussion forums I would not have passed the class. I was lost frequently. That being said though I did learn a lot, but since the explanations are sparse, I am not sure if I will retain this or how well I can apply it professionally without making a mistake.

교육 기관: Ashish R

•2021년 2월 11일

This is mathematics, probability and statistics, but shown as Excel, which is just a tool!

교육 기관: Mathilde S

•2021년 1월 2일

NOT beginners level and errors in material

교육 기관: Ian B

•2021년 4월 3일

This course contains very minimal instruction in Excel skills beyond the basics, as it is really just a math course consisting almost entirely of plugging values into premade spreadsheets. This would perhaps be forgivable if it were a decent math course, but that is also not the case. Lecture videos are low quality, littered with confusing errors and there is even a mistake in a graded quiz that remains uncorrected long after being brought to the attention of course staff. The final assignment is so poorly explained and confusing that extensive use of peer advice from forums is needed. It is obvious from the poor quality of this course that the instructor and staff have little respect for students' time and learning experience.

Plagiarism and requests for quid-pro-quos appear to be rampant in the final assignment, and peers grade assignments incorrectly and arbitrarily even when provided answers explicitly match the criteria of the grading rubric, so expect your grade to have little connection to the correctness of your assignment or how much effort you spend on it. It's essentially a dice roll whether you receive graders capable of understanding the rubric and/or willing to take the time to accurately assess your work.

I spent many hours completing this course in earnest and I wish I could have that time back to apply to more valuable courses. I will not be continuing with this Specialization or taking any additional courses from Duke on Coursera and I recommend anyone considering this course or others in the Specialization to look elsewhere.

교육 기관: Kaela W G

•2016년 2월 7일

Probably the worst class I have ever taken on Coursera. The teacher asked us to do tons of things without explaining how and used tons of complicated math formulas without explaining what they were, what they did, or when and how to use them. There were also actual incorrect answers in the videos on occasion, so that even if you did do things correctly, you would think you were wrong and be confused, and there were a lot of inconsistencies between the spreadsheets used in the videos and the methods used to solve things compared to the actual spreadsheets given to us, which makes things pretty impossible to learn. If you're more advanced, it may be easier to find and understand the differences between the video and the spreadsheets, but the whole point of this class is that it is for beginners.

교육 기관: Miranda F

•2020년 12월 20일

For a specialization labeled for beginners, I found this course to be very challenging compared to the other courses in the specialization. I expected that this class would cover pivot tables and how to find and interpret regression using Excel. This was not the course. The teacher explained concepts using upper division math, so I struggled to learn the concepts and did not have a teacher who could explain the concepts. The video lessons had very limited information. They assumed you knew the math already. The course would improve if it covered half the material and had exercises and worksheets that demonstrated how to do the equations.