Forecast Financial Modelling – Forecast


Freight Commodity Demand Volume Forecast Power BI Visualisation

The Australian Bureau of Statistics (ABS) and the Australian government publishes a wide variety of datasets for public consumption. This particular dataset comprised of close to a million rows with a 40 year freight demand forecast by commodity across NSW at Statistical Area 3 (SA3) Level (a regional breakdown of Australia with populations between 30,000 and 130,000 people in each area). This data was aggregated to a higher level (SA4) according to the ABS definitions and a number of rows were removed that held no information.

To see the report in more detail click on the “full-screen arrow” on the bottom right.

This dashboard uses functionality including dropdown options, custom ToolTips, and custom map plots. The intention of this dashboard was to show how geospatial demand forecasts can be analysed via visually impressive plot functions in Power BI even with a simple dataset.

The data source for this Power BI visualisation is from The Australian Government.

Like this article? You’re one step closer to making data-driven decisions.

Reach out to us to start a conversation – we welcome an opportunity to understand your data needs, challenges and aspirations. We utilise an expert toolkit of data capabilities and services to help take guesswork out of your decision making.

More like this


University Dashboard: Department of Education and Training (DET), Australia data sources


Edinburgh Car Accidents Power BI Visualisation

More dashboards Contact Us