by gene connolly | Nov 26, 2018 | Power BI |
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 different results in...
by gene connolly | Nov 26, 2018 | Data & Analytics |
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...
by gene connolly | Oct 26, 2018 | Data & Analytics |
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 https://www.tableau.com/asset/building-effective-dashboards-core) It got me...
by gene connolly | Sep 19, 2018 | Data & Analytics |
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 your...
by gene connolly | Aug 20, 2018 | Power BI |
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...