Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« Introduction to Oracle Analytics Cloud - OAC | Main | Getting Started with People soft Campus Solution »

Data Visualization in OBIEE 12c

Backdrop

Data visualization is the presentation of data in a pictorial or a graphical format which takes care of a complex problem that could be easily overlooked and makes things easier using graphs, patterns, and design. It is useful in converting real-time data into rich reports and visualizations. Effective data visualization should be informative, efficient, appealing, and in some cases interactive and predictive.

It enables us to see analytics presented visually which helps us to grasp difficult concepts / identify new patterns easily. With interactive visualization below are the possibilities: drill down into graphic representation and diagrams for more detail; interactively altering the data and how it's processed.

Data visualization also has benefits:

1. Absorb information in new and more constructive ways.

2. Visualize relationships and patterns between operational and business activities

3. Identify and act on emerging trends faster

4. Manipulate and interact directly with data

5. Foster a new business language

In the sections below, we would be explaining how it adds value to Organization.

How it can be used?

Advanced data visualizations support more in-depth and complex analytics. A visual tier that sits on top of the analytics program allows users to view the results of complex algorithmic processing. Not only can they get insight into what's happened, they can forecast what might happen, using rich graphics to quickly derive business actions. The fact is, when people transition from spreadsheets to data visuals, they are able to register the values they are seeing as a whole.

Consider the below table showing traditional reporting:

obiee1.png

Now consider the ability to visualize every line above like below. A simple visualization can make the boring data come alive:

obiee2.png

One is about putting the emphasis on the data. The other is about the shape and patterns of the data requiring our sense of sight. We need both for better decision making.


What is the Scope of Data Visualization in OBIEE?

The basis of OBIEE has supported BI Cloud service for a long time and with the arrival of data visualization offered in OBIEE 12c, it is at the same level with other bigger tools such as Tableau and Qlick View. The tools work with the support of various cutting-edge techniques, for example, overlapping, brushing, outliner selection and other developments.

obiee3.png

Conclusion

obiee4.JPG1. Easy to Use- OBIEE 12c is reasonably easy to use, users can examine data by either overlapping it on a geographical map or by decoding the dashboard visuals by choosing outliners.

2. Uploading Mash Up- OBIEE 12c comes with a technique called data mash-up which makes the task of uploading the data online and creating the report easier. Users can self-perform tasks like uploading files and data sets or building ETL process without taking support from IT professionals. 

3. Simple export- In OBIEE 12c RPD is presented without changing the target system connection pool details, so the export and migration of data sources don't need the connection to the pool folder data.

4. Additional Features

·         Data visualization allows the users to use the results from current OBIEE reports.

·         Data can be sourced from external databases.

·         Users can edit columns, create new calculations, etc. on the uploaded data.

·         Upload limit of the data file has been increased to 50MB.

·         Color Schemes can be modified which and has the choice to change the entire dashboard or only change individual visualizations.

·         Allows users to add text boxes to their data and comments on other users.

·         The Presentation Mode permits to insert a Data Visualization project into an OBIEE Dashboards and hides the editor components since projects can be made read-only which let the report to function almost like a "classic" OBIEE dashboard reports.



Authors:

Sathya Bhama & Smriti

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles