Alicia WilliamsinGoogle Cloud - CommunityAnalyzing customer feedback at scale — from Google Sheets to BigQuery!In this post, I’ll walk you through analyzing sentiment at scale without writing a single line of code.Feb 61Feb 61
Alicia WilliamsinGoogle Cloud - CommunityAnalyzing images with Gemini Pro Vision and BigQueryLearn how to access the Gemini models from BigQuery to analyze your big data, including images.Jan 18Jan 18
Alicia WilliamsParsing delimited text: Google Sheets vs SQL in BigQueryI recently ran across the challenge of parsing some irregular strings of text. Each string was a collection of alphanumeric characters…May 3, 2023May 3, 2023
Alicia WilliamsAdvent of Code in a SpreadsheetA practical way to learn and practice with Google SheetsDec 2, 20223Dec 2, 20223
Alicia WilliamsAutomating YouTube comment notifications using Google SheetsIn my new-ish role as a Developer Advocate, I’ve had the opportunity to build some pretty cool things and share them with audiences at…Jul 23, 20193Jul 23, 20193
Alicia WilliamsinGoogle Cloud - CommunityAnalyzing sentiment of text with domain-specific vocabulary and topicsPart 2: Making sentiment predictions with AutoML from Google SheetsJun 18, 20191Jun 18, 20191
Alicia WilliamsinGoogle Cloud - CommunityAnalyzing sentiment of text with domain-specific vocabulary and topicsPart 1: Creating a custom machine learning model with AutoMLJun 10, 2019Jun 10, 2019
Alicia WilliamsTaking the plunge: learning how to automate with Apps ScriptI started learning Apps Script last year out of a desire to automate my program management tasks and enhance the data analysis I was…Mar 6, 20192Mar 6, 20192
Alicia WilliamsTaking the plunge: my approach to learning SQLI can’t tell you when I started learning SQL. I would be misrepresenting the situation if I said I started from scratch last year when I…Feb 5, 2019Feb 5, 2019
Alicia WilliamsTaking the plunge: which programming language should I start with?I have searched this exact phrase on Google more than I would like to admit. And it never ends well. In fact, there are a lot of opinions…Jan 15, 2019Jan 15, 2019