Page History

Reports/Dashboard menu will be displayed as Dashboard if the installation has Dashboard license else it will be displayed as Reports

Accessing Dashboard

1. Log into ProTrack Warehouse.

2. Select Dashboard from the Reports drop down menu

3. Dashboard screen has three sections:
   
   • Analytics
   • Pulse
   • Notification

Analytics

Fig 1 Dashboard Screen - Analytics

Pulse

Clicking on will show the pulse.

Notification

Clicking on  will show the notifications

How to use Dashboards

The Dashboard provides the user the ability to see information at any level with full drill down capability.

How to create a new Dashboard

Dashboard Designers can create dashboards from the Analytics page where all your existing dashboards are displayed.

 Create a New Dashboard

1. Click + to create a new dashboard on the Analytics page.
   
2. In the Data Set field, select the ElastiCube model to which you want to connect. If you’ve completed Step 1 – Connect to Data, select ‘Tutorial’ in the Data Set field, otherwise choose ‘Sample ECommerce’.
3. A default title name matching the ElastiCube model name will be given to the dashboard. Feel free to change it.
   
4. Click Create.
   Now that you have a dashboard, you can start adding widgets to it.

2 – Create Your First Widget: Sales Trends

Create your first widget to get a general idea of your sales performance.

1. Click Select Data on the left side of the screen:
   
2. A list of available fields will be displayed grouped according to the table they belong to. This window is called ‘Data Browser’, and lets you easily find the fields available in your ElastiCube model. Select the ‘Revenue’ field:
   

Now you immediately get a ready made widget that shows you all revenue to date. We call this kind of widget an “Indicator”.

But to understand revenue over time, add a time field to the mix:

1. Click + Add More Data:
   
2. In the data browser, hover over the Date field and click More… Then select Quarters:
   
3. Click Create to add the line chart widget to the dashboard.
   The revenue trend is also positive showing annual growth, so now go ahead and explore what’s driving this growth. It would be interesting to uncover profitable product categories.

3 –

Now try to understand the interaction of cost and revenue to discover the most profitable product lines.

1. On the top of the dashboard click Image Removed.
2. Click Select Data and select the ‘Category’ field.
3. Click Add More Data and select the ‘Revenue’ field.
4. Click Add More Data again and this time hover over the ‘Cost’ field and click More… > Average.
5. Now select the scatter chart icon Image Removedfrom the widget buttons on the left, and click Create.
   Image Removed
   It’s simple to see that product categories on the right generate the most revenue and those products in the lower left have the lowest cost and revenue. Hover over each scatter point to see the category behind it, to discover that Cell Phones and PDAs generate most of the revenue.
   You now understand which product lines to sell, but to get a complete view of your market, you need to identify optimal customer segments to target in each market – start by creating segments based on age.

4 – Creating Pie Charts to Visualize Customer Segmentation

Image Removed

Image Modified

1. You can clearly see that customers between the ages of 65+ are the most valuable in terms of the revenue they generate. This insight can be used to focus advertising budgets and develop unique campaigns to grow these customer segments. Now, you can turn your attention to identifying which markets are growing at the quickest rate.

5 – Creating a Map to See Market Growth

Before you focus on growth, you should focus on a specific year first, by adding a filter.

The Filter panel on the right of the dashboards lets you add dynamic filters to the dashboard.

1. Click Filter Your Dashboard on the right side of the dashboard.
2. In the Data Browser, click on the Date field.
3. Click the multi/single selection button Image Removed to make it a single selection filter.
4. Leave only 2013 selected, and click OK.
   Image Removed
   Your dashboard is now filtered to show data only for the year 2013.
   Now create a map:
5. Click Image Removed at the top of the dashboard.
6. Click Select Data and select the Country field.
7. Click Add More Data again and select the Revenue field.
8. Click on the scatter map button type Image Removedon the left.
   Now you see a map, where the biggest circles represent the countries with the highest revenue. But if you want to concentrate on the markets with the biggest growth in revenue, its easy:
9. Hover and click to open the menu of the Total Revenue field and select Quick Functions > % Change Over Time > Growth.
   Image Removed
10. Click Create.
    Now the biggest circles on the map represent countries with highest growth. You can see for example that the United States is very hot right now. You can use this information to focus resources as well as further analyze these markets to understand revenue drivers.

6 – Rearrange the Widgets in the Dashboard

You can rearrange the dashboard by dragging and dropping, and resizing the widgets. Dragging one widget on top of another splits the area in the dashboard and allocates space for both widgets.

See this animation to get a feeling of how to rearrange widgets:

Go ahead and rearrange your dashboard however you see fit.

You can now easily see all four visualizations showing sales trends, product mix, customer segments and fast growing markets. You can explore and drill into the details to get further insight.

7 – Filtering and Drill Downs

In our pie chart we can clearly see that our strongest age range is 65+. Let’s explore this age range a little more:

1. Click the 65+ slice in the pie chart.
2. As a result, a new filter is added to the filter panel on the right, and the entire dashboard is now filtered to focus on this age range.
3. Taking a look at the updated scatter chart, you can see that Monitors are by far the most revenue generating category for this age range.
4. Right-click the 65+ slice in the pie chart and select Drill Into… from the menu.
5. A Data Browser will pop up, letting you select any field to drill into. Click on the Brand field.
6. You can now see which brands contribute the most to the revenue of your selected age range.
   You can make direct selections by dragging the mouse over the points that interest you in the scatter and line charts as well.

How to add Pulse

How to add Notification