Create Your First Analysis in Oracle Analytics

Introduction

This tutorial will guide you through the process of creating your first analysis in Oracle Analytics. You will learn how to display the top ten products, manipulate data columns, apply sorting and filtering, and choose an optimal visualization. Finally, you will save your results and learn how to share the analysis via email.

Step 1: Create a New Analysis

• Open Oracle Analytics.
• Navigate to the home page.
• Click on the “Create” button and select “Analysis” from the dropdown menu.
• Choose the appropriate subject area that contains your product data.

Step 2: Add Columns to the Analysis

• In the analysis editor, locate the 'Columns' pane on the left side.
• Drag and drop the relevant fields (e.g., Product Name, Sales, Quantity) into the analysis area.
• Ensure the columns represent the data you want to analyze.

Step 3: Delete a Column

• Identify the column you wish to remove from the analysis.
• Click on the column header to select it.
• Right-click and choose “Remove” from the context menu to delete the unwanted column.

Step 4: Sort the Data

• Click on the column header you want to sort (e.g., Sales).
• Select the sorting option (Ascending or Descending) to organize the data as needed.
• Confirm that the top ten products are displayed based on your sort criteria.

Step 5: Add a Filter

• Find the 'Filters' pane on the left side of the analysis editor.
• Drag and drop the desired field (e.g., Product Category) into the filters area.
• Configure the filter settings (e.g., select specific categories) to refine the data set.

Step 6: Choose a Visualization

• Click on the “Visualizations” tab in the analysis editor.
• Browse through the visualization types (e.g., bar chart, pie chart).
• Select the best visualization that represents your data clearly and effectively.

Step 7: Save the Analysis

• Click on the “Save” button at the top of the analysis editor.
• Enter a descriptive name for your analysis.
• Choose the appropriate folder for organization and click “OK” to save.

Step 8: Share the Analysis via Email

• Locate the “Share” option in the analysis toolbar.
• Select “Email” from the sharing options.
• Enter the recipients' email addresses, add a subject line, and include a message if necessary.
• Click “Send” to share your analysis.

Conclusion

You have successfully created an analysis in Oracle Analytics that showcases the top ten products. By following these steps, you learned how to manipulate data, apply filters, choose visualizations, and share your insights effectively. Next, explore more advanced features in Oracle Analytics to enhance your data analysis skills.