Oracle Analytical Cloud Service (OACS)

Course Overview

Topic

1. Autonomous Data warehouse

• An understanding of  ADW is OAC.
• Configuring autonomous data warehouse instance.
• Creation of ADW Database and bucket.
• Creating a connection between SQL developer and ADW Database.
• loading data to Object data storage.

2. Configuring OAC DBaaS instance.

3. Configuring Analytics instance in OAC.

4. Oracle Analytical Cloud

• Loading data via flat files, relation DB using Data sync.
• Walkthrough to Oracle Apex.
• Creation of Data model.
• Deploying the Data model and executing the analysis.
• Creating the analysis using ADW Instance and using the Data Model Created.

5. Data visualization Desktop

• Installing DVD on local Machine.
• Creating connection TO ADW instance with Data visualization desktop.
• Creating data flow and publishing to create the subject area.
• Creation of reports and different visualization using DVDs.
• Publishing reports to the Dashboard using Data visualization.

6. Data Sync Utility

• Installing Data sync Utility.
• Walkthrough to Oracle Data Sync.
• Creating a connection to ADW instance.
• Loading data to ADW instance via Relational Database and flat files.
• setting uploading strategy on data sync.
• running jobs in oracle Bics.
• Monitoring error on Oracle Data sync and scheduling of jobs.

7. Creation of connection to OAC Instance with Autonomous Data warehouse.

8. Creation of DataModel in OAC using tables and views.

9. Creation of Reports and Dashboard in OAC.

10. Discussion on Uploading RPD On OAC.

11.Understanding and walkthrough to the Components on OAC.

12. Understanding the Administration section on OAC.

13.Creation of users and groups on OAC.

14. Assigning permission to Users, groups and Application Role on OAC.