How to create dashboard using Hortonworks Hive DB database
Build beautiful Hortonworks Hive SQL reporting dashboards
This article will address the following topics as well
- How to create Hortonworks Hive DB dashboards ?
- How to build online reporting dashboards for your business?
Easy Dashboard Reporting with Hortonworks Hive DB
Apache Hive is a component of Hortonworks Data Platform(HDP). Hive provides a SQL-like interface to data stored in HDP. Hive provides a database query interface to Apache Hadoop. Hortonworks is a leading innovator in the industry, creating, distributing and supporting enterprise-ready open data platforms and modern data applications.
Hortonworks provides Hive JDBC and ODBC drivers that let you connect to popular Business Intelligence (BI) tools to query, analyze and visualize data stored within the Hortonworks Data Platform.Drivers that work with InfoCaptor and Hive DB InfoCaptor Hortonworks Hive JDBC drivers
Here is an example of how InfoCaptor connects with Clouder Impala
Are you using Hortonworks Hive DB for your data marts or data-warehouse? If so, build your Free Hortonworks Hive DB it dashboard software.
Hortonworks Hive DB
Benefits of Hortonworks Hive DB database dashboard
Instant Visibility. A Hortonworks Hive DB 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 Hortonworks Hive 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
“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 Hortonworks Hive DB database dashboard
How to create Hortonworks Hive DB database connection
Hortonworks Hive DB supports both ODBC and JDBC connections. To work with Databases, you would need the following Connection details like
- Hortonworks Hive DB server IP or name
- Hortonworks Hive DB database name
- Hortonworks Hive DB port number
- Hortonworks Hive DB user and password
Check out the InfoCaptor Hortonworks Hive DB connection details
How to build Hortonworks Hive DB pivot table for dashboard reporting
InfoCaptor provides powerful visual analytics for Hortonworks Hive DB and you simply point to the table in your Hortonworks Hive DB 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 Hortonworks Hive 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 Hortonworks Hive DB data
Create bar charts and line charts for Hortonworks Hive SQL reporting tables and views
Once you have a visual clue about your Hortonworks Hive DB data using pivot tables, it becomes very easy to convert into bar chart, line chart or any other chart. Check this picture, how Hortonworks Hive DB data is visually mapped between pivot table and bar chart
Create Advanced d3.js charts for Hortonworks Hive DB 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 Hortonworks Hive DB reports can easily incorporate circle pack, sunburst, cluster and treemap diagrams. Sankey Flow diagram for your Hortonworks Hive analytics data is also an excellent choice for quick data analysis.
Add Hortonworks Hive DB 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 Hortonworks Hive SQL reporting dashboards
- Add dashboard parameters to the Hortonworks Hive DB reporting page
Finalize and Publish your Hortonworks Hive 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