Excelerator BI can help you exploit your data using Power BI. Kick-Start Your Power Pivot Journey Get expert Power Pivot help so you can quickly turn any data into high value reporting assets. Power Pivot & Power BI Training and Coaching Not all Power Pivot training is made equal.
I’m presenting again this year at SQL Saturday Melbourne (30th June 2018) and Sydney (7th July 2018). My topic this year will be “DAX as a Query Language“. What is SQL Saturday? SQL Saturday is an annual 1 day event that is held in many cities around the world. It is a day when SQL professionals take a […]
After what seems like a lifetime of waiting for the paperback book economy to tick its required boxes, both of my new books Supercharge Excel and Supercharge Power BI are now available to ship to most countries in the world from Amazon.com. This is a good opportunity for me to clarify how these new books […]
Level: Intermediate Last week I presented a webinar with Chuck Sterling (from Microsoft) on the topic of Time Intelligence. This was a YouTube broadcast event that anyone could join live, however it has also been recorded and can be watched at any time (see below). This article is a follow up from that webinar with […]
Level: Intermediate to Advanced Matt here. I recently met Parker Stevens online through LinkedIn – he too is a Power BI fan, just like me. Parker has shared a few techniques with me that I found very interesting. These topics have not been covered on my blog before and hence I thought it was a […]
Level: Intermediate. Sometimes, just when you think you are getting the hang of the DAX language, something happens that completely baffles you. Such events can cause you to doubt your own learning and progress. But let me assure you – this happens to EVERYONE at sometime or another. In this article I am going to […]
Level: Advanced I was answering an interesting forum question last week, and as is often the case I thought it would make an interesting article to share with you all here. I have modified the scenario a bit for this article and have built out some test measures to help explain some concepts. Problem Definition […]
I wrote a blog on this topic a few years ago over at PowerPivotPro.com. I have learnt a lot about Power Query since that time, plus Power Query has come along in leaps and bounds, and it now has a lot more capability than it had previously. Today I am going to write a new […]
There are some things that are very easy to do in Excel that don’t seem to have an immediately obvious and simple solution in DAX. One such problem is when you want to apply compound growth on an investment. Let me make up an example so it is clear what I am talking about. Simple […]
Ken Puls is coming again to Australia and once again he has generously offered to speak at the Sydney Power BI User Group. This time ‘round Ken will be talking on a broad topic around how Power BI and Excel are increasingly being enhanced to work together. Microsoft calls this “Power BI and Excel – […]
Today I want to issue a warning to anyone considering using Publish to Web to share corporate data internally within an organisation. Publish to Web is a standard feature on all Power BI accounts (free and Pro) – I first wrote about it two years ago here. This is a great feature that is designed […]
Read Full Article
Read for later
Articles marked as Favorite are saved for later viewing.
Scroll to Top
Separate tags by commas
To access this feature, please upgrade your account.