Select Page

Art of BI: Oracle BI 12c and Data Visualization

Sherry Milad | | April 21, 2016

There are many things to be considered when you’re implementing a net new implementation of Oracle BI 12c or upgrading to OBIEE 12c from 11g. A new data visualization feature of Oracle BI 12c is one of the key features that may help change the speed of moving to Oracle BI 12c from a walk to a brisk jog. Even though the Oracle BI 12c Data Visualization component (also known as Visual Analyzer) may have additional licensing considerations, it is almost impossible to separate associating the vast features of Data Visualization from any Oracle BI 12c discussion.

So what do you get with OBIEE 12c separately from Data Visualization?

Almost the same thing you get with every upgrade of OBIEE, the sleeker new look, better performance and well, a noticeably smoother upgrade process with the Baseline validation tool, and an interesting new Administration and life cycle management setup. The Metadata is now separated from the configuration giving way to a simpler, more robust security, and easier backup, restore and disaster recovery. There’s of course many more subtle new features.

However what stands out with the Oracle BI 12c release is the Oracle Data Visualization component, along with the many incredible features associated with it. I do want to highlight again though that there may be some additional licensing features associated with OBIEE 12c for the full Data Visualization Visual Analyzer functionality.

Not only does Oracle Visual Analyzer provide a “self-service” visual tool, where you have all your attributes and metrics on one side and just drag and drop them onto your work pane to create and view numerous visualizations instantly, (you can even select recommended visualizations to explore all the new ways Oracle recommends viewing your data!) but the best part, in my opinion, is the Data Mashup capability. This gives the user some flexibility to no longer be tied down to only the IT department’s development timeframes or a reliance on ETL development efforts in order to view their ancillary datasets. Prototyping with data and Excel files becomes a joy, and a layer of business user bliss is achieved.

In the early preview releases of OBIEE 12c, before it was GA, Oracle showed the “Mashup” feature as a part of the answers/analysis editor, allowing you to upload your own external data source (in excel format) and use it as a standalone subject area for creating your own reports from it directly or combining it with other existing subject areas – thus “mashed up” with other data. For now this feature seems to only be available through the Data Visualization license, but things may change down the road. I guess we’ll have to wait and see what other visualization and mashup concepts are ahead for Oracle Analytics.

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS:could not resolve the connect identifier specified” Oracle error is a commonly seen message for database administrators.

Vijay Muthu | February 4, 2021

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

12c Upgrade Bug with SQL Tuning Advisor

Learn the steps to take on your Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.