Actual Proof of Concept dashboard (published with approval Philips). Global dashboard with emphasis on Healthcare Sector.
KPI’s monitored are: Sales, Gross Margin and EBITA. Data is based on actual data from a certain year, for POC purposes the actual current month is April 2009. Actual dashboard connects to SAP BW queries and shows a table specifying the latest refresh time per dataconnection. The image of a magnifying glass located within a chart area signifies a dril functionality.
In tab “Overview” the dril works for months in current year (2009) of the “Actual Sales” chart and is set up for the “Sales Growth” gauges. In tab “Sales” the dril works for sectors in “Sales to thirds per sector” chart and is set up for the “Sales to thirds per Business” chart and “Sales Growth” gauges. The combo box specifies the month. In tab “Gross Margin” the dril works for sectors in “Gross Margin per sector” chart and is set up for the “Gross Margin per Business” chart. The combo box specifies the month. In tab “EBITA” the dril works for sectors in “EBITA per sector” chart and is set up for the “EBITA per Business” chart. The combo box specifies the month.
The Picture menu shows Sector specific images (logo), clicking on these will show Sector specific views. For Philips Group this means the overal Tabset where comparision between Sectors and their Businesses is possible.
One sector is further detailed, the sales from Sector Healthcare can be analysed per European country. The current sales can be compared to last month this year or same month last year. Through the dril the sales for a specific country can analysed per month.
This dashboard was developed for Ensior and can be viewed here.