Databricks has partnered with International Orphan (GO) Venture, a nonprofit group that connects households with sources and communities that may stop kids from falling into systemic tragedies.
By means of Databricks for Good, an initiative delivering professional bono skilled companies for social affect, the Databricks Crew helped GO Venture strengthen its knowledge basis and speed up its mission and affect.
Information Challenges and Limitations
In 2025, GO Venture native companions served virtually 122K kids throughout 43 U.S. states and internationally 53K kids throughout 6 international locations. With greater than 1,600 energetic companion companies within the U.S. submitting requests and 8,200 response groups responding in close to actual time, knowledge was housed throughout methods, making reporting a problem. Consequently, vital questions, equivalent to “What does it value (i.e. finance knowledge) to facilitate every request (i.e. platform knowledge)?” have been typically calculated outdoors of automated reporting methods in spreadsheets, making knowledge availability and consistency not as environment friendly because it may very well be.
GO Venture wanted a software that might simply pull knowledge from quite a few sources into one trusted knowledge layer to drive reporting and enhance general knowledge consistency and availability. Whereas consolidating knowledge right into a unified knowledge platform, it additionally wanted to make sure knowledge governance, entry, and permissions have been tightly built-in so that each one consumer varieties from inside workers to company companions to church volunteers had entry to applicable subsets of knowledge for his or her functions.
To deal with these challenges, GO Venture chosen Databricks for its ease of setup with serverless workspaces, seamless integration with cloud platforms, Unity Catalog governance capabilities, and talent to unify knowledge engineering, analytics, and AI on a single platform.
Modernizing A Information Structure with Databricks
Throughout the Databricks for Good engagement, GO Venture partnered with two Databricks Supply Options Architects (DSAs) and a Databricks Venture Supervisor over a three-month interval to design and implement a contemporary knowledge structure depicted under.
The answer was designed round a medallion structure (bronze, silver, gold) to offer a scalable and reliable basis for each analytics and AI-driven use circumstances. Uncooked knowledge from third-party APIs and AWS RDS MySQL have been ingested effectively via each open supply and Databricks-managed options, enabling fast onboarding of recent knowledge sources whereas preserving pipelines resilient as volumes grew. Information high quality and reliability within the silver layer have been enforced via pipeline expectations (utilizing Spark Declarative Pipelines), enabling early identification of downstream knowledge points and establishing a standardized knowledge high quality framework.
Lastly, the info was aggregated into the gold layer, which served because the trusted supply for downstream consumption. Metric views powered centralized dashboards that democratized entry to insights for various groups, eliminating reliance on guide reporting or specialised technical assist. On the identical time, these curated datasets enabled personalised, AI-generated newsletters with out redefining core enterprise metrics or creating parallel knowledge silos.
Underlying all of this, Unity Catalog served as a unified governance layer throughout all knowledge and AI property, enabling GO Venture to confidently scale self-service analytics and AI initiatives.
Options and Outcomes
The next sections spotlight the options delivered via the Databricks for Good engagement and the measurable outcomes they achieved for GO Venture.
Centralized KPI Dashboard
A major problem dealing with GO Venture was the shortage of a single, accessible view of organizational efficiency throughout its community of companions. Key metrics have been saved throughout a number of knowledge sources, requiring groups to manually acquire and interpret the data. This course of was each time-consuming and vulnerable to inconsistency.
By means of the Databricks for Good program, Databricks partnered with GO Venture to rework this fragmented reporting mannequin right into a centralized, automated KPI dashboard constructed on a knowledge lakehouse structure.
As an alternative of counting on static exports or guide updates, new knowledge was routinely ingested and processed, enabling dashboards to replicate modifications a lot nearer to actual time. This ensured management and discipline groups have been at all times working from probably the most present data out there. The top outcome was a unified supply of fact that brings collectively operational knowledge from throughout the group into an up-to-date dashboard.
This dashboard leverages the next key Databricks options:
- Metric Views to standardize KPI definitions and guarantee constant calculations throughout all studies and dashboards. GO Venture now not must ship round SQL snippets, hoping to get the WHERE clause right.
- AI/BI Dashboards to allow the creation of intuitive, drag-and-drop visualizations tailor-made to GO Venture’s operational wants.
- Databricks One to permit enterprise customers to securely devour and work together with AI/BI dashboards with out requiring direct entry to the Databricks workspace or underlying datasets.
Consequently, GO Venture achieved the next enterprise and technical outcomes:
- Operational effectivity: Lowered reporting cycles from days to minutes, permitting customers to observe the well being of regional metrics on demand fairly than ready for electronic mail studies.
- Fast productiveness and studying: Enabled staff members to rapidly creator and iterate on advanced analytical queries utilizing the Information Science Agent, accelerating perception era with out requiring deep SQL experience.
- Scalable reporting basis: Lowered reliance on one-off, advert hoc studies by establishing a standardized reporting basis instantly inside the Databricks Information Intelligence Platform.
General, the consolidated KPI dashboard offered GO Venture with well timed, actionable insights into outreach efficiency. With close to real-time visibility into key metrics, the group can reply sooner, allocate sources extra successfully, and in the end strengthen its capacity to stop extra kids from falling into systemic tragedies.
Personalised AI-Generated Donor Outreach
With a data-driven view of efficiency in place via the centralized KPI dashboard, GO Venture turned its focus to activating these insights via more practical stakeholder engagement. GO Venture sought to supply well timed and personalised content material at scale in an effort to enchantment to donors utilizing knowledge personalised to their area people.
Beforehand, GO Venture relied on a largely guide course of. Information needed to be individually extracted from a MySQL database for every stakeholder, then formatted and woven into communications by hand making it troublesome to incessantly tailor messaging for all prospects.
By means of the Databricks for Good initiative, the staff designed and carried out an automatic system to generate personalised, AI-powered newsletters instantly from curated datasets on the Databricks Information Intelligence Platform. By combining ruled knowledge with built-in GenAI capabilities, the answer reworked operational metrics into stakeholder-ready narratives with minimal human intervention.
For this deliverable, the next key Databricks options have been used:
- Databricks Notebooks and Databricks AI Features (ai_query) to dynamically generate stakeholder-specific narrative summaries based mostly on pocket book widgets (to drive segmentation logic), avoiding guide configuration and customized scripts.
- Basis Mannequin APIs to combine GenAI instantly from the info platform, enabling content material era alongside knowledge preparation and transformation.
- Unity Catalog Volumes to securely retailer unstructured, AI-generated e-newsletter outputs as PDFs in cloud storage, simplifying downstream distribution and entry.
This resulted within the following enterprise and technical outcomes for GO Venture:
- Accelerated content material creation: Personalised donor market snapshot draft era now happens in seconds as an alternative of days, permitting GO Venture’s advertising and marketing staff to deal with refinement and storytelling fairly than guide content material creation.
- Eradicated guide knowledge aggregation: The staff now not wants to drag month-to-month affect knowledge from a number of methods. As an alternative, customers can choose a stakeholder, and pre-configured widgets routinely filter the related knowledge and generate personalised content material utilizing the ai_query perform.
- Scalable, data-driven donor advertising and marketing: Tight integration of notebooks, the Information Science Agent, and trusted knowledge pipelines allowed GO Venture to quickly construct donor advertising and marketing merchandise tailor-made to native markets. Fundraising groups can now generate personalized, data-backed studies on demand throughout all U.S. geographies in a fraction of the time beforehand required to supply a single report.
Collectively, these capabilities allow GO Venture to maneuver past static reporting and into personalised, AI-driven storytelling, thereby strengthening stakeholder relationships whereas amplifying the visibility and affect of its mission.
On this preliminary section, the answer relied on Databricks AI Features to generate e-newsletter content material. Trying forward, GO Venture plans to leverage Agent Bricks to introduce domain-specific brokers chargeable for completely different sections of the newsletters. This method will additional cut back immediate tuning overhead, enhance consistency throughout outputs, and allow extra scalable optimization of the underlying massive language mannequin (LLM).
Influence and Outcomes
By means of the Databricks for Good program, GO Venture reworked its knowledge capabilities from disparate reporting into a contemporary, scalable knowledge and AI basis constructed on the Databricks Information Intelligence Platform.
Corey Vaudo, Chief Information and Info Officer of the International Orphan Venture, shared the next perspective on the partnership:
“The all-in-one nature of Databricks is nice for a small staff of our measurement. As an alternative of spending time studying and chaining numerous instruments collectively, we’re targeted on the issues at hand and are assured that the options we want exist already within the software we have chosen. We stay up for working with Databricks on extra initiatives sooner or later.”
In case you are a nonprofit group or work intently with nonprofits and are serious about studying how Databricks can function a drive multiplier for social affect, please attain out to us at [email protected].
