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 | Jan 25, 2013 | Data Integrity, Spreadsheet Development, Spreadsheet Tidiness
In preparation for teaching a workshop on Excel Dashboards & Reports, I’m thinking about what needs to be covered. Several months ago, Mynda Treacy of My Online Training Hub provided an excellent guest post on Excel reporting. (Going forward, I use...
by Oz du Soleil | Oct 21, 2012 | Data Integrity, Data Management
Data Management Policies are one area for limiting crap data and related consequences. This is an aspect of Data Management that’s away from the doing inside the cells, formulae, queries, PHP coding and data fields. Why is this important? Why do businesses need...
by Oz du Soleil | Sep 7, 2012 | Data Integrity, Excel Geekdom, Spreadsheet Development, Tips
Crossfooting is the Word of the Day. I woke up today and read a forum post about spreadsheet errors. Smart spreadsheet users include crossfooting to check the integrity of their spreadsheets and results. So: what is crossfooting? Crossfooting: calculating a...