Hi All,
I need to create a dashboard that represents the following:
5 Lines of Business (LOB)
...Each with the same 20 KPIs
......Each KPI based on a specific set of 5 to 15 Questions
.........Questions can be phrased as a statement and responses can be like the following (to compute a score):
(1) Never
(2) Infrequently
(3) Frequently
(4) Always
The 20 KPIs have different owners (so potentially 100 owners)
I think I need a solution that offers:
A. a consolidated place mat to summarize everything
B. a detailed view for each LOB
C. a comparison view across each KPI
D. a KPI owner view
I am pretty experienced in MS Access and Excel and I am thinking that Access would give me flexibility for managing the data and building trends, but before I embark in that direction, I thought I would see what you guys think. I also believe that visualizing a finished Dashboard solution would help me in designing the back-end if I were to go with Access.
Any thoughts would be appreciated. I have reviewed a lot of the content here and found some fantastic solutions. Can someone point me in the direction of a dashboard template that might meet the needs I have described? Thanks in advance!
MA_GA
I need to create a dashboard that represents the following:
5 Lines of Business (LOB)
...Each with the same 20 KPIs
......Each KPI based on a specific set of 5 to 15 Questions
.........Questions can be phrased as a statement and responses can be like the following (to compute a score):
(1) Never
(2) Infrequently
(3) Frequently
(4) Always
The 20 KPIs have different owners (so potentially 100 owners)
I think I need a solution that offers:
A. a consolidated place mat to summarize everything
B. a detailed view for each LOB
C. a comparison view across each KPI
D. a KPI owner view
I am pretty experienced in MS Access and Excel and I am thinking that Access would give me flexibility for managing the data and building trends, but before I embark in that direction, I thought I would see what you guys think. I also believe that visualizing a finished Dashboard solution would help me in designing the back-end if I were to go with Access.
Any thoughts would be appreciated. I have reviewed a lot of the content here and found some fantastic solutions. Can someone point me in the direction of a dashboard template that might meet the needs I have described? Thanks in advance!
MA_GA