Name: BI Training
Address: AU
Telephone: @
Price range: @

Blog Categories

Matt Allington

Matt Allington is the Data Professional you want to be trained by. Matt does a phenomenal job of breaking concepts down into easily digestible chunks. He is also the principal consultant at Excelerator BI Pty Ltd. There are 3 main areas where he can help you save months and even years of self-learning: Kickstart Power BI in your organisation, training and consulting. He also brings his 35-year career expertise in business and data analytics directly to you with his high quality Power BI training courses and consulting. Check out his Public Training and begin your Power BI Ninja journey!

Why Excel will SAVE you millions

By Matt Allington / April 27, 2014 September 27, 2019 / BI Strategy

Yesterday I read this post called “Why Excel is costing you millions” by Gayle Ryan. I have never seen a more misleading and ill informed post about Excel, and I was motivated to provide a response to this article here. Ryan starts out by talking about static reporting, and how […]

Create a PowerPivot Date Table with Power Query

By Matt Allington / March 14, 2014 September 26, 2019 / How to, Power Query, PowerPivot

I really love PowerPivot and Power Query. I have been doing Rob Collie’s on line training course on using PowerPivot. When I got to the section on Time Intelligence, it occurred to me that Power Query could be used to create the date table that you need. I did a […]

Power Query Reference

By Matt Allington / March 7, 2014 September 26, 2019 / Power BI, Power Query

There is a good Microsoft site for the Power Query M formula language reference. There is a lot of really useful information about the key functions of the language on that page, and I recommend it for anyone that is looking to do more with Advanced Power Query functions. If you […]

Faster Data Insights with Power BI

By Matt Allington / March 7, 2014 September 26, 2019 / Learning Resource, Power BI

A couple of weeks ago Microsoft held a full day online session called Faster Data Insights With Power BI. There were 8 sessions of about 50 mins each that covered various aspects of the new Power BI suite. The sessions have now been converted to YouTube videos and are available […]

Consolidate Multiple Excel Files in SharePoint using PowerQuery

By Matt Allington / February 23, 2014 September 26, 2019 / How to, Power Query

I had read an interesting request on the Whirlpool forum over the weekend. Whirlpool user Alicia2 wanted to extract Word document metadata into a Spreadsheet. That seemed like an interesting problem and something I could use some time. So I decided to help her out. I built this Spreadsheet that […]