Lesson#6 - BigQuery for beginners| Analyze data in google bigquery | Step by step tutorial (2020)

Lesson#6 - BigQuery for beginners| Analyze data in google bigquery | Step by step tutorial (2020)
#bigquery #googlecloud #bigquerytutorial #gcp #googlebigquery #bigquerypricing
*Link to Complete playlist*
1) Latest technology tutorial (2020) -
• What is a Data Vault ?...
2) Google Cloud Platform Beginner Series (2020) -
• Google Cloud Platform ...
3) Crunching Data Series (2020) - • Learn - Data Engineeri...
Hi Friends, I am Anshul Tiwari and welcome to our youtube channel ITkFunde.
About this video -
In this 6th video tutorial under the google cloud platform beginner series (2020), we will learn to work with google big query from scratch. In this 25 minute tutorial we will cover the following :-
1) WHAT IS BIG QUERY ?
2) BIG QUERY FEATURES
3) BIG QUERY PRICING
4) BIG QUERY DEMO (ACCESS StackOverflow BIG DATA)
5) HOW BIG QUERY SPECIAL DATATYPES (ARRAY) ?
We will understand why bigquery is the USP of google cloud platform. What makes it so fast, efficient, and cost-effective. We will also learn biqquery pricing model and how it is so cheap to crunch your data on big query.
We will then take a hand on exercise to explore StackOverflow public dataset provided by google big query and try to solve a query using SQL. We will understand how big query supports array data types and provides functions like UNNEST () to convert your array data types into strings.
Credits & Resources -
Google Documentation - cloud.google.c...
A Good article on unnesting - / how-to-use-select-from...
Google Cloud Platform Channel- / googlecloudplatform
**Social Links**
Facebook - / itkfunde
Linkedin - / ansh9685
Twitter - / ansh9685
Blog - blogs.itkfunde...
Instagram - / itkfunde
**About This Channel**
Friends ITkFUNDE channel wants to bring I.T related knowledge, information, career advice, and much more to every individual regardless of whether he or she belongs to I.T or not. This channel is for everyone interested in learning something new!

[@Kaabstract]

Man!! Great video!!

[@AnshulMarele-gbaa]

Hi, you always post very very informative videos. One Que. I have an Excel365 file which has data from the odbc connection, which updates automatically in scheduled intervals, how can I sync that Excel data into Google Sheets with auto updates?

[@informationsatellite5155]

Amazing session .. thank you very much.

[@luiscunha3759]

Very good video! Thanks a lot!

[@arshqureshi5388]

Sir ppl still don't know much about cloud once tis subject gets into the curriculum ur going to be top on youtube channel for gcp

[@ITkFunde]

Thanks Arshiya hope it helps every one

[@EstherAdeniyi-mr7pt]

You were Excellent, thank you.

[@CaribouDataScience]

Thanks , this was helpful.

[@deepak3475]

Precisely explained for a layman

[@ITkFunde]

Thanks Deepak

[@nagesh007]

Thanks

[@yuvabhagvatkathakarshriyag9305]

this is very helpful lab session on GBQ.

[@ITkFunde]

Thanks Yagnik

[@googlemani]

Very neatly explained the BigQuery concept along with a good demo. Thank you, its very helpful.

[@timwebster85]

I learnt a ton from this thank you!

[@VinodKumar-wc6bu]

Great job

[@G7DHALIWAL]

At 1.58 .. I think its atlas not hercules.

[@rajithkumar3424]

good one

[@timothy2600]

Your tutorials and explanations are clear to understand and concise, make more on ML pipelines in GCP

[@proud_indian408]

I'd say far better explanation than any other GBQ tutorial, really nice sir, is it possible to make the same concept using IaaS like terraform in gcp , please 🙏

[@ITkFunde]

Hi Rawin thanks its a good idea I will pit it in my list

[@EV_Techie]

@@ITkFunde sir I have 2 database and want to compare 2 table and find unmatched records. Can you please reply how to do it.

[@stephenfoster9009]

Sampson was the strongest man on Earth. Hercules is a myth. Thx.

[@niftystrategy6933]

very nice explanation

[@ITkFunde]

Thanks Rajiv

[@namandeepkaur8165]

thanks for teaching in a simple way! amazing !!

[@deepikasrinivasan1808]

Thanks for the detailed explanation!

[@nilavasen8631]

hello, I have a question. Do one need to learn Big Data as pre requisite to learn GCP Data Enginner services, like BigQuery, BigTable etc. ? Plz suggest.. TY.

