About CMBI's Census Power BI Sample Model
Interact with this comprehensive Census Power BI Model that compares 2011 and 2016 Census results.
Census Model highlights
The sample has the following features
- Over 40 million census data points
- Select any suburb or compare all the suburbs
- Integration of 2011 and 2016 census data for comparison
- Ranking and % of population for all metrics
Compare suburbs for 1000s of census statistics
The embedded Power BI reports below are fully interactive. Change the values in the dropdown menus to explore the Census statistical groups or to view different suburbs. Click the table headers to sort the table by the selected column.
Understanding the dropdown parameters
- Table Group - change this parameter to see a different set of statistics in the Census Metric drop down
- Census Metric - select a particular Census data point
- State - filters the suburbs in the Power BI report/table
You can clear the selected value for a parameter by pressing the small eraser icon on the dropdown menu
Compare census statistics on the map
Hover over a bubble on the map below to see the statistics for that suburb. Change the dropdown menus to view different Census statistics.
Detailed suburb census statistics
Narrow the list of suburbs in the Suburb Picker dropdown by using the Search Suburb text box in the report below.
Use the eraser icons on the Search Suburb textbox to see a complete list of suburbs in the Suburb Picker dropdown.
NOTE: the report may take 15-30 seconds to refresh when you change the suburb.
Download all the files for this and other Power Pivot and Power BI samples
CMBI's Australian Census Sample includes an Excel and Power BI Desktop file to download, notes, and online interactive dashboard.
CMBI's Sydney house price Power Pivot sample includes an Excel file to download and detailed notes.
CMBI's World Cup 2018 Power Query sample includes an Excel file to download, notes, and instructional video.
About CMBI
CMBI designs and develops business intelligence and analytics solutions for clients in Sydney and regional NSW. CMBI technology expertise includes Power BI, Power Pivot, Power Query, Excel, SQL Server, Analysis Services, SharePoint BI, and Tableau.
Contact us today to see how we can help you achieve your BI goals.
