Just completed my April Challenge dashboard (even though past the deadline, but it's something I had to do, and I learned so much, the best project I have worked on so far)
The Global Fuel Price Report: Analytical Study of Petrol, Diesel & LPG Pricing, Tax Burden, Subsidy Regimes & Crude Oil Dynamics
DATA ENGINEERING: Built 14 new calculated columns in Power Query and DAX including price-to-crude ratios, tax amount in USD, price band classifications, subsidy gap index and more.
Key findings from 84 countries · 7 regions · 2020–2026 · 27,468 records:
→ Venezuela pays $0.02/L. Hong Kong pays $5.54/L That is a 354x price gap in the same world
→ Europe pays 3x more than the Middle East
Not because crude costs more, because governments tax more
→ 2020 COVID collapse dropped global avg to $1.48/L, 35% below the all-time average
→ Post-2022 prices remain 71% above 2020 despite crude stabilising, prices rise faster than they fall
→ Africa pays MORE than South America despite lower GDP, an infrastructure problem presenting as a price problem
Built entirely in Power BI from raw data to full dashboard, columns, DAX, measures, conditional formatting and all.
@ezekiel_aleke
#PowerBI #DataAnalytics #FuelPrices #April #DataChallenge #EnergyAnalysis #DAX #aprilchallengewithezekiel