Chevron Left
Back to Google Data Analytics Capstone: Complete a Case Study

Learner Reviews & Feedback for Google Data Analytics Capstone: Complete a Case Study by Google

4.8
stars
15,877 ratings

About the Course

This course is the eighth and final course in the Google Data Analytics Certificate. You’ll have the opportunity to complete a case study, which will help prepare you for your data analytics job hunt. Case studies are commonly used by employers to assess analytical skills. For your case study, you’ll choose an analytics-based scenario. You’ll then ask questions, prepare, process, analyze, visualize and act on the data from the scenario. You’ll also learn about useful job hunting skills, common interview questions and responses, and materials to build a portfolio online. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources. Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary. By the end of this course, learners will: - Learn the benefits and uses of case studies and portfolios in the job search. - Explore real world job interview scenarios and common interview questions. - Discover how case studies can be a part of the job interview process. - Examine and consider different case study scenarios. - Have the chance to complete your own case study for your portfolio. - Learn AI skills from Google experts to help complete data analytics tasks....

Top reviews

JT

May 12, 2023

Excellent course. Highly recommended. Teaches the latest technologies and provides real work experiences. Already leveraging some of the things I have learned in my current role as a business analyst.

CO

Jan 12, 2024

Are you interested in Data Analytics? If yes, I suggest you enrol and complete the Google Data Analytics Certificate program via Coursera. The Google Data Analytics Certificate program is top-notch.

Filter by:

2176 - 2200 of 2,597 Reviews for Google Data Analytics Capstone: Complete a Case Study

By Mohit M

•

May 10, 2022

a

By Nwamaka C

•

Mar 12, 2022

By GEONHAKLEE

•

Oct 25, 2021

.

By Deiyandara G C

•

Sep 25, 2021

By Laura D

•

Sep 1, 2021

By Mark C

•

Jul 26, 2023

The first 7 courses were fantastic. Teachers were great- lessons were great- activities were great.

However the Case Study gets the biggest F (0 stars) that I can possibly rate. I did not finish it, I could not upload the giant files to any tool to be able to analyze it and I was stuck on a few things that did not work and was frustrated and lost.

Here are the reasons.

1. The files (for case study 1) are very large- and most learners do not have access to the enterprise versions of tableau, sheets, Rcloud or Google Big Query. Therefore, you were unable to get the files to where you needed them to be to use the tools that we learned about. I have used these tools for many years and I knew that on Big Query, you can create a bucket and load them there but the other software was not able to process files especially over 100MB

2. Since this was all new to us, I felt like i was just thrown into the fire- There was no way to get help on specific questions like 'I'm having trouble understanding what the ask is- or what the business task was.' There was a business task defined, but then we were only assigned step 1. I didn't understand if we were supposed to share and provide possible solutions for that question or the over all task.

3. The case study PDF needs to be much more verbose on what we are supposed to do. There are some suggestions like find the mode and mean and make sure the data is clean, but if one of those didnt work, again it was hard to figure out why and try to solve the issue.

4. I did not like the fact that there was no direction on what we were supposed to be looking for. We were supposed to analyze the data (once we got the upload problem solved and then joined the files and created all the extra calculated columns) there were some hints, but all were we supposed to do (in a nutshell ) is look at all the ways the membership people were different than the casual people. Once you look at some graphs (if you could figure out what you were supposed to graph) I was not sure what to do after that- Was I supposed to wait for the other team members to complete their parts and then work with them to come up with a share and act?

5. No matter what path you selected, the videos and materials took you through BOTH scenarios and I thought I kept picking the wrong one after I watched and read about case study 1. It should take you to the next phase after you select a study. Again confusing.

6. I would have all the career and interview and resume stuff in an optional module. We were learning about the case study, then went to resumes and interviews and it was a broken path that just made me wait until all that was done before I even started the study.

Anyway- I didnt get hardly anything out of the case study. And that waas disappointing to me as it is such an important part of doing data analysis. I felt I was alone out on an island and really had no clue what I was supposed to be doing.

By Anthony C

•

Aug 26, 2022

