Instant Visibility. A Netezza 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 Netezza SQL reporting reporting, it's a live view of
exactly how your marketing campaign is performing.
"Five minutes into using InfoCaptor and you will know that you found a mission critical product. InfoCaptor helps you see your data from different angles like a CSI investigator on a crime scene. It helps visualize endless data, perform real time analysis and tell you where to focus your attention, what are the opportunities to invest your capital. The return on your InfoCaptor investment is guaranteed on your first project"
Steps to build Netezza database dashboard
How to create Netezza database connection
Netezza supports both ODBC and JDBC connections.
To work with Databases, you would need the following Connection details like
How to build Netezza pivot table for dashboard reporting
InfoCaptor provides powerful visual analytics for Netezza and you simply point to the table in your Netezza 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 Netezza 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 Netezza data
Create bar charts and line charts for Netezza SQL reporting tables and views
Once you have a visual clue about your Netezza data using pivot tables, it becomes very easy to convert into bar chart, line chart or any other chart.
Check this picture, how Netezza data is visually mapped between pivot table and bar chart
Create Advanced d3.js charts for Netezza 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 Netezza reports can easily
incorporate circle pack, sunburst, cluster and treemap diagrams. Sankey Flow diagram for your Netezza analytics data is also an excellent choice for
quick data analysis.
Add Netezza 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 Netezza SQL reporting dashboards
Add dashboard parameters to the Netezza reporting page
Finalize and Publish your Netezza 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
InfoCaptor is free for personal use, startups, students and non-profits
Within minutes of downloading you will be able to build Sankey Diagrams from all kinds of data. Mix data from Netezza and Excel or CSV files for building stunning dashboards, absolutely free!