Strait of Hormuz Energy Impact Analysis
Budget: €8 – €30 EUR
## Power BI Project Request – Strait of Hormuz Impact Dashboard
I am looking for a complete Power BI project for a university jury presentation.
### Project Topic
**Strait of Hormuz Impact Dashboard**
The project should analyze the importance of the Strait of Hormuz in global energy markets and the potential impact of disruptions on oil prices, energy security, and regional vulnerability.
This is a highly relevant and current geopolitical topic.
### Main Research Question
**How could disruptions in the Strait of Hormuz impact global oil markets, energy security, and regional vulnerability over time?**
### Sub-Questions
1. How have global oil prices evolved over time?
2. What percentage of global oil trade passes through the Strait of Hormuz?
3. Which countries and regions are most dependent on oil transported through the Strait of Hormuz?
4. How have geopolitical tensions in the region historically affected oil prices and energy markets?
5. Which countries and regions face the highest risk if the Strait of Hormuz is disrupted or closed?
### Requirements
The project must be built entirely in Power BI.
Please use:
* Power Query for data cleaning and transformation
* Proper data modeling (star schema if applicable)
* DAX measures and KPIs
* Time-series analysis
* Interactive dashboard design
### Deliverables
#### 1. Power BI File (.pbix)
Must include:
* Data cleaning in Power Query
* Data quality checks
* Data model
* DAX measures
* KPIs
* Time-series analysis
* Interactive dashboard
#### 2. Dashboard Pages
At minimum:
**Page 1 – Executive Overview**
* Key KPIs
* Global impact summary
* Oil market overview
* Regional risk indicators
**Page 2 – Time-Series Analysis**
* Oil price trends
* Historical events and impact
* Forecasting
* Trend analysis
**Page 3 – Regional Vulnerability Analysis**
* Maps
* Regional dependency analysis
* Risk assessment
* Country comparisons
#### 3. PowerPoint Presentation
A professional 20-minute presentation including:
* Introduction
* Research questions
* Dataset overview
* Data cleaning process
* Data model
* DAX measures
* Dashboard walkthrough
* Key findings
* Recommendations
* Conclusion
* Q&A preparation
#### 4. Documentation
A short document explaining:
* Why the datasets were selected
* Data cleaning steps
* Analysis techniques used
* Key insights
* Answers to the research questions
### Dataset Requirements
Please use reliable public sources such as:
* World Bank
* U.S. Energy Information Administration (EIA)
* International Energy Agency (IEA)
* IMF
* Our World in Data
* BP Statistical Review
* Other reputable public datasets
The datasets must contain a time component and enough historical data to support meaningful trend and time-series analysis.
### Goal
The goal is not to create an overly academic project.
The goal is to create a professional, business-oriented Power BI dashboard that demonstrates:
* Power Query skills
* Data modeling
* DAX
* Time intelligence
* Dashboard design
* Business storytelling
I am looking for a complete Power BI project for a university jury presentation.
### Project Topic
**Strait of Hormuz Impact Dashboard**
The project should analyze the importance of the Strait of Hormuz in global energy markets and the potential impact of disruptions on oil prices, energy security, and regional vulnerability.
This is a highly relevant and current geopolitical topic.
### Main Research Question
**How could disruptions in the Strait of Hormuz impact global oil markets, energy security, and regional vulnerability over time?**
### Sub-Questions
1. How have global oil prices evolved over time?
2. What percentage of global oil trade passes through the Strait of Hormuz?
3. Which countries and regions are most dependent on oil transported through the Strait of Hormuz?
4. How have geopolitical tensions in the region historically affected oil prices and energy markets?
5. Which countries and regions face the highest risk if the Strait of Hormuz is disrupted or closed?
### Requirements
The project must be built entirely in Power BI.
Please use:
* Power Query for data cleaning and transformation
* Proper data modeling (star schema if applicable)
* DAX measures and KPIs
* Time-series analysis
* Interactive dashboard design
### Deliverables
#### 1. Power BI File (.pbix)
Must include:
* Data cleaning in Power Query
* Data quality checks
* Data model
* DAX measures
* KPIs
* Time-series analysis
* Interactive dashboard
#### 2. Dashboard Pages
At minimum:
**Page 1 – Executive Overview**
* Key KPIs
* Global impact summary
* Oil market overview
* Regional risk indicators
**Page 2 – Time-Series Analysis**
* Oil price trends
* Historical events and impact
* Forecasting
* Trend analysis
**Page 3 – Regional Vulnerability Analysis**
* Maps
* Regional dependency analysis
* Risk assessment
* Country comparisons
#### 3. PowerPoint Presentation
A professional 20-minute presentation including:
* Introduction
* Research questions
* Dataset overview
* Data cleaning process
* Data model
* DAX measures
* Dashboard walkthrough
* Key findings
* Recommendations
* Conclusion
* Q&A preparation
#### 4. Documentation
A short document explaining:
* Why the datasets were selected
* Data cleaning steps
* Analysis techniques used
* Key insights
* Answers to the research questions
### Dataset Requirements
Please use reliable public sources such as:
* World Bank
* U.S. Energy Information Administration (EIA)
* International Energy Agency (IEA)
* IMF
* Our World in Data
* BP Statistical Review
* Other reputable public datasets
The datasets must contain a time component and enough historical data to support meaningful trend and time-series analysis.
### Goal
The goal is not to create an overly academic project.
The goal is to create a professional, business-oriented Power BI dashboard that demonstrates:
* Power Query skills
* Data modeling
* DAX
* Time intelligence
* Dashboard design
* Business storytelling