Country Scan

Subnational Country Growth Scan
02
The Subnational Growth Scan is similar in methodology and functionality to the Country Growth Scan. However, rather than benchmarking countries of the world, the tool allows users to benchmark different states or regions within a singular country.
I developed the tool upon request as follows:
-
Odisha Growth Scan (India)
-
Mexico Subnational Growth Scan
-
Amazonas Growth Scan (Brazil)
-
Chile Growth Tool
Coverage
-
India: 28 states
-
Brazil: 5 regions
-
Chile: 15 regions
-
Mexico: 32 states
Methodologies
-
Growth decompositions
-
World Bank Job Diagnostics
-
Macro econometric instruments
-
Manhattan distance techniques
-
Survey analysis
Data Sources
-
National data as provided by national statistics offices, central bank, and ministries
-
Enterprise Survey data
-
Labor force surveys
-
Financial Times
-
World Integrated Trade Systems
-
...among many others
The User Experience
Sample Selections
Unlike the Country Growth Scan, the Subnational Growth Scans are a one-step process. The database lives in the Excel tool and users simply select their subnational regions and periods for benchmarking. Users make their selections for comparators (in this case, regions or states within country) and periods of analysis directly in the Excel tool.

Sample Outputs




To build the subnational growth scans, I took the following steps:
-
Worked in close collaboration with country teams and lead economists to source official data at the subnational level.
-
Cleaned, and consolidated the data from all sources.
-
Wrote Stata code that (a) calculated relevant indicators and (b) generated a complete and balanced dataset at for all states/regions.
-
Designed and built the user interface in Excel, writing Excel formulas to automatically pull data and generate dynamic charts based on user inputs.


How I Built It
DISCLAIMER:
The tool developed on this page was delivered to the World Bank Group. The tool itself is a property of the World Bank Group. The data utilized for the tool was publicly available data. The methodologies were developed by World Bank Group economists.