Oracle by Example brandingExploring and Visualizing Data Using Oracle Data Visualization Desktop

section 0Before You Begin

This 15-minute tutorial shows you how to use Oracle Data Visualization Desktop to explore and visualize the data within the Oracle Big Data Cloud.

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

What Do You Need?

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

section 1Create a First Visualization (Trips by Age by Gender)

  1. Right-click My Calculations and choose Add Calculation.
    my calculations
    Description of the illustration a1.jpg
  2. Expand Aggregate and double-click Count(*). Enter the Name as num_trips and click Save.
    New Calculation page
    Description of the illustration a2.jpg
  3. Drag num_trips and RIDERAGE onto the Canvas.
    Click on num_trips
    Description of the illustration a3.jpg
    The chart is displayed.
  4. Drag GENDER on the Color section and let the chart update.
    Drag gender
    Description of the illustration a4.jpg
    The chart shows the visualization of bike trips based on RIDERAGE and GENDER.

section 2Create a Second Visualization (Trips Per Hour)

  1. Click the + sign next to Canvas1 to create a new canvas.
  2. Drag num_trips and STARTHOUR onto the canvas to visualize number of bike trips per hour.
    Drag Starthour to the canvas
    Description of the illustration b2.jpg
  3. Click the Horizontal Stacked drop-down arrow and change the visualization to Line.
    Line visualization
    Description of the illustration b3.jpg

    Line visualization
    Description of the illustration b3_1.jpg
  4. Drag the STARTDATE to the Color Section and WORKDAY to the Trellis Columns section to visualize number of bike trips per hour based on startdate and workdays.
    Drag Startdate
    Description of the illustration b4.jpg
    Drag Workday
    Description of the illustration b4_1.jpg

section 3Create a Third Visualization (Trips per hour based on workdays and weather)

  1. Right-click My Calculations and select Add Calculation. Expand Expressions and double-click Case (If).
    2. New calculation
    Description of the illustration c1.jpg
  2. Enter weather for the Name and CASE WHEN PRECIPITATION>0.1 THEN 'WET' ELSE 'DRY' END in the expression field.
    New Calulation
    Description of the illustration c2.jpg
  3. Drag WEATHER to the Trellis Columns section and PRECIPITATION and MAXTEMPERATURE to the Item (Detail) section.
    Drag Weather
    Description of the illustration c3.jpg
    Drag Precipitation and Maxtemperature
    Description of the illustration c3_1.jpg
  4. Click Save to save the project.Enter Bike and Weather Report as the project name and click Save.
    Save Project
    Description of the illustration c4.jpg

more informationWant to Learn More?