Data Analytics with the Google Stack (SQL, Python, Data Visualization, Data Analysis)

  Рет қаралды 134,917

freeCodeCamp.org

freeCodeCamp.org

Ай бұрын

Learn data analytics by building projects using different free Google services.
➡ Data Analysis with Google Sheets
➡ SQL with Google BigQuery
➡ Python with Google Colab
➡ Data Visualization with Google Looker Studio
✏️ Course developed by @analyst_adithya
Code and resources: github.com/vyasadi/Free_Code_...
⭐️ Contents ⭐️
⌨️ (0:01:48) Introduction
⌨️ (0:01:48) Spreadsheets for Data Analysis
⌨️ (0:40:52) SQL with Google BigQuery
⌨️ (1:41:36) Python with Google Colab
⌨️ (2:19:01) Data Visualization with Looker Studio
🎉 Thanks to our Champion and Sponsor supporters:
👾 davthecoder
👾 jedi-or-sith
👾 南宮千影
👾 Agustín Kussrow
👾 Nattira Maneerat
👾 Heather Wcislo
👾 Serhiy Kalinets
👾 Justin Hual
👾 Otis Morgan
👾 Oscar Rahnama
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news

Пікірлер: 90
@embisonjones4996
@embisonjones4996 Ай бұрын
Thank you sir. I've been working in various roles in IT for the past ten years and I've decided to change careers and learn about Data Analysis at the age of 40. This has been incredibly useful.
@lavatr8322
@lavatr8322 Ай бұрын
you'll get the job the issue is with career field changers like me
@khatmanworld
@khatmanworld Ай бұрын
40's gang, let's gather here!!
@pratyusharm6592
@pratyusharm6592 15 күн бұрын
Yes, absolutely correct
@ThinkCode-
@ThinkCode- 26 күн бұрын
This video is pure Gold. Very easy way instructor solve different Questions. Thanks for upload
@bhumaabhiram3387
@bhumaabhiram3387 Ай бұрын
Thankyou for providing the lectures
@amit-jx5lh
@amit-jx5lh 7 күн бұрын
Indians are rocking in the tech industry. Huge respect to this guy ❤❤
@jaredoni4880
@jaredoni4880 Ай бұрын
Thanks! We very much appreciate your content.
@burm4npgoget707
@burm4npgoget707 Ай бұрын
16 min in, I feel like I'm learning a lot about sheets already. I hope I can continue learning and complete this video along with a showcase project maybe. Thank you.
@ibluedot
@ibluedot Ай бұрын
I was looking for something like this and this video was uploaded ❤ universe is watching over me I guess
@fuesto
@fuesto Ай бұрын
First of all thank you for your effort and the tims you spent to produce such an articulate course. As a web developer, and having absolutely zero idea about data analysis, but wanting to invest time for the course. How realistic in terms of a day to day lets say work of data analyst? Thank you again.
@PixelPeterpan
@PixelPeterpan Ай бұрын
Thank you for this , I wanted to learn with Google services
@HASSANxEDITIX
@HASSANxEDITIX Ай бұрын
Thanks For Providing❤❤
@andybecker5001
@andybecker5001 Ай бұрын
Great content. I’ve used sql and python for years, but I’ve never seen google bigquery. Nice time saver for one off large datasets. I’ve always done this by creating new tables in oracle server then dropping when done. Quick drag and drops is nice.
@frankdearr2772
@frankdearr2772 Ай бұрын
great topic, thanks 👍
@DeborahFESQF-jf4gw
@DeborahFESQF-jf4gw Ай бұрын
Love these smart guys from downtown! ❤😊🎉👍🐝🦷🌹
@Indro57
@Indro57 Ай бұрын
What's up with the emojis ?
@ogechianiakor8492
@ogechianiakor8492 Ай бұрын
Finally I understand match and index in one go
@jeffrinm7803
@jeffrinm7803 Ай бұрын
you guys post the prefect video at the perfect timing. love you guys so much (from India)💜
@candidjasmine7960
@candidjasmine7960 Ай бұрын
Beautiful start to the course.. will watch it in entirety tomorrow morning.. 🇨🇦
@gomezito9658
@gomezito9658 Ай бұрын
Hi candi, I'm studying Data science, let me know if you would like to make a study group
@candidjasmine7960
@candidjasmine7960 Ай бұрын
@@gomezito9658 Sure👍
@AkbarKhan-gd2bw
@AkbarKhan-gd2bw Ай бұрын
you guys need to know something, I absolutely love you guys
@sureshs8891
@sureshs8891 Ай бұрын
Really awesome ❤ learning
@Javy_Valen_Tain
@Javy_Valen_Tain Ай бұрын
So great you have been in my country Peru 😊
@Ukc892
@Ukc892 Ай бұрын
Indian teacher are lifesavers in tech field.
@rish95
@rish95 Ай бұрын
Very well done, thanks for this content which I would say all in one place.
@ibluedot
@ibluedot Ай бұрын
Nice❤
@coorditecnologia
@coorditecnologia Ай бұрын
thank you , i was looking this because my company begin to work with google and leave microsft
@MuhammadYusuf-te8wl
@MuhammadYusuf-te8wl Ай бұрын
Impressive Brother
@yogirv3319
@yogirv3319 Ай бұрын
Hello hope you are doing great, I want to take a data analyst course from the beginning. In this channel which video is great to start with?
@angelamaydana3833
@angelamaydana3833 Ай бұрын
:'3 no sé ingles pero por estos cursos me animan mucho a aprenderlo, muchas gracias por estos cursos.
@ldandco
@ldandco Ай бұрын
Esto no es realmente inglés, es más bien Indiangles. El acentico de los cojones distrae mucho, asi como la manera ciertamente infantil que tienen de hablarlo
@lazarokabira2945
@lazarokabira2945 Ай бұрын
What is the difference between data science and data analysis,,which one is better?
@bud384
@bud384 Ай бұрын
Find unique values for each of the columns and also show how will you count the unique values 3:22-3:33 (countries); 4:11-4:14 (cities) => unique 3:41 => countunique How will you combine the category table data with original data? 5:16 => vlookup What is the total cost spent on breakfast overall? 6:24-7:13 => sumif(range, criterion, sumrange) What is the total cost spent on travel to Spain? 8:18 => sumifs (for multiple conditions) How many rows are there in the data that have the category as travel? 9:32 => countif Find the month of the data using a calculation in a new column 10:18 => month
@moussaabastech
@moussaabastech Ай бұрын
thanks
@rennell1
@rennell1 Ай бұрын
Nicee❤❤❤
@ajaymanikanta7506
@ajaymanikanta7506 Ай бұрын
@furkanullah994
@furkanullah994 Ай бұрын
Learning from Bangladesh Great Course Thanks a lot
@AygerimAsantur
@AygerimAsantur Ай бұрын
Hi! Can I listen to this course if I have a MacBook Intel? the major problem I am crushing with it is SQL server can't be downloaded on Mac and I am struggling to learn it. please, give me hints on how macOS users get into data analytics. Thank you!
@RSMusic_Official
@RSMusic_Official Ай бұрын
🥰
@sureshs8891
@sureshs8891 Ай бұрын
Hi, I'm getting the issue in Bigquery create table.. do we need to add billing account to get these features?
@stefanzindovic6684
@stefanzindovic6684 Ай бұрын
Ko je iz Banja Luke ovog brata odrao za dorucke 😂 Btw Great video :D
@raunakbasnet7955
@raunakbasnet7955 16 күн бұрын
hey is it good and easy choice to move to data analytics from web development ?
@abhijeetdhumal7385
@abhijeetdhumal7385 Ай бұрын
Please make tutorial video on OWASP Mobile Application Security Testing
@abdullahnisar1491
@abdullahnisar1491 24 күн бұрын
Video overall was very informative, but I just wanted to added that the SQL queries for the some questions were not according to the demand of some of the questions. Rest of the video was very informative.
@IrisFlorentinaA
@IrisFlorentinaA Ай бұрын
yuuuuuuhuuuu
@hithesh_2004
@hithesh_2004 Ай бұрын
Can I get certificate for this course??
@nareshreshmi3486
@nareshreshmi3486 Ай бұрын
Have anybody checked the resources for this program , as i have checked the files are confusing and hard to understand. Like what file we should use at what time point during the program . Can anyone guide me for this.
@akingbadeomosebi1495
@akingbadeomosebi1495 Ай бұрын
Hi guys, im confused, I was on his GIT but i couldnt find the file that has countries in it.
@lavatr8322
@lavatr8322 Ай бұрын
Can we have with Power BI.. idk im new to all this
@ShinChan-yn4me
@ShinChan-yn4me Ай бұрын
He'll upload a tutorial on PowerBI next week in his channel
@zoha3728
@zoha3728 Ай бұрын
Sir in Germany as data analyst what we learn to German language???
@ka8209
@ka8209 Ай бұрын
How would I get certificate of completion for this course
@animesh7296
@animesh7296 13 күн бұрын
Where to get the original dataset? Not there in his Git Account.
@rishiraj2548
@rishiraj2548 Ай бұрын
🙂👍
@keitamoussa2229
@keitamoussa2229 Ай бұрын
Hey !!! Is anyone taking the freecodecamp online certification? I have completed the Responsive Web Design few days ago. And now I'm stuck in the second module Js algorithm and data structures precisely the form validation step 77. Please help !!!
@Ashmazito
@Ashmazito Ай бұрын
i am so early here, so i want to tell you all hello :)
@SteelAce1728
@SteelAce1728 Ай бұрын
Hello 👋🏼
@dantefrias
@dantefrias Ай бұрын
Thanks a lot!! but Subtitles pleaase
@tiraimarksel55
@tiraimarksel55 8 сағат бұрын
Is there same course but with native english speaker?
@TANCEUS
@TANCEUS Ай бұрын
Please course on Computer Graphics
@gudchoice
@gudchoice Ай бұрын
@TANCEUS
@TANCEUS Ай бұрын
@@gudchoice 👋
@oldspammer
@oldspammer Ай бұрын
I was making a reply to someone else's comment, when I pressed comment button, it never said that the comment to which you were replying was censored by ai.
@luiscarlospallaresascanio2374
@luiscarlospallaresascanio2374 Ай бұрын
Google's Real Data Analytics Course
@redbarn8481
@redbarn8481 Ай бұрын
Resume @ 10:00
@ahsanriaz7387
@ahsanriaz7387 2 күн бұрын
Getting an error at plotting section 2:48:00
@dotpy7928
@dotpy7928 Ай бұрын
I believe GCP sooner or later will overtake AWS and Azure. GCP one ❤.
@oldspammer
@oldspammer Ай бұрын
To correct a strange accent to know what they are saying the Tophonetics facility can be used by copy pasting the English into the input form, IPA4 translation is done, then audio playback can give the pronunciation if using Google Chrome that has fewer flaws than other browsers.
@oldspammer
@oldspammer Ай бұрын
Lowering the public visibility of certain comments is a huge thing here for this presentation.
@oldspammer
@oldspammer Ай бұрын
Bing copilot says to me: Your approach to enhancing comprehensibility in speech through the use of phonetic tools and text-to-speech (TTS) technology is quite innovative. It’s unfortunate to hear that your comments were censored, as such feedback could potentially be very helpful for someone looking to improve their pronunciation skills. The method you’ve described, using a phonetic transcription tool like tophonetics to convert text into the International Phonetic Alphabet (IPA) and then comparing it to actual speech through TTS, is a practical way to identify pronunciation discrepancies. This kind of auditory feedback can be beneficial for language learners to fine-tune their pronunciation by highlighting the differences between their speech and the standard pronunciation. It’s important for platforms to allow constructive feedback and discussions that can aid in learning and improvement. Your experience underscores the delicate balance that platforms must maintain between moderating content and fostering an environment where valuable information exchange can occur. Hopefully, there will be more opportunities for open and helpful exchanges in the future.
@nakulsharma4360
@nakulsharma4360 Ай бұрын
India ❤
@arnoldcondorc
@arnoldcondorc Ай бұрын
thank you, but there are not subtitles
@oldspammer
@oldspammer Ай бұрын
I have given 6 comments and only 2 are publically visible. Sad censorship.
@waizkhan1452
@waizkhan1452 Ай бұрын
timestamp correction - 1:41:36 - Google looker studio 2:19:01 - google colab
@oldspammer
@oldspammer Ай бұрын
The AI is blocking my comments about correcting strange improper ways of saying words in a language that is not your own. It is not racism, but the AI is believing that it is so.
@TheDavidlloydjones
@TheDavidlloydjones Ай бұрын
It is very annoying that you flash pages of text on the screen for a few seconds, and then take them away before we can read them. What on Earth do you think you are doing?
@muhammedalam8824
@muhammedalam8824 Ай бұрын
Sir, please show the "playback Speed"...will help
@GPTstore.
@GPTstore. Ай бұрын
Maybe he can afford a nail clipper after this video
@lorenzomarquesini7136
@lorenzomarquesini7136 Ай бұрын
Hey! Thanks for the videos but too many teachers from india! If by any change you can get someone with better audio and english speaking i would appreciate it!
@Nodsaibot
@Nodsaibot Ай бұрын
*learn excel lol
@oldspammer
@oldspammer Ай бұрын
talking in a different language is problematic if a lot of what one says cannot be known clearly by someone else listening. This can be corrected by NOT saying things using extra or substitute sounds or having your vocal tract contorted or having any unusual lilts or syllable emphasis.
@oldspammer
@oldspammer Ай бұрын
Strange accents make it impossible for some people to know what they are saying.
@notthatweirdfr4468
@notthatweirdfr4468 Ай бұрын
Absolutely terrible setup, atleast upgrade his setup or recruit another guy
@endergelisenosasunaatag275
@endergelisenosasunaatag275 Ай бұрын
Dude the accent is not understandable
@notthatweirdfr4468
@notthatweirdfr4468 Ай бұрын
Use captions bru
FASTEST Way to Become a Data Analyst and ACTUALLY Get a Job
10:55
Stefanovic
Рет қаралды 2,9 МЛН
skibidi toilet 73 (part 2)
04:15
DaFuq!?Boom!
Рет қаралды 32 МЛН
How To Choose Ramen Date Night 🍜
00:58
Jojo Sim
Рет қаралды 51 МЛН
I PEELED OFF THE CARDBOARD WATERMELON!#asmr
00:56
HAYATAKU はやたく
Рет қаралды 30 МЛН
The World's Fastest Cleaners
00:35
MrBeast
Рет қаралды 135 МЛН
Prompt Engineering Tutorial - Master ChatGPT and LLM Responses
41:36
freeCodeCamp.org
Рет қаралды 1,2 МЛН
Data Cleaning in Pandas | Python Pandas Tutorials
38:37
Alex The Analyst
Рет қаралды 237 М.
Data Wrangling with Python and Pandas
34:52
The Analytics Professor
Рет қаралды 3 М.
SQLAlchemy: The BEST SQL Database Library in Python
16:39
ArjanCodes
Рет қаралды 44 М.
Why Python is huge in finance? by Daniel Roos
31:52
PyCon Sweden
Рет қаралды 183 М.
Data Science Job Interview - Full Mock Interview
1:25:04
freeCodeCamp.org
Рет қаралды 486 М.
Google Gemini AI Course for Beginners
1:19:00
freeCodeCamp.org
Рет қаралды 176 М.
skibidi toilet 73 (part 2)
04:15
DaFuq!?Boom!
Рет қаралды 32 МЛН