by Oz du Soleil | Jun 7, 2013 | Data Integrity, Data Management, Excel Geekdom
I’m getting ready to teach a 2-session workshop on parsing data in Excel. As with other courses, before I teach them for the first time, I have to clarify the mindset to decide who would get the most from the course. Scrubbing data, reorganizing columns, peeling...
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 | Apr 4, 2013 | Data Integrity, Data Management
Data Management: Process by which required data is acquired, validated, stored, protected, and processed, and by which its accessibility, reliability, and timeliness are ensured to satisfy the needs of the data users. (BusinessDirectory.com) In my previous...
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 | Mar 9, 2013 | Data Integrity, Data Management, Spreadsheet Development
There was a steel smelter in my hometown. He was a tall, solid block of quiet energy. When asked about his occupation he’d hiss with deliberate bravado: “I work with fire” The way he emphasized “fire” conveyed his passion...
