Google's Data Analysis full project walkthrough

Sdílet
Vložit
  • čas přidán 26. 04. 2023
  • In this video I'm going to show you step by step my take on the Bellabeat case study project for the Google Data analytics professional certificate.
    Currently looking for a position full time/part time as a data analyst/business analyst. Contact me: / juan-carlos-martinez-p...
    Resume: docs.google.com/document/d/1k...
    Portfolio: jc-martinez95.github.io/portf...
    #sql #dataanalytics #sqlqueries #sqlforbeginners

Komentáře • 34

  • @user-tz5cq6vh5k
    @user-tz5cq6vh5k Před 4 měsíci +4

    Excellent project. You are truly the best for me.

  • @felixamoako9526
    @felixamoako9526 Před 11 měsíci +1

    You did a great job, bro. More blessings to you

  • @TheCarocornExists
    @TheCarocornExists Před 8 měsíci +2

    Thank you so much! It's all coming together now😅

  • @bukonlalawal7963
    @bukonlalawal7963 Před 11 měsíci +8

    Thank you so much for the step by step analysis.

  • @jonplaud
    @jonplaud Před 2 dny

    I love this!

  • @aminamoallim9121
    @aminamoallim9121 Před 9 měsíci +2

    Hi Juan, great video thank you for sharing your work. I have a question, could the calories column in that data is related to calories intake rather than the calories born?

  • @JohnDows
    @JohnDows Před 4 měsíci

    Perfecto senor!

  • @MrTiagoGregori
    @MrTiagoGregori Před 7 měsíci +7

    I'm on this course and they aren't using python but R.

    • @damilo7404
      @damilo7404 Před 6 měsíci +2

      You can use any tool at your disposal

  • @mercyokwoli6837
    @mercyokwoli6837 Před 2 měsíci

    Thank you so much

  • @sourach6325
    @sourach6325 Před 4 měsíci +5

    hi, i am taking the same course and i am doing the case study but i am lost about how the case study should look like at the end, so after i went to your portfolio i saw that you did the both case studies that are on the google course project and i saw that you write each step and what you did in it, so i want to ask you about the steps of finishing this project so i need first to analyze and then put is in Kaggle as you did and this how i am done from the project??
    plz tell me i really need your help

    • @juanmartinezii5677
      @juanmartinezii5677  Před 2 měsíci

      You can download the files and do the analysis locally on your machine with Jupyter notebooks or on Google Collab and upload the project files on your GitHub profile or do the analysis directly on kaggle

  • @MohammedAli-ck5op
    @MohammedAli-ck5op Před rokem +8

    Thank you for brief explanation about the google data analytics case study

  • @lhodeniz
    @lhodeniz Před rokem +4

    Thank you. Good job in R!

  • @channelwhoa66
    @channelwhoa66 Před měsícem

    I just completed this with your walkthrough! Thank you for this! It really helped my understanding much better for working with Python, but in DA in general? Can I ask, this is Python. Yes? And where do people go to learn the code to do different things? How did you learn and memorize how to write all that code in that way?! where do we learn this! Thank you Juan!

  • @felixjones4522
    @felixjones4522 Před 2 měsíci +1

    I'm new to data analytics do u have videos explaining the basics on becoming a data analyst

  • @AdityaSingh-zw5ev
    @AdityaSingh-zw5ev Před 2 dny

    Hi Juan great work I just have a question
    1)It is very hard to find correlation between data points in this and also other different datasets provided by Coursera because I was analyzing minutes_sleep dataset and its very confusing did you also had problems analyzing those datasets ?

  • @jonplaud
    @jonplaud Před dnem

    1:20:29 I keep getting an error saying Keyerror: 'activity_level'

  • @ashumatak
    @ashumatak Před 9 měsíci +3

    Hi, Thank you for the video, can we use the same set of code for R programming?

    • @JohnDows
      @JohnDows Před 4 měsíci

      What's the trouble to use the same data-set with R?

  • @OttomanSmack44
    @OttomanSmack44 Před 9 měsíci +1

    Is it possible to do this in python? Or are there any videos utilizing python?

    • @MDCRITICA
      @MDCRITICA Před 7 měsíci

      If I'm not wrong, you might find Python cases in Kaggle itself. Take a look. I'm pretty sure I saw someone that did it with Python.

    • @channelwhoa66
      @channelwhoa66 Před měsícem

      My undersanding is that this is Python!

    • @OttomanSmack44
      @OttomanSmack44 Před měsícem

      @@channelwhoa66 after months Thank God I now know sql python Tableau/Looker and sheets/excel keep the hustling. You’re right it is Python.

  • @channelwhoa66
    @channelwhoa66 Před měsícem

    Why would you use Python if it wasn’t a tool used in the course?!? Also did u get hired?

    • @juanmartinezii5677
      @juanmartinezii5677  Před měsícem +1

      Because I believe Python is a more well rounded tool which you can use for other purposes, whereas R is mainly only used for data analysis and data science.

    • @juanmartinezii5677
      @juanmartinezii5677  Před měsícem +2

      Yes, I did get hired with this and my other projects in my portfolio

    • @channelwhoa66
      @channelwhoa66 Před měsícem

      @@juanmartinezii5677 Is it possible to complete this particulat case Study using excel or sheets?

    • @juanmartinezii5677
      @juanmartinezii5677  Před měsícem +1

      @@channelwhoa66 I recommend doing as many projects as you can, and not only copying and pasting projects, but doing projects about topics you are interested in. Also keep practicing and learning because at the end what matters the most to employers is that you are capable of doing the job

    • @channelwhoa66
      @channelwhoa66 Před měsícem

      @@juanmartinezii5677 michisimas gracias Juan!! Last question…. For note😁 Should I wait to apply to entry level jobs while I work on portfolio? Or wait till I have a project?
      Thanks again Juan! 🍻