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...
by gene connolly | Dec 8, 2017 | Power BI |
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...
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 22, 2017 | Power BI, Uncategorized |
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...
