Life Hack for Big Data Analysts!
Where there is data smoke, there is business fire. Data is what entrepreneurs and data analyst have for breakfast.
But even if you don’t have a data science degree, you can use data to grow your business and make life easier. All numbers and no diagrams make data presentations really boring (and confusing!). But converting data into pretty pictures is not easy. Wouldn’t it be awesome if someone did this for you? Great news — you can make Google do it! Big Data Analysis to a Slide Presentation is the perfect lab for you. This lab is an interesting blend of Big Query and Apps Script, and teaches you how to automatically create pretty pictures from terrabytes of data.
Psst, read all the way to the end for a free Qwiklabs credits offer….
Here is a sneak peek of what you will be doing in this lab.
The set up of this lab is a little different from the other labs of Qwiklabs. In other labs you use the Google Cloud Console, but in this lab you will use the script.google.com for creating a new project. Just ensure that you are not using your personal GCP account or pre-created project for this lab.
All through this lab you will be using App script along with queries. In this introduction section you will be briefed about the Google Apps Script and the use of it. Here is what all you can do with Apps script
It is very easy to use App Script for Google Sheets and Google Slides as it is already installed in both apps. Services with built in Apps are awesome!
Query BigQuery and log results to Sheet
With this task, you will be completing most of the lab. The instructions of this lab are self explanatory with screenshots. All you have to do is understand the different functions which you are executing and also the output of these queries.
Create a new Apps Script project
The first subtask of this section is to create a new Apps Script project. You will be working with this project the rest of the lab. Follow the instructions as given and you will easily be able to create a project to work with in this lab.
Enable the BigQuery advanced service
We need to enable big query in apps script in order to run the queries and create our dataset. The instructions are perfectly provided in the lab and you will find no difficulties while enabling Big Query. Refer to the screenshots in case you are finding any difficulties.
Enter and run your application code
Now you are all set to start scripting. Copy the given code and paste it in the code editor. Save the file and rename the file as given in the lab instructions. It is very important to study the different queries which you are running in this lab. In this code, you will be creating a data set in the form of a G-sheet which you will later convert into a slide presentation.
Did you study Hamlet in school? You might recognize the sample database — Most common words in all of Shakespeare’s work. his data is just for the purpose of learning and completing this lab and thus the data which you will see will not be a huge amount of data but it will be sufficient enough to perform different functions in this lab. We won’t ask you any questions about poor Yorick, either.
After successfully running this query you will see a new datasheet in your Google drive. This will be the data which you will be using in the lab for further steps.
Test the Query in Big Query
As we are using SQL in AppScript to get the dataset it will be helpful to make sure that the query which we have fired is right. The lab manual explains how to verify the query. Good to know — you can use this practice for all the SQL queries which you will be running in AppScript.
Create a chart in Google Sheets
Now you create a chart in Google Sheets. In this section you have to look at the different scripts which you will be running carefully. What will happen here is that runQuery will communicate with BigQuery, and will send the results into a Sheet.
Sometimes it’s easier to understand the flow with a chart:
In the lab instructions you will be asked to modify the scripts according to the above steps in order. Once you are done saving the file, you will see a new datasheet. Congrats, you created a chart which represents your data!
Put the results data into a slide deck
Almost done! In this final step you will be making a slide deck in which all the data in the sheet will be presented accordingly (remember the pretty pictures?). Here are the steps which you will be following in order to complete this lab and get your slide deck ready
That was easy, wasn’t it?
Take this lab using this link and get 25 Qwiklabs credits free!! Hurry, the offer is just available for a week till 18th September. (You may need to sign out → sign back in to see the free credits.)
Moving further if you wish to learn more hacks like these you can go for the quest BigQuery Basics for Data Analysts and learn some great data skills.