Drag and drop an Excel file
This article shows you how to display data from a Microsoft Excel file using simple drag-and-drop operations in Dundas BI.
Related video: Using Excel as a Data Source
2. Drag an Excel file to the EXPLORE window
For this example, create a new dashboard from the main menu, and use the blank dashboard template.
Locate your Excel file in Windows Explorer.
Drag the Excel file from Windows Explorer and drop it over the EXPLORE window in Dundas BI.
The Excel file is automatically imported into Dundas BI as a data connector.
Expand the Data Connectors folder in the EXPLORE window to see the auto-generated data connector which corresponds to the Excel file. You can further expand the data connector to see the column structure of the Excel sheet.
Drag the Excel sheet from the EXPLORE window to the dashboard canvas. A table visualization appears which displays the contents of the Excel sheet.
3. Drag an Excel file directly to the canvas
Optionally, you can drag an Excel file from Windows Explorer and drop it directly onto the dashboard canvas (in Edit mode) instead of the EXPLORE window. The Excel file will also be added as a data connector automatically, and a corresponding table visualization will appear on the canvas.
4. Remove a column from the table
Right-click over the table visualization. From the menu, select Data Binding Panel.
In the Data Binding panel, remove the 'x' column by clicking the delete icon to its right.
5. Replace date column with time hierarchy level
Expand the Time Dimensions folder in the EXPLORE window.
Expand the default time dimension and also its first hierarchy.
Drag the 'Month' level of the hierarchy, hover over the table visualization, and then drop it onto the existing 'date' column in the ROWS field of the Data Binding panel.
The table visualization is updated automatically to show month names in the 'date' column.
6. Re-visualize as a bar chart
Finally, select the table, click Re-Visualize from the toolbar, and then click Bar. The table is now displayed as a bar chart with month names along the X axis.
Dragging and dropping a file to the application will upload the file.
- Changes to the original file will not affect the generated data connector. To refresh the data based on the changes made in the original file, specify a UNC path in the data connector settings. See Connecting to Excel for more information on connecting to an Excel file.
- An uploaded file will be automatically warehoused after the first use to improve performance.
- You can download an uploaded file. Right-click the checked-in data connector in the Explore panel and select Download File.