Lots of options and very easy to connect data sourced

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.

Quick response time, great solutions, and awesome people to work with