Portfolio
Portfolio
DwellAssured was a startup that operated in the senior care and aging-in-place industry. Its core service was providing home safety assessments and recommendations for older adults who wanted to remain in their homes rather than move to assisted living.
The company connected clients with qualified service providers—such as home modification specialists, handymen, and healthcare professionals—to implement tailored solutions that helped seniors live safely and independently.
Issue:
DwellAssured assumed it had strong service provider coverage in the DC/VA/MD area, but this belief was not supported by any centralized or accurate data. Internally, teams operated under the false assumption that no coverage gaps existed. In reality, provider data was outdated, incomplete, and scattered across systems, making it impossible to confidently assess service reach or plan strategic expansion.
Solution:
To address these visibility and alignment challenges, a three-part solution was implemented:
Standardized Provider Survey – A detailed online form was sent to all active service providers to capture up-to-date service offerings and geographic reach (zip codes, cities, counties).
Centralized Provider Data – Survey responses were cleaned and standardized in Excel, tagged by service type and region to enable consistent analysis.
Geographic Mapping & Analysis – Using Power BI, Google Maps, and GIS tools, provider data was visualized through heatmaps and overlays to highlight dense areas and expose rural or underserved zones.
Result:
This solution replaced assumptions with real data, aligned cross-functional teams, exposed critical service gaps, and enabled leadership to make informed expansion decisions. It also established a repeatable process for scaling into new markets.
This project exemplifies how data-driven analysis can reveal the gap between organizational assumptions and operational reality. By systematically collecting, consolidating, and visualizing provider network data, I created a strategic asset that transformed decision-making from assumption-based to evidence-based, ultimately enabling more effective market expansion and resource allocation strategies.