721
Report Author: Le Hong Quang
721
Share template with others
Report submitted for FP20 Analytics ZoomCharts Challenge 14 (March 2024). The report was built with the National Fuel Market Analysis dataset and includes ZoomCharts custom Drill Down PRO visuals for Power BI.
Author's description:
As I dive in to the dataset I have discovered some insight:
- Huge increase in fuel price in 2022 and 2023 due to pandemic, wars, economic crisis, In most regions Gasoil Grade 3 and Petrol Premium 95 Octane 24.71% have highest revenue share, little difference in price by shifts.
- Price have tendency to increase around quarter 3,4 due to increase in demand (In most case both Price and Revenue largely increase around quarter 3,4) - In most of regions and cities price and revenue have negative relationship (the higher the price the lower the revenue and reversed).
- The revenue and price (Price represented by the size of circle) is much higher at the East where the trading of fuel with countries that high export of fuel is highest.
- Fuel sellers in the East have slow price increase rate due to high demand than the other sellers.
- Seller in the South have lowest revenue and average price due to the geographical disadvantage.
- The general trend is lower revenue/price coming to Southern part and higher when coming to Eastern and Southern part.
Participate in data challenges, build and submit reports to get free template downloads.
Join CommunityMobile view allows you to interact with the report. To Download the template please switch to desktop view.
How to use a PBIX template
Preview the interactive report, download the PBIX file, open it in Power BI Desktop, and replace the same data connection with your own dataset.
Preview and download
Explore the report online and download the PBIX template file.
Open in Power BI Desktop
Open the downloaded PBIX file in Power BI Desktop.
Connect your data
Replace the sample data source with your own dataset.
Refresh and adjust
Refresh the model and update fields or visual were needed.
Save and share
Save your report and publish it for your audience.