Profile cover photo
Profile photo
Ani Lopez
2,868 followers -
Sr. Measurement Strategist
Sr. Measurement Strategist

2,868 followers
About
Posts

Sharing here Google Spreadsheet to schedule #BigQuery jobs http://goo.gl/fmxmNf

There are several ways to #ETL BigQuery but this is the simplest, just a query, a table to append results and a spreadsheet in the meantime they add this option in BQ UI. No coding required and it works in production seamlessly.

1. Copy the sheet
2. Update the query and the details of the table to append results
3. Go to Tools > Script Editor
4. Create trigger for the day/time when you want the query to run

Benefits
- Overcome data transformation limitations in Data Studio or others
- Blazing fast dashboards if connected to the table with transformed data
- Saves you the pain to write lengthy SQL statements in the middle of JS code
- Saves time you can use to have more fun

Happy Analysis / Dashboarding!
Add a comment...

Post has attachment
We might have some storms in #Barcelona but it'll always be a welcoming city of light for those of good will, no matter your extraction, creed, gender or color.
My heart is with the victims. They shall not pass. Not now, NOT EVER!
Photo
Add a comment...

Post has attachment
My friend Francis makes an incredibly tasty 'salsa macha' typical from Veracruz. QueVivaMexico!
Photo
Add a comment...

Post has attachment
Totally recommended Coursera's 'Big Data and Machine Learning Fundamentals' course for a great overview. Not only in Google Cloud data related products and how to put them together to do stuff but also to understand classics like Hadoop, Pig, Hive, Spark, Machine Learning, Notebooks, and such.

Labs are step-by-step examples, copy&paste code, no need to know any particular programming lang although a bit of Python and SQL helps of course.
Add a comment...

Post has attachment
Add a comment...

Post has attachment

Post has attachment
Misleading title, nice reading though.
Assumption is that #data equals insight and direction. But does it?
Add a comment...

Post has attachment
Toward tidy #data analysis.
Add a comment...

Post has attachment
Minimalistic Learning Path to Become a #DataScientist
Add a comment...

Post has attachment
Learn for free #SQL every #data analyst should know: from Basic to Advanced.
The SQL Tutorial for Data Analysis
The SQL Tutorial for Data Analysis
community.modeanalytics.com
Add a comment...
Wait while more posts are being loaded