This page contains resources that I have found useful in my personal and professional life. It contains everything from quotes and books that I like to podcasts and videos.
If you don’t want to scroll through the entire list, you can click on one of the links below to filter the resources by specific category.
I will update this list as I discover new resources. If you have a resource you think I should add, please email me.
Power BI Whitepapers
All the Power BI whitepapers in one place.
Data Validation Search – Free Add-in
A common Excel request is to be able to type characters and see the in-cell data validation drop down list reduce, based on what you have typed.
This free add-in from Jon Acampora (Excel MVP) does just that. He has recently added a few new features.
If you have long drop down lists this add-in is a great addition to Excel.
This link has a video of how it works and the new features like Auto Open when a data validation list cell is selected.
The R Language
If you are into statistics then you probably already know about the R language – but if you don’t it may be worth looking at.
It is open source code that is built to handle statistics and big data. It has some limitations when used with Power BI but it can be used on its own.
This article looks at using visuals created with R in Power BI.
DAX is the function and query language of PowerPivot and PowerBI. It has been around for a while, but it didn’t really have many editing tools until DAX Studio came around.
DAX Studio has been created by the SQLBI.com guys – the legends in PowerBI.
I saw a demo today at the Perth Modern Excel User Group at Microsoft Perth – its great.
Whilst it is a powerful editor, it is not just a code editor.
There are lots of options to allow you to optimise your DAX code. Lots of output options as well.
You can test and see how long it takes to run your DAX commands.
If you regularly use DAX in Power BI or PowerPivot then DAX Studio is a must have.
Hacking Power BI
Chris Webb’s BI website is a great resource on Power BI, DAX and Power Query and Power Pivot
This post shows how to hack DAX to display characters. Opens up some new possibilities.
Power BI Free vs Pro
Compare the offerings of the Free vs Pro versions of Power BI.
The Pro version costs about AUD10 – 15 a month.
Thanks to Gilbert Quevauvilliers for creating the infographic + sharing.
Finding Those Pesky Links
Thanks to Bill Manville for sharing the add-in.
This is a free add-in that’s been around for a long time and it finds most of those frustrating links that may have been created by
The add-in has been updated over the years so it now handles Power Query.
Useful Excel Template for Power BI Desktop
A free Excel template that can
Power Query Cheat Sheet
Some great tips on language usage with DAX and the M language in Power Query with examples and explanations.
You can download pdfs.
There are lots of Excel blogs out there.
This page lists a lot of the best ones (unfortunately my site isn’t listed yet – but you never know).
April Update to Power BI
Ability to connect to the Power BI dataset and the ability to create a Query based on an example column. Interesting times ahead.
Quick measures also added.
Make your point
When using charts/graphs in your presentations make sure you communicate the point of the chart/graph. Don’t assume the reader will get the point.
The above blog post explains and demonstrates the issue well.
Power Query M Language Editor
Power Query (Get & Transform) uses the M language to allow you to customise and build in flexibility to your queries.
Currently writing the M language is tricky to write. It is case sensitive and there is no built-in help to assist you using the language.
Apparently Microsoft is working on creating an M editor, but there is no time line on when it will be ready.
This article takes you through some steps to create your own editor using Notepad ++.
If you use Power Query a lot then this may be worthwhile.
March 2017 Power BI update
There is a new Matrix Visual report with more options. It has a separate icon so you can compare to the existing Matrix.
The new Numeric Range slicer looks interesting too.
The World in Charts over the last 200 Years
Some informative charts showing how the world has change in the last 200 years.
Worth a look – some good trends there.