A Quick HBase Primer from a SQLBI Perspective

One of the questions I’m often asked – especially from a BI perspective – is how a BI person should look at HBase.  After all, HBase is often described quickly as an in-memory column store database – isn’t that what SSAS Tabular is?   Yet calling HBase an in-memory column store database isn’t quite right because in this case, the terms column, database, tables, and rows do not quite mean the same thing as one would think from a relational database aspect of things. Setting the Context How I usually start off is by providing a completely different context before I…

Rate this:

To the Cloud…and Beyond!

After all the years of working on enterprise Analysis Services implementations, there were definitely some raised eyebrows when I had started running around with my MacBook Air on the merits of Hadoop – and Hadoop in the Cloud for that matter. It got a little worse when I was hinting at the shift to Big Data: At a Crossroads … from SSAS to BigData! Revelations – rolling the hard six to SQL BI and Hadoop It sounded strange until we had announced during the PASS 2011 Day One Keynote which I also called out in my post Connecting PowerPivot to…

Rate this:

Hadoop Summit and all hail screen sharing!

Presenting for the first time at Hadoop Summit was a serious thrill and this was just Day 1!  Just as a refresher, Dave Mariani (@dmarini) from Klout and I got the awesome opportunity to present How Klout is changing the landscape of social media with Hadoop and BI (session info | meet the presenters).  It was fun to talk about how Klout uses Flume, Scala, node.js, Hadoop/Hive, and AJAX to work together with an Analysis Services cube to gain powerful insight.  Our theme: Hadoop and BI – better together   As well, it was great to meet so many of…

Rate this:

SQL BI at Hadoop Summit = Awesomesauce!

For the 2012 Hadoop Summit, I will have the honor to co-present with Dave Mariani (@dmariani) from Klout in our session How Klout is changing the landscape of social media with Hadoop and BI. Our session is currently scheduled for June 13th at 3:35pm but it is subject to change.  Check out our session and some pretty amazing others on the Hadoop Summit Schedule at: http://hadoopsummit.org/schedule/.  Our session info is: — How Klout is changing the landscape of social media with Hadoop and BI. In this age of Big Data, data volumes grow exceedingly larger while the technical problems and…

Rate this:

A Primer on Hadoop (from the Microsoft SQL Community perspective)

For a quick primer on Hadoop (from the perspective of the Microsoft SQL Community), as well as Microsoft Hadoop on Azure and Windows, check out the SlideShare.NET presentation below. Above the cloud: Big Data and BI View more PowerPoint from Denny Lee Note, as well, there is a great end-to-end Microsoft Hadoop on Azure and Windows presentation available at: Apache hadoop for windows server and windwos azure View more PowerPoint from Brad Sarsfield

Rate this:

BI and Big Data–the best of both worlds!

As part of the excitement of the Strata Conference this week, Microsoft has been talking about Big Data and Hadoop.  It started off with Dave Campbell’s question: Do we have the tools we need to navigate the New World of Data?.  And some of the tooling call outs specific to Microsoft include references to PowerPivot, Power View, and the Hadoop JavaScript framework (Hadoop JavaScript– Microsoft’s VB shift for Big Data). As noticed by GigaOM’s article Microsoft’s Hadoop play is shaping up, and it includes Excel; the great call out is: to make Hadoop data analyzable via both a JavaScript framework…

Rate this:

Hadoop JavaScript– Microsoft’s VB shift for Big Data

One of the cool things about the Hadoop on Azure CTP is its Interactive JavaScript Console – it allows users query and visualize data on top HDFS using a JavaScript framework.  For example, below is a graph pie visualization within a browser generated by the Interactive JavaScript console using graph.pie function. Why is this important and cool at the same time?  As one can note with amazing projects like node.js, JavaScript is being seen by many as its own first class programming / application language: The rise of Node.js: JavaScript graduates to the server. In the realm of Big Data,…

Rate this: