Power BI Tips: Filter ALL, Filter VALUES and KEEPFILTERS
Mastering filter arguments with CALCULATE is critical to having success building measures with DAX in Power BI. In the most fundamental case, you need to know the difference between how FILTER(ALL()) and FILTER(VALUES()) on a single column produce...
read moreTool Agnostic Analytics: Effective Dashboards and the Last Mile
You are going to build a dashboard. You’ve got the question you need to answer...check! And you have the data to build the required calculations...check check! But if you don’t walk that last mile with your target end users about *how* they want to see and...
read moreTool Agnostic Analytics: Building Effective Dashboards
I recently came across a good Tableau white paper entitled “10 Best Practices for Building Effective Dashboards” by Ellen Nadelhoffer, Senior Technical Writer at Tableau. (You can find it here...
read moreTool Agnostic Analytics: Yield, Speed and Outliers
What goes into a business process? What comes out? What doesn’t? And why? How fast does your process move inputs to outputs with desired outcomes? With undesired outcomes? What speeds it up or slows it down? Are there outliers or one-time events that skew...
read morePower BI Tips: Calculate 102 – Filter ALL or Filter VALUES?
If you are in Marketing and trying to understand the productivity of various sources of Leads that do or do not convert to Opportunities for Sales, using a tool like Power BI for that analysis can be a great choice. But knowing how to use filter arguments in a...
read morePower BI Tips: Pivot Table from Name/Value Pairs with “M”
When the data you “Get” in Power BI doesn’t come in nicely organized rows and columns, sometimes you need to do more with “Edit Queries” than just using the functions available on the ribbon. And that’s when you need bust out some “M” code to get the job done. In what...
read more