Gemini is coming inside
Gemini is coming inside #LookerStudio Pro and Looker BI
Promising features, available only through a preview program:
Conversational Analytics
Report and chart creation by prompts
Automated generation of annotated reports inside Google Slides
Formula assistant for calculated fields
Let's start today with a demo of the last feature in the list above.
Formula assistant!
What if we gave some challenges to create a complex formula, prompted with natural language. Not just a concatenation, not just a case statement with grouping.
In the use case below, I cooked a data set of article ids (called also slugs), that includes the date of publication of each article as the first part of a text dimension.
I want to extract it and get the number of past days until now.
So I asked the formula assistant, with a first prompt (remember, as any prompt in Gen AI, we ask, we check the outcome and we adjust with a new iteration of prompt...until the win)
"extract the date at the beginning of the article slug and calculate the difference of days with the current date"
...no detail about the format of the date, but quite specific to drive to the good functions (date_diff, current_date).
The first proposition is very good, not perfect, not the more elegant, but nicely split by step of treatment.
It generated an explicit error. So I take in account the limitation of NUMBER type (generating float here...ok...) and the mandatory forcing of INT64 for my use case. Just putting addition technical information.
"extract the date at the beginning of the article slug and calculate the difference of days with the current date casting numbers with int64"
Voila. Now it is a valid prompt answer. No more error. It adapted the same formula with my custom CAST :)
I would not suspect that it would be so easy. Just an example from my tests.
And for the moment, It is just the beginning of...imagine how it will be powerful and even more time saving with the training of all Looker Studio Pro users?
Formula assistant learning just thanks to formula use cases and the schemas of your data sources (anything else, and of course, not your data).
Congrats to all the Looker and Looker Studio teams!
Very exciting experience to be a privileged witness of the arrival of Gen AI in data visualization. And it is just the beginning.
Stay tuned for the next episodes.