15 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100
8 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.5 out of 100

Likelihood to Recommend

Azure Synapse Analytics (Azure SQL Data Warehouse)

It is very well suited for big data analytics. Predictive modeling, optimization, and other large scale analysis benefit from using a properly defined SQL Data Warehouse. It is also suited for simple business intelligence such as building historical and active dashboards
Anonymous | TrustRadius Reviewer

ClicData

We used ClicData dashboards in a somewhat unorthodox way: we used "Indicators", or icons within tables to represent data, and the results looked great. The ability to integrate 3rd party HTML into dashboards was valuable (although Clic Data correctly warns that response time may suffer).The ability to start small and release dashboards incrementally suited our needs very well. We also valued the responsive account team getting us quickly pointed in the right direction.
Ben Warren | TrustRadius Reviewer

Feature Rating Comparison

BI Standard Reporting

Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
9.4
Pixel Perfect reports
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
10.0
Customizable dashboards
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
8.8

Ad-hoc Reporting

Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
7.5
Drill-down analysis
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
7.4
Formatting capabilities
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
7.8
Report sharing and collaboration
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
7.3

Report Output and Scheduling

Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
8.5
Publish to Web
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
10.0
Publish to PDF
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
9.0
Report Versioning
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
7.0
Report Delivery Scheduling
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
8.0

Data Discovery and Visualization

Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
7.6
Pre-built visualization formats (heatmaps, scatter plots etc.)
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
8.2
Location Analytics / Geographic Visualization
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
7.0

Access Control and Security

Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
9.4
Multi-User Support (named login)
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
9.1
Multiple Access Permission Levels (Create, Read, Delete)
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
9.7

Mobile Capabilities

Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
4.5
Responsive Design for Web Access
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
5.2
Dedicated iOS Application
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
1.0
Dashboard / Report / Visualization Interactivity on Mobile
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
7.3

Application Program Interfaces (APIs) / Embedding

Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
10.0
iFrames
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
10.0
Themeable User Interface (UI)
Azure Synapse Analytics (Azure SQL Data Warehouse)
ClicData
10.0

Pros

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • It is very cost-effective
  • Development time needed was much less in comparison to other systems
  • Played very nicely with our ETL and OLAP reporting tools
Samir Patel, PMP | TrustRadius Reviewer

ClicData

  • Ease of use, I can put together a dashboard in about an hour that is used by daily.
  • Support, their support team is super helpful and always has detailed insight.
  • Connectors, they have a huge number of connectors that allow easy integration of your data sources.
Anonymous | TrustRadius Reviewer

Cons

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • Limited T-SQL query library
  • It is not suitable for OLTP environment
  • Doesn't support cross-database queries
Prabhu Sundararaj | TrustRadius Reviewer

ClicData

  • More widgets.
  • Sometimes it takes a while to refresh.
Anonymous | TrustRadius Reviewer

Usability

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Synapse Analytics (Azure SQL Data Warehouse) 8.0
Based on 1 answer
It helps us to provide data just in time to our clients. With help of massively parallel processing, it consumes less time for both loading and querying the data and it also helps us to plan a more precise budget to our business and send just-in-time alerts in case of any outrage.
Prabhu Sundararaj | TrustRadius Reviewer

ClicData

ClicData 10.0
Based on 1 answer
Like I mentioned before, the ease of use means we not only get very quick results and beautiful dashboards in minutes, it means my team is actually using it because they aren't frustrated in the learning curve or wasting time trying to accomplish simple tasks.
Anonymous | TrustRadius Reviewer

Support Rating

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Synapse Analytics (Azure SQL Data Warehouse) 7.9
Based on 3 answers
I like their Support team
Anonymous | TrustRadius Reviewer

ClicData

ClicData 10.0
Based on 1 answer
We've only needed support a couple times in the beginning as we were learning the system and how to display our data in interesting ways. Every time we reached out we got very detailed responses and were connected to someone that you could tell was very interested in making sure we were happy with how things were going.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Azure Synapse Analytics (Azure SQL Data Warehouse)

SQL Data Warehousing is much easier to manage if you already have SQL Server experience and analysts who are familiar with its interface. We are currently piloting using NoSQL and Hadoop type databases but it is difficult to get set up properly. Additionally, we have to re-train our users to learn how to create python scripts and use spark to query the data
Anonymous | TrustRadius Reviewer

ClicData

ClicData was the most flexible. It is cloud-based and even has WebService access. You can publish your data for access from other applications. The sheer number of data connectors is amazing. The ability to not only create dashboards, but you can schedule them to be delivered to specific recipients on a scheduled basis via PDF or a static HTML page.
Ben Warren | TrustRadius Reviewer

Return on Investment

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • We have had an improvement in our overall processing time
  • Cost was much lower than most of its competitors
  • Our reporting needs have grown and housing the data here has been great
Samir Patel, PMP | TrustRadius Reviewer

ClicData

  • ClicData was by far the most reasonable cost-wise, and we were able to get ROI within just minutes of using it.
Anonymous | TrustRadius Reviewer

Screenshots

Azure Synapse Analytics (Azure SQL Data Warehouse)

Pricing Details

Azure Synapse Analytics (Azure SQL Data Warehouse)

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Azure Synapse Analytics (Azure SQL Data Warehouse) Editions & Modules

Additional Pricing Details

ClicData

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional
$71*

* data volume, type of data source and level of automation

ClicData Editions & Modules

Edition
Premium$791
Team$2591
Enterprise$4991
Dedicated$8901
  1. per month
Additional Pricing Details
All plans include multiple users licenses but dashboards can be shared with external users via live links, no license needed. Plans and pricing vary based on the data connectors, refreshes, and the level of automation needed. A few hours of Expert Service are including in all plans but more hours can be purchased. A white label option is also available for consultants and agencies.

Rating Summary

Likelihood to Recommend

Azure Synapse Analytics (Azure SQL Data Warehouse)
8.3
ClicData
9.1

Usability

Azure Synapse Analytics (Azure SQL Data Warehouse)
8.0
ClicData
10.0

Support Rating

Azure Synapse Analytics (Azure SQL Data Warehouse)
7.9
ClicData
10.0

Add comparison