I have been waiting for this feature to be delivered for a while. Until this week, the only way to export data from Power BI was to do it into a source data table. That meant that if you had data laid out like shown below, and you exported it […]
I mentioned in an earlier blog that I have been doing some work with the owner of the InfoRiver Power BI Custom visual. I have been testing, given UI feedback, and more recently I have produced some instructional videos. I wanted to share the first of these videos with you […]
You may already be aware (but then again, maybe not) that Microsoft shares its plans for upcoming new features for the Power Platform every 6 months, and Power BI forms a subset of that plan. The next plan is called Power Platform Release Plan 2021 Wave 2. It takes a […]
Every now and then I write an off-topic blog post; today is one of those days. In the past I have shared how I manage my time, in case you are interested in going back and reading that one. Today I want to give you some motivation to save well […]
This article continues to build on my COVID Case Fatality Rate report for Australia. Something happened with the global source data this week – in short, it was wrong. This is a global database and I am sure there are many people diligently trying to keep the data up to […]
I am writing an off-topic article today but I promise I will circle back later in the week with a follow up article bringing it back on topic. In this article, I am going to share a COVID report I built today, and later in the week I will post […]
I was helping someone recently with an issue. They wanted to allow end users (department managers in this case) to enter data in a table as simply as possible, and then use this data for reporting. The challenge often is, that the easiest way to enter data from a user’s […]
Tabular Editor is a Power BI Tabular Modelling productivity tool developed by Daniel Otykier. I blogged about Version 2 of the Tabular Editor in this article here. The 3rd edition of Tabular Editor has just been released, and it is a major upgrade from version 2. TE 3 is not […]
I first wrote this article back in Feb 2017 to be a definitive list of the top reasons why you should learn how to use Power BI in your organization (in case you haven’t already made the decision to do so). In fact there is only one thing that worries […]
Power BI Corporate Training You’ve come to the right place At Excelerator BI, we offer world-class instructor-led training to organisations large and small. The training can be live face-to-face, or live remote and on-line. What's The Best Option For My Company? World Class Power BI Corporate Training for your Business […]
A client recently asked me if it was possible to build a Power BI report using data from a Microsoft Form. I have come across this question a few times now, and you could be excused for thinking this would be a straightforward task. Despite the fact that Microsoft has […]
To celebrate the release of the third edition of my book Supercharge Power BI, I plan to hold a live webinar this coming Thursday pm (US time), Friday morning Australia/NZ time. Sorry, it will be very late for Europe. I plan to cover 1 topic from my book, and I […]
One interesting trend I have seen over the last 12 months is the creation of a lot more non-technical Power BI content on the web. Adam Saxton and Patrick LeBlanc were early adopters of this format with their YouTube channel “Guy in a Cube”. More recently there have been new […]
I am proud and excited to announce that I have again updated my best-selling DAX book Supercharge Power BI, now in its 3rd edition. This book as a long history: First released back in Sept 2015 under the title “Learn to Write DAX”. Updated in June 2018 (2nd editions) in […]
Power BI Desktop is a free, standalone self service BI tool for data modelling and reporting. You will not get a better, free desktop data modelling and reporting tool than this anywhere. Power BI Desktop is evolving at a rapid rate with updates released every month. Due to the […]
As my regular readers may know, I am the co-organiser and co-founder for the official Power BI User Group here in Sydney. During the period where COVID has impacted our ability to congregate face to face, Iman and I have been running virtual, online meetup events. Last week I presented […]
Level: Beginners First posted May 2015, Updated Feb 2021. Many aspects of this article also apply to Power Pivot for Excel. Technically you don’t need calendar tables to use Power BI. Power BI comes with an inbuilt date capability called “Auto Time Intelligence”. But the inbuilt capability is very basic, […]
Level: Intermediate DAX is a tricky language; on the surface it is deceptively simple, but under the hood it can quickly become complex and it can take many years to master. If you have ever typed a formula and crossed your fingers when you press Enter, then you know what […]
Level: Beginners The objective of this article is to help you understand the differences between shaping your data (using Power Query) and modelling your data (using the modelling tools inside Power BI). You will need to do both to build a robust Power BI report. I first wrote this article […]
Matt Allington has been delivering Power BI training for more than 5 years and has more experience teaching Power BI than any other person in Australia. Matt Allington is a Microsoft MVP (Power BI) and is the author of the best selling book Supercharge Power BI. Matt developed a quality-targeted curriculum that […]
Excelerator BI | © 2023 | Sitemap