Considering the pricetag and self-paced flexibility of the course, I suppose I couldn't realistically expect much more. However, I would be remiss if I didn't at least offer a suggestion, for how I think the course could be improved. A better course design would offer not only an improved means of some assistance (either in the form of web-conferencing, being able to call a tutor/instructor help desk, or even just an email address to send questions to, when we get stuck). In addition, it would be helpful to either have the 8th class consist of several graded assisngments, that would each be a portion of a case study, that would be reviewed by a human, and that we would be given some feedback on, so that by the end of the 8th course, we would know that we have a case study that would help us to land a job. Either that, or the aforementioned review/grading/feedback process could de divided up, and incorporated into the first 7 classes, so that by the start of the 8th class, we would already have a job-ready case study for our portfolio. From that point, the 8th course could focus on having Google or Coursera staff reviewing our LinkedIn pages, resumes, and portfolios look, to further polish everything up, and have us do at least one mock interview, in which we present the case study that we just finished. I realize that the cost is supposed to be affordable (and compared to a university, it is), but tweaking the certificate, in an effort to provide a better service to the students, in the manner described above, would make the program even more valuable to the consumer. If my suggestions were offered to me (and future students), either at no additional charge (or at a fairly nominal additional fee), I would give the program a 5-star rating. But, for the price, it gave me some beginner's knowledge of R, SQL, and Tableau, and improvde my knowledge of Excel, so I feel that it is worthy of a 4-star review.

By Anthony B

•

Feb 21, 2024

As a disclaimer, I have previous experience with SQL, Excel, and Python. The SQL and Excel material taught in this course left much to be desired. In my opinion, the amount of material given for SQL and Excel is equivalent to coming into contact with either program only a handful of times. Having taken only a single short course on SQL using LinkedIn Learning, I was more than prepared to learn the SQL taught in this course, and the basic Excel functions would be more suitable for a computer literacy class. That is not to say that the instructors are incapable of sharing knowledge, but they have a unique ability to dive deeply into each subject to ensure that the student has a profound understanding of the topic. As a beginner, the information for R Programming and Tableau were exciting and informational, and - again - the instructors seem to be knowledgeable of each subject. A few complaints about Coursera directly: the Modules are inconsistent about whether or not there is an "End of Course" exam, the videos restart randomly and some are missing their transcripts, and several of the "attached files" available for download are not actually available for download. This course specifically, as produced by Google, attempts to drive the user to a Google based platform at every turn, and the exercises on Big Query are no longer supported (this was especially frustrating). All in all, I feel like the knowledge I gained from this course was still worth it. If you don't do it for the Excel or SQL, do it for the RStudio and Tableau experience, and do the capstone. Finally, this course does not take 6 months. The time estimates are completely inflated. Thanks for reading, if the comment allows for feedback I'd love for it to be housed here.

By Jana S

•

Jun 14, 2022

For the first half of the course, most of the material covered I was already aware of, specifically regarding spreadsheets, meaning the beginning was a little slow and I don't think I learned much new. It would have been nice to have 2 tracks to choose from, a beginner and intermediate track since most people have come across basic spreadsheet functions or some form of coding in their academic/professional career. I also did not always like that all the tests were in multiple choice format, I wish there were more questions included like the ones where you have to perform SQL or R code in order to answer the multiple choice. Additional to the individual project it would have been nice to have some sort of "graded" case study, which, similar to the end of each course exam, leads you through a small project, requiring you to use all the skills from every course in one exam, whilst still guiding you a bit through the process. Then I think it would be a bit easier to get started by yourself on the Capstone Project.

What was also a bit of an issue for me on a Mac was to match some videos in full screen, there was then not an option to rewind the video, the full screen always needed to be exiting, that was a bit annoying when one wanted to see the applications used in full screen.

Overall I thought the level was a little bit too easy, I do not think I would be comfortable applying for a juniour analyst position with this certificate alone, which is what the certificate is advertised as. Again, maybe having an intermediate track for people to have to chance to skip over the basics and go a bit faster into the complex aspects would be great.

