Creating Your First Visualization in Oracle Analytics Cloud

Before You Begin

This tutorial shows you how to create a project, select data to use in the visualization, and modify the visualization. You learn how to filter and sort the data, modify data properties, and change the visualization type. This tutorial takes approximately 10 minutes to complete.

What Do You Need?

Access to Oracle Analytics Cloud
Download the SAMPLE_REVENUE.csv file to a location on your hard drive.

Add Data

Sign in to Oracle Analytics Cloud Service with your credentials.
In the Home page, click Create, and then click Project.
In the Add Data Set dialog, click Create Data Set.
In the Create Data Set dialog, select File, select the SAMPLE_REVENUE file, and then click Add.
Click Visualize.
From the Data Elements pane, drag the following to the canvas:
- PROD_TYPE
- REVENUE
- DEPARTMENT
Description of the illustration initial_viz.jpg.
In the Explore pane, select and drag PROD_TYPE to the Color drop target.
Description of the illustration prod_type_color.jpg.
Select and drag DEPARTMENT to Color drop target to exchange position with PROD_TYPE in the visualization.
Click the visualization list and select Horizontal Stacked as the visualization type.
Description of the illustration department_color.jpg.

Filter the Data

In the canvas, click next to Click here or drag data to add a filter.
From the SAMPLE_REVENUE list, select PROD_TYPE.
From the PROD_TYPE list, select Cell Phones and Smart Phones, and click inside the dialog to close the list.
Description of the illustration filtered_results.jpg.
From the Data Elements pane, select COMPANY, and drag it to the Y-Axis drop target to replace DEPARTMENT.
In the Elements pane, drag COMPANY to the Color drop target.
In the canvas, click the menu , and select Clear all filter selections.
Description of the illustration rev_prod_type.jpg.

Change Properties for the Revenue Data Element

In the Data Elements pane, select Revenue, then in REVENUE Properties, click Number Format .
In the Number Format row, click Number and select Currency.
In the REVENUE by PROD_TYPE, COMPANY visualization, click the menu , select Sort, and click Product Type and Company by Revenue low to high.
Description of the illustration rev_currency.jpg.