Category Archives: Project Management

Knowledge Area, Projects, Funding - LMD Dashboards - Part 1

In this article Leadership Management dashboard discussed how CSREES uses Oracle Portal technology for their reporting and Dashboard needs.
Joseph Barbano (REEIS-Leadership Mgmt Dashboard Project Manager) kindly sent us the link to their dashboard portal.
When you logon to the system you get to perform few setups to register with the database.
There are three subtabs that you […]

Leadership Management Dashboard (LMD) at CSREES

This Dashboards and Business Intelligence in Government describes how national program leaders at the Cooperative of State Research Education and Extension Services use a dashboard to quickly review the project status of grants awarded to the research, education and extension communities.
Building the Leadership Management Dashboard (LMD) at Cooperative of State Research Education and Extension Services […]

Various methods of creating Digital Dashboards - Part 4

Read about the
Type - 1 approach
Type - 2 approach
Type - 3 approach
Type 4: This type defines the method of creating dashboard using Excel. The data and presentation is all part of the Excel file. This is the most popular approach as it is very easy and affordable to create dashboards. It is the least favourable […]

Various methods of creating Digital Dashboards - Part 3

Read about the Type 2 Approach
Type 3: This category involves the use of some big vendor BI tool. These BI tools are quite comprehensive and come with tons of options to choose from. They provide ad-hoc reporting and easy dashboard creation options. Once installed and configured, there is often a need to define data layer […]

Various methods of creating Digital Dashboards - Part 2

This is a continuation of the Dashboard Creation Methods
Type 2: This category involves the use of some Dashboard designing tool. You need to download and install the third party software and learn their basic steps in designing the dashboards. Most often the designing tools offer variety of connection methods to the various databases and write […]

Various methods of creating Digital Dashboards - Part 1

Are you trying to build a Dashboard or a new Application?
Three are three types of Dashboard Solutions
Type 1: This category defines those tutorials where you built everything from scratch. You write your own SQL queries, database connection methods and create data files. Then you construct your own presentation layer by defining the html, XML and […]

Project Dashboard KPI - 2

Projects KPI Listing
Billable Utilization Percent
Billable Weighted Hours / Capacity Hours
Capital Cost
Project Cost eligible to be capitalized
Capital Percent of Total Cost
Capital Cost / Total Cost
Capital Project Cost
Capital Project Cost
Contract Project Cost
Contract Project Cost
Non Billable Cost
Non Billable Cost
Project Backlog
Project funding not yet accrued as revenue - unrecognized funding.
Project Book To Bill Ratio
Project Bookings / Project Revenue
Project Bookings
Project […]

Project Dashboard KPI - 1

Projects KPI Listing
Available Resource Percent
Available Hours / Capacity Hours
Billable Cost
Billable Project Cost
Billable Percent of Budget Cost
Billable Cost / Budget Cost
Billable Percent of Total Cost
Billable Cost / Total Cost
Billable Utilization Percent
Billable Weighted Hours / Capacity Hours
Capital Cost
Project Cost eligible to be capitalized
Capital Percent of Total Cost
Capital Cost / Total Cost
Capital Project Cost
Capital Project Cost
Contract Project Cost
Contract […]

Project Management dashboard

Kpi and Metrics used

Resource utilization by region
Resource open hours
Revenue by resource type

The colors are ok, nothing to drool! No Date parameters?

Dashboard Zone - Your online community for everything Dashboards