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.
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!
To begin creating a new autonomous data warehouse, let’s log into Oracle Cloud.
Click Sign In
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.
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.
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.
Drag the CPU scaler up to 16 for instant, additional computing power.
Drag Slider to 16
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.
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.
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.
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.
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.
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.
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.
Mission accomplished!
ITThanks 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