What is most valuable?
- Valuable to use smaller data sets
- Automatic Extract Creation
- Replace on publish data sources
- Online sync client
- Progressive-loading dashboards.
- Parameter to pass an initial SQL dynamically
- Combine multiple sets with union
- Subscribe and schedule the reports to receive email on data snapshot
- Ad-hoc reports and ease of use for the end user
- Reduces development effort
- Easy maintenance
- Security with role-based access and in line with Active Directory and SSO
- Alerts and scheduling
- Heat maps, geographical charts, 3D charts, drill down/drill up, drill through, cascading effects, and multi-dimensional and canned reports all in one tool
- Embedding into Microsoft SharePoint
How has it helped my organization?
- The end users need not depend on the regular BI developers for certain quick and ad-hoc reports.
- Generic avoidance of sharing the emails with an embedded Excel etc
- Can be accessed from multiple smart devices
- Snapshot facility to the end user for analysis
- Effective visuals
What needs improvement?
- Facility to add custom code to the dashboard will be helpful.
- Custom SQL feature is not working as expected from the performance perspective. Irrelevant of the SQL, the engine executes for everything available.
- Archive historical data using extracts
- MeasureName filter can’t be shared across multiple sheets in a dashboard.
- Cascading with relative has restrictions over the worksheets in a dashboard.
- Multiple selection in parameters
- Formatting option for individual filter is not available.
- Using HiveServer2 connector is a big challenge to pull, even with smaller data sets. Not sure if that has been improved with Spark Thrift server connector.
- Not much support for Hadoop / Hive as the backend in the market, connectivity issues not limited to the drivers.
- Few complex report requirements (for dashboards) could not be achieved with better performance (e.g. Dynamic Parameters).
- Reverse engineering from the front end report is not that impressive.
- For massive volumes of data, the performance acutely degrades.
- Permitting external users with no SSO is still a concern.
- Server support on Linux is lacking.
- Caps on report scheduling
For how long have I used the solution?
I have been using this solution for more than three years.
What was my experience with deployment of the solution?
TDS deployment will not encourage editing after the deployment.
With the TDS deployment, a few of the formats are lost. So far, this is not a serious issue.
How are customer service and technical support?
Approached from the client side, waiting time is reasonable high.
Which solution did I use previously and why did I switch?
I previously used MicroStrategy, QlikView, SQL Server Reporting Services, SQL Server Analysis Services, Panorama, SAP BusinessObjects, and in-house Java-based reports.
The reasons I chose this product were: ease of doing things, faster performance, and it is an all-in-one tool.
How was the initial setup?
Comparatively, basic setup is not a hard task.
What's my experience with pricing, setup cost, and licensing?
Our use case is met, but the pricing is still a matter of concern.
What other advice do I have?
It is a nice visual and high performance all-in-one BI tool which is becoming more popular with its ease of use and user-friendly features, effective visuals and apt major functionalities of BI.
However, it depends on one’s requirements and budget to balance the need.
We would recommend using it for mid-size datasets to visualize near real-time data, as there is no control over the execution model.
Which version of this solution are you currently using?