神刀安全网

Oracle’s New Data Visualization Desktop

A recent addition to the Oracle lineup of visualization tools is the Oracle Data Visualization Desktop. Described by Oracle as a “single user desktop application that provides Oracle Data Visualization functionality to business users,” ODVD is an easy-to-install data visualization tool for Windows 7, 8 or 10 that packs some very powerful features.

Oracle’s New Data Visualization Desktop I recently had a chance to sit down and explore ODVD and wanted to share some of my first impressions.

At its core, ODVD is a stand-alone version of Oracle’s DVCS. If you are at all familiar with Visual Analyzer, you will feel right at home.

Oracle’s New Data Visualization Desktop

Installation was a breeze on my Windows 10 VM and only took about 5 minutes and required no additional software or plugins for the standard VA functionality.

After installation, launching ODVD is as easy as clicking on the desktop icon like any other stand-alone application.

Oracle’s New Data Visualization Desktop

Oracle’s New Data Visualization Desktop

After the ODV startup, I was presented with a home screen which contains a search field for finding projects, a list of user folders and a main window to select individual visualizations that have been created.

Oracle’s New Data Visualization Desktop

Clicking on the hamburger icon in the top left corner brings up a menu where I can choose to start Visual Analyzer with the last data source selected, select new Data Sources or create a new VA Project.

Oracle’s New Data Visualization Desktop

I chose to create a new VA project and selected the sample data from Oracle (the sample data is an optional install chosen during the ODVD install process). Creating a dashboard was a fairly straightforward process. Following Visual Analyzer’s functionality of dragging and dropping columns, I was able to put together a simple sales and profit dashboard in a few minutes.

Oracle’s New Data Visualization Desktop

While creating my dashboard, I noticed that Oracle has included some new visualization types. You can now choose Scatter (Cat.), Stacked Scatter (Cat.), Donut or Sunburst visualizations.

Oracle’s New Data Visualization Desktop

Oracle’s New Data Visualization Desktop

One other feature that Oracle added to ODV is the ability to insert images onto the dashboards. You can choose to upload your own image or link to a URL to pull images from the web.

Oracle’s New Data Visualization Desktop

Oracle’s New Data Visualization Desktop

I uploaded an image and changed the canvas layout to freeform, which allowed me to move the image anywhere on the dashboard. By adjusting the transparency it is possible to have the image underlay the entire dashboard and still be able to see the visualizations. This example is pretty extreme, and in a real world scenario, caution should be used as to not obstruct the visualizations.

Oracle’s New Data Visualization Desktop

Next I decided to try to connect to my Oracle 12c sample database to pull in some new data to work with. Selecting “Create New Datasource” from the menu prompted me with three options: create from a file, from an existing app or from a database.

Oracle’s New Data Visualization Desktop

Clicking on the “From Database” option, I was presented with a connection screen.

Oracle’s New Data Visualization Desktop

On this screen I discovered one of the most impressive things about ODVD. Clicking on “Database Type” reveals a dropdown menu which you can choose from a variety of database formats, including Spark, Hive and Mongo DB, among others. Oracle’s New Data Visualization Desktop

That’s awesome.

Because I already had 12c DB installed, I selected the Oracle Database Type and entered all my connection information.

Once a connection to the database is made, it shows up in the available connections list. Clicking on my sample database brought up a list of available schemas to choose from. In this case, I chose the sample HR schema which then brings up a list of tables available to add as data sources for visualizations.

Oracle’s New Data Visualization Desktop

Oracle’s New Data Visualization Desktop

I chose to add EMPLOYEES, JOBS and LOCATIONS and then started a new VA project. The HR tables now show up in the list of available data sources.

Oracle’s New Data Visualization Desktop

I selected EMPLOYEES and JOBS and, within seconds, was able to create a simple table showing a list of employee names, their job titles, salaries and commission percentages.

Oracle’s New Data Visualization Desktop

As you can see, adding new data sources is quick and easy and allows users to explore their data and create meaningful visualizations from that data in a very short amount of time.

Another feature is the Advanced Analytics portion of Oracle Data Visualization Desktop. This feature, which uses R, gives users the ability to do things like highlight outliers or show trend lines with a click of a button.

Oracle’s New Data Visualization Desktop

Oracle’s New Data Visualization Desktop

This feature does require an optional install located within the ODV application folder. The install process proved once again to be very quick and easy and completed in about 5 minutes.

Oracle’s New Data Visualization Desktop

Oracle’s New Data Visualization Desktop

After the installation was complete, I created a new VA project. Choosing the sample data provided by Oracle for ODV, I created a quick scatter chart and then, by right clicking anywhere on the visualization, clicked “Add Outliers.”

Oracle’s New Data Visualization Desktop

Oracle’s New Data Visualization Desktop

As you can see, outliers and non-outliers are easily distinguishable by the color key that ODVD assigned automatically.

Next, I wanted to see how if I could change some of the colors in my visualization. ODVD allows you to do this under the visualization menu.

Oracle’s New Data Visualization Desktop

Oracle’s New Data Visualization Desktop

Oracle’s New Data Visualization Desktop

As with OBIEE, entering specific hex values is supported as well as selecting from pre-made color pallets is possible with ODVD.

Using the same right-click functionality that I used for adding outliers, I was able to additionally add a polynomial trend line to show a gains and losses.

Oracle’s New Data Visualization Desktop

Next, I decided to see if I could export this data and import it into Excel. Choosing export from the visualization menu, I was able to easily export the data as a .CSV and upload it into Excel.

Oracle’s New Data Visualization Desktop

Overall, Oracle Data Visualization Desktop is a very impressive new addition to the to the DVCS lineup. The ability to collect data from multiple sources, its native adaptors for a variety of popular databases, and the ability to manipulate visualizations to convey the data in creative ways make it a strong contender against Tableau and Wave. It requires no remote server infrastructure and is a solid business solution for users Oracle Data Visualization functionality in a small and easily accessible package.

I feel as though I have just cracked the surface of everything this tool can do. Check back for future blogs and articles as we at Rittman Mead continue to explore the possibilities of ODV. The future of data visualization may be closer than we think.

If you would like more information about Visual Analyzer or the Oracle Cloud Service, see this blog post by Mark Rittman.

If you would like to watch the official Tech Demo of ODV, you can find it here .

Rittman Mead also offers in depth professional training courses for OBIEE 12c and Visual Analyzer.

转载本站任何文章请注明:转载至神刀安全网,谢谢神刀安全网 » Oracle’s New Data Visualization Desktop

分享到:更多 ()

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址