Welcome IT pro!
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.
Then, begin setup of your warehouse with the click of a 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.
Success—now let’s take a quick look and double-check our settings.
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.
Drag the CPU scaler up to 16 for instant, additional computing power.
Now refresh the report to get the updated performance stats.
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.
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.
The smart search panel automatically suggests query results.
Let’s add “Product Sub Category” to the mix.
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.
Select “Customer Segment” add it to the mix.
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.
Thanks to the ease of use and power of Oracle Autonomous Data Warehouse you’ve successfully embraced the power of autonomous with Oracle.