Data Analysis with G Suite and GCP

Transcript

1. Data Analysis with G Suite and GCP Alicia Williams, Developer Advocate at Google @presactlyalicia
3. Agenda 1. Who, What, and Why of building on G Suite 2. Overview of Apps Script 3. Data Analysis Demos
4. Why build on G Suite? Automate Extend Leverage Engage Integrate ➔ It’s where you already do a lot of work ➔ Put it to work for you ➔ Make it work your way ➔ Bring information & insights together ➔ Do more with less
5. Pitch Books Time Reporting Systems Approval Workflow Apps Marketing Campaign Apps Document Automation System Tracking Databases Org Chart App Automated Report Generator Service Requests Sales Compensation Models Capital Budgeting Asset Management Opportunity Tracker Expense Reporting Task Management Security Dashboard Invoice Generator Dashboard Apps Event Planning Inventory Tracking Employment Verification Training Scheduler & Mgmt Bulk Email Mgmt Benefits Calculator Time Off Request What can you build on G Suite?
6. Don’t quit your day job - just do it better! Who can build on G Suite?
7. Who can build on G Suite? Business User Citizen Developer Corporate IT Full Time SWE Record Macros Record Macros App Maker Apps Script App Maker Apps Script Apps Script Add-ons APIs Complexity
8. Building with G Suite... Apps Script APIs Serverless scripting environment based on JavaScript REST APIs & Client libraries to integrate your own solutions w/ G Suite
9. Building with G Suite... Integrate your solution with G Suite data & functionality Optimize for performance & quotas Choose your language and dev environment REST APIs provide wide coverage of G Suite products Client libraries for native use w/ Java, Python, .Net, JS + Develop for mobile w/ Android or iOS Access data for Cloud + on-premise integration Deploy with G Suite Marketplace to reach users APIs REST APIs & Client libraries to integrate your own solutions w/ G Suite
10. Building with G Suite... Apps Script Serverless scripting environment based on JavaScript Build Custom Functions in Sheets Record a Macro in Sheets Add logic to Docs, Sheets, Slides, Forms Design your own UIs w/ menus, sidebars & dialogs Create & deploy Add-ons Set Automations aka Triggers Bring data into Google Data Studio Build Hangouts Chat bots Develop (Standalone) Web Apps Interact with the rest of Google APIs
11. Building with Apps Script Apps Script Serverless scripting environment based on JavaScript
12. 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
15. Actions • Create • Pull • Push • Clone • Deploy • View logs Built on the new Apps Script API Professional workflows Command line interface clasp for working with git and your local IDE
16. Advanced Google Services Work much like Apps Script's built-in services— offer autocomplete, and handle the authorization flow automatically. https://developers.google.com/apps-script/advanced/
17. 1 Sheets + ML
18. Analyzing Feedback ⭐⭐ Open-ended response boxes ⭐⭐ Manually reviewing feedback
19. Cloud Natural Language cloud.google.com/natural-language Extract entities Detect sentiment Analyze syntax Classify content
20. 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
21. Sheets Cloud NL Forms Apps Script
22. Demo Time
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. 2 Sheets + Big Data + Slides
28. BigQuery Standard SQL, Column Oriented Automatically Encrypted, Durable, and Highly Available Petabyte-Scale Fully Managed, Zero-Ops Data Warehouse Virtually Unlimited Resources
29. Sheets data connector for BigQuery Analyze and share large datasets from BigQuery right from within your spreadsheet!
30. Demo Time
31. Sheets Apps Script BigQuery Slides
32. A few “gotcha”s 01 Need a G Suite Business/Enterprise account @gmail.com won’t be sufficient to use the Data Connector :( 02 Data access is important If you don’t have access to the data tables for your company/division, pulling fresh data might be hard. (Make a friend?) 02.5 But, Apps Script! Maybe your data doesn’t have a sweet connector, or you can’t get access to it. Doesn’t mean you can’t make your day easier by Apps Scripting that email report directly to your Sheet!
33. Collect Prepare Analyze & Visualize Share Sheets democratizes the analytical workflow to help you get insights faster Real Time Collaboration
34. Get started Dive into the demo code: github.com/aliciawilliams/analyzingtext Test Drive Cloud NL: cloud.google.com/natural-language Read the blog post: bit.ly/data-connector-blog Test drive Data Connectors: bit.ly/data-connector
35. Thank you! Alicia Williams @presactlyalicia on Twitter and Medium