Skip to main content

What is AI/BI Genie?

Summary

  • No-Code AI/BI Interface: AI/BI Genie enables business users to conduct self-serve analytics using natural language without SQL knowledge.
  • Expert Configuration: Data analysts configure Genie spaces with datasets, sample queries, and guidelines so Genie accurately interprets business questions.
  • Continuous Learning: Genie asks clarifying questions when uncertain and remembers explanations as instructions for future queries.

What is AI/BI Genie?

Watch: What is AI/BI Genie?
AI/BI Genie is a no-code interface powered by AI with data intelligence that allows business users to conduct self-serve data analytics using natural language. Domain experts, such as data analysts, configure Genie spaces with datasets, sample queries, and text guidelines to help Genie translate business questions into analytical queries. After set up, business users can ask questions and generate visualizations to understand operational data. You can continuously update Genie’s semantic knowledge as your data changes and users pose new questions. For additional information about data intelligence, see read our product documentation (https://docs.databricks.com/en/databricksiq/index.html#databricksiq-powered-features)
AI/BI Genie uses the names and descriptions from annotated tables and columns to convert natural language questions to an equivalent SQL query. Then, it responds with the generated query and results table, if possible. If Genie can’t generate an answer, it can ask follow-up questions to clarify as it attempts to provide a response.

Chapters

FAQs

How does AI/BI Genie work?

Genie uses table and column names and descriptions to convert natural language questions into SQL queries. It responds with the generated query and results table, or asks follow-up questions if clarification is needed.

How do I set up a Genie space?

Create a Genie space from a dashboard, table, or navigation bar. Name it, describe the data it covers, choose a warehouse, and add example questions to guide Genie's behavior.

How does AI/BI Genie enable business users to ask data questions in natural language?

AI/BI Genie allows business users to ask natural language questions about their data without SQL knowledge, automatically translating questions into optimized queries that return accurate insights. The system understands data relationships, business terminology, and context to interpret user intent correctly and provide relevant answers. By democratizing data access across the organization, Genie eliminates the need for analysts to manually create queries for routine business questions.

How can business users ask natural language questions to analyze enterprise data?

AI/BI Genie is a natural language query interface that interprets business questions and automatically generates optimized database queries, making data accessible to non-technical team members. The tool understands organizational context and data relationships to provide accurate answers without requiring SQL expertise from end users. Integration with Databricks governance ensures that data access respects organizational policies while enabling rapid, self-service analytics.

How can business users ask natural language questions to explore company data?

Natural language interfaces like AI/BI Genie enable business users to explore data without SQL by translating conversational questions into database queries, making data accessible to non-technical stakeholders. These systems learn organizational context, data relationships, and business terminology to interpret questions accurately. Integration with governance systems ensures data access respects organizational policies while enabling rapid, self-service analytics across teams.

Full transcript

0:00 Introduction to AI/BI Genie

Hi, I'm Pearl Uber and today I'll walk you through how AIB Genie helps business teams get the answers they need without having to know SQL or any complex tools. Picture this. You're an analyst at a coffee and pastry franchise company and your team keeps asking you the same questions over and over, such as which product sold the most units or what were the top selling franchises last quarter? Instead of digging through dashboards or running SQL queries every single time, imagine if there was a way that they could just ask these questions directly, like having a conversation.
That's exactly what Genie does. Setting up Genie is super simple. You can create it from a dashboard, a table, or directly from the navigation bar. You name it, describe what data it covers, choose a warehouse, and then add some example questions to help guide your team. Think about the key questions they'll want answered. The more you prep Genie with instructions and context, the better it performs. The best part, you only see data you have access to, so it's secure and governed from the start.

1:42 Interacting with data

Once Genie is set up, it's time to see it in action. Let's start with a common question. Which product sold the most units? seller is Outback Oatmeal. Now, let's ask, "Show me all products in descending order." Genie quickly lists them, showing Tokyo Tidbits and Golden Gate Ginger close behind. Unlike rigid BI driven dashboards, Genie learns over time. If it doesn't understand something like how much revenue did we make from our cash cows in May 2024, Genie will ask for clarification.
Once I define cash cows as customers spending over $150 weekly, Genie will remember that for next time. To verify that Genie understood what was asked, you can take a look at the underlying SQL code. As you can see, cash cows are customers with a weekly spend of over $150. You can also save these explanations as instructions, making Genie smarter with every interaction. Once you've tested Genie and you're confident that it's accurate, you can share it with your team.

3:21 Sharing and monitoring

You can select who can manage, edit, run, or even view Genie. Unity Catalog handles permissions so everyone only sees what they're supposed to. Sharing is as easy as sending a link. After launch, you can monitor how your team uses Genie. Feedback buttons let users rate responses so that you can see what works and what needs some tweaking. It's a great way to stay proactive about improving Genie, keeping it aligned with what your business users need.
Now, let's talk about how Genie stays accurate. Good data governance is key, and that's where Unity Catalog comes in. Unity catalog manages your data and AI governance, making sure that Genie always uses the right data without duplicating anything. Here I can add comments to tables and columns that Genie will use to better understand the data. Genie transforms how your team interacts with data by making it as easy as having a conversation.

4:40 Conclusion and summary

No more hunting through dashboards or writing complex SQL. Just ask and get the insights that you need. The seamless integration with Unity catalog ensures that data governance and security are maintained at every step, giving you confidence that your answers are accurate and compliant. So give Genie a try today and watch it work its magic so that your team can focus on what they do best, which is driving your business forward.

Learn more about the Databricks Data and AI platform.

The information provided herein is for general informational purposes only and may not reflect the most current product capabilities or configurations.