By Donna O

•

Dec 27, 2022

The capstone case study is a good idea to capture all that was taught to this assignment and use the assignment as a portfolio. After spending hours with Tableau and R I could not remember what to do or how to start or approach the case study 1 bike-ride. I know Tableau and R is necessary to create the portfolio however I spent so much time on the course and they were at the end of the other modules that I forgot what to do. Now I have to review the course again to complete the capstone. My recommendation about the format to complete a capstone would be at the end of ACT the capstone be given to complete while these modules are fresh in the mind. Then have Tableau module followed by the same capstone to add Tableau. Then R module followed by the capstone to add R. This is a better approach because at the end of each module you build on the capstone case study while the course is fresh in your mind. Also, there was mention of a checklist in one of the lab learnings that I think would benefit students to keep track of what do first at the beginning for the course rather than somewhere in 4 or 5 module. Lastly, the Course Challenge ought to be reset after 5 hours instead of 24 hours later this too long a wait to return to complete the quiz.

By Sean H

•

Oct 26, 2022

Overall very good at the high level and moves chronologically in a way that makes sense. It gives a good framework for understanding how to understand and analyze data problems and the videos are very helpful. Because its a course that covers a broad spectrum, it falls short when it comes to some of the nitty gritty and the learning curve with respect to Rstudio and SQL. Specifically there were some basics that were missed in the SQL section that make the more advanced sections confusing so have supplementary learning materials ready for this section. BIG Query is also less intuitive to use than say, MySQL workbench. For Rstudio, it wasn't bad but again, some of the basics were glossed over that could make some of the more advanced topics confusing so have supplementary materials and youtube videos at the ready to fill in the gaps. Overall though, the course mostly strikes the right balance with respect to the three tools, how they interact and how to use them as well as their strengths and weaknesses. I felt I was able to combine Excel, SQL and Tableau very effectively to create a coherent case study for the capstone project and the additional resources related to job search and building your profile are extremely helpful.

By keerthana h

•

Nov 13, 2022

good for an junior data analyst and have to be nice internship for the people who have opted for this course and to get it easily when they have to complete it in less time also. They have a lot of case study being learning is an important factor for this. And then by clicking submit you must agree feedback may be viewed by the coursera community for the compliance of the profile privacy is being done. junior data analyst and have to be nice internship for the people who have opted for this course and to get it easily when they have to complete it in less time also. They have a lot of case study being learning is an important factor for this. And then by clicking submit you must agree feedback may be viewed by the coursera community for the compliance of the profile privacy is being done.

By Kirk M

•

Apr 30, 2023

There is always room for improvement. I do think this course needs to be updated. Requirements need to be more clear. There needs to be better visual examples and links to helpful hints. Communicating in the forums seems arduous, and getting responses with well constructed sentences was next to impossible. This is not a criticism, but an observation. One thing I really wished that was available was a link you could click if you got stuck and you could see better examples of what to do. Having a button that says, "If you are stuck, click here". I know the objective was to see things in new ways, and think for myself...and I often felt that a little more guidance was warranted.

Anyhow, thanks for making this possible for me to learn something new and exciting.

By John S

•

Sep 22, 2022

Overall, I enjoyed the learning experience. I did find that the data files were much larger than what we had used in the past, which created problems when it came to uploading them into BigQuery and Google Sheets. I was able to make do, but in ways that weren't ideal in terms of making use of the tools we had learned throughout the other courses. I wound up performing all of my analysis in Excel.

I did feel like the interview advice and simulations were helpful, and I appreciated the reminder about the pipeline of companies hiring out of the course completion, which I had forgotten about.

By Yuhsuan C

•

Jan 22, 2023

I enjoyed the content this programme offered and the online practice was convenient too. There was one thing I would suggest Coursera and Google to improve which is the online test. There were a couple of times when I tried to redo the test, the page couldn't be refreshed successfully and therefore in the end I had to wait for 24 hrs due to repetation. And also, when doing the programming or SQL related tests, the pages sometimes couldn't run properly so I was confused that if or not I entered the wrong answers but in the end my original answers were correct but the page didn't work.

