{"id":2020,"date":"2013-10-29T10:23:20","date_gmt":"2013-10-29T14:53:20","guid":{"rendered":"http:\/\/www.danielpradilla.info\/blog\/?p=2020"},"modified":"2015-04-07T16:51:08","modified_gmt":"2015-04-07T21:21:08","slug":"zoomdata-bi-without-etl","status":"publish","type":"post","link":"https:\/\/www.danielpradilla.info\/blog\/zoomdata-bi-without-etl\/","title":{"rendered":"Zoomdata: BI without ETL"},"content":{"rendered":"

\"zoomdata\"<\/a><\/p>\n

This weekend I took a few minutes to test Zoomdata<\/a>.<\/p>\n

And when I say minutes, I literally mean minutes. These guys have done an amazing job to provide a quick mobile-ready<\/strong> demo that you can download as a VM<\/a>, or as I did, install from an RPM package in a fresh Linux system.<\/p>\n

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.<\/p>\n

I know, I know. I used a pie chart.\u00a0Don’t use pie charts<\/strong><\/a>!<\/p>\n

Besides the built-in chart types, Zoomdata includes a “visualization studio<\/a>“, in which you can import and use another JavaScript library \u00e2\u20ac\u201csay, D3js<\/a>\u00e2\u20ac\u201c to create sexier charts. After a few tweaks, I managed to feed my twitter datasource into this bubble chart:<\/p>\n

\"zoombubble\"<\/a><\/p>\n

The product uses mongoDB in the back-end and \u00e2\u20ac\u201cif I understood correctly\u00e2\u20ac\u201c 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 \u00a0sliders 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\u00a0at the demo site<\/a>.<\/p>\n

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 \u00e2\u20ac\u201cI can think about one or two cases at work in which I would really, really, need to merge two datasources with ETL\u00e2\u20ac\u201c 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.<\/p>\n

If you work in BI, I encourage you to download<\/a> one of their pre-packaged VMs and give it a whirl.<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

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… Continue reading Zoomdata: BI without ETL<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[172,331],"tags":[197],"class_list":["post-2020","post","type-post","status-publish","format-standard","hentry","category-projectmanagement-en","category-software-development-en-en","tag-visualization","entry"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1tlzy-wA","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1881,"url":"https:\/\/www.danielpradilla.info\/blog\/how-to-choose-the-right-chart\/","url_meta":{"origin":2020,"position":0},"title":"How to choose the right chart","author":"Daniel Pradilla","date":"06\/11\/2012","format":false,"excerpt":"There's a chart for every situation. Each type of information that you have and each analysis that you want to make can be benefited or harmed by the chart you choose. The idea of displaying data graphically is to help the other person understand what you mean to say. Do\u2026","rel":"","context":"In "Best of"","block_context":{"text":"Best of","link":"https:\/\/www.danielpradilla.info\/blog\/category\/bestof\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2012\/11\/d3charts.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2012\/11\/d3charts.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2012\/11\/d3charts.jpg?resize=525%2C300 1.5x"},"classes":[]},{"id":1884,"url":"https:\/\/www.danielpradilla.info\/blog\/how-to-create-better-charts\/","url_meta":{"origin":2020,"position":1},"title":"How to create better charts","author":"Daniel Pradilla","date":"10\/11\/2012","format":false,"excerpt":"We're often tempted to include some kind of accessorizing effect in our charts without knowing that deep down we're making them impossible to interpret and thus ruining their purpose. A typical case is the 3D pie chart. Many people, including executives, have a certain likeness for 3D charts. Somehow they\u2026","rel":"","context":"In "Best of"","block_context":{"text":"Best of","link":"https:\/\/www.danielpradilla.info\/blog\/category\/bestof\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2012\/11\/Tufte-Chartjunk.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2012\/11\/Tufte-Chartjunk.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2012\/11\/Tufte-Chartjunk.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2012\/11\/Tufte-Chartjunk.png?resize=700%2C400 2x"},"classes":[]},{"id":1973,"url":"https:\/\/www.danielpradilla.info\/blog\/improve-sap-business-objects\/","url_meta":{"origin":2020,"position":2},"title":"How to improve your Business Objects charts","author":"Daniel Pradilla","date":"13\/08\/2013","format":false,"excerpt":"Business Objects, SAP's BI platform, is notoriously bad for data visualization. Somehow, it empowers the developers to make all the wrong decisions at the same time and create really ugly and unusable \"dashboards\". Lately, I've seen my share of ugly bobip visualizations, like the one above. Which would seem ok\u2026","rel":"","context":"In "Project Mgmt."","block_context":{"text":"Project Mgmt.","link":"https:\/\/www.danielpradilla.info\/blog\/category\/projectmanagement-en\/"},"img":{"alt_text":"disaster, disguised as a \"dashboard\"","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/08\/Slide-5-SAP-BusinessObjects-4.0-Event-Insight2.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/08\/Slide-5-SAP-BusinessObjects-4.0-Event-Insight2.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/08\/Slide-5-SAP-BusinessObjects-4.0-Event-Insight2.jpg?resize=525%2C300 1.5x"},"classes":[]},{"id":2139,"url":"https:\/\/www.danielpradilla.info\/blog\/interactive-visualizations-javascript\/","url_meta":{"origin":2020,"position":3},"title":"Creating interactive visualizations of large datasets using JavaScript","author":"Daniel Pradilla","date":"09\/04\/2015","format":false,"excerpt":"Crossfilter is a JavaScript library initially designed by Square to explore large multivariate datasets in a web browser. It basically allows you to create sorted indexes and feed them to a charting library like D3, and enable the user to filter by clicking and dragging, even when sifting through 200.000\u2026","rel":"","context":"In "Project Mgmt."","block_context":{"text":"Project Mgmt.","link":"https:\/\/www.danielpradilla.info\/blog\/category\/projectmanagement-en\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1886,"url":"https:\/\/www.danielpradilla.info\/blog\/how-to-create-a-dashboard\/","url_meta":{"origin":2020,"position":4},"title":"How to create a dashboard","author":"Daniel Pradilla","date":"12\/02\/2013","format":false,"excerpt":"Consider the dashboard of a car: in it, the driver can see the most important data: speed, RPM, mileage, etc. The dashboard displays decision-making information, in a graphical manner, in a single place. The information dashboards should comply with the same requirements: Although not necessarily copying the model of a\u2026","rel":"","context":"In "Best of"","block_context":{"text":"Best of","link":"https:\/\/www.danielpradilla.info\/blog\/category\/bestof\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2012\/11\/car-dashboard-2.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2082,"url":"https:\/\/www.danielpradilla.info\/blog\/amcharts-a-charting-library-for-creating-interactive-web-charts\/","url_meta":{"origin":2020,"position":5},"title":"amCharts, a charting library for creating interactive web charts","author":"Daniel Pradilla","date":"19\/05\/2014","format":false,"excerpt":"amCharts is a new JavaScript library for creating charts on the web. It handles many types of charts and it's somewhat reminiscent of D3.js. Its most exciting feature is a live editor, which removes the grunt work related to your typical JavaScript charting library and enables you to design, change\u2026","rel":"","context":"In "Project Mgmt."","block_context":{"text":"Project Mgmt.","link":"https:\/\/www.danielpradilla.info\/blog\/category\/projectmanagement-en\/"},"img":{"alt_text":"amcharts","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2014\/05\/amcharts.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2014\/05\/amcharts.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2014\/05\/amcharts.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2014\/05\/amcharts.jpg?resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts\/2020","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/comments?post=2020"}],"version-history":[{"count":0,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts\/2020\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/media?parent=2020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/categories?post=2020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/tags?post=2020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}