A Business Intelligence tool for schema-less JSON data from API endpoints
February 11, 2016
A Business Intelligence tool for schema-less JSON data from API endpoints
Score 10 out of 10
Vetted Review
Verified User
Software Version
Professional
Overall Satisfaction with Zoho Reports
Our customers include large retail chain stores. In our product, we provide some big-data insights to our customers. We use Zoho Reports to come up with customised reports for our customers, tailor-made to fit their needs. With Zoho Reports, we are able to offer a consultancy service to our customers who want more than what our standard reports can provide.
- Zoho Reports connects with our API endpoint to import data into Zoho Reports. It does this quite well, without enforcing specific schema restrictions on our data. Our data is stored in NoSQL database, and our API endpoint produces JSON data documents, each with different structure depending on the dataset being requested. Zoho Reports automatically interprets our data, and converts into a set of rows and columns.
- Once our data is imported into Zoho Reports, creating different type of visualizations is a breeze. Zoho Reports enables us to create many types of charts, dashboards, pivot tables and more.
- Zoho Reports has this feature called "Custom Formula", that allows us to create new columns in the data that are computed by applying various transformations to existing columns. For example, we are able to create a "Is Weekday" column by applying custom formula on our "Date" column. This "Is Weekday" column enables us to create visualizations that compare weekday vs. weekend performance numbers of our customers' shops.
- The visualizations are "live". Zoho Reports can be set up to pull data from our API endpoint periodically (e.g. once every day). As the data gets updated, so do all the visualizations. We are able to publish these "live" visualizations via permalinks or embed them within another web page, so that our customers always see the most up-to-date visualizations.
- Scheduled emails is another great feature. Once we set up a tailor-made report/dashboard for our customer, we are able to set up scheduled emails. Once set up, Zoho Reports automatically sends emails to our customers with the up-to-date copy of visualizations as attachments.
- There is a fair bit of learning curve before you can get productive with Zoho Reports. It is not so steep that it'd scare off users, but it does take some effort to get used to the various features and options in Zoho Reports.
- A private hosting option would be really good to have, as some of our customers might have data security concerns. Although Zoho Reports takes good measures to keep the data safe and secure, the data still gets imported from our cloud servers to Zoho Reports servers. This can be a concern for some users, for example large corporations or government entities who have their own private cloud infrastructure.
- Editing of column names could have been easier. At the moment you have to right click on each column > click rename > type new name > Save. On save, the entire table is reloaded and the view focuses on the left-most column, instead of the column just renamed. If there are more than 5 or 6 columns, this quickly becomes irritating because you end up having to scroll to the right to get to the next column you want to rename.
Zoho Reports has the features that we were looking for -
The best part is that these features don't cost us zillions of dollars. The pricing tiers are reasonable, and they provide a sufficient trial period.
To top it all, Zoho Reports is not your entry-level BI tool. It has a comprehensive set of features that make it well worth the money, and more.
We evaluated many other tools. In terms of features and ease of use, Tableau was the best. Zoho Reports came in a close second. Most others did not qualify our criteria - either because they did not work well with schema-less NoSQL JSON data, or they did not provide the kind of features we were looking for (e.g. embeddable visualizations, scheduled emails, rebranding).
We chose Zoho Reports over Tableau because Zoho Reports comes with a better tiered pricing model.
Not to mention, the Zoho Reports support team has been excellent!
- Import of data from an API endpoint in JSON format (no specific schema)
- Scheduled imports
- Drag-and-drop creation of visualisations
- Export of visualisations in PDF, CSV & Image formats
- Fairly easy to use
- Scheduled emails
- Privacy settings per visualisation
- Cloud hosted
- Embeddable visualisations
- Rebranding option
The best part is that these features don't cost us zillions of dollars. The pricing tiers are reasonable, and they provide a sufficient trial period.
To top it all, Zoho Reports is not your entry-level BI tool. It has a comprehensive set of features that make it well worth the money, and more.
We evaluated many other tools. In terms of features and ease of use, Tableau was the best. Zoho Reports came in a close second. Most others did not qualify our criteria - either because they did not work well with schema-less NoSQL JSON data, or they did not provide the kind of features we were looking for (e.g. embeddable visualizations, scheduled emails, rebranding).
We chose Zoho Reports over Tableau because Zoho Reports comes with a better tiered pricing model.
Not to mention, the Zoho Reports support team has been excellent!