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
@germanbrunner31264 жыл бұрын
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).
@GaganKPolska4 жыл бұрын
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.
@MeasureSchool3 жыл бұрын
Great!
@lindamyers9514 ай бұрын
I feel the same way I was glad to find video.
@snehas16343 жыл бұрын
A perfect introductory video. Thank you for the super walk-through.
@梁佳玥-s5p2 жыл бұрын
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.
@yousefesfahanian2636 Жыл бұрын
you are the best !
@rohanpunyarthi7317 Жыл бұрын
Best Introduction.
@zacharycachuela72642 жыл бұрын
It was a great video, I learned alot as a beginner on this SQL thank you man!
@songsofsalem3 ай бұрын
Not rocket science after all. Got a lot of learning to do though. Thanks for sharing.
@ricardoparra7473 жыл бұрын
Measurement School is simply the best
@CelineYangXu3 ай бұрын
could i change the query name ? without save the query?
@C15-k4d8 ай бұрын
Is it data studio or looker stidio ?
@berkkalyoncu415 Жыл бұрын
Thank you man
@bumuthudilshan53954 жыл бұрын
Awesome video! very helpfull. Thanks!
@eluxury22 жыл бұрын
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?
@guillermorosas33983 жыл бұрын
excellent video, thanks!!
@jamesleleji94702 жыл бұрын
How do you reorder columns in BIGQuery? Thanks
@ajaviles133 жыл бұрын
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?
@MeasureSchool3 жыл бұрын
you would need to have an extraction tool to stream the data in real time, so yes, it's possible
@Loriiik3 жыл бұрын
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
@germanbrunner31264 жыл бұрын
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. :)
@rickardcarlsson98554 жыл бұрын
Very good introduction, I would love to see some examples if how to analyze GA-data.
@MeasureSchool4 жыл бұрын
thanks for the suggestion.
@bala7386 Жыл бұрын
i like to know how to skip the part of credit card information.
@africomptyltd52745 ай бұрын
😢 please help bro
@mjuzik2783 Жыл бұрын
Hi, is this tutorial still relevant after 2 years? I'm looking into this topic and would like to learn the basics.
@digavalli123 Жыл бұрын
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..
@nadirarbia68274 жыл бұрын
Very simple & clear introduction. Good job ! Would love to see a video with analyzing google ads data :)
@TheDarkVlame Жыл бұрын
if value in the row becomes null how can i solve this problem. Can you help me pls
@matthewbryan62804 жыл бұрын
Nice introduction, nice use of chapters and at a good pace. Appreciated.
@sthopefoundation3 жыл бұрын
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_mishra2 жыл бұрын
Hey Rodney, what would you recommend now that you're one year into it?
@DavidEsp1 Жыл бұрын
Thank you, a very helpful quick tour
@MikeTaylor1113 жыл бұрын
The best introduction to GBQ I've seen. Thanks Julian.
@李星颖 Жыл бұрын
very clear tutorial i feel like i master bigquery after watching
@brawlernoob67804 жыл бұрын
Thanks Julian, Its Very Simple to learning customer behavior by data.
@markswearingen1172 жыл бұрын
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
@kgkbym2 жыл бұрын
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?
@asmaerchid-r6f2 жыл бұрын
Many thanks to you it is very short and concise and you made the use soon clear.
@salaiarunmanijb174 Жыл бұрын
How to Visualize multiple query at a time
@souleyedeme19022 жыл бұрын
Great tutorial! You saved me a lot of time! Thank you very much!
@DavidEsp1 Жыл бұрын
Intro music to dialogue loudness ratio is >1. No big deal, but 1:1 would improve.
@kritikarana5320 Жыл бұрын
Your tutorials are always awesome 👍
@C15-k4d8 ай бұрын
Is it data studio or looker stidio ?
@C15-k4d8 ай бұрын
Is it data studio or looker stidio ?
@kellygian7237 Жыл бұрын
so much easier when you explain it ! thank you !
@devikanaik45773 жыл бұрын
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.
@kaorisimmons5848 Жыл бұрын
the group by is crazy
@tommy9x3 жыл бұрын
I don't see create dataset any more
@videosvideos6243 Жыл бұрын
Can you set up a table based on Google scholar articles? Will it auto create a table from it?
@obitheanalyst Жыл бұрын
Can I get the exact link to where you downloaded the sales dataset
@foxmulder12603 жыл бұрын
Thank you, it's clearer !
@Avi80534 ай бұрын
Thank you
@azhari79682 жыл бұрын
I have to enter my credit card number to start BigQuery?
@chitwanhumad40793 жыл бұрын
Can we connect on-premise data using BigQuery and show reports on GA?
@raptyaxa57712 жыл бұрын
So it's like a regular SQL plus data visualization tool.
@palomagarcia-delgado1173 жыл бұрын
Simple and clear introduction, thanks!
@MeasureSchool3 жыл бұрын
Glad it was helpful!
@meka85403 жыл бұрын
Could you please let me know how to insert a default value I n bigquery
@yuliia32463 жыл бұрын
This is super great overview!! 🎉 Thank you so much! Really useful
@shishirmahapatra67703 жыл бұрын
It was a very useful intro.
@ReyTezz Жыл бұрын
Hi where can I find the dataset? The google sheet?
@azzahyder10 ай бұрын
thank you this was very helpful
@LaureanVincent53 жыл бұрын
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!
@MeasureSchool3 жыл бұрын
Excellent!
@naveenc88892 жыл бұрын
Its really interesting and nice video to understand in a simple way
@pedrojunior67558 ай бұрын
Thanks a lot for this overview!
@adegboyegablessingolamide4147 Жыл бұрын
Thanks in the bunch. This is great
@tommy9x3 жыл бұрын
you forgot CSV link file
@dianaflute2 жыл бұрын
Thank you
@sumaiyasohail81863 жыл бұрын
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.
@MeasureSchool3 жыл бұрын
no, never took the exam
@kavitvichhivora70252 жыл бұрын
Amazing video 🔥
@AlexyLek3 жыл бұрын
Thanks for sharing
@AhlamLamo4 жыл бұрын
nice quick tutorial i like it thank you
@dollysiharath42052 жыл бұрын
Thank you!!!
@thinkpositive803 жыл бұрын
Thank you :)
@chirukurisuryavaraprasad06792 жыл бұрын
Nice
@mohanvoleti2 жыл бұрын
Super
@techspecialistapple93933 жыл бұрын
very well presented mate
@LAMERFENER3 жыл бұрын
Nice accent
@desisto0074 жыл бұрын
Thank you so much for sharing that!! Is that possible to integrate it with Google analytics?
@MeasureSchool4 жыл бұрын
Yes, it is - indirectly via export or directly if you have GMP
@theresebjrknes42723 жыл бұрын
His voice reminds me of Tom Lehrer's voice.
@MeasureSchool3 жыл бұрын
never heard of him... is that a good thing?
@paragjain25724 жыл бұрын
Great work. Thanks for sharing.
@AtoZMotivation34 жыл бұрын
Tell a little bit more about KZbin teespring Store l
@MeasureSchool4 жыл бұрын
what do you want to know about it?
@maheshkariya3 жыл бұрын
*Thanks* 🙏
@MeasureSchool3 жыл бұрын
You are welcome!
@gaius_mariusАй бұрын
Very helpful tutorial, thank you very much
@6496astom3 жыл бұрын
Thank you very much
@MeasureSchool3 жыл бұрын
You are welcome!
@shankarnarayananiyer87153 жыл бұрын
This is what Mario Goetze would look if he was a Data Geek :D...
@MeasureSchool3 жыл бұрын
lol... now I just need to learn to play football
@shankarnarayananiyer87153 жыл бұрын
Go for it. You might even score in the world cup finals ;)