Turning Fragmented Data into Decision-Making Infrastructure
How Black Swan Consulting built unified behavioral health data baseline, enabling evidence based leadership.
The problem
The data existed without clarity.
The system was making consequential decisions on funding, workforce, and emergency response without a reliable data foundation. Systems existed across every county but none were integrated, comparable, or decision-ready.
- Only 7.14% of counties had integrated data systems. The rest operated in completely disconnected silos.
- No unified baseline existed across counties, making statewide analysis impossible.
- Funding and policy decisions were made reactively, based on incomplete or inconsistent information.
- Critical gaps in services, workforce, and infrastructure were invisible at the leadership level.
Leadership lacked a reliable, system-wide view of needs, gaps, and priorities, meaning every decision carried avoidable risk.
BSCI Approach
From disconnected information to actionable insight.
Black Swan Consulting Inc designed and executed a structured data integration and analysis framework, combining quantitative aggregation across all 17 counties with direct field validation through qualitative research.
- Aggregated and validated quantitative data across multiple sources, establishing consistent definitions for the first time.
- Conducted 30+ key informant interviews and structured stakeholder surveys to surface qualitative gaps that numbers alone couldn't reveal.
- Built a unified statewide data baseline , enabling cross-county comparison and analysis.
- Applied thematic analysis to identify systemic gaps, regional disparities, and priorities hidden within fragmented datasets.
- Translated all findings into decision-ready insights structured to answer the specific questions leadership needed answered.
THE RESULT
The first unified statewide data baseline.
Black Swan transformed fragmented county data into a decision-making infrastructure that leadership could act on immediately , moving the state from reactive guesswork to evidence-based planning for the first time.
- First unified statewide data baseline established , consistent definitions, cross-comparable for the first time
- Critical funding and policy gaps identified with regional specificity, giving leadership clear, defensible evidence
- Decision-making shifted from reactive and anecdotal to structured and evidence-based across the entire system
- A repeatable analysis framework built for ongoing use, a permanent infrastructure upgrade
STRATEGIC IMPACT
Leadership now has a system to use their data.
Black Swan transformed fragmented county data into a decision-making infrastructure that leadership could act on immediately , moving the state from reactive guesswork to evidence-based planning for the first time.
WHY THIS MATTERS
“Most organizations have the data, but lack clarity, integration, and structure to use it”
Public-sector systems are drowning in disconnected reports, inconsistent metrics, and county-level data that was never designed to be compared. The result is leadership making consequential decisions without a reliable foundation, and every flawed decision carries real cost in services, funding, and lives.
Black Swan bridges that gap, turning fragmented information into clear, integrated, actionable strategy that leaders can trust and funders can verify.
Let’s Talk
organizations align people with purpose.