00:00 - Intro 5:02 - The Big Data Problem 7:21 - The Solution 9:15 - Your Data Pipeline Journey 15:54 - What is BigQuery? 24:00 - Extract & Load Data: Getting Data into BigQuery 29:37 - Transform Data: Clean, Join, Prepare and Manipulate 31:03 - Using Your Data: Visualization, Analysis, and Upload 34:25 - A Hands-On Demo
@andresu6796
3 жыл бұрын
Great and usefull video,thanks a lot and he explains very well.
@MeerVideos3 жыл бұрын
As Digital Marketing is evolving and nobody knows how this is going to be in the next 5 years, It's so great to see how data science and marketing coming together. I'm on a journey to become a Market/Business Analyst from Digital Account Management. It's going to be an interesting switch and these videos are indeed life savior.
@putyah2 жыл бұрын
This video is awesome. I've used the timeline/slides of this video for many presentations and it has been an blueprint for many projects. I always refrence to this channel before presenting. Thank you.
@madhukyatham4 жыл бұрын
Great Video measure school, Thank you, expecting more on bigquery as data guy. Thanks
@AkshayKumarJain_official3 жыл бұрын
This is a great video, I came across before having an interview to understand use-cases. Thanks
@useydkerimoglu57202 жыл бұрын
I think this was the most helpful video I have ever watched on KZread. All the love :)
@lena57214 жыл бұрын
Best 1 hour investment in my education lately. That’s so this great video
@MeasureSchool
4 жыл бұрын
Great to hear!
@dudeiknowman4 жыл бұрын
Thank you so much! So much value.
@ASO-xh5vu2 жыл бұрын
Fantastic presentation. Absolutely fantastic
@ignaciopinero25692 жыл бұрын
Nice one guys : ) thank you a lot and keep it up
@birdsong25523 жыл бұрын
more like these would be great!
@e-commercecorporation45832 жыл бұрын
Very informative video Thank you so much
@saumitrad2 жыл бұрын
The trainer (Amad) is fantastic.
@niteshnirala16644 жыл бұрын
Thanks for video Ahmad and Julian! Few questions I had - When we have terabytes of data in Bigquery. Do we leave it there or should I export to Google Cloud Storage? What is the good practice to minimize cost in Google Cloud? - I will be interested in having the app script. Do you have script that will update columns in row if it has a matching date? I want to extract data in weekly basis and upload it. I want to avoid duplicates and override values if the fields has changed.
@akshay68223 жыл бұрын
Great video, I tried the same with a UK data set but for some reason, it’s giving me a syntax error when I merge two data sets “Unexpected String Literal”.
@ryanvaughan12474 жыл бұрын
Can’t thank you enough.
@maraudeuse9522 жыл бұрын
Hello hello! Thank you for the tutorial. I did everything that was in the video, but I got no data in the datatable. I also did not get error message. Can you please tell me how I can debug the problem or what to do?
@gotit5473 жыл бұрын
If I run query and connected that data to GDS and display there then how does the data view in data studio get refreshed if the data is from source like GA that is live
11 ай бұрын
Ahmad is a top notch trainer. Which I could learn on the job with him. ;) I did not know that UA also had sampling data. The video has almost three years, so I don't know if at that time was possible. But right now can't we create a simple pipeline GA4 > BigQuery? Or the example of data pipelines were given to connect more data sources than only GA4? Did not full understand it. TY.
@jahangeeryousaf65873 жыл бұрын
hi Julian, coming to this video and the function that was copy pasted. i tried that function but i was stuck at newblob and could not go further and when i generated table automatically and tried to export the data to datastudio i was stuck with following error... Failed to fetch data from the underlying data set Error ID: 0e5ecee6 can you help me with it? i will be very thankful to you
@user-oe5ki5to5v3 жыл бұрын
Much thank you! Could you tell about incremental uploading? How does it work in BigQuery?
@abdulmunaf4941
3 жыл бұрын
Did you find any solution? Iam also looking for possible solution on incremental upload
@sandeepmore52902 жыл бұрын
Good..I like your in dept knowledge about google big query.Can you deliver hands on demo on Google Big Query in online mode..plz reply..
@RGopiKrishna4 жыл бұрын
why should we use it ?
@ElcoTubes4 жыл бұрын
Thank you for the great video. Is it possible to share the script?
@MeasureSchool
4 жыл бұрын
please Email ahmad on his website
@Poziom666
3 жыл бұрын
@@MeasureSchool If it's possible, also a script please
@abhimanyusachdeva30823 жыл бұрын
The reason it did not work is that you misspelled the "Var TableID = dailly_users_per state", spelling of "dailly" is wrong in the script.
@sikendongol42083 жыл бұрын
aayo BigQuery
@neuralbookkeeping9269 Жыл бұрын
Bummer, the one reason that I watched this video was to see how to authorize data and then he skipped over the process.
@michaelcarbonnier58772 жыл бұрын
I am having some debugging issues around the "var spreadsheet" line var projectId = 'GA-userdata'; var datasetId = 'GA_user_region'; var tableId = 'daily_users_per_region'; var spreadsheet = SpreadsheetApp.GetActiveSpreadsheet(); var values = spreadsheet.getsheetsbyname('Bigquery_ref').getDatarange().getValues(); var csv = generateCSV(values);
Пікірлер: 34
00:00 - Intro 5:02 - The Big Data Problem 7:21 - The Solution 9:15 - Your Data Pipeline Journey 15:54 - What is BigQuery? 24:00 - Extract & Load Data: Getting Data into BigQuery 29:37 - Transform Data: Clean, Join, Prepare and Manipulate 31:03 - Using Your Data: Visualization, Analysis, and Upload 34:25 - A Hands-On Demo
@andresu6796
3 жыл бұрын
Great and usefull video,thanks a lot and he explains very well.
As Digital Marketing is evolving and nobody knows how this is going to be in the next 5 years, It's so great to see how data science and marketing coming together. I'm on a journey to become a Market/Business Analyst from Digital Account Management. It's going to be an interesting switch and these videos are indeed life savior.
This video is awesome. I've used the timeline/slides of this video for many presentations and it has been an blueprint for many projects. I always refrence to this channel before presenting. Thank you.
Great Video measure school, Thank you, expecting more on bigquery as data guy. Thanks
This is a great video, I came across before having an interview to understand use-cases. Thanks
I think this was the most helpful video I have ever watched on KZread. All the love :)
Best 1 hour investment in my education lately. That’s so this great video
@MeasureSchool
4 жыл бұрын
Great to hear!
Thank you so much! So much value.
Fantastic presentation. Absolutely fantastic
Nice one guys : ) thank you a lot and keep it up
more like these would be great!
Very informative video Thank you so much
The trainer (Amad) is fantastic.
Thanks for video Ahmad and Julian! Few questions I had - When we have terabytes of data in Bigquery. Do we leave it there or should I export to Google Cloud Storage? What is the good practice to minimize cost in Google Cloud? - I will be interested in having the app script. Do you have script that will update columns in row if it has a matching date? I want to extract data in weekly basis and upload it. I want to avoid duplicates and override values if the fields has changed.
Great video, I tried the same with a UK data set but for some reason, it’s giving me a syntax error when I merge two data sets “Unexpected String Literal”.
Can’t thank you enough.
Hello hello! Thank you for the tutorial. I did everything that was in the video, but I got no data in the datatable. I also did not get error message. Can you please tell me how I can debug the problem or what to do?
If I run query and connected that data to GDS and display there then how does the data view in data studio get refreshed if the data is from source like GA that is live
Ahmad is a top notch trainer. Which I could learn on the job with him. ;) I did not know that UA also had sampling data. The video has almost three years, so I don't know if at that time was possible. But right now can't we create a simple pipeline GA4 > BigQuery? Or the example of data pipelines were given to connect more data sources than only GA4? Did not full understand it. TY.
hi Julian, coming to this video and the function that was copy pasted. i tried that function but i was stuck at newblob and could not go further and when i generated table automatically and tried to export the data to datastudio i was stuck with following error... Failed to fetch data from the underlying data set Error ID: 0e5ecee6 can you help me with it? i will be very thankful to you
Much thank you! Could you tell about incremental uploading? How does it work in BigQuery?
@abdulmunaf4941
3 жыл бұрын
Did you find any solution? Iam also looking for possible solution on incremental upload
Good..I like your in dept knowledge about google big query.Can you deliver hands on demo on Google Big Query in online mode..plz reply..
why should we use it ?
Thank you for the great video. Is it possible to share the script?
@MeasureSchool
4 жыл бұрын
please Email ahmad on his website
@Poziom666
3 жыл бұрын
@@MeasureSchool If it's possible, also a script please
The reason it did not work is that you misspelled the "Var TableID = dailly_users_per state", spelling of "dailly" is wrong in the script.
aayo BigQuery
Bummer, the one reason that I watched this video was to see how to authorize data and then he skipped over the process.
I am having some debugging issues around the "var spreadsheet" line var projectId = 'GA-userdata'; var datasetId = 'GA_user_region'; var tableId = 'daily_users_per_region'; var spreadsheet = SpreadsheetApp.GetActiveSpreadsheet(); var values = spreadsheet.getsheetsbyname('Bigquery_ref').getDatarange().getValues(); var csv = generateCSV(values);