Key Features

• Open Architecture: Work with any browser by leveraging JavaScript, HTML5 components, CSS3 and animated interactive visualizations in the embedded BI framework. View the platform on any device without any apps or downloads. 
• Add functions, transforms, controls, visualizations, data providers and export, and delivery providers. 
• Automate workflows to trigger when metrics exceed pre-defined values.  
• Customize the platform with vendor-provided SDKs with Eclipse and Microsoft Visual Studio support. Build calculated element transforms, bridge parameters and formula scripts with DundasScript. 
• Embedding: Perform analysis, reporting, data transformation, dashboard and mashup designing within business systems. Embed a screen or the entire application via iFrames or its Embed library. The software fully supports custom integration into other applications with server and client APIs, SSO and authentication support. 
• Dashboards: Create pixel-perfect dashboards with various visualization types that include bar graphs, scattergrams, pie charts, line graphs, radar charts, scorecards, trellis charts and maps. 
• Pre-built Templates: The vendor offers the option to pre-build dashboard templates and customize them as needed. Changing any template element applies the modifications in all linked dashboards. 
• Pre-designed Widgets: The tool offers pre-defined widgets as dashboard building blocks. Modify, duplicate and delete them as necessary. 
• Animations: Show changing levels and scales by adding animations to visualizations. Animate more than just the data – the software's web design allows animating diverse dashboard components like images and visuals. Developers can animate any dashboard element using built-in scripting. 
• Segment Analysis: Perform segmentation through its built-in period-over-period analytics functionality. Other techniques include slicer comparisons, the Group Members option, formulas and calculated elements. 
• What-if Analysis: Perform scenario analysis by inputting desired values into ready-to-use formulas. Pre-prepare them by substituting placeholder parameters for variables and connecting them to numeric inputs or sliders. 
• Regression Analysis: Predict future values by applying its trend and forecasting function to time series. The software provides four regression functions: linear, exponential, logarithmic and power. Additionally, exponential smoothing assists in time-series analysis and forecasting. 
• Statistical Functions: Calculate correlation, percentile, normal distribution, simple standard deviation and variance. The software provides Bollinger bands, moving averages, median, mode, k-means clustering and distance functions.
• Data Modeling: Explore data with intuitive user actions – drag and drop columns to create multi-level hierarchies or time dimensions. Or build data models from pre-prepared data cubes for additional transformations. The platform integrates with Microsoft SSAS, SAP NetWeaver BW 7.0+, Microsoft PowerPivot and Oracle Hyperion Essbase 11.
• Data Cubes: Analyze any data type with Dundas' data cubes — turn regular columns into dimensions, hierarchies and measures. Dragging metrics directly from a source automatically generates a data cube for instant analysis. 
• Decentralized Analytics: Offers decentralization at the organizational, multi-tenant and warehouse levels. 
• Choose to keep the data objects, connectors, dashboards and reports isolated from other business processes with organizational decentralization. 
• It’s built to fit into a multi-tenant environment — tenant content is exclusive, while global content sharing is optional. 
• At the warehouse level, tenants can opt to store their data separately. 
• Globalization: The platform features settings to define the user's language, country and data viewing preferences. It includes culture-sensitive formatting of numbers, dates, times and currency. The system identifies the user's location and displays numbers and dates accordingly. 
• Intuitive Visualizations: The platform offers tooltips to display measures and labels when users click on them or hover over a visualization. 
• Interactivity: Derive actionable insight with easy user actions like navigating, filtering, toggling template cells, scripting, and inputting and correcting data. 
• Visualization Types: Display dataset associations with Sankey, tree, chord and relationship diagrams. Advanced formula-based visualizations include Pareto charts, histograms, correlation matrices, parallel coordinates charts and forecasts. 
• Activity Tracking: Monitor user activity across projects and dashboards. Every BI instance can locally record usage data, such as which metrics users viewed and for how long. 
• Built-in Alerts: Get alerts when users add notes to metrics sets or data changes. Additionally, the system issues notifications when a user adds a measure correction to a metric set. 
• Maps and Geospatial Visualizations: The platform supports visualizing location data with choropleth maps, dot distribution maps, heatmaps and more. 
• Add map elements with built-in shapes, paths and symbols, or import ESRI shapefiles from the web. 
• Add location details to the zip code or street address by leveraging its integration with Bing Maps, ArcGIS, Carto, OpenStreetMap and Mapbox, among others. 
• Workspaces: Manage dashboards, visualizations and reports in one place with exclusive workspaces. The vendor provides a built-in project <GLOBAL> to store images, maps, diagrams, styles and themes in a centralized repository. 
• Pinboards: Display data from separate dashboards by collecting individual widgets into a pinboard. Duplicate, modify and delete them as necessary. 
• Integrations: The platform supports standard file formats, including CSV, PDF, Excel, text and HTML. 
• Fully supports Apache Hive, Spark SQL, Google BigQuery, Salesforce, Microsoft Dynamics, HubSpot, SQL Server, MySQL, PostgreSQL and IBM DB2. Integrates seamlessly with Marketo, Pardot, Google AdWords, MongoDB, Cassandra, Apache, HBase, Twitter and Facebook. 
• Relies on partner integrations to connect to QuickBooks, FreshBooks, Freshdesk, Zendesk, Slack, Shopify, Magento and BigCommerce. Other partner integrations include PayPal, Square, Stripe, Jira, Asana and Trello. 

Limitations

•  Offline mode isn’t available. 
•  Doesn’t support 3D charts out-of-the-box. 
•  Doesn’t give optimum performance with Internet Explorer 

Suite Support

Top Competitors

• Sisense
• QlikView
• Infor Birst

Cost of Ownership

Pricing Details