Тёмный

Google BigQuery Tutorial 

MeasureSchool
Подписаться 184 тыс.
Просмотров 307 тыс.
50% 1

Опубликовано:

 

4 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 102   
@MeasureSchool
@MeasureSchool 4 года назад
Have you used BigQuery already? What for? Let me know your use case. 0:00 - Intro 1:12 - What Is BigQuery, and Why Use It? 4:33 - Using Google BigQuery 5:20 - Creating a Dataset 7:44 - Querying Your Dataset 9:35 - Grouping Data 10:30 - Saving Queries 11:18 - Visualizing a BigQuery Dataset in Google Data Studio
@germanbrunner3126
@germanbrunner3126 4 года назад
I use it to store and blend digital marketing data from different sources like Facebook Ads, Google Ads and Google Analytics, to consume this data with PowerBI afterwards. I've been using the Stitch service to integrate all those data sources (except for Google Ads, which I was able to link using the native integration).
@GaganKPolska
@GaganKPolska 4 года назад
I will be using BigQuery in my new role as an Analyst and I was kind of scared of BigQuery but I am much more relaxed after watching the video. Thank you.
@MeasureSchool
@MeasureSchool 3 года назад
Great!
@lindamyers951
@lindamyers951 4 месяца назад
I feel the same way I was glad to find video.
@Loriiik
@Loriiik 3 года назад
One of the best Introduction videos I've seen. Straight to the point and even examples on how to interact with other platforms. Thank You
@germanbrunner3126
@germanbrunner3126 4 года назад
Great intro Julian! Thank you very much! I was wondering if you could make another video, showing how to push data into BigQuery using the Cloud Functions tool, maybe getting data from GA or Facebook Ads. :)
@MikeTaylor111
@MikeTaylor111 3 года назад
The best introduction to GBQ I've seen. Thanks Julian.
@李星颖
@李星颖 Год назад
very clear tutorial i feel like i master bigquery after watching
@kellygian7237
@kellygian7237 Год назад
so much easier when you explain it ! thank you !
@matthewbryan6280
@matthewbryan6280 4 года назад
Nice introduction, nice use of chapters and at a good pace. Appreciated.
@snehas1634
@snehas1634 3 года назад
A perfect introductory video. Thank you for the super walk-through.
@brawlernoob6780
@brawlernoob6780 4 года назад
Thanks Julian, Its Very Simple to learning customer behavior by data.
@nadirarbia6827
@nadirarbia6827 4 года назад
Very simple & clear introduction. Good job ! Would love to see a video with analyzing google ads data :)
@DavidEsp1
@DavidEsp1 Год назад
Thank you, a very helpful quick tour
@kritikarana5320
@kritikarana5320 Год назад
Your tutorials are always awesome 👍
@梁佳玥-s5p
@梁佳玥-s5p 2 года назад
Thank you for sharing this video. It is very helpful thatI could apply it to my work right now. The explanation is very to understand and the demo also made me understand the structure deeply.
@souleyedeme1902
@souleyedeme1902 2 года назад
Great tutorial! You saved me a lot of time! Thank you very much!
@asmaerchid-r6f
@asmaerchid-r6f 2 года назад
Many thanks to you it is very short and concise and you made the use soon clear.
@palomagarcia-delgado117
@palomagarcia-delgado117 3 года назад
Simple and clear introduction, thanks!
@MeasureSchool
@MeasureSchool 3 года назад
Glad it was helpful!
@yuliia3246
@yuliia3246 3 года назад
This is super great overview!! 🎉 Thank you so much! Really useful
@rickardcarlsson9855
@rickardcarlsson9855 4 года назад
Very good introduction, I would love to see some examples if how to analyze GA-data.
@MeasureSchool
@MeasureSchool 4 года назад
thanks for the suggestion.
@foxmulder1260
@foxmulder1260 3 года назад
Thank you, it's clearer !
@pedrojunior6755
@pedrojunior6755 9 месяцев назад
Thanks a lot for this overview!
@zacharycachuela7264
@zacharycachuela7264 2 года назад
It was a great video, I learned alot as a beginner on this SQL thank you man!
@yousefesfahanian2636
@yousefesfahanian2636 Год назад
you are the best !
@rohanpunyarthi7317
@rohanpunyarthi7317 Год назад
Best Introduction.
@digavalli123
@digavalli123 2 года назад
Nice video bro ! one query...Is it possible to delete table data using row_number function in big query...I am not succeeded...wanted to check with you..
@naveenc8889
@naveenc8889 2 года назад
Its really interesting and nice video to understand in a simple way
@mjuzik2783
@mjuzik2783 Год назад
Hi, is this tutorial still relevant after 2 years? I'm looking into this topic and would like to learn the basics.
@azzahyder
@azzahyder 10 месяцев назад
thank you this was very helpful
@LaureanVincent5
@LaureanVincent5 3 года назад
Super video.. this one and the follow up video.... I feel much more confident about pursuing my Media data analysis away from the paid connectors with BQ. On my way. Thanks obi one!
@MeasureSchool
@MeasureSchool 3 года назад
Excellent!
@adegboyegablessingolamide4147
Thanks in the bunch. This is great
@shishirmahapatra6770
@shishirmahapatra6770 3 года назад
It was a very useful intro.
@ricardoparra747
@ricardoparra747 3 года назад
Measurement School is simply the best
@songsofsalem
@songsofsalem 3 месяца назад
Not rocket science after all. Got a lot of learning to do though. Thanks for sharing.
@bumuthudilshan5395
@bumuthudilshan5395 4 года назад
Awesome video! very helpfull. Thanks!
@paragjain2572
@paragjain2572 4 года назад
Great work. Thanks for sharing.
@DavidEsp1
@DavidEsp1 Год назад
Intro music to dialogue loudness ratio is >1. No big deal, but 1:1 would improve.
@guillermorosas3398
@guillermorosas3398 3 года назад
excellent video, thanks!!
@CelineYangXu
@CelineYangXu 3 месяца назад
could i change the query name ? without save the query?
@bala7386
@bala7386 Год назад
i like to know how to skip the part of credit card information.
@africomptyltd5274
@africomptyltd5274 5 месяцев назад
😢 please help bro
@techspecialistapple9393
@techspecialistapple9393 3 года назад
very well presented mate
@berkkalyoncu415
@berkkalyoncu415 Год назад
Thank you man
@AhlamLamo
@AhlamLamo 4 года назад
nice quick tutorial i like it thank you
@sthopefoundation
@sthopefoundation 3 года назад
Julian, Great overview. I’ve been using GoogleSheets for Data Studio reports but have reached it’s capacity with 2years worth of data. I’m transitioning to GCP, it allows you to select 2 products for free. BigQuery is my first product selection. Any recommendations on the second product selection for a beginner in data visualization and cloud storage? Also, I’m assuming BigQuery will process the data queries much faster for GDS reports. Do you have more videos on BigQuery?
@prajjwal_mishra
@prajjwal_mishra 2 года назад
Hey Rodney, what would you recommend now that you're one year into it?
@raptyaxa5771
@raptyaxa5771 2 года назад
So it's like a regular SQL plus data visualization tool.
@videosvideos6243
@videosvideos6243 Год назад
Can you set up a table based on Google scholar articles? Will it auto create a table from it?
@C15-k4d
@C15-k4d 8 месяцев назад
Is it data studio or looker stidio ?
@Avi8053
@Avi8053 4 месяца назад
Thank you
@TheDarkVlame
@TheDarkVlame Год назад
if value in the row becomes null how can i solve this problem. Can you help me pls
@obitheanalyst
@obitheanalyst Год назад
Can I get the exact link to where you downloaded the sales dataset
@eluxury2
@eluxury2 2 года назад
If I am running several steps for data cleaning, how do I save the clean data as it goes like Excel versus saving the returned data separately after each steps?
@gaius_marius
@gaius_marius Месяц назад
Very helpful tutorial, thank you very much
@AlexyLek
@AlexyLek 3 года назад
Thanks for sharing
@kavitvichhivora7025
@kavitvichhivora7025 2 года назад
Amazing video 🔥
@sumaiyasohail8186
@sumaiyasohail8186 3 года назад
Hi, you elaborate it very well. Thanks for the consice explanation. I am preparing for GCP data engineering certification exam. Can you please guide me on which big query areas I need to emphasize more. I am running out of the time. Kindly suggest important areas regarding big query, that could help me to crack that exam. I am already doing qwiklabs regarding big query. Thanks & Regards.
@MeasureSchool
@MeasureSchool 3 года назад
no, never took the exam
@dollysiharath4205
@dollysiharath4205 2 года назад
Thank you!!!
@kaorisimmons5848
@kaorisimmons5848 Год назад
the group by is crazy
@salaiarunmanijb174
@salaiarunmanijb174 Год назад
How to Visualize multiple query at a time
@ajaviles13
@ajaviles13 3 года назад
Great video! But quick question: Can you use BigQuery to get real-time data within a Google Sheet? Let's say we have 100 franchises of McDonalds and each franchise uses Google Sheets to store sales data. Can BigQuery be used to extract this sales data in real-time to the Big Query data set interface?
@MeasureSchool
@MeasureSchool 3 года назад
you would need to have an extraction tool to stream the data in real time, so yes, it's possible
@ReyTezz
@ReyTezz Год назад
Hi where can I find the dataset? The google sheet?
@jamesleleji9470
@jamesleleji9470 2 года назад
How do you reorder columns in BIGQuery? Thanks
@thinkpositive80
@thinkpositive80 3 года назад
Thank you :)
@tommy9x
@tommy9x 3 года назад
I don't see create dataset any more
@azhari7968
@azhari7968 2 года назад
I have to enter my credit card number to start BigQuery?
@chitwanhumad4079
@chitwanhumad4079 3 года назад
Can we connect on-premise data using BigQuery and show reports on GA?
@kgkbym
@kgkbym 2 года назад
Hello, starting to learn bigquery but every time I try to query I don’t get that first line with “Select” on it, it’s just blank, does anyone know how fix that?
@devikanaik4577
@devikanaik4577 3 года назад
I m able to upload the csv but after uploading,table title is not coming under the Field name . I m getting something like string_field_0,_1,_3. How can i get the title mapped under field name.
@6496astom
@6496astom 3 года назад
Thank you very much
@MeasureSchool
@MeasureSchool 3 года назад
You are welcome!
@desisto007
@desisto007 4 года назад
Thank you so much for sharing that!! Is that possible to integrate it with Google analytics?
@MeasureSchool
@MeasureSchool 4 года назад
Yes, it is - indirectly via export or directly if you have GMP
@meka8540
@meka8540 3 года назад
Could you please let me know how to insert a default value I n bigquery
@maheshkariya
@maheshkariya 3 года назад
*Thanks* 🙏
@MeasureSchool
@MeasureSchool 3 года назад
You are welcome!
@mohanvoleti
@mohanvoleti 2 года назад
Super
@chirukurisuryavaraprasad0679
@chirukurisuryavaraprasad0679 2 года назад
Nice
@markswearingen117
@markswearingen117 2 года назад
I'm taking a class using bigquarry, been using it for months and I still have no clue what I'm doing. I hate Big Quarry
@tommy9x
@tommy9x 3 года назад
you forgot CSV link file
@shankarnarayananiyer8715
@shankarnarayananiyer8715 3 года назад
This is what Mario Goetze would look if he was a Data Geek :D...
@MeasureSchool
@MeasureSchool 3 года назад
lol... now I just need to learn to play football
@shankarnarayananiyer8715
@shankarnarayananiyer8715 3 года назад
Go for it. You might even score in the world cup finals ;)
@theresebjrknes4272
@theresebjrknes4272 3 года назад
His voice reminds me of Tom Lehrer's voice.
@MeasureSchool
@MeasureSchool 3 года назад
never heard of him... is that a good thing?
@AtoZMotivation3
@AtoZMotivation3 4 года назад
Tell a little bit more about RU-vid teespring Store l
@MeasureSchool
@MeasureSchool 4 года назад
what do you want to know about it?
@LAMERFENER
@LAMERFENER 3 года назад
Nice accent
@anousavelavet8425
@anousavelavet8425 2 года назад
Anousa Velavet
@C15-k4d
@C15-k4d 8 месяцев назад
Is it data studio or looker stidio ?
@dianaflute
@dianaflute 2 года назад
Thank you
@C15-k4d
@C15-k4d 8 месяцев назад
Is it data studio or looker stidio ?
Далее
Google Data Studio Tutorial for Beginners 🔥
27:51
Просмотров 565 тыс.
BigQuery Architecture
10:33
Просмотров 16 тыс.
How does BigQuery store data?
8:20
Просмотров 49 тыс.