Creating a Data Visualization Desktop Data Set

Before You Begin

This 10-minute tutorial shows you how to create a data set in Data Visualization Desktop.

This is the 4th tutorial in the Analyzing and Visualizing Data on Big Data Cloud series. Perform the tutorials sequentially.

• Creating a Trust Store File
• Configuring the Memory Settings for the Spark Thrift Server Process
• Connecting Oracle Data Visualization Desktop to Big Data Cloud
• Creating a Data Visualization Desktop Data Set
• Exploring and Visualizing Data Using Oracle Data Visualization Desktop

Background

Data visualization describes the presentation of abstract information in graphical form. Data visualization allows you to spot patterns, trends, and correlations that otherwise might go unnoticed in traditional reports, tables, or spreadsheets.

What Do You Need?

• Access to an instance of Big Data Cloud
• Oracle Data Visualization Desktop

Create a DV Desktop Data Set

1. Open Data Visualization Desktop.
2. Click the Navigator   icon and select Data.
3. Click Create and select Data Set.
   

   

4. Select the demo_conn connection. Click the default database.

   

   

5. Select the bike_trips_weather_parquet table. And click Add All to add all the columns.

   
   

6. Click the upload icon next to the filter icon in the dataflow pipeline.

   

7. Click the Refresh property and change the status to Live - Always use the database.

   

8. Enter a new name for data source and click Add. It will take a moment while DVD inspects the data.

   

   Preview data is displayed.

   

9. Scroll to the PRECIPITATION column and click the column header menu. Click Properties and change Treat As to attribute.

   
   

10. Click Create Project to create your first visualization project.

    

Next Tutorial

Exploring and Visualizing Data Using Oracle Data Visualization Desktop

Want to Learn More?

• Oracle Data Visualization Desktop
  
• Using Oracle Big Data Cloud