by Oz du Soleil | Apr 16, 2013 | Case Studies, Data Integrity, Data Management, Data Management for Nonprofits
Steve, the nonprofit Volunteer Coordinator, has a meeting with the Executive Director and a major donor in 3 hours, and Steve needs data! The canned reports in the cloud-based CRM aren’t formatted for details on volunteers, but Steve believes he can manually...
by Oz du Soleil | Apr 5, 2013 | Data Integrity, Data Management
Data Cleansing (Data Scrubbing) the process of amending or removing data that is incorrect, incomplete, improperly formatted, or duplicated. WARNING Hold on to your hat. This can get ugly. The cost of cleaning data is tough to get at. I used to charge $150 to...
by Oz du Soleil | Mar 26, 2013 | Data Integrity, Screencast
WHY SO MUCH ATTENTION ON VALIDATION? Embarrassment is what got me thinking about Excel data validation and general data quality. Let me describe 2 situations from years ago when I first started working with data: #1 My boss regularly had me run reports, and he’d...
by Oz du Soleil | Dec 29, 2012 | Data Integrity, Data Management, Spreadsheet Development, Spreadsheet Tidiness
Krampus torments a business owner who ran a business on crap data in 2012 high bounce rates on e-newsletters vital data sprinkled across multiple sources commission payments were wrong mail sent to out-of-state clients for local events unable to follow-up with major...
by Oz du Soleil | Nov 12, 2012 | Case Studies, Data Integrity, Data Management
We can talk all the live-long day about keeping clean data but there will still be corrupt data and human blunders. What happens when it’s our own damned fault? This topic is à propos after a recent chat with a Database Administrator about the realities of...
