Gen AI for Business Intelligence: Supercharge the way you consume data with Looker and Vertex AI

jessesherb
Staff

looker-bi-vertex-ai.png

If you ask most companies about their data maturity, their response will usually cover one of the following phases: 

  • Data Readiness. This is the first step in any data maturity journey, and it involves getting the data you need in the destination and format that you can use. This includes data migration, transformation, storage, and infrastructure.
  • Consumption Readiness. Once you have your data accessible, you need to be able to consume it. This means making it accessible to all users, not just technical ones, and providing the tools and training they need to use it effectively.
  • Realization Readiness. This is the most important step, but it's also the most overlooked. It involves taking action on the insights your data provides. This means automating workflows, creating new processes, and making changes to the way your business operates. 

Historically, there have been tons of solutions to address the first two of these phases. ETL and data warehouses to address Data Readiness, and no shortage of business intelligence and reporting tools to address Consumption Readiness.

The last phase, Realization Readiness, is typically the longest and hardest phase for companies to achieve. In part, many data and analytics projects end at the reporting or consumption layer from the onset. But a larger contributor is the difficulty of implementing downstream processes specific to your business. Since every business operates differently, this is the hardest part of the data maturity curve to create standardized solutions for. This means that most companies must rely on internal resources or partners to help build automations to power these processes. This is costly, time consuming, and usually deprioritized over other development needs. 

Gen AI will supercharge the way you consume data. Through the use of generative AI, we can bring the realization of our data to the same place we’re consuming it. Shortening this gap allows us to achieve things faster and more efficiently than ever before.  Let’s go through some example use cases to illustrate this.

Gen AI for business intelligence use cases

Here are four typical buckets we see of use cases related to Gen AI for business intelligence:

Create. Gen AI’s best capability right now is its ability to, well, generate. Let’s say our Customer Service team wanted to send a personalized email to our most loyal customers this year. 

  • Before: Use a templated email that went out to all customers or have someone manually type customized emails for each customer. 
  • After: Gen AI can generate personalized emails for each customer, based on some data points provided about them. The email copy is sent directly to an email deployment system.

Summarize. A popular use case for Gen AI is its ability to summarize or extract information, providing insights that may have otherwise not been uncovered. Perhaps our CEO has asked a business analyst to create a quarterly business review to see how the company is performing.

  • Before: Create reports and charts and comb through them manually to extract relevant insights for the quarterly business review.
  • After: Gen AI is fed a large dataset and summarizes into 10 bullet points in under a minute. It suggests interesting ways to visualize the data and sends the summary directly to Google Slides.

Discover. Datasets become even more powerful when enriched with other data points. Let’s see how we can improve the way we keep our CRM up to date and healthy. 

  • Before: Sellers and/or SalesOps spend 5+ hours per week on maintaining CRM health and keeping customer records up to date.
  • After: Gen AI is used to populate current address, website, LinkedIn page, recent news, etc. for each customer and update the records directly in the CRM on a regular cadence. 

Automate. The most sophisticated processes also require the most technical resources to implement. Automating these through the use of Gen AI creates endless possibilities for activating your data. Let’s look at a Customer Service team trying to improve customer experience and generate higher satisfaction scores for their website chat interface. 

  • Before: Reps must read through hundreds of chat transcripts, extract patterns, and summarize the results so the business can make necessary changes. 
  • After: Gen AI can create an automated sentiment analysis for every transcript as that comes in. This includes a calculated sentiment score and summary of the interaction. It can also detect similarities within cohorts of chats. These scores can be sent back to the data warehouse and/or BI tool for further analysis. 

Before Gen AI, automating any of the processes above would have been long, complicated and cumbersome to build. As a result, most companies never recognize this apex point of the data maturity curve, where data doesn’t just inform, but directly impacts the way the business operates. 

So why is Looker + Vertex AI the perfect pairing to solve this problem? 

Generative AI-powered business intelligence with Looker and Vertex AI

jesse_sherb_0-1702669523980.png

As our product team works hard to incorporate AI features into the Looker suite of products, Looker can already support your AI use cases.

Looker has always been a leader in extensibility. In other words, Looker’s API layer has always made it easy to send data from Looker to any downstream workflow or application. In fact, data scientists have been using Looker for years to power their AI/ML workflows by streamlining Data Readiness through its semantic data model, providing Realization Readiness through its RESTful API, and providing out of the box Consumption Readiness for analyzing results. 

Looker’s Data Actions allows users to have a UI for inputting information or selection choices before triggering a task to be performed. This provides a mechanism for users to input a prompt, or a question, they want to ask of their data. It also allows for users to create schedules to trigger these requests. Schedules can be done on a regular cadence, or based on criteria thresholds. 

jesse_sherb_1-1702669523959.pngBy leveraging Cloud Functions, we’re able to send the underlying dataset to Vertex along with the user prompt. Furthermore, we’re able to send contextual prompts behind the scenes to fine-tune the model and produce better results. All of this is executed in your own organization’s Google Cloud project, safely and securely

Diving more into Looker’s semantic layer, we’re also able to leverage Looker Blocks - pre-templated data models for common use cases. This provides us access to AI add-ons to our analytics. 

jesse_sherb_2-1702669524008.png

Another piece of technology being leveraged here is BigQuery ML, which allows us to prompt Vertex AI directly via a SQL query in BigQuery using the new ML.GENERATE_TEXT function. Prompts occur at query time, at the row level. This is amazing for automating repeatable tasks for your organization.

Looker + BigQuery + Vertex is the all-in-one Gen AI tech stack that can help you improve the way data impacts your company. AI is your next best data analyst, ready to automate and augment data analysis tasks, scale your data analysis capabilities, and govern your data and AI models responsibly.

If you’re ready to leverage AI at your organization or learn more about Google Clouds' offerings, reach out to your account team to start the conversation. Have questions? Please leave a comment below. Thanks for reading! 

12 2 5,879
Authors