By Michelle G

•

Sep 14, 2022

Overall I think it could have been a big harder - I was actually disappointed that no one would be looking at my capstone project and grading it. And I'm slightly annoyed that the capstone project I chose had data sizing issues that exceeded the systems I was supposed to use to analyze it - I wasted a lot of time trying to make things work when eventually they didn't. But otherwise the rest of the course was fine. Most of the module topics I was already familiar with. The R Studio content could have been swapped around a bit for better understanding. But overall it was very helpful.

By Gu R

•

Oct 27, 2021

The dataset used for divvy bike was too large for platforms like R. That was the most difficult part of the project. Rstudio would crash multiple times anytime a month that had a lot of entries were used. I was able to complete the coding but after many attempts. I think for the purpose of the capstone maybe using less months of the data would be more useful. I think the amount of data has increased since the beginning of this course which may be why the issue didn't exist before. Otherwise the project was good and definitely had me sharpen my r programming skills.

By Rokesh P

•

Mar 7, 2023

The module featuring the Tableau tool could have dealt with the topic in much more detail. Could have shared a bunch of examples ranging from easier ones to the tougher ones with at least the scripts for adding new columns and including and manipulating the visual elements documented and shared. Some challenging problems or an optional section to try out some challenging codes could have been added. Also, notifications to remind people to at least spend 15 minutes with the course would be awesome.

By Matt W

•

Jun 21, 2022

Great beginning introductory Course! Although, employers desire numerous other skills besides what is offred with this google certificate. More coaching needs to be available in order for a student to become proficient in the course work provided. I would be willing to pay more for one and one coaching that would help me to succeed. I felt numerous HR professionals are setting the bar too high (time goals) in order to receive people who might be proficient in the course work provided. Thanks

By Joseph C

•

Apr 11, 2024

The capstone is quite a great exercise to go through what I've learned in months. I strongly encourage Google to add more capstone-like exercise in each course so that students can have a down-to-earth case studies and solutions. The only weakness of this course is that the datasets and the question of capstone are not articulated enough, as well as the reference solution. Thus, It took me time to guess what exactly the definition of the data column and what can I do beyond the reference guide.

By APRIL A

•

Dec 15, 2023

Not bad. I finished in 3 months. You do get an intro into SQL, R, sheets, tableau, etc. Check out some other options, though. Perhaps think beyond the certificate you earn at the end. You can learn much more productively with slightly less guidance and more personal initiative. I.e. print out the R(programming) guides straight from CRAN and learn that way instead of watching a bunch of tokenistic video tutorials. Just an example. For the price, it's worth it.

By Mark

•

Apr 1, 2024

Informative and very helpful. However I thought that more instructions and info should of been given when covering coding languages. Also more insight on how things are set up and work, in some platforms, should of been given. I took notes on literally everything but felt unprepared when the capstone project came my way. Definetily will need to reach out to other resources whilst I continue to code. That said, a lot was covered and I am happy.

By Deepti P

•

Aug 29, 2023

The reason I am given a less star is only because, I wanted a feedback or one-to-one video feedback with expertise about how I did the capstone project, so that I could apply better efforts in future. I also noticed doing this course didn't help me much in getting work opportunities. The best part were the instructors. I also liked the mock interview conducted for understanding of better approach in regards to interview and resume.

By Jonathan M

•

Apr 21, 2022

This course was a strange and wonderful mix of technology and art. This is a great start for anyone interersted in Data Analytics. That said, the technical content on SQL and R is very introductory and very repetitive - it doesn't build enough, and, honestly, doesn't give a solid enough foundation to tackle the capstone. You will have to do a significant amount of learning on your own to be able to complete a worthwhile capstone.

By J G S A

•

Aug 6, 2023

Overall it is a great program, they teach you the basics to get an understanding of what data analytics is. One issue is that they introduce a program early on and then they don't come back to it until the end. There are refreshers but you would think it can all be done at one time. It is also easy to get lost between SQL and R and remembering all syntaxes. Great introduction course and great for learning at your pace.