Before you Begin

This 10-minute tutorial shows you how to create a language narrative visualization.

Background

A language narrative visualization creates natural language descriptions of the data contained in a visualization and generates related insights.

You can use a language narrative visualization with the following combinations:

  • Two attributes and one measure
  • One attribute and two measures

Oracle Analytics provides three natural language tones, Factual, Casual, or Business, that you can use in your language narrative visualizations. If the Oracle Analytics Gen AI service isn't enabled, your language narrative visualization uses the default Factual tone.

Contact your administrator about enabling Oracle Analytics Gen AI service.

What Do You Need?

  • Access to Oracle Analytics Cloud or Oracle Analytics Desktop
  • Download donation2024.xlsx to your computer

Create a Dataset

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Create, and then click Dataset. In Create Dataset, click Drop data file here or click to browse, select the donation2024.xlsx file, and then click Open.
  3. In Create Dataset Table from donation.xlsx, click OK.
  4. Click Save Save icon. In Save Dataset As, enter donations2024 in Name, and then click OK.


    Description of donation_dataset_joindiagram.png follows
    Description of the illustration donation_dataset_joindiagram.png
  5. Click the donations2024 tab. Select the DATE_POSTED column, click Options Options icon, and then select Convert to Date. In Convert to Date, select Custom from the Source Format list, and then enter dd.MMM.yyyy as the date format.
  6. Click Add Step.


    Description of convert_2_date.png follows
    Description of the illustration convert_2_date.png
  7. Click Save Save icon.

Create a Workbook

  1. Click Create Workbook. Close the Auto Insights panel.
  2. In the Data panel, hold down the Ctrl key, select TOTAL_DONATIONS and DATE_POSTED, right-click and then select Create the Best Visualization.


    Oracle Analytics create a line visualization with TOTAL_DONATIONS on the Y-axis and DATE_POSTED on the X-axis.

    Description of total_donations_date_posted.png follows
    Description of the illustration total_donations_date_posted.png
  3. In the Grammar panel, right-click DATE_POSTED in the Category (X-Axis), select Show By, and then select Month.


    Description of total_donations_by_month.png follows
    Description of the illustration donations_by_month.png
  4. In the TOTAL_DONATIONS by DATE_POSTED visualization, click the Menu Visualization menu icon, select Edit, and then select Duplicate Visualization.
  5. Click Change Visualization Type Change Visualization Type in the duplicate visualization, and then select Language Narrative Language Narrate Visualization icon.


    Description of lang_nar_viz.png follows
    Description of the illustration lang_nar_viz.png

Add an Attribute to the Visualization

  1. In the language narrative visualization, click Menu Visualization menu icon, and then select Delete Visualization.
  2. Select POVERTY_LEVEL in the Data pane and drag it to the TOTAL_DONATIONS by DATE_POSTED visualization.


    Description of total_don_poverty_level.png follows
    Description of the illustration total_don_poverty_level.png
  3. In the visualization, click the Menu Visualization menu icon, select Edit, and then select Duplicate Visualization.
  4. Click Change Visualization Type Change Visualization Type in the duplicate visualization, and then select Language Narrative Language Narrate Visualization icon.


    The language narrative visualization provides information on how poverty level impacts total donations by month.

    Description of poverty_level_donations.png follows
    Description of the illustration poverty_level_donations.png

Change the Tone of the Language Narrative

In this section using the same language narrative visualization, you change the Tone property to see the differences between the narratives.

  1. Select the language narrative visualization and click Properties properties icon.
  2. In the Tones row, click Factual and select Casual.


    Description of casual_tone.png follows
    Description of the illustration casual_tone.png
  3. In the Tones row, click Casual and select Business.


    Description of business_tone.png follows
    Description of the illustration business_tone.png
  4. In Properties, click 7 in the Level of Detail row and use the slider to decrease to 3.


    Description of level_of_detail.png follows
    Description of the illustration level_of_detail.png

Learn More