CASE STUDY
Economic Profiling Dashboard
Business Survey Data Analysis for Evidence-Based Planning
ROLE
Data Analyst & Business Intelligence Developer
PLATFORM
SQL · Power BI
FOCUS
Data Analytics · Business Intelligence · Urban Planning
The Real Problem
Field business surveys often produce large, inconsistent datasets that are difficult to analyze and interpret. Without proper cleaning and visualization, valuable insights into local economic conditions remain hidden, limiting evidence-based planning and policy development.
The Approach
Transform raw survey responses into reliable, decision-ready insights through structured SQL data preparation, analytical queries, and interactive Power BI dashboards.
The workflow focused on cleaning and validating field-collected data, generating key business indicators, and presenting findings through intuitive dashboards that support planners, researchers, and decision-makers.
What I Built
- Cleaned and standardized field survey data using SQL
- Designed analytical queries to profile businesses, employment, ownership, and economic sectors
- Built interactive Power BI dashboards for business profiling and economic analysis
- Performed spatial-economic analysis comparing key character areas within Migori Town
- Generated evidence-based insights to support planning interventions and policy recommendations
What Changed
- Transformed raw survey responses into a reliable analytical dataset
- Identified business growth patterns, operational challenges, and sector performance
- Revealed spatial-economic disparities across different areas of Migori Town
- Delivered an interactive decision-support dashboard for planners, researchers, and local stakeholders