Triggered by both Mike Durran and the Amis Oracle OpenWorld & CodeOne review I went through the OOW18 Session Catalog. The Oracle Data Visualization Hands on Lab is an easy way to get in touch with this product. I decided to give it a quick try.
Next to this I am also trying out the Oracle Cloud. I already provisioned an Autonomous Data Warehouse Cloud database (ADWC). It could be nice to combine part of the Hands on Lab with the Oracle Cloud trial.
Impact of Social Media Campaigns on
According to Mike, the Hands on Lab material can be downloaded here.
If you attended the @OracleAnalytics Data Viz Hands On Lab at #OOW18 and want to try it at home or you missed it, you can now download the materials from the OOW Session Catalog (HOL6370) or this link: https://t.co/iTRgAsSf6D— Mike Durran (@mikedurran) November 5, 2018
The Hands on Lab material consists of a pdf with the different steps to be taken. Next to that there are two .xlsx-files with the data.
I decided to try and use Oracle SQL Developer to load the .xlsx-files into my Autonomous Data Warehouse Cloud database. This proces is relatively straightforward.
Make sure you have a SQL Developer connection to ADWC. How you should achieve that is described in the Oracle Help Center.
Via an Right-Mouse-Click, you can Import Data.
As from here it is just following the wizard and load the .xlsx-files into ADWC.
Make sure all column names are valid. In the above example ‘DATE’ is a reserveren word. Special characters, like ‘#’, also need special attention.
If everything goes well, the data is loaded into a table, specified in the ‘Import Method’. In this case it is the table: KOOLKART_SALES_DATA.
Repeat similar steps for the other .xlsx-file.
If you want to proceed with the Hands on Lab you need to connect Oracle Data Visualization Desktop (DVD) to ADWC. The Oracle A-Team has dedicated a blogpost to this process. When DVD and ADWC are connected, a Data Set can be created.
From this point onwards, it’s easy to follow the Hands on Lab.
It’s nice to see how easy various components within the Oracle stack can communicate together. This blog only covers the first 58 or so pages. I guess the other steps can be followed just as easy. If there is anything worth mentioning or when I will take a sidestep again I will post again.