In this article, I will demonstrate how to create a dashboard on a blank slate using InfoCaptor: Rapid Dashboard Designer

Pre-requisites :

You should have already installed Dashboard Designer

Here are the list of tables (Dimensions and Fact) that are going to be used in the exercise.

Product Dimension

Store Dimension

Time Dimension

Sales Fact

This Sales Fact table contains columns that are mapped to the Dimension table using their keys e.g Product_key, Store_key and Time_key.

The sales fact table contains all the transaction that take place at a very detail level. In order to get information out of this detailed fact table, there are a few summary tables which maintain a high level aggregation of the detailed transactions.

We will keep the summary tables out for now. Let us just go with the bare basics of a simple data-warehouse star schema (one fact surrounded by three dimensions)

In our dashboard there will be 3 parameters and one portlet showing the Fact information to begin with. The dimension tables will map to the parameters of the dashboard.

Here is a rought sketch of how our initial cut of the dashboard will look

So lets begin..

Next