Global Macroeconomic Intelligence Dashboard
4 Economies · 5 Indicators · 34 Years of World Bank Data
4
Countries
5
Indicators
34
Years of data
9
Worksheets
Loading dashboard…
Interactive · Powered by Tableau Public
Problem
Macroeconomic decision-making — whether for asset allocation, country risk assessment, or strategic planning — requires a unified view of how major economies diverge across key financial indicators over time. Static spreadsheet reports cannot capture the dynamic, multi-dimensional nature of cross-country economic comparison.
Approach
Designed a parameter-driven Tableau workbook using World Bank macroeconomic data. Built a layered architecture: four KPI snapshot sheets feeding into a coordinated dashboard, a dynamic indicator selector parameter powering all trend charts, and LOD expressions ensuring accurate country-level calculations independent of view context.
Validation
LOD-calculated volatility indices (STDEV over 34 years) and LOOKUP-based YoY growth rates were cross-checked against manually computed Excel calculations for a subset of country-year combinations. FIXED LOD expressions were tested with and without dashboard filters to confirm they hold correctly under cross-sheet filter actions.
Output
A self-contained macroeconomic research platform: 9 interactive worksheets, 1 coordinated dashboard, dynamic indicator selector switching all charts with one parameter click. Any analyst can instantly compare how the 2008 financial crisis, COVID-19 shock, and 2022 geopolitical events impacted each economy across all five indicators.
Limitations
World Bank data has a 1–2 year publication lag for some indicators, so the most recent data points (2023–2024) may be incomplete. The dashboard covers four economies — selection reflects major global economic forces but excludes EU, Japan, and emerging markets. FDI and interest rate data have more missing values than GDP or CPI.
Next Improvements
Expanding the country set to include the EU aggregate, Japan, and Brazil for broader emerging market coverage. Adding a correlation matrix sheet to surface statistical relationships between indicators. Automating the World Bank data refresh via Tableau Prep.