Before You Begin

This 10-minute tutorial shows you how to analyze data from a file source dataset and curated dataset.

In first section of this tutorial, you create analyses with the donations2024 dataset. In the second section, you create analyses with the Donations by School curated dataset.

Draw your own conclusions about the insights available with the analyses in both section.

Background

This is the second tutorial in the Prepare and Analyze Data in Oracle Analytics series. Read the tutorials in the order listed.

What Do You Need?

  • Access to Oracle Analytics Cloud or Oracle Analytics Desktop
  • Access to the donation and Donations by School Datasets

Create Analyses with the Donation Dataset

This section uses the donations2024 dataset that you added in the Explore Data Flows tutorial.

  1. Sign in to Oracle Analytics.
  2. On the Home page, click Create, and then select Workbook.
  3. In Add Data, click donations2024, and then click Add to Workbook.
  4. In the Auto Insights panel, click X to close the panel.
  5. In the Data panel, expand DATE_COMPLETED, hold down the Ctrl key, select Year and TOTAL_DONATIONS, and then drag them to the canvas.


    The line view shows that 2023 had the largest number of donations.

    Description of total_donations_yr_completed.png follows
    Description of the illustration total_donations_yr_completed.png
  6. In the Data panel, hold down the Ctrl key, and then select SCH_CITY, TOTAL_DONATIONS, and NUM_DONORS. Right-click and select Create Best Visualization.


    A scatter view is added to the canvas that shows the total number of donors and total donations by city.

    Description of num_donors_city.png follows
    Description of the illustration num_donors_city.png
  7. In the Data panel, select SCHOOL_ID and drag it to Category (Points) to replace SCH_CITY.
  8. Click the visualization menu visualization menu icon and select Zoom Chart.


    The scatter view shows that 478 donors gave more than $26,000 in donations to the selected school.

    Description of num_donors_school.png follows
    Description of the illustration num_donors_school.png
  9. Click Save Save icon. In Save Workbook, enter Donation Analyses, and then click Save.
  10. Click Go Back Back icon to return to the Home page.

Create Visualizations with the Curated Dataset

In this section, you use the curated Donations by School dataset to gain insights.

You can see the donations patterns related to grade-level and poverty in the grid heat map views.

  1. On the Home page, click the Data search tag, enter Donations by School, and then click Search.
  2. In Donations by School, click Actions Action Menu icon, and then select Create Workbook.
  3. In the Data panel, hold down the Ctrl key, select POVERTY_LEVEL, GRADE_LEVEL, and Donation by Population, and then right-click and select Create Best Visualization.


    The bar visualization shows the grades 3 through 5 levels as different colors.

    Description of poverty_grade_level.png follows
    Description of the illustration poverty_grade_level.png
  4. In the Data panel, hold down the Ctrl key, select POVERTY_LEVEL, GRADE_LEVEL, and then select Average School Donation by Income. Drag the data elements to the canvas.


    Oracle Analytics creates the visualization next to the existing visualization.

    Description of school_income_donations.png follows
    Description of the illustration school_income_donations.png
  5. In the Data panel, select TOTAL_DONATIONS, and drag it to Values (Y-axis) to replace Average School Donation by Income.


    Description of total_donations_poverty.png follows
    Description of the illustration total_donations_poverty.png
  6. Click Save Save icon. In Save Workbook, enter Donations by School WBK in Name and click Save.

Next Steps

Create Aggregated Datasets

Learn More