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 morePower 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 moreAlteryx Tips: Capture (More) Insights from your Workflow’s “Lost Data”
After building a complex workflow that finally works and gets you the output you wanted, it’s tempting to give yourself a high five and move on. But do you ever think about the data you lose as it passes through Filters and Joins, from input to output, and whether you...
read morePower 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 moreAlteryx Tips: Huge Time Saver Combining XLSX Files with Different Schema
I have a client that provides a monthly snapshot of information in an XLSX file. When the data in those files are combined, it paints a historical picture of how data is changing over time that is great grist for an analytics mill. The client process that generates a...
read morePower BI Tips: Change Measures on Drill Down
I recently had to come up with a solution for a customer requirement to change the displayed measure as each level of a hierarchy changed by drill down through a column chart. Yikes! But with a little help from the Power BI Community, here’s the solution. For example,...
read more