Operational Efficiency

Giving business teams direct answers from their data with Databricks Genie

A company wanted to explore whether employees could ask questions of its business data without sending every request to the data team. Agilytic delivered a focused proof of concept using Databricks Genie, with business definitions, controlled internal testing and documentation to support the next stage.

Keyboard key with a chatbot icon, illustrating conversational access to business data.

To protect confidentiality, we may alter specific details while preserving the accuracy of our core contribution.

The question to test

The company already had a data warehouse and established reporting. Business users nevertheless relied on data specialists for ad-hoc questions. The aim was to test a more direct route to the information they needed.


The project began with a defined data perimeter and a selected internal group. Its purpose was to demonstrate a working approach, understand the preparation involved and gather feedback before considering wider use.

Choose a route that fits the existing platform

Agilytic compared several technical approaches before selecting Databricks Genie. The company’s data was already on Databricks, making the native conversational interface a practical choice for this pilot.


That choice kept the initial work focused on the questions, data and business logic, rather than on building a separate application. It also gave the team a way to test the approach within the company’s existing environment.

Give the assistant the business meaning behind the tables

Connecting the data was only part of the work. Important definitions, calculations and filters existed in reports and working files rather than in the underlying tables.


Agilytic worked with the client to bring that context into the Genie configuration. The team refined metrics and descriptions so that questions would be interpreted against the business’s intended meaning.


The project prioritized two key data areas. Rather than expanding the number of sources, the team added relevant metrics and worked through the detail needed to answer questions within that scope.


Data structure also mattered. The team explored how existing tables supported the required calculations and created a custom SQL transformation for an additional analysis need. A conversational interface still depends on data that can be aggregated correctly.

Build, test and make changes repeatable

The delivered work included:

  • Four Genie spaces spanning development, testing and production, including a space for an additional data area.

  • Automated deployment code integrated into the client’s existing pipeline.

  • A custom SQL transformation to support business analysis.

  • Configuration and maintenance documentation for the client team.

Testing remained within a small internal group. Users could rate answers and leave comments, allowing the team to adjust the configuration in response to feedback.


Setting up a production environment was an engineering deliverable. The project itself remained a limited-scope proof of concept, rather than a validated company-wide rollout.

What the pilot established

The company received a working conversational analytics pilot and a documented way to configure and deploy it. The project also showed how much of the work sits in business definitions and source preparation, beyond the chat interface itself.


The team observed better answers as the business context became clearer. Broader user adoption, request reduction and financial return were not established by this pilot. Those would require a wider evaluation with agreed measures.


The practical lesson is to begin with a useful business question and a manageable scope, then test the answers with the people who understand the data. Expansion should follow evidence from that work.

Explore what talking to your data could mean for your team

See our approach to Talk to my data and AI-powered BI, or discuss a first use case with us.

To safeguard confidentiality, we may modify certain details within our case studies.

Ready to reach your goals with data?

If you want to reach your goals through the smarter use of data and A.I., you're in the right place.

Ready to reach your goals with data?

If you want to reach your goals through the smarter use of data and A.I., you're in the right place.

Ready to reach your goals with data?

If you want to reach your goals through the smarter use of data and A.I., you're in the right place.

Ready to reach your goals with data?

If you want to reach your goals through the smarter use of data and A.I., you're in the right place.

© 2026 Agilytic

© 2026 Agilytic

© 2026 Agilytic