KEMBAR78
OAC Assignment Level1 | PDF
Scribd
Upload
60 views2 pages

OAC Assignment Level1

The assignment involves uploading an Excel file to OAC and transforming the dataset by modifying the order date and order priority columns. It requires creating various visuals such as bar graphs, tables, and maps to analyze sales data, along with detailed reports and calculations. The final outputs must be saved in designated OAC locations with specific naming conventions.

Uploaded by

Nikitha Pole
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
60 views2 pages

OAC Assignment Level1

The assignment involves uploading an Excel file to OAC and transforming the dataset by modifying the order date and order priority columns. It requires creating various visuals such as bar graphs, tables, and maps to analyze sales data, along with detailed reports and calculations. The final outputs must be saved in designated OAC locations with specific naming conventions.

Uploaded by

Nikitha Pole
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Assignment Level 1:

Use the excel file “Sample Order Lines.xlsx” from the oracle content folder

Create a dataset in OAC by upload this excel file.

As part of the dataset creation or by making use of the dataflows, make the following transformations,

 For the order date column remove the timestamp and display a new column just for the date
 For Order Priority column, change the value “Not Specified” as “N/A”

Save this data set as YOUR_NAME_Dataset in the OAC location.

Create the following visuals/canvas with the dataset you have created.

 Bar graph displaying the sales by customer segment and the yearly trend.
 Display a table that shows the top 10 products based on the highest quantity ordered. This must
have a parameter for product category so that we can use the prompt to select each category
and find out the top 10 order quantity.
 Create your own choice of visual to best display the Order Size and Profit made, based on the
order priority.
 Use the map visual by using the city column and show the sales record for each city. Add any
other appropriate measure column to extend this data visual.
 Use individual tiles at the top to display Order Quantity, Sales, Discount and Profit
 Create a report level calculation to separate customer name as customer first name and
customer last name (use these columns in the detailed report below)
 In the same workbook, create 2 detailed reports in separate canvas that display order details
and sales details. Use the drill report feature to establish a master-detail relationship between
the above visuals and the 2 detail reports.
 Use filters and prompts in the workbook as required and make a meaningful analysis.

Save the workbook with the name YOUR_NAME_Workbook in the OAC locations

You might also like