The cohort analysis from Eric Ries’ Lean Startup using SnowPlow and Hive
keplarllp.com
keplarllp.com
I'm building a behavioral database right now called Sky (more info at http://skylandlabs.com). It seems like we have some overlap. I looked at using something like Hive for my query language but I felt like it didn't handle time-based relations between events. I'm rolling my own language called EQL (Event Query Language) using LLVM to JIT compile.
I'd love to hear about what kind of questions you're answering for clients using event-based analytics. It feels like a market with a lot of possibilities that no one is really exploiting yet.