Conference Board Survey Data Analysis
Problem Statement
How do leading, coincident, and lagging economic indicators compare across major economies? This Power BI dashboard visualizes Conference Board data for the USA, UK, Germany, India, Mexico, and others to identify divergences in business cycle positioning and surface early signals of economic turning points.
Methodology
Data & ETL Pipeline
The dataset from The Conference Board includes leading, coincident, and lagging economic indicators for major countries like the USA, UK, Mexico, and others. It covers the timeframe from August 2022 to June 2023.
The raw data required significant preprocessing. Python scripts were used to read in and transform the data from a multi-row header format into a single header row. Additional manipulation involved melting (wide to long format) and exploding (splitting stacked values into rows) to prepare the data for analysis and visualization.
AI-Powered Categorization
The diverse set of economic indicators was categorized using an AI large language model, enabling logical interpretation and grouping. This AI-powered categorization combined with treemap visualization makes exploring the comprehensive indicator dataset more insightful.
Results
Key Findings
Industrial Production: India had the highest average industrial production over the period analyzed, 35% higher than the United Kingdom (second highest). Germany had the lowest production.
Indicator Flow: Economic indicators were categorized and displayed in a treemap hierarchy, making it easy to compare indicator categories and pinpoint which are highest versus lowest on average across countries.
Interactive Dashboard
Next Steps
- Expand time coverage beyond the August 2022 - June 2023 window
- Add predictive modeling for leading indicator trends
- Incorporate additional countries and emerging market economies