Welcome IT pro!

Here’s the scenario: as an IT professional, your goal is to support your business colleagues and the objectives of the enterprise from all technical aspects. Let’s explore a few examples of how Oracle can make your job easier.

Start Quick Tour

Using Oracle Autonomous Data Warehouse and Oracle Analytics you will complete 3 objectives:

  • Set up an Autonomous Data Warehouse
  • Scale your warehouse up and down as needed
  • Build visualizations for the sales manager

You are now autonomous. Let’s go!

Start Objective 1

To begin creating a new autonomous data warehouse, let’s log into Oracle Cloud.

Click Sign In

View Details
Open Service Console
View Account Usage Details

Next, open the service console.

Click Open Service Console

Then, begin setup of your warehouse with the click of a button.

Click Create Autonomous Data Warehouse button

Name your database, choose the number of CPUs, edit storage amounts for the data warehouse, specify the admin password, and hit “Create.” It’s that easy—the autonomous system handles all the hard work behind the scenes.

Click Create Autonomous Data Warehouse button

Success—now let’s take a quick look and double-check our settings.

Click Finance Mart row

Everything looks good—your Autonomous Data Warehouse is now up and running.

Next

Nice work! Oracle auto-configures your new database with optimal settings, provisioning a high-performance database based on Oracle’s Exadata architecture—meaning the system is fully encrypted and secure, with high availability and automatic backups. All in a matter of seconds.

Now let’s see how easy it is to scale your new warehouse at will.

Start Objective 2

Running against 6 billion records, a typical business analyst report (Profit by Brand and Regions) could take 100 seconds with a 4 CPU data warehouse.

But what if that just isn’t fast enough for your business? Let’s simply and quickly adjust the number of CPUs via a custom call to a REST interface.

Next
100 seconds
4
100 seconds
4

Drag the CPU scaler up to 16 for instant, additional computing power.

Drag Slider to 16

Refresh Data
Refresh Data Sets
Reset Colors
Clear Canvas

Now refresh the report to get the updated performance stats.

Click Refresh Data

Process time dropped from 100 to just 13 seconds—now that’s more like it.

Next
13 seconds
16

You can even scale capacity down just as easily to “shut off” CPUs when your data warehouse is not in use.

Drag Slider to 0

Now you’re only paying for what you use, and only when you need.

Next

Objective 2 Complete

Nice work! Just as you’re exploring easy scaling, a request for data visualizations comes in from the sales manager. Let’s explore how quick and easy it is to build effective visualizations to gather key insights.

Start Objective 3

The sales manager needs key information about sales by product, profit, and customer segment. From the Data Visualization home screen, quickly type the queries you’re interested in to see visual results.

Type in “sales”

The smart search panel automatically suggests query results.

Click Sales

Visual results are instantly displayed. Let’s add a product filter to keep building our picture of all the information the sales manager needs.

Next

Let’s add “Product Sub Category” to the mix.

Click Product Sub Category

Notice how the visualization starts to build based on all search parameters we choose, painting a clearer picture. Let’s keep going.

Next

Click the selection to add to our visuals.

Click #Profit

Now we’re getting some really good stuff. One last query—let’s add customer data.

Next

Select “Customer Segment” add it to the mix.

Select Customer Segment

Looks great!

Now you have a complete view to send over to the sales manager—which can even be sent to any mobile device, perfect for a business traveling scenario.

Finish!

Mission accomplished!

IT

Thanks to the ease of use and power of Oracle Autonomous Data Warehouse you’ve successfully embraced the power of autonomous with Oracle.

Next step:

This simulator is only the beginning. Uncover the full potential of Oracle Autonomous Data Warehouse by signing up for a free trial.

Access the free trial
/21
© Oracle | Terms of Use and Privacy |
| Ad Choices