Analytics with Autonomous Database

This hands-on lab will walk you through connecting Oracle Analytics Cloud (OAC) to Oracle Autonomous Database (ADB), getting immediate valuable insight out of your ADW data, scaling up the ADB database to optimize OAC performance, deepening analysis by mashing-up additional data and leveraging OAC interactive visualization features.

Estimated lab time: 4 hours, 40 minutes

Outline:

• Provisioning your Autonomous Database instance
• Provisioning your Oracle Analytics Cloud instance
• Connecting OAC to ADW and adjusting Data Set properties
• Immediate basic insights on data
• Asking direct questions on data
• Gaining insights with visual data dialog
• Monitoring ADW activity generated by OAC
• Building simple interactive analysis
• Mashing up additional datasets contextual data prep
• Geo maps and custom binning
• Leveraging Data Flows with ADW
• Leveraging Database functions with OAC

Prerequisites:

• Familiarity with Database is desirable, but not required
• Some understanding of cloud and database terms is helpful
• Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
• Bring a laptop to engage in activities