This weekend I took a few minutes to test Zoomdata.
And when I say minutes, I literally mean minutes. These guys have done an amazing job to provide a quick mobile-ready demo that you can download as a VM, or as I did, install from an RPM package in a fresh Linux system.
After the install, I added a twitter data source and created the dashboard that you see above, linking it with the built-in demo sales data. With a little more work, you could build a sentiment analysis vs. sales dashboard in under an hour.
I know, I know. I used a pie chart.Â Don’t use pie charts!
The product uses mongoDB in the back-end and â€“if I understood correctlyâ€“ the Zoomdata server periodically stores snapshots of your data sources, painlessly building a sort-of-data-warehouse on the fly. This makes it ideal for building dashboards for trends and historical analyses. All the charts have Â sliders at the bottom which allow you to go back in time and in some cases aggregate monthly or yearly data. You can see a sample of this behaviorÂ at the demo site.
Zoomdata comes with connectors to Cloudera Impala, JSON, CSV, Google Docs, Twitter and good-ol’ SQL databases. All with the promise of “no ETL”, which I don’t actually believe it’s completely true â€“I can think about one or two cases at work in which I would really, really, need to merge two datasources with ETLâ€“ but given that I was able to create a dashboard from different data sources without any kind of pain, I bet that in many cases you could do the same without a single transformation.
If you work in BI, I encourage you to download one of their pre-packaged VMs and give it a whirl.