Google products are generally free for use, don’t need to go overboard if you handle simple data. No Cost, Just Productive Dashboard Reminder: this is just a soft introduction tutorial on connecting google forms and data studio. Depth explanation of charts configuration is not included. Everyone wants to create their own dashboard that could help them understand and track their productivity. Also we have to consider that metric of productivity is vague and people have their own version to follow. So here is intro. tutorial that could help you guys get started in exploring your own data through google forms and google data studio that is generally free of use. *thanks google! First we gather data… but in a uniformed way. spreadsheets may create too much freedom which may deter us from inserting data everyday or every hour so we will use . google forms you can make your own question as you see fit Second we go to the from editor > responses then click the spread sheet button to check if data is being save properly. Note: you could always alter your results in the spreadsheet but this may affect your data integrity when doing a data sensitive project click the spreadsheet button to check if the data is being save correctly Third, go to google to add ‘blank report’ to create a dashboard. datastudio Click the blank report then click new data source to add to your dashboard create new data source then select spreadsheets to find your survey file, just hover your cursor to google sheet then you will see the select button light up then click the file name that is connected to your survey. NOTE: usually the end with a post-fix called ‘(Responses) click connect to import them to google data studio then google data studio would automatically parse and connect your data to your now blank dashboard. Fourth, play around with pre-built charts, filters, and tables. Quick Tip: Usually I use all the tools in the insert section. I suggest exploring the following features: 1. Table — just a way to organize data (you could use hyperlinks here as well) 2. Filter Control — for filtering data using your categorical data 3. Text — just simple text to add labels 4. Scorecard — Calculates the sum of all data or using a specific filter Tada! we are done. Friendly Personal Note: Just make it a habit of the using the form system then by the end of the year you will have serious personal data to analyze to add to your new year’s resolution! Thank for reading, should you have any questions about this project please comment below. I will try to answer the question in best of my knowledge.

Google

Working at a FoodTech Startup: A Data Scientist's Insights

Use Jupyter to Restart the Script from the Point Where the Scrapper Terminated

Read My Stories

Nominated for 2022 - Pythonistas Paradise

Buy Me a Coffee

Too Long; Didn't Read

Boost your HackerNoon story @ $159.99! 🚀

How to Create a Simple Dashboard with Google Forms and Google Data Studio

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

How to "Instantly" Create a Front-end for Your Python Program

10 Great Articles On Data Science And Programming!

10 FinTech Trends in 2021 [Part II]

10 Financial Predictions for 2021 to Protect Your Wealth

13 API Metrics That Every Platform Team Should be Tracking

How to "Instantly" Create a Front-end for Your Python Program

10 Great Articles On Data Science And Programming!

10 FinTech Trends in 2021 [Part II]

10 Financial Predictions for 2021 to Protect Your Wealth

13 API Metrics That Every Platform Team Should be Tracking

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps