The Challenge
Siloed data and legacy systems limit access to insights.
National Marrow Donor Project (NMDP) connects volunteer donors with patients who need peripheral blood stem cell or bone-marrow transplants for life-threatening blood cancers, diseases, and disorders.
Matching patients to donors, tracking barriers to transplant, and partnering with the right providers all depend on data everyone in the organization can actually use.
That wasn’t the case. Datasets were siloed, insights were disjointed, and reporting moved slowly through a bottleneck. Years of rapid growth had left the previous BI platform overly customized and rigid. Data inconsistencies between departments meant frontline staff and executives alike spent more time reconciling numbers than using them. The homegrown source systems necessary for their unique operating model were difficult to ingest cleanly into their legacy systems.
NMDP needed a modern technology stack that gave every department faster time to insight, a complete view of the organization, and true self-serve data access.
DAS42 and Snowflake are instrumental in customer churn prevention, revenue forecasting, and financial modeling.
The deployment and adoption of our modern analytics platform has transformed the way our stakeholders utilize and interact with data to advance the performance of our business.
These enhanced capabilities and processes deliver relevant and timely insights equipping our teams to activate on informed decisions. In addition, we are experiencing significant improvements in our Business Intelligence delivery model, including providing new capabilities and features at increased speeds. It’s been incredible to witness how this project is enabling NMDP’s life-saving mission.
— Tracy Smith, Senior Director Data & Business Analytics, National Marrow Donor Project (NMDP)
The Solution
Modernizing BI and self-service reporting.
NMDP partnered with DAS42 to guide and implement a business intelligence modernization initiative built on Snowflake and Looker.
The work was scoped around three objectives: replace the legacy BI reporting platform, build real self-service reporting, and grow the use of data across the organization.
Replacing legacy BI reporting. DAS42 deprecated more than 2,000 legacy reports and moved NMDP onto Looker. New enterprise data sources, including CRM and custom applications, were brought into Snowflake, with a data lake and dimensional models built in the centralized data warehouse to create a single source of truth. The new platforms resulted in improved page and report load times, increased how often data refreshed, and made it possible to connect datasets across the organization instead of viewing them in isolation.
Building self-service reporting.
DAS42 designed dashboards built for frontline users, not just analysts, and automated quality assurance checks behind them. All teams could get answers directly instead of routing every question through the data and analytics team, which freed that team to focus on higher-value analysis instead of standard reporting requests.
Growing data use across the organization.
DAS42 worked with NMDP to expand data governance, including stronger security practices for an organization that has to share data while protecting sensitive medical information. That included formalized code development guidelines to support centralized KPI definitions and a dashboard certification process to reinforce trust in what the data showed.
To support the rollout, DAS42 built training and onboarding materials alongside the platform itself: self-serve Looker how-to modules and videos, a Data Ambassador program, office hours, and train-the-trainer sessions for the technology team and end users across the organization.
The Results
Tripling BI Adoption and Empowering Data-Driven Decisions.
Usage of NMDP’s self-service BI platform has more than tripled, and more than 2,000 legacy reports were retired and replaced
by dashboards built on one centralized data warehouse, giving the organization a single source of truth wherein an individual member of the frontline staff could see the impact that they individually were having on the organization’s key metrics – lives they had helped save, potential future donors they had helped register, dollars they had helped raise for patient support programs or research, and so on.
With a stronger analytics foundation and governance built into the platform from the start, NMDP’s teams, from frontline staff to the executive suite, can now use data directly in day-to-day decisions that support its mission.
We work as an extension of our clients’ teams, solving the data problems that stand between them and a business decision.
Real clients, real results.
