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 | Jul 30, 2015 | Excel Geekdom, Spreadsheet Development, Tips
Months ago, my friend Michael asked, “is Excel for the common man?” That question has stirred my attention and imagination like I’ve just turned 21 years old again. Excel can be used for so many things and it’s been fun to come up with uses for...
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 | May 22, 2015 | Being a Good Analyst
I had the honor of speaking at The PASS Business Analytics Conference 2015 last month. PASS is primarily a SQL community but they recently started to look at the larger business intelligence picture because of the ways that data flows all throughout an enterprise. So,...