macroeconomic-analysis-r-sql

📊 View Full Report

📈 View Interactive Tableau Dashboard

Macroeconomic Trend Analysis | R + SQL + Tableau

Tools: R · ggplot2 · dplyr · SQLite · Quarto · Tableau
Period: April 2025 – February 2026

---

Overview

Built a macroeconomic analysis pipeline to model an 11-month disinflation cycle. Analyzed inflation, unemployment, GDP growth, interest rates, and consumer sentiment using tidyverse wrangling, ggplot2 visualization, SQL window functions, and Tableau dashboards.

---

Key Results

| Metric | Change | |—|—| | Inflation | −1.1 pp (3.8% → 2.7%) | | Unemployment | +0.5 pp (4.0% → 4.5%) | | GDP Growth | −0.9 pp (2.4% → 1.5%) | | Rate Cuts Modeled | 125 bps | | Inflation/Unemployment Correlation | −0.9851 |

---

Tableau Dashboard

Developed an interactive Tableau dashboard to visualize macroeconomic trends and highlight key relationships between indicators.

Features:

• Dual-axis comparison of inflation and unemployment
• Time-series analysis of GDP growth and interest rates
• Reference lines and bands for performance benchmarking
• Annotated insights highlighting economic relationships

View Dashboard on Tableau Public

---

Techniques Used

• tidyr::pivot_longer() for multi-series visualization prep
• SQL window functions: AVG() OVER, LAG() OVER
• CASE WHEN macro regime classification
• Pearson correlation computed natively in SQL
• Quarto for reproducible report rendering

---

Files

• EDA_project.qmd — full source code
• EDA_project.docx — rendered report