• RT @SethGrimes @NeilRaden @weckerson instead do two separate SUBSELECTS, do COUNT/SUM separately, then join results. Multipass SQL 101 :-)
     — 5:02 PM Mar 31
    from TweetDeck
  • RT @SethGrimes @NeilRaden @weckerson if u join two fact table w diff # or rows and do COUNT or SUM u may get wrong results - so not recmd
     — 5:01 PM Mar 31
    from TweetDeck
  • working on our new #BI SI selection tool w @lizherbert >500 names by >30 criteria. Will be great for shortlisting SIs for our clients.
     — 4:59 PM Mar 31
    from TweetDeck
  • @NeilRaden if u join two fact tables with diff # of rows and do counts and sums you could get wrong results
     — 4:57 PM Mar 31
    from TweetDeck
  • Blogged on 5 types of in-memory analytics architectures http://bit.ly/crHTjB #BI
     — 2:25 PM Mar 31
    from TweetDeck
  • RT @NeilRaden @weckerson does any EII tool ever know that you can't join two fact tables, for example
     — 2:24 PM Mar 31
    from TweetDeck
  • RT @johnrrymer: Almost done with Q1. Unexpectedly active given the lousy economy. BE same here!
     — 1:07 PM Mar 31
    from TweetDeck
  • Interesting disc w a client (not a first one) on the diff between EII and data federation right in ROLAP - EII is not multi-dim aware
     — 12:05 PM Mar 31
    from TweetDeck
  • RT @CurtMonash: Pharma company strategy in http://bit.ly/a4TRVd is great. Variants should be followed by many. BE: Thx!
     — 9:11 PM Mar 30
    from TweetDeck
  • RT @CurtMonash: Flooding is getting annoying -- my Roger Zelazny books are soaked BE: use the trump cards to move water into the shadows :-)
     — 9:10 PM Mar 30
    from TweetDeck
  • RT @NeilRaden Does it have ACID BE: nope, read only. I didn't think any columnar had true ACID, do they? Aren't updates batch only?
     — 9:06 PM Mar 30
    from TweetDeck
  • RT @santaferraro: If you are part of a BICC BE: lots of details here http://bit.ly/cdRvIG
     — 6:07 PM Mar 30
    from TweetDeck
  • @CurtMonash do you have a paper on 3 kinds of columnar - i'd be interested in taking a peek
     — 6:05 PM Mar 30
    from TweetDeck
  • RT @CurtMonash @NeilRaden so, Neil, if it has no DDL, but has SQL, is it relational? :-)
     — 6:03 PM Mar 30
    from TweetDeck
  • RT @NeilRaden @CurtMonash How would you classify Attivio which is an inverted index DBMS but has an ODBC SQL wrapper
     — 5:58 PM Mar 30
    from TweetDeck
  • Another client inquiry from IT "how do I sell BI to my biz users". Short answer: you work for a wrong co. Long answer http://bit.ly/908Ier
     — 5:56 PM Mar 30
    from TweetDeck
  • More and more clients questions on "what to put and not to put into EDW" http://bit.ly/dkwADS
     — 5:54 PM Mar 30
    from TweetDeck
  • @CurtMonash I usually say "non row oriented RDBMS" to deliniate
     — 5:51 PM Mar 30
    from TweetDeck
  • Partner ecosystem implications for #BI market see @hkisker blog http://bit.ly/cy03VM
     — 11:59 AM Mar 30
    from TweetDeck
  • Blogged on 3 top questions to ask a #BI vendor http://bit.ly/cSHxj0
     — 6:03 PM Mar 29
    from TweetDeck