Power BI Training for Government
Power BI Training for Government by Warren Dean
Welcome to the Course!
FREE PREVIEWLets Build a Demographics Report
FREE PREVIEW1.1 Files for Download
FREE PREVIEW1.2 Extracting Census Data from the ABS
FREE PREVIEW1.3 Get a CSV into Power BI
FREE PREVIEW1.4 Cleaning data with Power Query
FREE PREVIEW1.5 Static Elements
FREE PREVIEW1.6 ArcGIS Map
1.7 Exercise: Get and Clean CSV Data
1.8 Solution: Get and Clean CSV Data
1.9 Merge two Tables
1.10 Add Column
1.13 Clustered Column Chart
1.11 Query Modifications in Applied Steps
1.12 Add Column from Examples
1.14 Get Data from the Web and Model (See notes, please connect to csv)
1.15 Filter Pane and Top N
1.16 Exercise: Get and Clean Excel Data
1.17 Solution: Get and Clean Excel Data
1.18 Unpivot and Donut Chart
1.19 Interactions between visuals
1.20 Population Pyramid (Tornado Chart)
1.21 Custom Tooltip
Download Module 1.pbix
Lets Build a Spatial Report
FREE PREVIEW2.1 Files for Download and Model Overview
2.2 Static Elements
2.3 Slicer
2.4 Clustered Column Chart
2.5 Line Chart with Forecasting
2.6 Setting up Mapbox
2.7 Mapbox Geocoder and Lasoo
2.8 Mapbox Cluster
2.9 Mapbox Heatmap
2.10 Mapbox Custom Basemap
2.11 Mapbox Custom Choropleth and 3D
2.12 Bookmarks and Buttons
Download Module 2.pbix
Lets Build a Financial Report
FREE PREVIEW3.1 Get Names Groups from Excel
3.2 DAX Calendar Table
3.3 DAX Overview
3.4 Measures
3.5 Static Static Elementss
3.6 Slicer and Visual Arrange
3.7 Clustered Column Chart with a DAX Measure
3.8 Quick Measure
3.9 Waterfall
3.10 Pivot Table
3.11 Slicer with Hierarchy
3.12 Drill Down
3.13 Drill Through
3.14 What If Parameter
3.15 Decomposition Chart and Key Influences
Bonus - Zebra BI
Download Module 3.pbix
Lets Build a Building Utilisation Report
FREE PREVIEW4.1 Setup
4.2 Synoptic Designer for Power BI (Web)
4.3 Synoptic Panel (Custom Visual)
4.4 Calendar (Custom Visual)
4.5 Clustered Column Chart
4.6 Custom Sort Order
Download Module 4.pbix
Lets Build a Capital Works Report
5.1 Custom Tooltip with an Image
5.2 Publish to Power BI Service
5.3 Quick Insights
5.4 Report in the Power BI Service
5.5 Embedding a Power BI Report
5.6 Dashboard in the Power BI Service
5.7 Manage Alerts
Bonus - Custom Report Design with Figma
Downlaod Module 5.pbix