by Oz du Soleil | Jan 28, 2013 | Data Integrity, Spreadsheet Development, Spreadsheet Tidiness, Tips
The image below is an Excel Dashboard section generated from 847 rows and 11 columns of data related to classroom and book sales. In the range D1:N5 we summarize Monthly Sales Totals by Sales Rep. So much easier to look at this instead of scrolling around in the...
by Oz du Soleil | Jan 25, 2013 | Data Integrity, Spreadsheet Development, Spreadsheet Tidiness
In preparation for teaching a workshop on Excel Dashboards & Reports, I’m thinking about what needs to be covered. Several months ago, Mynda Treacy of My Online Training Hub provided an excellent guest post on Excel reporting. (Going forward, I use...
by Oz du Soleil | Dec 29, 2012 | Data Integrity, Data Management, Spreadsheet Development, Spreadsheet Tidiness
Krampus torments a business owner who ran a business on crap data in 2012 high bounce rates on e-newsletters vital data sprinkled across multiple sources commission payments were wrong mail sent to out-of-state clients for local events unable to follow-up with major...
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...
by Oz du Soleil | Oct 21, 2012 | Data Integrity, Data Management
Data Management Policies are one area for limiting crap data and related consequences. This is an aspect of Data Management that’s away from the doing inside the cells, formulae, queries, PHP coding and data fields. Why is this important? Why do businesses need...
by Oz du Soleil | Sep 25, 2012 | Data Integrity, Data Management
Today, 25 September, is my birthday and this reminds me of something: Data Collection Efforts That Invite Crap Data Crap data leads to questionable analysis, bad business decisions, and even contempt of your own customers because they’re the ones who fed you...
