Oracle Data Visualization Desktop : Getting Started

  • 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.

Download Link : http://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visualization-desktop-2938957.html

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.

 

page that opes up on first launch
Step 2: After installation, to open it, double click on the Data Visualization Desktop Icon like any other Stand-alone application.

 

6
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.

 

home page of DVD

 
Step 4: Clicking on the hamburger hamberger icon 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.

 

hamberger opens
Step 5: Select VA Project from the home screen. On clicking it opens up a dialog box prompting you to Add a Data Source. Select Create New Data Source since there is no data source present already.

 

create new data source

 
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.

 

select from Oracle database

 
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.

 

1

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.

 

2

 
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.

 

review the table and 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.

 

w_T_d has been added to the project

 
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.

 

different graphs present

 
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.

 

Visualization created

 
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.

 

3

 

Step 16: Below picture shows how the graph looks after changing the color of its items.

 

Visualization created after changing color

 
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.

 

4

 
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.

 

drag image field to 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 prop 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.

 

upload image and freedom

 

Step 20: Adjust the transparency of the image in the properties of the image tile, so the image will stay underlay the entire dashboard and still be able to see the visualizations.
transparent image

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.

aa4

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.

aa

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.

aa outliers

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.

 

5

Leave A Reply

Your email address will not be published. Required fields are marked *