One interesting new feature in Oracle’s Data Visualization Desktop (DVD) is the ability to go to the Oracle BI Public Store and install new visualizations in your local product install. This blog post shows how to download and install a “Calendar Heatmap” plugin from the Public Store and to use this plugin with a sample data set.
Once on the Oracle BI Public Store, scroll down and find the “Calendar Heatmap Viz Plugin” box and click on the box:
Next, the BI Public Store will prompt you to download the plugin:
Once you have downloaded the plugin, you will be able to find the content in the “Downloads” folder of the file system.
Copy and paste the zipped file from this folder into the “plugins” folder in your “DVDesktop” install. If there is not a plugin folder in the installed version, use the following path in the screenshot below.
If DVDesktop is already open, you will need to close it out and restart it so that it can read the new plugin. Once DVDesktop is open, you will want to start a new project.
It will then prompt you to select a data source. In this example, a new data source shows traffic stops in Montgomery County, Alabama.
After bringing in a new Excel file as the data source for this project, using the “Ctrl” key I will select both the “Day of Stop” and “Traffic Count” columns, and then right-click and select the “Pick Visualization” button.
Notice that the “Calendar Heatmap” visualization is now an option to select.
Select the “Calendar Heatmap” visualization.
Taking the data to a new level, right-click on “My Calculations” and select “Add Calculation.”
Bring in the “DAYNAME” function using the “Date of Stop” column so that there is a name value for each day of traffic stops.
Using the “Ctrl” option again, select the “Day of Week” column calculation that was just created along with the “Traffic Count” measure; then right-click and select “Pick Visualization.”
Select the “Horizontal Bar” visualization.
Right-click on any of the bars in the graph and select the “Sort” option. Then click “Day of Week” by “Traffic Count,” “High to Low” option.
One thing to note after bringing in this sort is that the two lowest days for traffic stops are Saturday and Sunday. This could be because there are less people on the roads on the weekend.
Need help or advice on data visualization plugins? Contact Performance Architects at firstname.lastname@example.org and we’d be happy to help.