ITIL / Dashboard / KPI etc

[Benny]

So it's a Saturday, I'm cool, I'm thinking about work.

Given a back end database that is accessible via SQL query how would I go about constructing a page that pulled information from there and presented it in graph format on screen and could be drilled into.

Open tickets, status, who has most, resolved in the last day/week etc.

Is PHP the answer with sql and a web front? or is there some easy way for me to do it with a piece of web creating software I haven't got? Dreamweaver etc?

An example is;

[OldBloke]

I've witten ASP dashboards for work where we have managers who are anal about stats. :sideways:

They're easy enough to create using ASP/PHP. It's the graphical elements i.e. graphs and dials that take the time and, if you don't have access to something like Swiff Chart (by Globfx), can be fiddly to code (I used the Office Web Components and that's truly fiddly).

PHP is probably easier becuase of the raft of Open Source gizmos designed to help.

In addition, Dashboards have to be 'current' so either page refeshes are necessary or client side refreshes using AJAX.

[Gone_Away]

mmm me likes pie. dashboards..