Trends don't need perfect data
When it comes to analyzing data trends (changes in data over time), it's important to keep in mind that the data does not have to be perfect (data never is!) in order for it to be useful.
In a conversation with a client recently, the client pointed out that their membership dashboard over several years is not 100% accurate, and therefore can't be trusted. They explained that some of the data for certain years was inaccurate (sometimes as much as only 95% accurate). And thus they didn't think the trending data was useful.
But here's the thing: the point of trending data is to see trends. Is membership growing? It is flat? Is it shrinking? Unless you're dealing with really small data sets (e.g., 50 members), a few percentage points off perfect is unlikely to affect the overall trends.
As the old saying goes, don't let perfect be the enemy of good. If you're trying to detect trends, "close enough" is very likely to get you the information you need to act.
Wes's Wednesday Wisdom Archives
A Data Integrity Report…for Reports!
I’ve written elsewhere about the value of data integrity reports. But one of the most […]
Simple rules for complex systems
Simple rules for complex systems I first heard the phrase “simple rules for complex systems” […]
Accentuate the positive
Accentuate the positive I’ve written before about the importance of database public relationsand celebrating success. I’ll add […]
Annual dues vs. anniversary dues
Annual dues vs. anniversary dues I served as director of membership for several years at […]
A change of systems requires a change of mindset
Every AMS vendor will tell you that the toughest part of implementing a new system […]
It doesn’t have to be optimal to be beneficial
It doesn’t have to be optimal to be beneficial I’m a big fan of the […]
Look for small wins
Look for small wins One of the toughest things about system implementation is simply how […]
Are you closing the loop?
Are you closing the loop? If your association does a call for presentations for any […]
Declare victory and move on
Declare victory and move on The law of diminishing returns is the point at which the […]
Clean as you go
Clean As You Go A good cook or baker knows that, when working in the […]