I was helping a UK enterprise Finance function stand up Genie. The easy path was one room, all the data, ask it anything. Instead we designed for two different jobs:
Narrow rooms for trusted answers. Two tightly-scoped rooms — one operational, one financial — each doing one thing exceptionally well. There's a number behind this: a Genie Room performs best at around 7 tables. It'll cope with 30. It won't work well with 100. Fewer, well-chosen tables mean sharper answers people actually believe — and trust is the whole game.
One blended room for exploration. Then, deliberately, a room that brings finance, operations and HR together — SAP, SAP Analytics Cloud and Workday in one place — to answer questions no single source can. Think cost per head against budget by function, or whether headcount growth is actually tracking financial performance. That's the beauty of the platform: the data was never designed to sit together, and here it just does.
The lesson: scope isn't one rule, it's a design choice per question. Narrow when people need to trust the answer. Broad when they need to explore what's possible. Same platform, two very different jobs.
And access shaped all of it — HR and financial data don't share an audience, so room boundaries were drawn around who should see what from day one, not retrofitted later.
Curious how others balance the tight, trusted rooms against the broad, exploratory ones? 👇
#Databricks #Genie #DataGovernance