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 | Nov 29, 2017 | Data & Analytics |
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...
by gene connolly | Nov 13, 2017 | Data & Analytics |
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...
by gene connolly | Nov 2, 2017 | Data & Analytics |
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...