Tools Used: 
  • Excel (PivotTables, Statistical Analysis), Data Wrangling, Data Visualization

Objective: 
  • Conducted a time-series analysis of US crude oil imports to identify long-term trends, seasonal fluctuations, and key drivers of oil supply variations. 
  • Developed interactive data visualizations and summary statistics to analyze changes in monthly and yearly import volumes.  

Data & Methodology: 
  • Integrated multi-source crude oil import datasets from public energy data repositories, ensuring data consistency and accuracy.
  • Performed data cleaning and transformation in Excel, structuring raw data for statistical modeling. 
  • Applied PivotTables and segmentation techniques to analyze regional import trends and country-specific contributions.

Key Analysis & Insights: 
  • Time-series trend analysis.
  • Found notable fluctuations due to geopolitical and economic factors. 
  • Visualized regional & country based import breakdown. 

US Crude Oil Imports- Time-Series Analysis & Trend Forecasting