Power BI Macro DashboardReact + Recharts + Economics

UK Economic Health Dashboard

A live version of the macro dashboard, rebuilding the core Power BI visuals in React so the project can be explored directly on the website. The analysis tracks inflation, unemployment, GDP growth, and Bank Rate from 2010 to 2024 using official UK data.

View GitHub Repo

Latest CPI Inflation

2.5%

Aligned to the latest single monthly reading used in the Power BI dashboard.

Latest Unemployment

4.3%

Aligned to the latest single monthly reading used in the Power BI dashboard.

Latest Bank Rate

5.11%

Aligned to the latest single monthly reading used in the Power BI dashboard.

Latest GDP Growth

0.5%

Aligned to the latest quarterly reading used in the Power BI dashboard.

Overview

A high-level macro snapshot across all four indicators.

CPI Inflation

Inflation peaks are immediately visible, especially the 2022 surge.

Unemployment Rate

A steadier labour-market series than inflation, even through recent shocks.

GDP Growth

Quarterly GDP keeps the COVID collapse and rebound visible in the overview, matching the dashboard logic.

Bank Rate

Policy was stable for years, then shifted sharply during the inflation shock.

Crisis Moments

A tighter view of the COVID collapse and later inflation shock.

COVID-19 Output Shock

Quarterly GDP growth keeps the Q2 2020 collapse visible rather than averaging it away.

Inflation Shock and Rate Response

Using the same annual values shown in the Power BI dashboard for 2021 to 2024.

Key Insights

The main macro storylines surfaced by the dashboard.

UK inflation rose sharply during the cost-of-living crisis and peaked in 2022 before easing.

Bank Rate stayed low for much of the 2010s, then increased rapidly once inflation remained elevated.

GDP growth captured the severe Q2 2020 COVID contraction and the strong rebound that followed.

Unemployment moved less dramatically than inflation during the 2022 shock, suggesting the labour market remained relatively resilient.

Relationships

The Power BI comparison views recreated directly in the browser.

CPI Inflation vs Bank Rate (2018-2024)

A policy-response view showing how rates caught up after inflation had already accelerated.

From 2018 to 2024, inflation rose much faster than interest rates at first, before Bank Rate increased sharply as the Bank of England responded to persistent price pressures.

Phillips Curve View

Inflation plotted against unemployment using the monthly macro series.

Why It Matters

A macro-focused project that complements the finance case studies.

This project shifts the portfolio from company-level and personal-investing analysis to the wider UK macroeconomic environment. It shows how official public data can be transformed into a decision-friendly dashboard and presented in a way that links economic events to business implications.

Build Workflow

How the dashboard was prepared end to end.

Downloaded official CSV files from the Office for National Statistics and the Bank of England.

Cleaned and reshaped the data in Python using pandas into Power BI-ready long and support tables.

Built a 3-page Power BI dashboard covering overview, crisis moments, and indicator relationships.

Exported a final dashboard package for GitHub and portfolio presentation.