Find me on
Includes a live interactive dashboard exploring relationships between global stock markets and commodities.
INTERACTIVE DASHBOARD
Explore the dashboard to analyze market trends, performance, and relationships across assets.
Includes a live interactive dashboard — explore the data in real time
OVERVIEW
This project explores the relationship between global stock markets and commodities using interactive data visualisation.
The dashboard enables users to identify trends, compare performance, and understand how different assets respond to market conditions and economic events.
THE PROBLEM
Financial data is complex and often fragmented, making it difficult to understand relationships between markets and commodities.
Without clear visualisation, identifying trends, volatility, and correlations requires time-consuming manual analysis.
THE SOLUTION
Developed an interactive Power BI dashboard that integrates stock and commodity data into a single, user-friendly interface.
The solution enables users to explore trends dynamically, identify correlations, and gain actionable insights into market behaviour.
KEY FEATURES
• Interactive Power BI dashboard
• Cross-market performance tracking
• Correlation and volatility analysis
• Filters by region, asset type, and timeframe
KEY INSIGHTS
-
Market relationships vary across regions and asset types
-
Energy commodities show high volatility but strong influence on markets
-
Gold demonstrates stability during periods of market uncertainty
-
Clear correlation patterns exist between major global markets
TECHNICAL APPROACH
TOOLS USED
Data was cleaned, transformed, and analysed using Python and BigQuery before being visualised in Power BI.
Power BI Python Google BigQuery Google Sheets
Sophia Lumpa
Business Intelligence & Operations Analyst
​
​
