Google Data Analytics Certificate Course 8 of 8 - Capstone Case Study + Full Program Impressions

you're a great teacher

Where did you even see other people's projects?
The "share your work forum" that appears to me on week 2 is full of people commenting just a dot ( - )
I have absolutely zero benchmark as to how I even start doing this project.
ANY, literally ANY company where you start working as a junior will tell you to analyze something concrete, not dump 25Mb of data onto you and say "see what you can find, good luck".
How do I even start "asking questions" if I haven't seen the data? I mean, there are all the raw data files, but so what?
Seems ridiculously counterintuitive, because every data is collected with a PURPOSE, and here you need to find a purpose by rummaging through data.
The ONLY guidance they give you is a word document talking about the products the company offers, ZERO insights on how to start or what to do.
I honestly wanted to see an example of how a project is done, even if with a different case study, so that I can start with this.
If I can see an example of a project I would be very grateful

I did 19 months (2022-2023 YTD), and I ended up with 8 Million rows of data. I had to write it to my own personal server to analyze in R.

Great video! Thank you for breaking the last project down. I just started the program 4 days ago and I am cruising through it; I am already planning ahead and wondering if you had any recommendations (of course I will binge on your content asap)! I saw Coursera had an "Advance DA certificate", Introduction to R or SQL courses etc... Thank you

Hopefully someone can help me. I'm having an issue with importing all the bike data in any of the 3 databases. Its too much for all sql, sheets, and r. How am I supposed to analyze the data if I can even get all the data in a database without the software crashing

Matt, this was helpful.

I recently completed the course and do have some gripes too from an Instructor perspective ( was a Math instructor for about a decade):

1. As a student I felt burned out with the repetitive format although they did mix it up with activities. Mostly I got burned out with the reading.
As a suggestion, they should consult with Khan Academy (owned by Google, by the way - maybe they did consult with them?) to come up with a more interactive approach. I used to utilize Khan Academy in my classroom because they do utilize AI to determine what areas of Math students need to work on and establish a personalized curriculum for the individual student.Similarly, they could do that for Adult learners to setup the curriculum for the individual to learn optimally.

2. The Case Study approach: I agree with you 1000% - it's not good to make it optional. However, people have different intentions for taking the course, but it is absolutely necessary to apply it and design something tangible as you state, to connect the dots to make it worth while.

Now, personally I feel very overwhelmed with completing the case study - just getting started. So I been checking out the data and been struggling with just uploading it ( perhaps you can provide some suggestions? Been working with Sheets and also Mac Numbers) - maybe I can analyze 3 months instead of 12 to make it easier?. I feel I'm echoing a good percentage of people's frustrations with feeling overwhelmed with getting started. I feel they should've walked us through a Case Study to demonstrate how to do it. I understand part of being an Analyst is to troubleshoot and figure it out, but being new to this would boost our confidence and by walking us through it could make it a requirement. They could have structured it differently to make the process more beneficial and enhance our learning. I felt like they left some of us in the dark with the case study. As for myself, I do have tech experience and am able to troubleshoot but very new to the process of Analysis.

Are there two Google Data analytics courses? One with the capstone case and other without it?

You rock dude...😎

Thank you for walking through the Capstone module! Honestly, I was dragging my feet a little bit on the R module because I was anxious of the possible intensity of the capstone. Now I realize it's what you make of it!

Hi Matt, new subscriber here. Glad I found your channel. You're giving helpful advice. I'm also doing the course and are about to start on the Capstone course. Like others, I feel a little overwhelmed too and I will check out some of your other videos.

I appreciate your comments on the actual hiring process for new analysts. It makes me feel a little less stressed, and a little more competant, because this capstone project is really making me reasses my abilities right now! I enjoyed the course and felt like I had a pretty good understanding up till now. But like you mentioned in one of your comments it's a pretty big leap that the capstone project expects you to make. It's not supposed to be easy.. I actually think I will create my own case study after watching your video.. something I am actually more passionate about and not the same as all the other newbie analysts.

Great video and well explained.

This is just what I needed, really: Track 1. For someone like me who is a slow learner, I prefer to be guided; this would greatly help me once I reach course 8. I'm currently on course 4 and working my way up to that certificate.

Kudos to those who took Track 2. But for me, I'd rather go to Track 1 and be guided in my journey to the finish line.

thanks for this video. i finished it but i fell lost about capstone project
yes, i think there was too much excel and less about others,
R part was diffcult for me, very general information
i don't feel prepare to do it :( but i will try later, when i learn more about SQL and R

I absolutely have LOVED this course. I am on my capstone now... and am going to work on 3 different projects for my portfolio. The ONE thing that SADDENS me is that I will not be able to get my certificate. I AM however screenshoting every finished course to prove to potential employer that I have completed all 8... 7 now... just finishing these projects!!❤️

Hi Matt. I'm trying to finish the capstone for the bike or exercise apps and I noticed the files were too big for excel one drive. The bike case study has datasets over 100mb and it won't load. So then I tried the exercise app one, which has smaller files, but I think I need to combine them and that will also make them too large for google one drive on excel to open. Any advice?

