GenAI Enablement on a Governed Data Foundation

IDS built a governed semantic layer on Delta Lake that normalized customer data models into a consistent structure the GenAI assistant could query reliably, then supported the internal team in standing up its own data science capability to maintain and extend it.

Client

A mid-size B2B software company

Services provided

About the project

Our solution

The Customer: Who they are

A mid-size B2B software company wanting to embed a GenAI assistant into its core product to help customers query their own data in natural language.

The Challenge: Identifying the villain

Early prototypes hallucinated answers because they queried inconsistent, ungoverned customer data models — every customer’s schema was slightly different, and the LLM had no reliable ground truth to work from. “The demo looked magic until a real customer asked a real question,” said the VP of Product.

The Journey: The search for a solution

The company’s small internal data team tried prompt-engineering their way around the data quality problem, but no amount of prompt tuning fixed answers built on an unreliable schema.

The Discovery: Finding IDS

The company found IDS through the “GenAI is only as good as the data beneath it” positioning in an IDS webinar and reached out specifically for the data foundation work, not just the AI layer.

The Solution: The hero arrives

IDS built a governed semantic layer on Delta Lake that normalized customer data models into a consistent structure the GenAI assistant could query reliably, then supported the internal team in standing up its own data science capability to maintain and extend it.

The Implementation: The battle

The rollout started with a single customer segment to validate accuracy before general availability, with a human-in-the-loop review step for early responses. The obstacle: balancing response latency against accuracy — IDS tuned the retrieval layer to keep answers fast without sacrificing reliability.

The Results: The happy ending

  • Hallucination rate: reduced from a double-digit rate in prototype to under 2% 
  • Feature adoption: 60%+ of active customers within the first quarter of GA 
  • Internal data science team stood up and self-sufficient post-engagement
  • Time to add a new customer schema to the assistant: weeks → days 

“We finally trust what it tells our customers.” — VP of Product 

Technologies used: Python · Databricks · Delta Lake · Azure ML

Facebook
LinkedIn
Send on E-mail

More use cases

One Platform, Two Data Worlds: A Big Data Analytics Mart for Banking Group Controlling

Client: Leading Banking Group
IDS designed and built a new analytical data mart purpose-built for Controlling, constructed entirely on big data technologies rather than the client’s Oracle stack.

Migrating Without Missing a Beat: A New Data Warehouse Foundation for a Banking Controlling Team

Client: Leading Banking Institution
When the migration to the new DWH began, IDS took on the task of carrying that Datamart — and the business logic behind it — onto the new platform.

From Hadoop to Databricks: Scaling a Banking Data Platform Beyond Its Limits

Client: Banking Client
IDS Consulting was brought in to provide hands-on technical support and consultancy for the migration to Databricks.

From Days to Minutes: An 8-Year Data Warehouse Transformation for a Leading Telecom Operator

Client: Leading Telecom Operator
IDS Consulting was brought in not for a single fix, but as an ongoing extension of the client’s Data Warehouse team. The mandate: modernize how data moved through the platform, and keep it evolving safely as the business — and the underlying infrastructure — kept changing around it.

Full-Stack Data Platform with Embedded Testing & Knowledge Transfer

Client: A mid-size IT services company
IDS delivered the platform end-to-end (Python and .NET services, automated test coverage from day one) while running a structured knowledge transfer track in parallel — pairing IDS engineers with the client’s internal team throughout, not just in a handover week at the end.

A Full-Stack Commerce Data Platform, Built and Tested End-to-End

Client: A Full-Stack Commerce Data Platform, Built and Tested End-to-End
IDS delivered full-stack development (Java backend, React front end) with a dedicated QA workstream running in parallel from the start — functional, regression, and performance testing built into every sprint — under a single programme manager accountable for scope, timeline, and quality together.