Easy Dashboard Reporting with IDS Server

InfoCaptor

IDS Server

Excel/CSV Data

Benefits of IDS Server database dashboard

Instant Visibility. A IDS Server dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time IDS SQL reporting reporting, it's a live view of exactly how your marketing campaign is performing.

• Better Decision Making
• Gain Competitive Advantage
• Enhance Collaboration
• Spotting potential problems
• Merge with data from Excel Dashboards
• Live SQL against database
• No need for Data-warehouse or ETL
• Leverage the speed and stability of your powerful database.

Check out the Top 10 Tangible benefits of Excel dashboards

How to create IDS Server database connection

IDS Server supports both ODBC and JDBC connections. To work with Databases, you would need the following Connection details like

• IDS Server server IP or name
• IDS Server database name
• IDS Server port number
• IDS Server user and password

Check out the InfoCaptor IDS Server connection details

How to build IDS Server pivot table for dashboard reporting

InfoCaptor provides powerful visual analytics for IDS Server and you simply point to the table in your IDS Server schema or database. Pick your columns and put them in rows or columns.

One of the first things to do for data analysis is to browse your IDS SQL reporting data and chart different varieties of Pivot Tables. Pivot tables is one of the simple and yet powerful visualizations. InfoCaptor's entire visualization engine is based on pivot tables. Check the detail steps on how to build Pivot Tables views for IDS Server data

Create Advanced d3.js charts for IDS Server tables and views

While you can create pivot tables and bar charts that are very common display types for majority of dashboard reporting, InfoCaptor liberates you from the basic chart types by providing advanced d3js based hierarchical visualizations. Your IDS Server reports can easily incorporate circle pack, sunburst, cluster and treemap diagrams. Sankey Flow diagram for your IDS analytics data is also an excellent choice for quick data analysis.

Add IDS Server based analysis/report to dashboard view

• Once you are happy with your analysis in the visualizer you can add it to the dashboard
• Keep adding as many analysis you need to the IDS SQL reporting dashboards
• Add dashboard parameters to the IDS Server reporting page

Finalize and Publish your IDS SQL reporting dashboard

Once you are done with the dashboard, you can share the dashboard with ohter users.

• Public sharing: Share dashboard as public URL
• Inivite users to your group and share it via group

List of sample and possible IDS analytics dashboards