Make Your Databricks Investment Pay Off
Farmatodo had moved to Databricks but wasn’t feeling the benefit. SunnyData rebuilt the foundation, making its slowest dashboards 60-70% faster and ready for self-service and Genie.
Client Challenge
Moved to Databricks, but not yet feeling the benefit
Farmatodo had switched from Looker to Databricks, but they kept the same setup as before. Their queries still ran on tables that didn’t take advantage of Databricks’ speed. As a result, dashboards loaded slowly and people were less likely to use them.
Farmatodo also needed row-level security, so each person sees only their own data. On that setup, it would have made things even slower.
The Solution
Fix the foundation, then build on it
SunnyData started by respecting what Farmatodo had already built,
then improved it without breaking anything live.
Understand how people work
We studied how business users explore their data, starting with Sales, before touching anything technical.
Rebuild the foundation
Tables were redesigned to use Databricks' built-in speed features, and the shared business definitions were rebuilt on best practice, with Farmatodo's own logic kept intact.
Tune for speed and security
We measured how security filters slowed queries, then gained enough speed to absorb them.
Set up self-service
Guidance on dashboard design, plus training, so teams build fast dashboards on their own.
One Foundation, Many Tools
Define your business once. Use it everywhere.
With the right semantic layer in place, every tool reads from the same trusted definitions,
with no extra copies of the data.
Four stages, one foundation
Illustrative representation.
The four stages: 1, Your data: fast, optimized tables. 2, One set of definitions: business logic, defined once. 3, Secure by design: each person sees only what they should. 4, Any tool: dashboards and SQL today, ready for Genie and AI assistants next.
Key Benefits Achieved
Business results, before and after
What They Can Do Now
A foundation to grow on
Self-service at scale
100+ people can build and publish their own dashboards for 400+ viewers.
Ready for Genie
The same trusted definitions can feed Genie and other AI assistants, with no data duplication.
A team that knows how
Farmatodo's BI team built its technical confidence with SunnyData, which stays on as an advisor.
Ready to get more from your Databricks investment?
SunnyData tunes what you've already built, so dashboards run fast and your teams, and tools like Genie, can build on it.
