by Matt Allington | Sep 7, 2018 | Excelerator BI
It’s pretty early in the morning here in Sydney Australia (just after 6 am actually). I just finished a fun YouTube session with Avi Singh where I demonstrated my approach to using variables in DAX to help write more complex formulas. Avi streamed the session live...
by Matt Allington | Sep 3, 2018 | Excelerator BI
Level: Beginners Power Query is a product that allows business users to extract data from any source, cleanse and transform that data, and then load the modified data to a new location, typically into an Excel spreadsheet or a Power BI data model. Power Query is very...
by Matt Allington | Aug 27, 2018 | Excelerator BI
Evaluation contexts in Power BI DAX I was in Seattle, USA in the last week of July participating in the Microsoft Business Applications Summit. I love attending conferences like this and it was a privilege to present on a few topics over 3 days. One of the...
by Matt Allington | Aug 22, 2018 | Excelerator BI
Way back in 2014 I decided to check out what Google Trends had to say about Power Pivot and Power Query global Interest. In case you don’t know, Google Trends will show you the relative frequency of people searching for certain words – it is a good indicator of...
by Parker Stevens | Aug 20, 2018 | Excelerator BI
Level: Intermediate Matt: This is the second article in a series from Parker Stevens where he talks about using R with Power BI. If you missed the first article, you can read it here. Parker: Power BI comes with a ton of built-in features but eventually you might...
by Matt Allington | Aug 16, 2018 | Excelerator BI
One thing I did a long time ago was set up my own forum called PowerPivot Forum. This forum is open to anyone to join and to ask questions and/or help others. If I have any spare time (decreasingly so these days), I help people out on the forum too. It occurred to me...
