Charley Kyd wrote a nice OLAP primer entitled Don’t Discard Those Spreadsheets: The Power of Excel-Friendly OLAP. I haven’t done much work with OLAPs, so it’s nice to have it laid out in simple terms.
7 thoughts on “OLAP Primer”
Posting code? Use <pre> tags for VBA and <code> tags for inline.
Ditto, I will be reading that for sure!
Dick, please prepare a 5-minute summary presentation on that OLAP thing, and deliver it in the bar at the upcoming Summit. The one that has OLAP-dancing.
Charley is very helpful. I took his teleconference seminar a year ago – excellent. That changed my situation at work (Fortune 50 company) to where I often now teach Excel setup for working from mainframes and automating weekly updates in Excel with minimal effort. Great stuff.
I am now trying to determine how to get his OLAP approach introduced to the company.
[…] The power of Excel-friendly OLAP Dick Kusleika pointed a few days ago to a paper by Charley Kyd. In it, Charley gives a convincing overview of the possibilities revealed by OLAP-powered Excel solutions. Speaking from experience, I can only attest to the amazing things this combination allows you to achieve. […]
This is also a good resoucre – and intresting product!
http://www.palo.net/index2.php?show=1
Great catch Dick. Thanks for pointing this out!