by Oz du Soleil | Sep 27, 2013 | Data Management
Today Chandoo posted an interesting blogpost on “The Best Excel Interview Questions.” This is interesting for many reasons. For one, in Excel forums this question comes up a lot in very different variations: Someone says they’re an Excel expert, how...
by Oz du Soleil | Aug 13, 2013 | Data Management
Once again, let’s get out of the spreadsheet and discuss other things that we need to manage this world with reliable data. Today, we look at what it takes to fully own a data-driven role. Many of us are shocked when we take on a new position and discover how...
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 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 | 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...