In recent months Oracle has extended its portfolio of data analytics solutions. Building on the availability of Data Visualization Business Intelligence Cloud Service in recent months it has released new versions:
The new releases are targeted at the growing market for business users buying software and is intended for those starting out with analytics, but offering the potential to grow into Business Intelligence Cloud Service down the line.
Oracle’s research informs them that business users are demanding faster response times to data questions and seek greater self-service. DVCS and DVD provide powerful analytics accessible to everyone:
DVCS home page displays Visual Analyzer projects currently in the current user’s folder, and provides access to key functionality via badges.
Figure 1. Oracle DVCS Home Page
Provides access to online video guides, tutorials and help pages.
Administration of the service is undertaken in the Console:
The most important of these is arguably the Users & Roles. The foundation of authorisations within DVCS is the management of Application Roles.
Three pre-defined application roles are provided; Viewer, User, Administrator, with one inheriting characteristics of its parent
|Application Role||Description||Inherits From|
|Administrator||Delegate privileges – access to console to perform administrative tasks||User|
|User||Create visualizations, explore and load data (including with Rest API and Data Sync)||Viewer|
|Viewer||View and run visualizations||N/A|
Custom application roles can be created based on the pre-defined application roles, to suit organisational requirements. Users are then associated to these application roles.
It is via application roles that access to VA projects and data source is controlled.
The key purpose of the Catalog page is to set permissions on folders and projects within those folders to control which users can access those projects.
It is here that data sources for use in Visual Analyzer projects can be accessed. Data sources can be established directly from:
Figure 5. Creating New Data Sources in Oracle DVCS
Alternatively, data can be transferred to DVCS using alternative methods:Data Sync – schedule to create/refresh data from:
It is also in the Data Sources page that permissions to data sources are set, determining which users/roles can access the data underpinning VA projects.
There are obvious similarities between DVCS and DVD but there are differences between the current set-ups.
Figure 6. Oracle DVD Home Page
The first thing to notice is that there is no Catalog or Console for the desktop version. Because this is a single-user on-premise installation, obviously there is not the same facility for sharing data and projects, so there is no requirement for these areas of functionality.
However, DVD includes direct connectivity to databases, unlike DVCS.
Additionally, in DVD individual projects can be exported and imported, with the option to include the data sources within the import/export file.
Figure 8. Data Visualization Visual Analyzer
The key features of Visual Analyzer are that:
Additionally, by using the Stage facility, users can edit the data sources, not values but structure or format.
VA within DVD and DVCS is broadly similar, although there is some additional visualization types in DVD, including Image, which allows uploading of images or creating URL links to reference externally hosted images.
Additionally DVD offers Advanced Analytics, which includes the ability to highlight outliers or overlay trend lines.
Figure 10. DVD Advanced Analytics
Oracle believe that they have looked at competitor products, such as QlikView and Tableau, and improved upon them by enabling:
Also, Oracle hope to introduce businesses to DVCS or DVD, in the knowledge that Oracle’s portfolio can scale with organisations’ needs and ambitions. Organisations will be able to grow into other products in the portfolio e.g. BICS (includes Data Visualization) or OBI 12c & Data Visualization
Both DVCS and DVD are available to use to trial / evaluate:
Oracle are currently offering a perpetual single user license for Data Visualization Desktop.
Data Visualization Cloud Service is currently licensed based on on an operational cost per month per user, with a minimum of five users.
However, DVD is packaged at no extra cost with DVCS (or BICS), so customers who subscribe to it, currently can receive a matching number of DVD licenses at no extra charge.
Oracle Data Visualization offers some attractive features to help users understand their data and share appealing visuals.
Currently, DVD and ODVCS offer slightly different functionality to each other (e.g. connectivity, advanced analytics). However, Oracle intend that from later this year all versions of DV will be synchronised, which will mean DVCS users will be able to take advantage of the additional functionality available in DVD.
In the coming weeks and months I will provide updates as I delve a little deeper into specific areas of functionality such as:
Author: Philip Ratcliffe
Job Title: Oracle APEX Development Consultant
Bio: Philip is a Development Consultant at DSP-Explorer. Building on considerable experience in development including using Oracle PL/SQL and supporting Oracle EBS, Philip is employing APEX to provide quality, bespoke software solutions to a range of organisations.