If the answer is No then what other software you suggest to use to create dashboard with speedometer, I tried it with Excel but it is very hard, looking for easier dashboard where it will move the dial as more input values added Saving Changes...
MS Excel can be used (pie chart with some modifications to the line formatting). But it is a cumbersome process which is not easily replicable in future scenarios.
I often use one of these reporting tools to give me the number and then manually graph the velocity half-pie chart speedometer in MS Powerpoint. Once you have the base semicircle prepared there, all one has to do is to rotate and recenter the arrow.
...
1 reply by Riyadh Salih
Apr 30, 2018 12:10 AM
Riyadh Salih
...
Karan, well said and that's exactly what I have done on excel using double pie chart, but i was wondering if that can be done during reporting on MS project
If you are using the server version of MS Project, as there is a SQL back end database, any BI tool which has dashboard support would work.
But I'd ask the question, why a speedometer? Projects rarely have "real-time" updates the way a transaction processing system will, so what would a speedometer show which a more traditional bar chart or line chart couldn't?
Kiron
[But I'd ask the question, why a speedometer? Projects rarely have "real-time" updates the way a transaction processing system will, so what would a speedometer show which a more traditional bar chart or line chart couldn't? ]
For my projects, it's a visual of the current velocity. With colours for slow, could-be-faster, on-track, or supercharged velocity. An arrow shows which colour wedge the project is currently on.
This is primarily used for periodic meetings with the more senior stakeholders (internal or external) and is complemented by a line graph. They don't have to measure and calculate slopes in the velocity chart. I have, therefore, found it to be more useful when stressing on a specific point where help is needed (resources need to pick up their pace, changes to backlog need to be discouraged, we are overstretching ourselves and output quality is a risk, etc.). Saving Changes...
If you are using the server version of MS Project, as there is a SQL back end database, any BI tool which has dashboard support would work.
But I'd ask the question, why a speedometer? Projects rarely have "real-time" updates the way a transaction processing system will, so what would a speedometer show which a more traditional bar chart or line chart couldn't?
Kiron
Kiron, we have few stakeholders who like fancy scoreboard so they like the idea when you change values the needle moves on three different colors (area on speedometer) Saving Changes...
MS Excel can be used (pie chart with some modifications to the line formatting). But it is a cumbersome process which is not easily replicable in future scenarios.
I often use one of these reporting tools to give me the number and then manually graph the velocity half-pie chart speedometer in MS Powerpoint. Once you have the base semicircle prepared there, all one has to do is to rotate and recenter the arrow.
Karan, well said and that's exactly what I have done on excel using double pie chart, but i was wondering if that can be done during reporting on MS project Saving Changes...
If you are using the server version of MS Project, as there is a SQL back end database, any BI tool which has dashboard support would work.
But I'd ask the question, why a speedometer? Projects rarely have "real-time" updates the way a transaction processing system will, so what would a speedometer show which a more traditional bar chart or line chart couldn't?
Kiron
Kiron, many projects I know they do require real time data (tick by tick) Saving Changes...
