Skip to content

jamesouu/global-macro-insights-sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

48 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Global Inflation Analysis (2005-2025)

📚 Overview

This project analyzes inflation dynamics for China, United States, United Kingdom, Germany, and Japan from 2005 to 2025 using IMF CPI data. It builds a PostgreSQL database, calculates key inflation features (MoM %, YoY %, 3-Month Moving Average, 12-Month Volatility), and visualizes the trends using Python.

📂 Project Structure

  • /data/ — Cleaned inflation data (inflation_clean.csv)
  • /sql/ — SQL scripts for database creation and inflation feature engineering
  • /inflation_analysis/ — Python code for fetching, analyzing, and plotting
  • /charts/ — Automatically generated inflation analysis charts
  • README.md — Project documentation

📈 Highlights

  • Year-over-Year Inflation (%) comparison
  • Month-over-Month Inflation Momentum
  • Inflation vs 3-Month Moving Average
  • 12-Month Rolling Volatility of Inflation Rates

🛠️ Tools Used

  • PostgreSQL
  • Python: pandas, matplotlib, seaborn, psycopg2
  • Data Source: IMF CPI Database

🧑‍💻 Author

JO


✅ This project is ideal for hedge fund macro research, investment analyst applications, and data science portfolios.

About

SQL-powered dashboard project for analyzing macroeconomic indicators across countries

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages