by Oz du Soleil | Jan 31, 2016 | Data Integrity
So many spreadsheets require basic math, but poor layout makes a spreadsheet unnecessarily complicated and brittle. They don’t need sophisticated dashboards, forecasts, statistical analysis, or connections to a database. They just need to perform basic tasks...
by Oz du Soleil | Aug 23, 2015 | Being a Good Analyst, Data Integrity, Data Management, Excel Geekdom
The PASS Business Analytics Conference 2015 was April 20 to 22 and it was an honor to be a speaker, sharing knowledge and getting to know people in the Business Intelligence realm who are outside of Excel. PASS is primarily a SQL community but they recently started to...
by Oz du Soleil | Aug 6, 2015 | Being a Good Analyst, Data Integrity, Excel Geekdom
As we develop tools in Excel, it’s nice to be at a place where everything is automated. One change in a cell cascades through the spreadsheet and updates everything that’s impacted by the single change. However, there are times when we need to override a...
by Oz du Soleil | May 31, 2015 | Being a Good Analyst, Data Integrity, Data Management for Nonprofits
I found this blog a few months ago: NonProfit With Balls (NWB). The blogger is Vu Le and this guy loves data as much as I do. He says that if data were syrup, he’d put it on his soy ice cream. If you know me, I’d say that capsaicin is the edible form of...
by Oz du Soleil | Jan 8, 2015 | Data Integrity, Data Management
Two must-read articles as we start managing our data in 2015: What End of Year Data Predictions Mean by Jordan Goldmeier, Cambia Factor CEO, Excel MVP and co-host of ExcelTV. Technology Can’t Ever Solve the Information Management Problem by Joe Shepley, VP and...
by Oz du Soleil | Nov 26, 2014 | Data Integrity, Data Management
Last week I was in a cafe and saw 2 professional-looking middle-aged gentlemen at a table. One guy told the other how he’d advised someone not to take a computerized Excel exam as part of an interview. His personal experience was that those exams are just...
