Author: Rachel Dyer

Each of us struggles with DAX in different ways. The language is so elegant, so elusive and maddeningly Houdini-like, that anyone who works it long enough comes to love it. But progress comes in fits and starts. One week you think you have...

RACHEL DYER (CSG Pro)   Rachel Dyer is the Vice President of Analytics at CSG Pro with in-depth expertise of the Microsoft BI stack and dimensional modeling. She has a broad management background and strong communications skills, coupled with considerable technical experience in platform...

I'm a fan of SSAS, so you should know that up front. But I'm also working with clients who (a) need to keep their data on premise (health care, banking), and who (b) are large enterprises. If I had to move those...

This is a cool trick that goes hand in hand with Relative Month Index. It shows how to include a slicer that lets the user choose which month they want to start a 24 month look back in. Users love 12 or...

If you want to understand DAX, sooner or later you’re going to have to deep dive into Table Functions. The SQL BI guys Marco Russo and Alberto Ferrari train people in Table Functions before CALCULATE. And for good reason. If I’ve learned anything about DAX,...

Of all the great things about the new Power BI, there’s one thing not so loveable, and that is the confusion introduced by using the same term to mean yet another thing. If you go by the powerbi.com site, you get the impression “Power...

We’ve blogged earlier on the 60,000 -feet level overview of Power BI and what there is to like about it. This blog is a follow-on with a particular angle. I’m going to make a case that Power BI is a great set...

Ready to wrangle your data?