Oracle Data Visualization

Ruqaya Al Jaafreh

Summary

Rearrange the data elements

Content

Dears, 

I am a beginner in using ODV and  I want to analyze a financial report.However, I have an issue in the preparing data stage which shows the unnecessary data like number of years in data elements and hide the major headlines with no name as shown in the attached images. 

Note that the report list the titles like ( revenue, profit, cost of goods sold, ...etc) as rows and flowed by their sub-titles. 

please guide. 

nandoo007

Hi,

I am guessing your source is a file ie not connected to a database.

If the data source is file - Oracle docs clearly mentions that you can only use .xlsx or CSV or Text files.

In case of Excel files that data source should have -

  - content in data-oriented way, no pivot tables

- must have a regular layout with no gaps or inline heading

- Row1 must contain column names

- Row2 onwards should contain data -

If you reformat the data source in ODV compatible way you should be able to visualize the content easily.

 

Regards
Mahesh K

Gianni Ceresa

"Please guide" ? Guide you to ... what?

You used an Excel file as source, but your excel file isn't a dataset, it is a formatted file (containing at least a pivot but more probably something really formatted), right?

That's not what a datasource is supposed to be, an Excel file used for DVD is more just a table, without any formatting and as Mahesh K said, composed by columns with headers etc.

So use an appropriate source or format your Excel first to be a datasource and not a report.

FPonte

Hi Ruqaya.

Sorry but I don't think you will be able to do much with the file you have as it looks like is already in a reporting format.

You may need to prepare the data to a more tabular view before using in DV. Even before using Data Flows withing Oracle DV.

If you want to improve you skills on Oracle DV check this.

Oracle® Fusion Middleware User’s Guide for Oracle Data Visualization Desktop

Best of luck.

Fernando

Ruqaya Al Jaafreh

Thank you for your valued comment. How can I reformat the data in ODV? 

 

Ruqaya Al Jaafreh

thank you for you valuable comment. 

Ruqaya Al Jaafreh

 

Thank you for your valuable comment. Yes, I noticed later the data sheet was already formatted. 

Ben Cryer

Data visualization has become the de facto standard for modern business intelligence (BI). The success of the two leading vendors in the BI space, Tableau and Qlik — both of which heavily emphasize visualization — has moved other vendors toward a more visual approach in their software. Virtually all BI software has strong data visualization functionality.

Data visualization tools have been important in democratizing data and analytics and making data-driven insights available to workers throughout an organization. They are typically easier to operate than traditional statistical analysis software or earlier versions of BI software. This has led to a rise in lines of business implementing data visualization tools on their own, without support from IT.

Data visualization software also plays an important role in big data and advanced analyticsprojects. As businesses accumulated massive troves of data during the early years of the big data trend, they needed a way to quickly and easily get an overview of their data. Visualization tools were a natural fit.

Visualization is central to advanced analytics for similar reasons. When a data scientist is writing advanced predictive analytics or machine learning algorithms, it becomes important to visualize the outputs to monitor results and ensure that models are performing as intended. This is because visualizations of complex algorithms are generally easier to interpret than numerical outputs. more