Blog

Oracle Data Visualization Cloud Service

Oracle Data Visualization Cloud Service

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:

Data Visualization Cloud Service (DVCS) (Oct 2015)

Data Visualization Desktop (DVD) (May 2016)

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:

no training or specialist IT skill required

creates rich, visual analytics intuitively

blends multiple data sources

enabling sharing of insights and stories, and collaborative working

Data Visualization Cloud Service

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

Academy

Provides access to online video guides, tutorials and help pages.

Figure 2. Oracle DVCS Academy Page

Console – for the administration of the service particularly authorisation and backup/restore

Figure 3. Oracle DVCS Console Application Role Management Page

Administration of the service is undertaken in the Console:

Snapshot – for backing up the project Catalog or recovering from backup. A snapshot can only be taken of the entire Catalog, not individual projects.

Users & Roles – for controlling permissions authorisation that determine what users can do and see.

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.

Data Visualization Desktop

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.

Figure 7. Creating New Database connection in Oracle DVD

Additionally, in DVD individual projects can be exported and imported, with the option to include the data sources within the import/export file.

Visual Analyzer

Figure 8. Data Visualization Visual Analyzer

The key features of Visual Analyzer are that:

It selects the best visualization type based on the data selected by the user

It allows multiple visualizations on a pane and highlights related data between the visualizations

Users can create complex calculation or filters based on expressions

It blends data sources together by automatically inferring connections between the data sets

Users can take snapshots of visualizations (insights) to build stories that can be presented in the Story Navigator

Additionally, by using the Stage facility, users can edit the data sources, not values but structure or format.

Figure 9. Visual Analyzer Stage for editing data source

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

Competition

Oracle believe that they have looked at competitor products, such as QlikView and Tableau, and improved upon them by enabling:

faster development (fewer clicks)

improved filtering

single pane dashboard creation

superior mobile experience

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

Other Links

Licensing

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.

Conclusion

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:

Philip is a Development Consultant at 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.