[@pradeepkogala3646]

Nice video . Please post more videos on GCP.

[@shahnawazkhan1636]

Awesome

[@ITkFunde]

Thanks Shahnawaz ☺️

[@latestvideosnews]

Nice

[@saptarshisarkar1002]

Are you continuing this series? Only 9 vdo I can see. Outstanding vdo by the way Sir.

[@shivaramakrishna3871]

Excellent

[@deepakjaiswal-tm4pj]

Please create full course if possible, waiting from bottom of my hart .... :-)

[@zishanafzal6671]

Sir, Is the query similar to what we mysql query becoz here we also use sql but unnest function is not there?

[@sandeepmore5290]

Good..Can you give LIVE demo session...?..Reply..

[@cricmania1413]

Sir thanks for this video. Which one is better Snowflake or Big query please explain

[@ITkFunde]

Its a good question but unfortunately i havent worked on Snowflake but I am planning to explore it in my own capacity and will share my novice learnings and comparison with Big Query

[@nabarunganguly5976]

I would like to learn bigquery. Will you please teach me. I need to learn this immediately.

[@jitendrachouhan7024]

How to train Recommandation Model from google analytics event.

[@triumphmusic7495]

Big query saves data date wise how can i retrieve one month data in big query, will i have to join all tables first

[@ITkFunde]

You need to have a date field in your table if you simply want last one month data you can have a created_date column to be added for each record moreever you can partition your table month wise for cheaper reads.

[@kawtikwarfamily5978]

No further videos uploaded on gcp?

[@ITkFunde]

Sorry mate due to multiple request I am currently making vidoe series on networking but would soon switch to GCP. Thanks for your feedback 🙏

[@rahulrasure4591]

Hello , Is there any full tutorial on Google BigQuery ? If any can you please provide here the link. It would be very helpful to learn Google BQ.

[@simmyantony6575]

Really helpful video.Can you please suggest a good comprehensive course on BigQuery ?

[@ITkFunde]

Coursera offers some comprehensive courses and also affliated with Google

[@efcdatasupport6375]

Sir How To Connect Mircosoft SQL Server Database / Table into Google Sheet through BigQuery?

[@digitaldiary9410]

please sir upload more videos on gcp..

[@jayalakshmij872]

Hello sir do you know how to reach sub collections in firestore to bigquery

[@johnho3542]

Do you have more tutorials on big query :)

[@gamyamentertainment4922]

Hi Brother, In the google cloud platform cloud shell editor, I was written one code, but I was facing a Chrome driver issue. I was written python code in my local IDE(visual studio code ) code is working and the file I was pushing into the google cloud bucket. the same script I was running into google could shell editor, asking for chrome driver executable, needs to be a path like that error I was facing. Did you know how to overcome this error ? please tell me if you have any solution.

[@ITkFunde]

can you send me the eact error with error code ?

[@gamyamentertainment4922]

@@ITkFunde yes..i will send you

[@gamyamentertainment4922]

@@ITkFunde How can i send that image Bro?

[@ITkFunde]

send on [e-mail]

[@gamyamentertainment4922]

@@ITkFunde please check sir..I was sended issue in your email

[@maheshrai5940]

Vedio content is not clear. Subject and explaination is good but presentation is not visible

[@moushmidas2584]

Really helpful.❤️❤️..sir could please create some more video for data migration...like kafka server payload to cloud bucket...demo

[@ITkFunde]

Thanks Moushmi sure thanks for your support I have plans to do a data series in future

[@sha2460]

@@ITkFunde i request you to please create more videos regarding data engineering perspective on GCP as well. also do include dataproc,dataflow, partition, bucketing etc, please

[@shamsudindahir]

How can I download this

[@moulika123teja7]

Any contact for online class?

[@kaladharmurakonda9233]

Dear sir , If give me 17 chapter gcp certificate From you. After complete classes. Kaladhar muakonda

[@JackieJernigan]

Gonzalez Daniel Gonzalez Lisa Harris William

[@lheojfgzwhfyuodognjo9491]

text

[@AkashVerma-mg7ys]

Poor explanation as some where you write whole query and didn’t explain and skip that part.

[@jzr6148]

This query will give the same result : SELECT tagst, count(*) as tag_count FROM `bigquery-public-data.stackoverflow.posts_questions`, UNNEST(split(tags,"|")) as tagst WHERE EXTRACT(YEAR FROM creation_date) >= 2008 GROUP BY tagst ORDER BY tag_count desc LIMIT 10

[@toast_on_toast1270]

Excellent video, thank you!