Posts Tagged Dashboard

Will QuickSight Kill Tableau ?

QuicksightOver the past years we have seen an exponential increase in the amount of data being generated. On an average, nearly 2.5 quintillion bytes of data was being generated every day in 2012. Extracting actionable insights from such prodigious amount of data can be a nearly impossible task at times.

Gartner 2015 MQ

Fig 1: Gartner: Magic Quadrant for Cloud Infrastructure as a Service, Worldwide report, Lydia Leong et al, published 18 May, 2015

Amazon Web Services has been one of the pioneers in catering to the ever-changing data needs of enterprises with its highly scalable and pay-as-you-use services.

AWS senior vice-president, Andy Jassy recently unveiled QuickSight, a brand new service from AWS in Business Intelligence domain, during an annual re-invent conference held for developers. Some of its salient features are

  • Extremely fast, cloud-powered, BI service for 1/10th the cost of traditional BI software.
  • Fast Calculation with in-built SPICE (Super-fast, Parallel, In-memory Calculation Engine)
  • Easily scalable with thousands of customers and terabytes of data.
  • Provides SQL-like interface for other BI Tools to access data stored in SPICE.
bdt319-new-amazon-quicksight-cloudnative-business-intelligence-17-638

Fig 2: Working module of Amazon QuickSight (aws.amazon.com/quicksight/)

Most of the organizations using traditional BI solutions (SAP Business Objects/Crystal Reports, IBM Cognos, Oracle BI etc.) invest in substantial resources to get their first visualization. Agile BI solutions (Tableau, Qliksense, Sisense, Domo etc.) have their own constraints in terms of processing and customization capability, which limit their potential use.

Bearing in mind all these aspects, we need to ask, “Can Amazon QuickSight really kill the old guard BI services?” Let us take a look at some of the many crucial characteristics that we can consider to compare Amazon QuickSight with the market leader in BI services i.e., Tableau.

QUICKSIGHT v/s TABLEAU

Price: 

Amazon QuickSight has come up with an extremely competitive pricing structure (90% less as compared to other BI products). Its standard edition is priced at $9 per month per user and the enterprise edition is priced at as low as $18 per month per user (one year contractual basis).

Pricing

Fig 3: Pricing Structure for Amazon QuickSight (aws.amazon.com/quicksight/)

Tableau on the other hand has its cloud-based service (Tableau Online) starting at $500 per user per year. This gives QuickSight a huge edge over other competitors, especially while catering to small to medium enterprises, which are sensitive on budget.

Data Processing:

One of the major features of Amazon QuickSight is SPICE- a Super-fast, Parallel, In-memory Calculation Engine. Based on the technique of columnar storage coupled with in-memory technologies, SPICE helps in running queries at a lightning rate producing results in a few milliseconds with following salient features:

  • 2 to 4x compression columnar data
  • Compiled queries with machine code generation
  • Rich calculations and SQL-like syntax

For the data to be analyzed using QuickSight it is mandatory for the data to be in SPICE. This enables organizations to scale their data to large volume without any additional overhead.

Tableau’s Data Engine is an in memory analytics, high-performing database on one’s PC. It uses memory mapped I/O, i.e. the data is loaded in disks after it is imported. This results in low usage of RAM which eventually provides the desired performance.

Target Group:

Both Amazon and Tableau, have a significant customer base ranging from small scale organizations to some of the top firms in the world. Nevertheless, AWS has been a promising player in providing customer satisfaction, as a result of which most of the organizations tend to use AWS for storing massive data. It makes sense here to say that Amazon will target its AWS users as potential customers for QuickSight. Many organizations are shifting their base from on-premise to AWS Cloud for several reasons. On the contrary, some enterprises still prefer to store their critical datasets on their local premise for legal and security reasons.

Ease of Use:

Amazon posits QuickSight as a self-discovery tool which does not require people to have in-depth knowledge about data visualization. Tableau on the other hand requires certain level of expertise.

Features:

Finding the right visualization for data is extremely important. QuickSight’s Autograph feature automatically predicts the best visual for your data to be displayed. Likewise, Tableau provides us with a “Show Me” which detects data based on data types, cardinality etc.

Limitations:

QuickSight is most appropriate for data that is stored in AWS’s cloud and also more importantly the data that can be put onboard SPICE. As quoted by Ashley Jaschke (Director, Product Management, Tableau) QuickSight will be suitable for lightweight visualizations. Many companies still keep their data outside of AWS’s cloud. Since, Tableau has a provision for ingesting data from multiple sources it has the ability to provide much deeper and significant insights.

QuickSight is currently available only as a preview version and it would be too early to decide as to whether QuickSight will dominate the BI services market, but it is surely poised to make a heavy impact.

