by Oz du Soleil | Aug 7, 2012 | Data Management, Excel Geekdom, Spreadsheet Development, Tips
There are plenty of tutorials about working inside spreadsheet cells: creating formulae, finding ways to extract elusive data, etc. However, some of the best Data Management attention is spent outside of the spreadsheet cells: development of the overall file. So...
by Oz du Soleil | Jul 21, 2012 | Data Management, Excel Geekdom
With the first glimpses of Excel 2013 (as part of Office 15) being released & reviewed it’s a good time to address two prognostications about Excel’s future. 1. EXCEL IS DEAD, IT HAS NO FUTURE I was on a conference call recently and the premise...
by Oz du Soleil | Jul 11, 2012 | Data Management, Excel Geekdom, Spreadsheet Tidiness, Tips
So, a client delivers a lot of data to me. They need it scrubbed or, reorganized or, an application built around their to automate tasks … or some combination of the three. Guess what? Most projects involve something that I don’t know how to do (yet). And...
by Oz du Soleil | Jun 8, 2012 | Data Management, Excel Geekdom
If we were to take a poll of people who are both good at Data Management, and are musicians I bet we’d find an unusually high number of bassists and drummers. Why? Any good band must have a solid rhythm section Any good business must have solid Data...
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...
