Getting Started with Sample Data

This topic describes how you can use sample data to get started with Oracle Data Visualization Cloud Service.

About the Sample Data

This topic is designed to guide you through the sequential process of uploading and exploring the sample data in the files, starting with sample sales data.

To access the sample data, go to http://www.oracle.com/technetwork/middleware/bi-foundation/bics-sample-2283629.html, and download dvcs-sample-sales.zip.

This zip file contains 6 sample data files for you to explore. File names prefixed with a F are fact files and those prefixed with a D are dimension files.

Upload and explore the sample data files in the order shown. For instructions, click the corresponding topic.

Upload Sequence Sample Data File More Information

Upload sales figures

PCW15 F Sales.xlsx

Uploading Sample Sales Data

Upload the calendar

PCW15 D Calendar.xlsx

Uploading Sample Calendar Data

Upload item descriptions

PCW15 D Items.xlsx

Uploading Sample Items Data

Upload store characteristics

PCW15 D Stores.xlsx

Uploading Sample Stores Data

Upload delivery details

PCW15 F Deliveries.xlsx

Uploading Sample Deliveries Data

Upload warehouse details

PCW15 D Warehouse.xlsx

Uploading Sample Warehouses Data

Uploading Sample Sales Data

The PCW15 F Sales.xlsx file contains individual order details and revenue.

  1. On the Home page, in the Create section, click VA Project to begin the process of creating a project and visualizations.
  2. In the Add Data Source dialog, click Create New Data Source.
  3. Click From a File, and in the File Upload window, navigate to your local directory containing the sample files.
  4. Select PCW15 F Sales.xlsx, and then click Open.
  5. In the Upload a File dialog, verify that the data are true numbers, and not keys.
  6. Change Store Id and Item Id columns to Attribute.
  7. Click Add to Project.
  8. On the Data Elements pane, press the Ctrl key and click the Sales Date and Revenue data elements to drag and drop them on to the canvas.

    The Revenue by Sales Date visualization is displayed.

Uploading Sample Calendar Data

The PCW15 D Calendar.xlsx file contains calendar data.

  1. With the Revenue by Sales Date visualization displayed on the canvas, right-click the Data Elements pane, and select Add Data Source.
  2. Locate and upload PCW15 D Calendar.xlsx.
  3. In the Upload a File dialog, match the Day Date and Sales Date columns in the existing and new data sources.
    1. In the Day Date column, in the Attribute cell, click the down arrow.
    2. From the drop-down list, select Match.
    3. Click the Select Column cell, and select Sales Date.
    4. In the Upload a File dialog, click the Add Facts link, and then select Extend a Dimension. This turns all measure columns into attributes. This action is a shortcut. It saves you from having to switch each numeric column from a Measure into an Attribute.
    5. Click Add to Project.
      Notice that the Calendar data source is displayed.

      Description of samplecalendar06.jpg follows
      Description of the illustration samplecalendar06.jpg

  4. In the Data Elements pane, expand the Calendar data source. Select the Per Y Mth# data element, drag it to the Category drop target in the Explore pane, and drop it over Sales Date to replace it.
    This action replaces the sales dates with calendar months (YYYYMM).

    Description of samplecalendar08.jpg follows
    Description of the illustration samplecalendar08.jpg

Uploading Sample Items Data

The PCW15 D Items.xlsx file contains details such as the operating system (OS) and pricing for the products sold in stores and delivered from warehouses.

  1. With the Revenue by Per Y Mth# visualization displayed on the canvas, right-click the Data Elements pane, and select Add Data Source.
  2. Locate and upload PCW15 D Items.xlsx.
  3. In the Upload a File dialog, click the Add Facts link, and then select Extend a Dimension to set all measures as attributes.
    When you perform this action, you are loading facts because there are numeric values in the source file. You can combine Recommended Retail Price (RRP) with revenue to calculate unit price or you can multiply RRP with unit price to discover if there has been any discounting.
  4. Click Add to Project.
  5. In the Data Elements pane, expand the Items data source, and drag the OS data element to the Color drop target in the Explore panel.
    This action displays operating system revenue data by month organized by color.

