Dashboard

I. General Feature Description

Dashboard aggregates multiple project files (either located on your machine or online) in a virtual master project to help you get a higher-level perspective on your projects. It offers the advantage of bringing projects together in order to analyse them, without having to manually insert them as subprojects into a master file expressly created for this purpose. The feature is especially useful to observe resources – it is actually a frequent scenario that in overlapping projects considered individually resources are not overallocated, but when considered as a whole, shared resources across multiple projects are assigned to more work than the normal working capacity.

 

II. Prerequisites

However, for optimal results you must make sure, before creating a dashboard file, that your projects are uniform and that they respect the following prerequisites:

1.  Resources
Resources shared across multiple projects must be identical in all projects (Name, Calendar, Max. Units, Std. Rate, Ovt. rate, Cost / Use, etc.) in order to be correctly aggregated.

2.  Calendar Options
All included projects must have the same calendar options.

3.  Scheduling
Work must be entered in the same unit type in all projects (and selected as Work Unit in the New Dashboard dialog).

4.  Currency
All projects should have the same currency (and selected as dashboard Currency in the New Dashboard dialog). If a different currency is selected, no conversion will be performed.


 

III. Step-by-step How to Use Guide

In this section you can see a complete scenario meant to demonstrate the Dashboard functionality. Let us assume we have 3 project files:

 

III.1. Create a new dashboard file with Housatonic Project Viewer

image1.png


 

After entering the product, you need to access the Dashboard menu from the menu bar:

image2.png

You will then be presented with the New Dashboard dialog:

image3.png

On the left side of the dialog, projects need to be selected. Currently, local and online files are supported so either hit Browse to select a file on your hard drive, or choose Online from the dropdown list and input the file URL (starting with http:// ). According to our scenario, after selecting the projects, this side of the dialog will look as follows:

image4.png

Now that the files are selected, we need to configure the Dashboard settings, according to the projects’ settings and the viewing preferences. The default Dashboard view is Task Sheet and it is also the only one that allows choosing the columns to be displayed on rendering.

image5.png

Dashboard Settings:

  • Dashboard Name – the name of the dashboard project (if left blank, dashboard will be set by default).
  • Dashboard View – one of the main views: Task Sheet, Gantt Chart, Tracking Gantt, Task Usage, Calendar, Resource Sheet, Resource Usage, Resource Graph, Team Planner, Network Diagram.

    Currency – allowed currencies are USD, AUD, BRL, CAD, CHF, CNY, DKK, EUR, GBP, HKD, HUF, JPY, MXN, NOK, NZD, RON, SEK, ZAR. All projects should have the same currency and this is the currency you have to select here. If a different currency is selected, no conversion will be performed.
  • Currency Symbol – the corresponding symbol for the currency selected above.
  • Duration Units – Minutes, Hours, Days, Week, Months. The default duration unit is Days. It is recommended for this setting to be the same with the ones in the compound projects.
  • Work Units – Minutes, Hours, Days, Week, Months. The default duration unit is Hours. It is recommended for this setting to be the same with the ones in the compound projects.

Dashboard Columns:

The default columns are those of the Entry Table:

  • Name
  • Duration
  • Start
  • Finish
  • Predecessors
  • Resource Names

To add to this list, you need to select a column from the left list and press the " > " button. To exclude a column, you need to select it from the right list and then press the " < " button. If you are content with your options, simply hit Enter or press the View button:

image6.png

image7.png


 

You will initially see the dashboard project summary, along with the projects' summary tasks, which you can expand afterwards if you please.

The Dashboard summary Start is given by the earliest Start date of all its subtasks. The Finish is given by the latest Finish date.

You can now browse through all the available views, like with any regular project file.

 

III.2. Saving a dashboard configuration file

You might have noticed a Save option in the New Dashboard dialog. As entering the project paths and settings every time for each session can get a bit tedious, you have the option of saving a custom XML file containing all these pieces of information, so that the next time all you will have to do is to open this file.

You don't have to worry if you didn't do this from the beginning. If you re-enter the Dashboard menu, you will see that all the fields in the dialog are restored to their last values.

The Reset button will restore all the fields to their default value (i.e. no project files selected, default settings and columns).

image8.png

image9.png

The default file name is the one you chose in the New Dashboard dialog, but you can set another name if you want to.


 

III.3. Open a previously created dashboard file

In order to open a dashboard file, you need to enter the Dashboard menu and press the Open button in the New Dashboard dialog. Then, you need to browse on your local hard drive for a saved dashboard file.
 
image10.png

image11.png


 

This will have the same result as creating the dashboard from scratch and choosing View. You can always go back to the dialog and change dashboard settings or add more projects if you want to. Save is only necessary when you want to review the dashboard in a future session. 

III.4. Exporting a dashboard project

If you want to see your dashboard in application, you need to export it, as a project. In order to accomplish this, you need to enter the File and choose Export Dashboard.

image12.png


 

image13.png

A dashboard project suitable for the Project Plan 365 application is a regular XML project file which contains additionally some dashboard preferences regarding the default view and the columns that will be displayed. The dashboard export is done in an what-you-see-is-what-you-get manner, meaning that the view and columns shown at the moment of the export will be those displayed when importing the dashboard project.

The default name for saving is the dashboard name + the suffix “_project.xml” to make it easier to differentiate between the dashboard configuration file which only contains the project paths and preferences and where all the indicated projects are loaded and processed on every opening and theactual dashboard project which is already processed and can be exported to xml format, like any other project, but with some preferences stored, in order to make it easy for you to visualise the projects as you want to, without additional effort. Please do not confuse these two formats.

 

III.5. Opening a Dashboard project in Project Plan 365

You can access Project Plan 365 either by installing it as a server-side application, or by going to  its online address (http://projectplan365.com/pp365/demo.html).


 

Choose the view only option.

image15.png


 

From the main menu, Click on Dashboard and then Open Dashboard:

Then simply browse for your dashboard project (My Dashboard_project.xml from the section above)  and click View Dashboard.

image17.png


 

image18.png

And here is the Dashboard project, with the viewing preferences (view and columns) at the moment of exporting it from Housatonic Project Viewer.

 

IV. Feature Applications

IV.1. The main purpose of the Dashboard feature is getting a higher-level perspective on your projects:

image19.png

Overall duration, costs and work, as well as actual / remaining values of these fields can provide a project manager with an up-to-date global assessment of how the projects are going according to plan. Dashboard makes all these easy to keep track of.


 

IV.2. The Dashboard feature is also particularly helpful for observing your resources and their assigned work at global level, as well as overallocations of shared resources across multiple projects:

Let’s take a look at the resources’ situation in the three projects used in our scenario:

1. ExpoClock.mpp

image20.png

2. Egypt Artifacts Expo.mpp

image21.png

3. Italian Paints Expo.mpp

image22.png

In each project, Tehnical Personal is the only overallocated resource. But looking at the dashboard Resource Sheet, we see that all the work resources are overallocated, at global level:

image23.png

Overallocations at dashboard-level can be analysed in depth by using, for instance, the Resource Usage view:

image24.png

or the Team Planner view:

image25.png


 

It has never been easier to get an overall assessment of projects indicators and stats and keep an eye on resources shared across different projects than using the Project Plan 365 Dashboard feature.