Tableau for iPad: Project Elastic, Vizable and the unmet need for an equivalent of Tableau Reader app for iPad

^94CC986F1AB58484387E60ECE71B490D88170B70C1E1680390^pimgpsh_fullsize_distrTableau Software (NYSE: DATA) helps anyone quickly analyze, visualize and share information and boasts of helping more than 35,000 customers obtain visual intelligence in the office and on-the-go.

Portability, scalability, ease of development and cloud based hosting are a few of the major concerns that fast paced organizations have to deal with while buying BI tools. Although iPad is the most popular portable device in the business industry, not much has been offered in this segment by major BI platforms.

In October 2015, Tableau released the app ‘Vizable‘ for iPad (earlier codenamed ‘Project Elastic’ during R&D phase). Vizable aids in understanding data patterns and their relationships. It is a fast paced powerful tool which shows trends and graphs, converting data into information.

Having said that, there are many basic features yet to be added to Vizable.

  • At present, Vizable has no option available for developing any module, restraining itself to only playing around with filters, adding columns, sorting, etc.
  • Considering the visual components available, bar chart for data in categories and a line chart for data by time are the only options Vizable currently provides.
  • Data files can only be opened if they are stored on the iCloud.In the same segment, Tableau has also introduced a new app named Tableau Mobile to stay in touch with data whether you are offline or online using the live Tableau Server or Tableau Online connections. This app too, has its drawbacks at a certain level. The best use of Tableau Mobile can be seen only if we are connected to the server. However, when offline, Tableau Mobile provides only snapshots view of the dashboards.

QlikView and Spotfire are the two other bigwigs in the visual analytics industry which have their own apps competing with Tableau Mobile and Tableau Vizable. The following chart provides a brief comparison amongst the three.

CRITERIA QLIKVIEW MOBILE SPOTFIRE ANALYTICS TABLEAU VIZABLE
Cost Free Free Free
Rating Low Low High
App Size Light (7.5 MB) Light (5.3 MB) Heavy (70.9 MB)
UI Complex Simple Very Simple
Offline Usability Yes No Yes

In this segment, there is no sole winner yet as each of the above has their pros and cons. However, as far as the statistics are concerned, Tableau is leading the industry with an annual growth rate of 114% and operating in more than 150 countries. In spite of this, it leaves a lot to be desired when it comes to the need of a portable solution.

5 Features Klipfolio Must Have

5 Features Klipfolio Must Have

5 Features Klipfolio Must Have

Klipfolio is an online dashboard platform and is widely used for building real-time business dashboards. The company was founded by Peter Matthews (present CXO) and Allan Wille (present CEO) in 2001 and is headquartered in Ottawa, Canada. The company has focused on creating an operational browser based dashboarding product with ease in usability for non-technical users.

With its rich dashboard features and data integration capability with various data services, it is arguably one of the best cloud based platform in its price range. Some of the key dashboard development features are user role management, custom CSS, data refresh scheduling, user annotations and powerful data manipulation capability. The other competitors are Cyfe, Geckoboard, Ducksboard etc but Klipfolio is still winning over them in most of the product features.

Despite of being a fan of this platform, today I am going to succinctly pin-point 5 features Klipfolio must include in near future.

  • Multiple Select Input Control

The input control component klip (term given by Klipfolio to its widgets) currently allows users to select from 3 input options – Dropdown Selection, Text Input and Date Picker. All these controls are typically used for filtering the data in klips. The dropdown selector let you select only single item to filter the data which sometimes limit user’s view.

  • Scaling Map Visualization

Map visualization is an interesting feature of Klipfolio. However, this feature is limited for selected geographies in world like USA, Europe, Germany etc. Adding more geography would certainly make this feature more useful.

  • Better Data Handling

Klipfolio can only handle data up to 10MB size. Once the data source size increases, the dashboard load times starts getting affected.

  • Drill Down Capability

Klipfolio has minimalistic drill down capability. With the current architecture, it is unlikely to see major improvements in near future.

  • Calculated Data Fields

Data manipulation can currently be done only by using functions inside a klip. These functions are great and can take care of almost all the data manipulation requirements but at the same time affects the performance. Having an option to add calculated fields would not only help in easing the calculations but will also improve the dashboard load time.

 

With all said, Klipfolio is still a great platform for SMEs and the product development team is well aware of all its shortcomings!

Follow Us

Address

Wakad, Pune, India
Phone: +91 7720876464
Email: info@rudderanalytics.com

Disclaimer

Important: This site and all textual and non-textual contents on it are under copyrights of Rudder Analytics.