ClicData Pros and Cons

I am coming off of using a competitive service (idashboards) for the past 5-8 years) and I only wish I had found clicdata sooner. idashboards wanted us to sign a 2 year contract for more than 7x the price of clicdata which jumped to 14x the price the 2nd year. Even putting price aside, ClicData is SO MUCH BETTER in every way! The mid tier membership with ClicData is serving our needs perfectly with a database connection, 10 users and live link capabilities. We haven't embedded any dasboards yet, but nice to know the capability exists. The support is phenomenal and I got a free hour of training with a very knowledgeable support representative. I did that about a month into using the service so I had a bunch of questions gathered up and he answered them ALL. You can always contact support with minor issues too and they are super helpful. Review collected by and hosted on G2.com.

Occasionally there are little bugs, but those seem to get fixed quickly. For the price, there is nothing I would complain about! Review collected by and hosted on G2.com.

The system is super user friendly and the customer support is Oh My God. They solve your doubts/issues so fast that it makes it easy for you to continue working on your project. Review collected by and hosted on G2.com.

A couple of things actually-

1. It does not let you have multiple windows side by side. Like if you open dashboard in window 1 and data in window 2, it logs out of window 1.

2. It hangs at times but thats ok. Review collected by and hosted on G2.com.

I run a small business marketing automation agency and was looking for a solution that would allow me to show real-time reports to customers about their CRM (Infusionsoft in my case), marketing and sales data. ClicData let me do all of that since it pulled real-time report from the api tables for the tools I was using.

Other tools out there forced me to know how to do actual programming to get any useful data, but Clicdata makes it fairly easy as long as you know some basics around data and formatting. Review collected by and hosted on G2.com.

Like any other software out there, this one is not perfect. Here are a few things I wished it would have had:

- More pre-built report templates (I mostly had to create mine from scratch).

- I'd like to see more connectors for small, online businesses. I didn't see any native connectors for apps like Stripe or Zapier, which are very common in the work I do. Review collected by and hosted on G2.com.

Our dashboard design is clean and easy to use. Having the majority of KPI's in once place is most helpful. Review collected by and hosted on G2.com.

I need to refresh the pages frequently in order for it to load correctly. Many times I have to reload the data a couple of times. I'm never fully confident that the first time I open one of the pages, that it will not have an error on it.

It would be nice if the data could link directly from some of our systems so we could have real-time information. Review collected by and hosted on G2.com.

It's built on a solid cloud-based foundation (MS Azure), and employs T-SQL syntax for the more serious programming. Changes are made immediately, so testing can be very interactive. Performance is generally good, and predictable.

For mediocre SQL programmers (like me), it's like writing SELECT statements graphically. The transform operations are mostly intuitive, and sequenced to make it easy to maintain. I was especially impressed with the Pivot transform, which replicated a complicated Excel pivot table I had built as a prototype.

The widgets cover most of the functions you might need to construct a dashboard.

ClicData support is excellent and responsive. I always got a response within a day for any critical issues or questions. They encourage you to use their support channel, in part, I suspect to get some of the less intuitive functions working properly.

Administrative functions are straightforward and flexible. Licenses can be upgraded incrementally, so the application grows with usage. Review collected by and hosted on G2.com.

I found the online documentation weak and sometimes even incorrect. It often reads like "English as a 2nd language". I think they steer you to their consultants to make up for the limited documentation.

While the simple table widget is rich in options, the drilldown and pivot tables are rather limited in formatting choices. For example, if you need to word-wrap within a table cell, the simple table is often your only choice.

Selecting the correct widget or function to store variables is tricky. Numeric values are limited to only a few widgets, so performing mathematical functions can be hazardous. Review collected by and hosted on G2.com.

The flexibility of the product is key. Use of Azure for data storage and data connectivity to just about any type of data source is a big benefit.

There are many widgets (charts and tables to use for dashboards). There is no limit to the number of dashboards.

The solution gives flexibility for other users and secured login also.

Each dashboard has its own live link that you can set to use forever or have it expire after a given set of time.

Data synchronization is simple with their data connectors. Connect to dropbox, SQL, Google Drive and more... Review collected by and hosted on G2.com.

I wish there was even more widgets for the dashboards.

It would also be nice to be able to query the back-end data using SQL Studio.

The other missing feature is the ability to copy pre-configured widgets and use them from dashboard to dashboard. Review collected by and hosted on G2.com.

ease of use

sensational support

fair price

fast

very beautiful Review collected by and hosted on G2.com.

Nothing displeases me until now......... Review collected by and hosted on G2.com.

Data: I primarily work with training and revenue data. The tables I have worked with have not exceeded 150,000 rows.

ETL & visualization Tools: I've dabbled in Qlik Sense, PowerBI, Domo and SAP Lumera. Most of my experience is with ClicData and Tableau.

- I like the fact that it is 100% Cloud/Browser based, so I can work on it from anywhere.

- Data refreshes are SUPER easy.

- Data visualization is easy to learn.

- There are a lot of data transformation options and they are easy to learn. You can start off with the GUI options and ease your way into SQL queries.

- The data merge and fusion capabilities are powerful and easy.

For low to upper medium grade ETL and visualization I strongly suggest you take a look at ClicData. And if you don't have huge security concerns, i.e. no passwords or simple password protection. Review collected by and hosted on G2.com.

August 2017 - I wish their documentation was better. I wish they had better formula examples. The lack of a user community makes for a lot more trial & error. I wish the API's were easier to work with. This would make it easier to integrate with our other applications. Review collected by and hosted on G2.com.

ClicData allows for easy ingestion and merging of data sources, as well as transforming the data and refreshing on regular schedules from connected sources such as Dropbox. Review collected by and hosted on G2.com.

The formulas use different syntax depending on whether you're making calculations within the dashboard widgets or within the data source transformations, which makes it confusing at times to remember how to write them Review collected by and hosted on G2.com.

The Dashboard User Interface on the website is easy to navigate & not super complex. Which makes it easy to use from all skill levels. The Dashboards have easy plug in's and interfaces that make it simple to navigate and use. Review collected by and hosted on G2.com.

The stability and reliability of the entire dashboard system is not enterprise level. This makes it hard to rely on from a business perspective. The pricing structure for "refreshes per month" makes it challenging to utilize the product as a "real -time". I believe the refreshes per month should be one of 2 packages sold by the company. Providing multi-tier packages for customers looking for real-time dashboard data, without worrying about refreshes at a reasonable cost.

ClicData servers do not seem to be reliable or beefy enough to support customer demand. Review collected by and hosted on G2.com.