Blockchains and Bitcoins – Realtime Analysis with SAP Lumira

[shankarsgs]

Bitcoins is gaining popularity among the masses, if you are a crypto fan or have not heard bitcoins before, then you should definitely check it out. Bitcoin is a form of Crypto Virtual currency that you can use pretty much like a real world currency, except its Virtual. I have been following bitcoins for long time and I am going to use SAP Lumira to build simple storyboard that help to analyse on latest bitcoin stats.

Since it’s going to be live data, I am going to use a NoSQL database designed to handle realtime web data, it’s called RethinkDB and you can refer my blog Rethink your Big Data with SAP Lumira and Rethi... | SCN on how to consume data from RethinkDB in SAP Lumira. Let’s proceed on creating our storyboard!!

Prepare the Data

Data on bitcoins are present pretty much everywhere on the internet. Realtime API’s and stats data can be collected using web service. I have sourced some data from https://data.bitcoinity.org/ and https://blockexplorer.com/q through real time application that writes the data onto RethinkDB. All the operations of merging and map reduce are done at RethinkDB so that only the necessary data is brought into Lumira.

I am using the lumira-rethinkdb Data Access extension to connect to my RethinkDB and bring the data into Lumira. I have a Database called bitcoin and inside that various tables holding various data like price, trade and the blockchain information.

All the tables are linked by foreign key Time using which different tables’ data are merged inside SAP Lumira.

I am merging data of all the tables present and finally I get the complete dataset in my Prepare tab in SAP Lumira

We have now obtained the data. Let’s visualize the data to understand it even better.

Visualize

We are using Time as our main Dimension since its real time data. We will be using different measures to analyze different data related to bitcoins and its block chains.

Bitcoin is slowly adapting into a form of regular currency. As the web gets Realtime, we would also need Realtime Visualization and use of NoSQL database to support the flow of data. SAP Lumira works very well with databases like RethinkDB and MongoDB which you can see here https://scn.sap.com/community/lumira/blog/2014/06/17/connecting-sap-lumira-with-mongodb--part-1 and https://scn.sap.com/community/lumira/blog/2014/06/17/connecting-sap-lumira-with-mongodb--part-2

Love this Blog! Tip this blog @ 1DtfHaPcUCaA95WY4eaM2se7kkvPQFELsz