Hello Matt,
I just entered my capstone phase but I actually wanted to talk about the course in whole
I started this course because i feel i was lacking 2 things:
1. asking the right questions
2. getting insights from the data to then eventually act on the data

I fell that this course fails to expand on these two critical subjects, for one leads to another and the added value CEOs see from an analyst is if that person can translate data into money.
because at the end of the day, that's what we need to do.
ETL data into money for the company.
and i fail to do that.

so, on that subject, do you know of a course that can boost my insights ability to find how I can make a company more profitable, and therefore make me a abetter analyst?
thanks

good point. ur the analyst. but them technical interviews may say otherwise if u dont go deep enough

how much days needed to complete course 8 ??? can you tell it approximately

New sub. Very informative

Do you have to do the discussions and learning journals to complete the courses and certificate?

I’m just starting my ‘capstone project’ in this course and I must say, it’s a bit overwhelming. I blew through the course in 2 months with awesome grades. I thoroughly enjoyed it, especially the hands on projects and quizzes. I was feeling really confident going into the final case study portion, but I feel a little blind sided. I’m not quite sure what end result they are after or how to approach it. I’ve been looking at other peoples projects who have taken the same course, and it seems the ones that are readable and streamlined are using coding and programs that weren’t actually taught in this course. I’m brand new to this, looking to switch from a 20+ year career in the service industry. I feel like I just got thrown into the deep end of the pool when I just learned how to doggy paddle. Did any other newbies feel overwhelmed at this stage of the certification process? Any advice is appreciated.

Does Coursera/Google review your capstone project after you complete it?
I'm asking because if that's not the case, I'd probably write it in my native language and not in english.

I am glad this professional certificate are related to the unrelated field. I move from education to Data analysis for the sake of curiosity.

what the heck the purpose of this video. Bloody wasting your time and ours. Please stop doing this,

Matt is engaging and unbias in commenting on the Google Analytics Certificate program.

such dope content , i guess my question is how do i build on this? Am thinking of doing the ibm certificate so that i can showcase my python skills , but how can i build my accreditations to a degree certificate? Any suggestions ?

Hey Matt do you have a walk through video on completing a cap stone project?? I’m at a lost on where to start

I'm so grateful and thankful for this and you. Thank you so much for encouraging people like me who are trying so hard for a career change. I got so disappointed last couple weeks after reading all the bad review on the course, tho I know better to not do that. I'm on course 6 of this certificate now, and tbh coming from a different industry to try to study on my own and understand the material that I can tell this is a great course to start like you mention many times. Just want to let it out there for everyone who is trying for a career change like me to believe in themselves and just do it. cheers!

Awesome!!
Just finished the course, and onto my capstone project. Wish I found this channel sooner! Ty

After how many days will i receive certificate after completing this Google data analytics professional certificate course

Thanks for your honest review

Hi, I complete Foundations: Data, Data, Everywhere. Without these (Ask Questions to Make Data-Driven Decisions, Prepare data for exploration, Process data from dirty to clean, Analyze data to answer question, Share data through the art of visualization, Data analysis with R programming) courses can I participate Google data analytic capstone project? Please suggest me

Thank you ❣️

Thank you Matt. I feel like I needed a little more clarity before diving all in. I'm excited to finish it up and start looking for work! I really needed to re-think how I communicate my technical skills. It is cringe looking back and knowing your Data Analytics "skills" was using "Tableau, excel and SQL before." so captivating in interviews.... NOT haha.

I'm a complete newbie to the DA/Tech world. What are some tips for a brand new person trying to break into the tech world? And how to limit feeling like you're drowning during work.

Hi I wanted to first practice on the two case studies before enrolling on week 8. Where can I find the dataset for Case study 1 & 2?

Hey Matt, how to proceed for jobs after getting a Professional Certificate?

Appreciate thus review so much. thank you

Thanks for this video, I just completed the modal 7.

I have completed this course but the capstone project doesn’t look like it’s for beginners. So quick question yea. There is plenty of datasets don’t even know what to do with it. There is like many files for month of January with different datas in it. How do i even cleaning? Will i clean each dataset differently ?

Thank you for your video and advice

Certificate not generated for 3 and 4th course. However certificate generated for 1st and 2nd course. Doing it on financial aid, finished each course 100%.

Are we get a full certificate of all these course in one??

Do I need to keep my subscription going for course 8? I'm going to start week 4 of course 7 soon but my schedule has become super busy lately and I don't know when I'll be able to finish the whole thing. If not, once I finish course 7, I might have to cancel the subscription and come back later

Ah! This is great content! Love the phase and detailed information!

Thank you for sharing your insights on this course. I just completed Courses 1-7, started Course 8 yesterday and wanted to hear what others thought about it. " Tools dont make the Analyst. Analyst uses the tools"...great way to put it!

I loved your line, "tools don't make the analyst" earlier I am doing the same but after taking this course I get to learn how to "ask right questions" at different stages of Data Analysis. 😃✌️
Thank you Matt😇

Do you think this certification is enough to get an internship ?

By the way teamtreehouse just released a Data analysis techdegree, can you take a look please ?