Uploading Sample Stores Data

The PCW15 D Stores.xlsx file contains details such as the address and buyer for each store.

  1. With the Revenue by Per Y Mth#, OS visualization displayed on the canvas, right-click the Data Elements pane, and select Add Data Source.
  2. Locate and upload PCW15 D Stores.xlsx.
    Notice that the Store Id column is automatically matched.
  3. In the Upload a File dialog, verify that all columns are set to Attribute.
  4. Click Add to Project.
  5. In the Data Elements pane, expand the Stores data source, and drag the State data element to the Trellis Rows drop target in the Explore panel.
    This action displays operating system revenue data by month and state organized by color.
  6. On the project toolbar, click Save Project, and then select Save As.
  7. Save the project as Pcw15 – Sales in MyFolders.
  8. Next, review the associations in place between the data sources you’ve uploaded so far to the project. With the visualization displayed, right-click the Data Elements pane, and select Source Diagram.
    When there is a 0 displayed in the Source Diagram, this means that there is no relationship between those data sources.
  9. Close the Source Diagram.

Uploading Sample Deliveries Data

The PCW15 F Deliveries.xlsx file contains order data.

  1. With the Pcw15 – Sales project open, right-click the Data Elements pane, and select Add Data Source.
  2. Locate and upload PCW15 F Deliveries.xlsx.
    Notice that the Order # column is automatically matched.
  3. Match the Ord Date and Sales Date columns.
  4. Match the Delivery Store Id column to the Store Id column.
  5. Click Add to Project.
  6. Next, right-click the Data Elements pane, and select Source Diagram.
    Notice that the diagram has more lines because there are more relationships between the source files.
  7. Investigate the relationship between the sales and deliveries data sources.
    1. In the Source Diagram, double-click the link between PCW15 F Sales and PCW15 F Deliveries.
    2. In the Connect Sources dialog, notice the matches that exist between the data sources.
    3. Close the Source Diagram.
  8. Next, create a measure to calculate the number of days for delivery.
    1. In the Data Elements pane, click Add Calculation.
    2. In the New Column Formula dialog, name the measure as Days to Deliver.
    3. Under Functions, expand Aggregate, and double-click Avg to add it to the expression.
    4. Highlight expr in the expression, and double-click TimestampDiff in the Functions pane to add it to the expression.

      Note:

      TimestampDiff is displayed under the Calendar/Date functions.
    5. Replace the interval expression with SQL_TSI_DAY.
    6. Highlight expr in the expression, and in the Data Elements pane, under the Deliveries data source, drag and drop Order Date on to the highlighted expression.
    7. Highlight timestamp2 in the expression, and in the Data Elements pane, under the Deliveries source, drag and drop Delivery Date to the highlighted expression.
    8. Click Validate. The “Expression validated” message is displayed.
    9. Click Save.
      Notice that the calculation is displayed in the Data Elements pane under My Calculations.
  9. In the Data Elements pane, drag Days to Deliver to the Values drop target in the Explore panel.
    This action displays the days to deliver by month. Notice a pattern where delivery times are longer at certain times of the year for different states.

Uploading Sample Warehouses Data

The PCW15 Warehouse.xlsx file contains details such as the address, and min and max ship times for each warehouse.

  1. With the Pcw15 – Sales project open, right-click the Data Elements pane, and select Add Data Source.
  2. Locate and upload PCW15 D Warehouse.xlsx.
  3. In the Upload a File dialog, click the Add Facts link, and then select Extend a Dimension.
  4. Click Add to Project.
  5. In the Data Elements pane, expand the Stores data source, right-click State, and then select Create Best Visualization.
    A new visualization with a pivot table is added to the canvas.
  6. Drag and drop Days to Deliver from the Data Elements pane (under My Calculations) to the Values drop target in the new visualization.
  7. In the Data Elements pane, expand the Warehouse data source, and press the Ctrl key to select and drag the Min Ship Time and Max Ship Time data elements to the State drop target in the Days to Deliver by State visualization.
    You can compare the days to deliver targets to the actual delivery times for each state.