Articles Comments

Free Excel Dashboards » Dashboard, Excel Dashboard, Excel Dashboard Software » How to build Excel Dashboards – 3

How to build Excel Dashboards – 3

Previous step : Excel Dashboards – 2

Create Dashboard and Table portlet

Once connected, it will show you a list of action items to pick from

Image

We will click on “New Blank Dashboard

In the Dashboard Name, we type in “Order Management Analytics”

Image

Click OK.

It will present you with a table browser showing all the available worksheets as tables

Image

Expand the node to see all the worksheets.

In this example file, we just have one worksheet named “order_data”. Note how, it attaches a $ sign at the end, which indicates this is an Excel Worksheet.

So make sure you do not have any dollar sign when naming the Excel worksheet and no other special characters and no white or blank characters. Replace blank characters with “_” underscore character

Double Click on the “order_data$” node

Image

Click on the “* alias=ord” item at the very top to select all the items

Image

You may change the name of any column or any other property such as sort and group by.

We will leave it as it is and click on the “Create Table” button.

This action creates a Table Portlet (Qlet) in the Dashboard canvas

Image

We will use this Qlet as our basic building block for the following exercise

Next : How to build Excel Dashboards – 4

For more information visit How to build Excel Dashboards – 3

No related posts.

Related posts brought to you by Yet Another Related Posts Plugin.

Filed under: Dashboard, Excel Dashboard, Excel Dashboard Software

Comments are closed.