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
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).
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.
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. :)
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.
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..
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!
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?
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?
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.
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?
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?
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.