by Oz du Soleil | Apr 21, 2012 | Case Studies, Data Integrity, Data Management
One challenge in Data Governance is ensuring that business rules are accurately reflected in your processes, reports, queries and spreadsheet formulae. A critical element is anticipation of the strange things that might happen that would cause false positives and...
by Oz du Soleil | Apr 17, 2012 | Data Integrity, Excel Geekdom, Spreadsheet Tidiness
Think about that person who comes in before the dentist? They look around, take x-rays, and get everything clean and set up for the dentist. In some ways a Data Hygienist is similar: come in before the Analyst; before the Accountant, before the Database Architect;...
by Oz du Soleil | Apr 17, 2012 | Case Studies, Data Management, Excel Geekdom, Spreadsheet Tidiness, Tips
Converting PDF to Excel. OMG! Several of my clients have needed critical information that was locked in a PDF file. Maybe they wanted to sort thousands of entries by zip code, # of employees, square-footage or by industry. No-can-do in a PDF! There are lots of PDF to...
by Oz du Soleil | Apr 17, 2012 | Data Management, Tips
Crap data is costing you money. Crap data is keeping you from making money. Your needs don’t call for a pre-packaged system with more bells and whistles than you need. Your needs don’t call for an expensive pre-packaged system with more bells and whistles...
by Oz du Soleil | Apr 17, 2012 | Excel Geekdom, Tips
{=sum(- -(b8:b550 < f8:f550))} One more thing I’ll whoop on ya today: Excel’s spooky little double-negative. S’pose you want to know the number of times something was true, and then do math with it COUNTIF won’t help because...
