by Matt Allington | Mar 14, 2019 | Excelerator BI
One of the things I like about my live, online training courses is that I get to hear great questions from the trenches from people learning DAX and Power BI. Last week, John asked me how to apply conditional formatting with a Text field (not a numeric field). I...
by Matt Allington | Mar 11, 2019 | Excelerator BI
I was trying to clean up my hard disk drive on my PC the other day. I use a program called WinDirStat to show me graphically what is taking space (as an aside, this is great software and you can download it here). After running the software I noticed that I had...
by Matt Allington | Mar 4, 2019 | Excelerator BI
I woke up Saturday morning to a lot of chatter and blog articles about an announcement that Microsoft made at SQL Bits. Microsoft is adding “Calculation Groups” to the DAX language. There are a number of blogs already that talk about the announcement, including Chris...
by Matt Allington | Feb 28, 2019 | Excelerator BI
I was answering a question for a student in one of my online training courses this week. The question was, “Do you know of a way in power query to efficiently extract YYYY-MM from a Date column?” This can be done ‘manually’ with multiple steps including: Extract the...
by Matt Allington | Feb 19, 2019 | Excelerator BI
Updated Feb 2019. This is an edited version of my original article which first appeared on my site in Feb 2016. The rate of change in the tools available to a Business Analyst has never been faster than it is today. The market is changing so quickly that many...
by Matt Allington | Feb 14, 2019 | Excelerator BI
Today Gartner released the 2019 magic quadrant for Business Intelligence. As expected (by me at least), Microsoft is continuing its trail blazing and now has a clear lead over Tableau in both ability to execute and completeness of vision. I thought it would be...
