Analyzing Text Data with Google Sheets and Cloud Natural Language

Some of the most valuable insights for businesses come from free-form user feedback, but text data can be difficult to process and summarize in a scalable way. This session will show how to use Cloud Natural Language to open up opportunities for analyzing qualitative feedback alongside quantitative data. I’ll show you how to use Google Forms to collect feedback, Google Sheets and Cloud Natural Language to analyze it, and Data Studio to visualize the insights; a powerful yet lightweight solution!

Transcript

1. Alicia Williams, Cloud Advocate at Google @presactlyalicia Analyzing Text Data with Google Sheets and Cloud Natural Language
2. Who am I? Alicia Williams Cloud Advocate, G Suite & GCP @presactlyalicia Loves: Spreadsheets, and expanding knowledge of SQL, JavaScript, and Data Viz Weekday activities: Scaling data analysis, getting more out of my data
3. “We crave your feedback!” “Answer a few questions to improve...” “How’d we do?” “Last chance to take our survey!” “Please take a moment to fill out this feedback form...”
7. Why?
10. 1 Collect
11. Forms
12. Google Forms ➔ Collaborate & create surveys ➔ Built-in analysis tools ➔ Templates to get started quickly ➔ Respondents can upload files
13. Sheets Forms
14. Reviewer’s name Stay date Reviewer’s comments
15. 2 Analyze
16. Possible solutions Manually review the data • Energy intense • Unstructured • Not scalable • Inconsistent Change data collection design • Restrictive on data types • Requires control of collection Leverage machine learning • Let’s see!
17. Cloud Natural Language cloud.google.com/natural-language Extract entities Detect sentiment Analyze syntax Classify content
18. 1. neighborhood Sentiment score: 0.9 Magnitude: 0.9 Salience: 0.74 I liked the <neighborhood> 1 but the nearby <transportation> 2 was terrible. Entity-based sentiment Location 2. transportation Sentiment score: -0.9 Magnitude: 0.9 Salience: 0.26 Other
19. Sheets Cloud NL Forms Apps Script
20. Apps Script ➔ Scripting language based on JavaScript ➔ Automates tasks across Google products and services ➔ Serverless - code editor in your browser, and scripts run on Google’s servers script.google.com
21. Demo Time
22. 3 Visualize
23. Sheets Cloud NL Forms Data Studio Apps Script
24. Data Studio datastudio.google.com Connect Sheets BigQuery Cloud Storage Cloud SQL MySQL/ PostgreSQL And more... Share with link. Just like Drive. Embed as interactive report or infographic. </> Use as a presentation. Share Visualize
25. Demo Time
26. Problem solved Makes analysis is more consistent and scalable. Adds numeric structure to text data, making analysis and visualization possible - charts and graphs! Maintains the ability to collect and analyze valuable free-form text data; no need to change collection method. "Laptop Notebook Front Transparent" by chapay, used under CC0 1.0 / Modified from original
27. Get started Learn Apps Script: developers.google.com/apps-script/overview Test Drive Cloud NL: cloud.google.com/natural-language Dive into the demo code: github.com/aliciawilliams/analyzingtext Connect to Cloud NL from Docs: g.co/codelabs/nlp-docs Read the blog post: bit.ly/nlp-from-sheets
28. Alicia Williams @presactlyalicia on Twitter and Medium Thank you!