Dashboard

End-to-end solution for creating, managing, and sharing interactive dashboards.

Drag and drop your data with complete control through TrustCore’s dashboard designer application.

Wide variety of data sources


All the commonly used data sources, including Microsoft Excel, CSV, SQL Server, SQL Server Analysis Services, Spark SQL, Hive, Oracle, MySQL, PostgreSQL, SQLite, Access, Salesforce, JSON, Microsoft Azure Table storage and RESTful web services are supported.

Analyze big data


Connect to all your data with live querying of Hadoop. Integrate with SQL query engines like Spark and Hive in combination with the TrustCore Big Data Platform.

Business user friendly


The drag-and-drop friendly dashboard designer application makes it possible for business users to compose and publish dashboards without any help from IT.

Rich selection of widgets


All the widgets commonly used in business dashboards, including a variety of charts, gauges, maps, treemaps, and grids have been included. You may also include your own HTML5 and JavaScript based custom widgets to dashboard using a few steps.

Dedicated filter panel


The dedicated panel for filter widgets allows accommodation of more visualization widgets in the viewer surface.

HTML5 powered


Dashboards are rendered using HTML5 so the only requirement for end users to view dashboards is to have a modern browser installed.

Tabbed view of dashboards


Multiple dashboards can be showcased in one page through tabbed view.

Data stays in your servers


You can host the dashboard server within your local network or on your secure cloud servers so all data remains secure within your servers.

Embed dashboards within your applications


TrustCore Dashboard Platform ships with a powerful server application for managing and sharing dashboards, but if you prefer to host the dashboards within your applications then we also provide a viewer control

Deploy the Dashboard Server on Microsoft Azure


Easily scale your dashboard server application on demand by deploying as an Azure App Service or Azure Virtual Machine.

Data notifications


Receive email notifications when specific values reach a threshold. For example, when the total sales is greater than $10,000.

View dashboards on mobile devices


View and interact with dashboards hosted on the dashboard server from mobile devices using the available Android and iOS mobile applications.

Cost effective licensing


Our licensing is cost effective for both small and large teams. Please contact us for more details.

CONCEPTUAL OVERVIEW DIAGRAM

Preparing data


Existing data that is stored in a wide variety of data sources like Microsoft Excel files, relational databases, and HDFS are first transformed into a format that is ready for visualization using dashboards. The TrustCore Big Data Platform also greatly compliments the dashboard since it offers one of the most versatile ETL tools available. Data from virtually any format, including a mix of structured and unstructured data sources, can be imported into HDFS and be easily transformed into the desired format before visualizing as dashboards.

Simple data preparation


The dashboard designer application has the capability to do simple transformations on data like joining multiple tables, adding expression columns, hiding specific columns, and more. If the data is almost in the format that you need for visualizing as dashboards and only requires a few simple tweaks, then it is possible to do that within the dashboard application itself.


Complex data preparation


If the data transformation requirements are more complex and require operations like merging data from several sources, including a mix of structured and unstructured data, then we recommend using the TrustCore Data Integration Platform. Data from various sources can be imported and transformed into the desired format.

Composing dashboards


The intuitive dashboard designer application makes it easy for everyone to create powerful dashboards. The rich selection of data visualization widgets available makes it possible to visualize your data as desired. It is also possible to make the dashboards interactive by letting end users drill down and filter data.


Connect to data


There is built-in support to connect to most common data sources including Excel, CSV, Text Document, JSON, SQLite, SQL Server, SQL Server Analysis Services, PostgreSQL, Spark, Hive, ODBC enabled databases like SQL, MySQL, Oracle, and Access, Microsoft Azure Table Storage, Salesforce and RESTful Web Services.


Common ODBC (ANSI SQL)


Connect to a wide range of databases that inherit the ANSI SQL 92 standard through their ODBC drivers..


Integration with TrustCore Data Integration Platform


Create a dashboard data source from Data Integration Platform dataflows using the server explorer in Dashboard Designer.


Connect using OAuth


Using OAuth connect to popular web services of Twitter, Facebook, LinkedIn, Google, Yahoo, Instagram, Dropbox, and GitHub.


Data transformation


Data transformation operations like joining tables, filtering, hiding columns, and adding expression columns can be performed. There is built in support for over 40 expressions.


Multi-tabbed dashboards


Multi-tabbed dashboard allows you to showcase related information through a sequence of visualizations. TrustCore on Dashboard Designer makes it easy to configure multiple dashboards through interactive options.