by Oz du Soleil | Sep 4, 2012 | Data Integrity, Data Management, Excel Geekdom, Spreadsheet Tidiness
What Are Pivot Tables Used For? What Are Pivot Tables Good For? Many of you have heard of Pivot Tables and aren’t sure what they are. I’ll leave you to Google how to mechanically get one working but if you’re like me, teaching the mechanics...
by Oz du Soleil | May 1, 2012 | Case Studies, Data Integrity, Data Management, Tips
Who’s the Data Boss? Anyone? As a Data Mercenary, I’ve seen a lot. One thing that has regularly come up: disconnects in Data Governance which result in a lot of people feeling pain within and outside of the business, and confusion about who’s...
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...