- Oracle Data Visualization Desktop gives decision-makers their own personal desktop application to access, explore, blend, and share data visualizations where you can create visual stories on data from a variety of sources including spreadsheets, databases and applications.
- Combine and blend your data using the intelligent visualizations to quickly see patterns choosing from a variety of visualizations. Selecting data in one visualization highlights related data in everything else on the screen.
- Oracle Data Visualization Desktop is a single file download with no remote server infrastructure requirements. You open and close it just like any other desktop application and there is no login. It is a single-user desktop application which is available offline, where you can create completely private analysis having personal control over the data source connections.
Step 1: Download and install the compatible version of Oracle Data Visualization Desktop.
The installation is quite simple and requires no additional software or plugins for the standard Visual Analyzer functionality. Below is the dialog box that appears on launching Data Visualization Desktop for the first time after installation.
Step 3: After the Data Visualization startup, it presents a home screen which contains a search field for finding projects, a list of user folders if you have created any, link to create visual analyzer project and the data sources present.
Step 4: Clicking on the hamburger icon, in the top left corner brings up a menu where you can choose to start Visual Analyzer with the last data source selected, select new Data Sources or create a new VA Project.
Step 6: Next, the Data Visualization Desktop provides users with three options to choose data from.
1. From a File : On selecting this option, users get to import excel files from their local machine and create required visualizations. This is self explanatory and nice way to include non-curated data in an analysis.
2. From Oracle Applications : Here you can connect to an existing OBIEE instance. The data used for creating a visualization is the same data which has been used for creating an OBIEE analysis.
3. From Database : This option provides you to connect with a live data source where you can have your desired data from a database table.
Step 7: On selecting From Database, it leads you to a connection screen where you can give the connection name, clicking on Database Type reveals a drop-down menu which you can choose from a variety of database formats, including Spark, MySql, Hive and Mongo DB, among others. Here we have considered Oracle as the Database Type. Click Save.
Step 8: In the next window, enter all your connection information like host and port of the system where the database resides and Username, Password and Service Name to access the database. then Save the Credentials.
Step 9: Once a connection to the database is made, it shows up in the available connections list. Select the TENNISTOURNAMENTS schema and click OK.
Step 10: On clicking the schema name it brings up a list of tables available to add as data sources for visualizations. Select W_TOURNAMENT_D and click OK.
Step 11: Here you can review the table and its columns. Also you can change the column type from Attribute to Measure and vice versa. Notice that the Query Mode is selected Live that show you are retrieving data from a live database. Select Add to Project.
Step 12: The W_TOURNAMENT_D table has been added to the project listing all the dimensions and measures that are ready to use. Click on the bars icon as shown in the picture to create your first visual on dragging and dropping the items from the data elements pane.
Step 13: The Oracle Data Visualization Desktop comes with a variety of graphs providing an user to see the data from different angles. Combo, Stacked Scatter, Sunburst are among the newly introduced graphs.
Step 14: Create a Scatter graph on dragging the TOURNAMENT_WID column to Y-Axis, TIER to X-Axis while color of the dots varies according to the SOURCE.
Step 15: Formatting a graph has been made really easy in the Data Visualization Desktop. Simply right click anywhere on the visualization and in the box that appears, go to Color then select Manage Color Assignments. Click on an item and select the color you want to see it in then OK.
Step 16: Below picture shows how the graph looks after changing the color of its items.
Step 17: Similarly, to add a reference line to the graph, click anywhere on the canvas and select Add Reference Line. Then you can also make additional changes to the type of the reference line that is going to be added. The dotted line is the reference line added to the graph is shown below.
Step 18: Oracle has introduced another feature for inserting images into the dashboards to the Data Visualization Desktop. Go to the Visualizations pane, drag and drop the Image component anywhere in the canvas.
Step 19: Click on Select Image where you can choose to upload your own image or link to an URL to pull images from the web. After the image gets added to the dashboard, click on the properties icon of the image tile and change the Canvas Layout to Freedom. By doing this, you will be allowed to move the image anywhere on the dashboard.
Step 21: Oracle has added another feature for the Advanced Analytics area in Data Visualization Desktop, which uses R that gives users the ability to do things like highlight outliers or show trend lines with a click of a button. Select the Analytics Pane to view the available options.
Step 22: First of all, you need to download the Oracle R Distribution Setup and paste it inside the temp folder following the path C:\Users\Your_PC\AppData\Local\temp
Download Link : https://oss.oracle.com/ORD/ORD-3.1.1-win.zip
Step 23: Then double click on install_advanced_analytics inside Oracle Data Visualization Desktop folder following the path C:\Program Files\Oracle Data Visualization Desktop
Select the language and let the Setup Wizard do its work so it will make the advanced analytics options available to the visualizations.
Step 24: To test the Advanced Analytics option, Right click anywhere on the dashboard and select Add Outliers. Now you can see the outliers and non-outliers are easily distinguishable.
Step 25: To export the data used in the visualization and import it to an excel, right click on the visualization and select Export Data. Save the exported file with an appropriate name then open it to review the data in excel.