Alteryx Tips: Look Both Ways before you Join

If you are an Excel pro who has been fortunate enough to find Alteryx Designer, you probably love the Join Tool and are feeling OK about breaking up with VLOOKUP 😊 But if you aren’t careful about how you use this new superpower, can you turn bad data into *really* bad...

read more

Power BI Tips: CALCULATE 101

One of the most challenging and useful DAX functions to master in building complex measures and calculated columns is the CALCULATE function. In what follows I’ll describe two specific scenarios where knowing how and when to use CALCULATE is a must. My hope is that...

read more

Power BI Tips: One Dataset to rule them all!

In the Power BI Desktop August Feature Summary (https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/) Microsoft announced the “live connect” Power BI Service connector is generally available. Now everyone can start using this feature...

read more