Oracle Analytics Cloud and Server

Products Banner

Oracle Data Visualization

Received Response


Rearrange the data elements



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. 




  • 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.


    Mahesh K

  • "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
    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.


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


  • thank you for you valuable comment. 


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

  • 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