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 | Apr 1, 2013 | Data Management
LEARN TO LOVE YOUR DATA DUMPS I am hearing more and more that people don’t know what’s in their data, what to ask of their data, especially “how do I get at what I do know I’m looking for?” Here’s a story: THE INFORMATION IS...
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...
by Oz du Soleil | Feb 14, 2013 | Data Management, Spreadsheet Development
Fantastic article today from Forbes and author Tim Worstall. Microsoft’s Excel Might Be The Most Dangerous Software On The Planet The author points to aspects of the financial markets that would have been impossible without Excel. However, because it’s the...
by Oz du Soleil | Jan 14, 2013 | Data Management, Excel Geekdom, Screencast, Tips
Tonight, I’m preparing to teach a workshop and need examples to show the students. Here’s your behind-the-scenes peek into using Excel to generate data to build useful examples. WHY GENERATE BOGUS DATA (AKA DUMMY DATA) SETS? Knowing how to generate random...
