I’ve written in the past about using the CUBE functions in Excel. The general pattern of the examples I’ve used was pretty consistent: Creating a set of members of some sort, like products or customers using the CUBESET function Extracting…
Here are 2 tips for visualizations in Power BI Dashboard. In Power BI service (PBIS) there are reports. But there are also dashboards. Dashboards are sites to pin key visuals. People can view but not interact with them. They can click…
Power BI comes stocked with a great set of visuals that keep getting better (more options to do multiples, please). Even when the default set isn't enough, there is also a great collection of additional visuals you can find in…
Year End CPE Rush Doesn’t Have to Suck(When You’re Learning DAX and M)Happy Thanksgiving everyone! Normally I use this holiday as an excuse to post something off-topic, but this year, I’m gonna stay ON topic and share something I’ve been…
Have you ever needed to get data out to an internal customer quickly to meet an urgent business need, in an easy to access, updateable format? Of course! There are lots of ways to do this, and I’ve tried various…
Navigating the sea of data One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens. For example, receivables not being paid…
It’s sometimes difficult to find things that Power BI can’t do. There always seems to be a solution no matter the task at hand. A little while ago I was wondering to myself if it was possible to embed a…
I watched a video from Guy in a Cube’s Patrick featuring Marco Russo where they walked through an example using a technique to debug DAX measures using VAR/RETURN – I loved this! https://www.youtube.com/watch?v=9SV2VnYbgg4 The video made me recall another Blog…
This is a quick tip on automated testing with Power Query. I loved Nar's post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality. For…
The Microsoft Data Platform (and probably any BI tool) and FP&A seem to have at least one thing in common: it’s hard to find qualified people. I hear it all the time. I don’t think I consciously concluded that I…