InetSoft Product How-To: Building a Dashboard Using InetSoft's BI Tools

In this chapter, we will walk through the creation of a simple viewsheet. Every viewsheet is based on a worksheet, and for this example we will use a preinstalled data worksheet called ‘ProductSales’.

View a five-minute Flash demo to get an overview of what InetSoft's business intelligence software, Style Intelligence, can do and how easy it is to use.

 

 

 

 

 

The ‘ProductSales’ data worksheet returns customer and order information. It is based on the sample ‘Orders’ database. Our viewsheet will incorporate output and selection components to provide for quick analysis of this sales data.

1. Launch the User Portal by clicking Start → All Programs → Style Intelligence → Style Intelligence Examples.

2. Select the User Portal. Under the Design tab, click the ‘Visual Composer’ link.

The Visual Composer opens in a new window. The left-side panels in the Visual Composer are labeled ‘Asset’ and ‘Component’. The ‘Asset’ panel lists all data worksheets and viewsheets. The ‘Component’ panel lists all of the components available to a viewsheet.

3. Click the ‘New Viewsheet’ button. This opens the ‘New Viewsheet’ window.

4. Expand the ‘Global Worksheet’ node and the ‘Tutorial’ folder. Select the ‘ProductSales’ data worksheet and click ‘OK’.

5. In the ‘Component’ pane, expand the ‘ProductSales’ node, then drag the ‘SalesByDate’ data block from the left pane into the grid. This creates a table component and adds the data block’s columns.

6. Expand the ‘SalesByDate’ node to show the list of fields within that data block.

7. Click and drag the ‘State’ field to an empty cell in the grid. This creates a selection list that will let you specify which states’ data you want to display.

8. Now, we want to be able to specify a time period for our output. Drag a ‘Range Slider’ component from the left pane into an empty cell in the grid.

9. Link this Range Slider to the desired field: Click and drag the ‘Date’ field and drop it onto the ‘Range Slider’ component in the grid.

10. You have completed construction of your first viewsheet. Click the ‘Save’ button in to the toolbar, and save the viewsheet under ‘User Viewsheet’ with the name “Sample Viewsheet”.

11. Click the ‘Preview’ button on the main toolbar. This provides a preview of what the user will see in the Portal, and allows you to manipulate the viewsheet as a user would in the Portal.

Previous: Visual Exploration

Next: Visual Exploration with Dashboards

InetSoft Viewpoint

"The problem in so many organizations is that different management activities get disconnected. It’s very typical that people have been executing against a strategy which is no longer in place. Our strategy might not have been fully vetted. So that the goals and objectives that have been created are nonsensical. They can’t actually succeed with that strategy as it was defined. So performance management can be injected in there. So in between the notion of setting the strategy, goals, and objectives, there is a vetting process. So use modeling to actually vet the strategy to come up with multiple scenarios so that when we do set the goals, they are actually practical. In between the goal-setting and execution, that is where you have to make a real commitment, and that’s where planning plays a critical role. So you fortify that commitment process with a planning solution. So there are two ways right there, by the way, that are unique to performance management that are not really business intelligence. So the modeling capability that is used in between the vision and goal setting and then the planning solution that is implemented between the goal setting and the execution process are unique to performance management." - Mark Flaherty, CMO, InetSoft

 

 

 

 

 

 

 

 

 

 

 

 

 

More Resources:

		For ASPs Needing to Embed Dashboards
		Corporate Dashboard Industry: InetSoft
		Dashboard BI - the New Wave of Business Intelligence
		Building Dashboards and Balanced Scorecards