Using an Excel Spreadsheet as a DV Desktop Data Source

Oracle Data Visualization (DV) Desktop allows you to bring in your own data from an Excel file and to use this data as a source for visualizations.  In this case, I compiled a basic spreadsheet of sample Major League Baseball (MLB) attendance data. I uploaded this content to DV Desktop and created visualizations using the data as a demonstration of how you can do this:

  1. Start up the “DV Desktop” tool and go to the “Create Project” link:

  1. Once there, it prompts for a data source. Select the “Create Data Source” button in the top right corner:

  1. After finding the source Excel file location, DV Desktop quickly looks at the data and recommends what would be the best data type for each column. In some cases, the user might have to go in and change those data types. In this case, the “Attendance” column came in as an attribute column with an integer data type. To change this, you can select the “Settings” icon when you hover over the column name. I changed the “Attendance” column to be treated as a measure so that I could build visualizations from the data.

  1. After setting all of the columns to the correct data type to make sure the data is treated correctly (“Measure” or “Attribute”), I clicked the “Add” button in the top right corner:

  1. The application creates a list of columns from the Excel file in your “Data Elements” tab on the left-hand side of your screen:

  1. Next, I built a bar graph showing the attendance in the MLB from the year 2016:

In summary, there are many different data sources that DV Desktop can use to create visualizations. Excel spreadsheets provide a very easy way to bring data together into a table and to get started. Whether extending existing data models or creating on-the-fly visualizations, DV Desktop and Excel spreadsheets are a great combination to get the job done.

#oracle #DVDesktop #CameronRoss #BusinessIntelligence #BI #OracleDataVisualizationDesktop