PART A:
For each of the below, in addition to your answer, provide the dashboard page where you found it.
For 1-4, use the dashboard at: https://www.idashboards.com/dashboard-examples/healthcare-dashboards- doctors-scorecard/
1) Has Dr. May’s wait time been improving over time?
2) Which doctor saw the highest percentage of women patients in September?
3) Which two doctors have offices next to Dr. Davis’s office?
4) Which doctor is the worst at listening to patients?
For 5-8, use the dashboard at: https://www.idashboards.com/dashboard-examples/government-parks-dashboard/
5) Which property had the highest cost per visitor in 2017?
6) Was the 2017 cost per visitor rated good or bad for Long Island?
7) Which area has the greatest number of state parks?
8) What do you think accounts for the trend seen in the annual budgets from 2007 to 2010?
For 9-12, use the dashboard at: https://www.idashboards.com/dashboard-examples/insurance-dashboard/
9) Have more males or females had accepted auto claims in the past 45 days? 10) Who is the oldest customer with a business claim that is in progress?
11) How many claims are currently in progress at the insurance company?
12) Which type of claim has the highest profit?
For 13-15, use the dashboard at: https://www.idashboards.com/dashboard-examples/transportation-logistics- dashboard-fleet-management/
13) Which vehicle type had the highest fuel cost the previous March?
14) Which vehicle type makes up the greatest percentage of insurance costs?
15) How many empty miles did the company experience for all vehicles the previous June? 16) What percentage of rigid trucks are currently available? Is this good or bad?
PART B:
Identify two strategic decisions that the information in one (or more) of the example dashboards at idashboards.com can help the company make. Be specific when describing these decisions. Identify the information in the dashboard that can be used to make these decisions, and the dashboard that are you using.
PART C:
We very briefly discussed the concept of Balanced Scorecards in our lab introduction. Identify at least two metrics for the (1) Customer, (2) Financial, and (3) Internal Business Processes dimensions that are presented in one or more of the example dashboards at idashboards.com, and be specific as to where they are a decision maker could locate them in the dashboard (and which dashboard you are using).
PART A:
For each of the below, in addition to your answer, provide the dashboard page where you found it.
For 1-4, use the dashboard at: https://www.idashboards.com/dashboard-examples/healthcare-dashboards- doctors-scorecard/
1) Has Dr. May’s wait time been improving over time?
2) Which doctor saw the highest percentage of women patients in September?
3) Which two doctors have offices next to Dr. Davis’s office?
4) Which doctor is the worst at listening to patients?
For 5-8, use the dashboard at: https://www.idashboards.com/dashboard-examples/government-parks-dashboard/
5) Which property had the highest cost per visitor in 2017?
6) Was the 2017 cost per visitor rated good or bad for Long Island?
7) Which area has the greatest number of state parks?
8) What do you think accounts for the trend seen in the annual budgets from 2007 to 2010?
For 9-12, use the dashboard at: https://www.idashboards.com/dashboard-examples/insurance-dashboard/
9) Have more males or females had accepted auto claims in the past 45 days? 10) Who is the oldest customer with a business claim that is in progress?
11) How many claims are currently in progress at the insurance company?
12) Which type of claim has the highest profit?
For 13-15, use the dashboard at: https://www.idashboards.com/dashboard-examples/transportation-logistics- dashboard-fleet-management/
13) Which vehicle type had the highest fuel cost the previous March?
14) Which vehicle type makes up the greatest percentage of insurance costs?
15) How many empty miles did the company experience for all vehicles the previous June? 16) What percentage of rigid trucks are currently available? Is this good or bad?
PART B:
Identify two strategic decisions that the information in one (or more) of the example dashboards at idashboards.com can help the company make. Be specific when describing these decisions. Identify the information in the dashboard that can be used to make these decisions, and the dashboard that are you using.
PART C:
We very briefly discussed the concept of Balanced Scorecards in our lab introduction. Identify at least two metrics for the (1) Customer, (2) Financial, and (3) Internal Business Processes dimensions that are presented in one or more of the example dashboards at idashboards.com, and be specific as to where they are a decision maker could locate them in the dashboard (and which dashboard you are using).
PART A:
For each of the below, in addition to your answer, provide the dashboard page where you found it.
For 1-4, use the dashboard at: https://www.idashboards.com/dashboard-examples/healthcare-dashboards- doctors-scorecard/
1) Has Dr. May’s wait time been improving over time?
2) Which doctor saw the highest percentage of women patients in September?
3) Which two doctors have offices next to Dr. Davis’s office?
4) Which doctor is the worst at listening to patients?
For 5-8, use the dashboard at: https://www.idashboards.com/dashboard-examples/government-parks-dashboard/
5) Which property had the highest cost per visitor in 2017?
6) Was the 2017 cost per visitor rated good or bad for Long Island?
7) Which area has the greatest number of state parks?
8) What do you think accounts for the trend seen in the annual budgets from 2007 to 2010?
For 9-12, use the dashboard at: https://www.idashboards.com/dashboard-examples/insurance-dashboard/
9) Have more males or females had accepted auto claims in the past 45 days? 10) Who is the oldest customer with a business claim that is in progress?
11) How many claims are currently in progress at the insurance company?
12) Which type of claim has the highest profit?
For 13-15, use the dashboard at: https://www.idashboards.com/dashboard-examples/transportation-logistics- dashboard-fleet-management/
13) Which vehicle type had the highest fuel cost the previous March?
14) Which vehicle type makes up the greatest percentage of insurance costs?
15) How many empty miles did the company experience for all vehicles the previous June? 16) What percentage of rigid trucks are currently available? Is this good or bad?
PART B:
Identify two strategic decisions that the information in one (or more) of the example dashboards at idashboards.com can help the company make. Be specific when describing these decisions. Identify the information in the dashboard that can be used to make these decisions, and the dashboard that are you using.
PART C:
We very briefly discussed the concept of Balanced Scorecards in our lab introduction. Identify at least two metrics for the (1) Customer, (2) Financial, and (3) Internal Business Processes dimensions that are presented in one or more of the example dashboards at idashboards.com, and be specific as to where they are a decision maker could locate them in the dashboard (and which dashboard you are using).
1) Has Dr. May’s wait time been improving over time? – No, the waiting time for Dr. May is not improving over the time. As per the data, the waiting time improve during the month of May, June, July and August, but again the time shoots up in the later year.
2) Which doctor saw the highest percentage of women patients in September? – Dr. Jones is seeing the highest number of women patients with a score of 47%
3) Which two doctors have offices next to Dr. Davis’s office? – Dr. Clark and Dr. Sieber have office nest to Dr. Davis.
4) Which doctor is the worst at listening to patients? – Dr. Sieber has the worst listening of 77%.
For 5-8, use the dashboard at: https://www.idashboards.com/dashboard-examples/government-parks-dashboard/
5) Which property had the highest cost per visitor in 2017? – Taconic has the highest cost per visitor of $7.12
6) Was the 2017 cost per visitor rated good or bad for Long Island? – Cost for 2017 is rated as good for long island as it was under the budget
7) Which area has the greatest number of state parks? – Long Island has the greates number of state park, 27.
8) What do you think accounts for the trend seen in the annual budgets from 2007 to 2010? – For most of the areas, budget decrease in the period of 2007 to 2009 and then a rise in budget approx in 2010 or after that.
For 9-12, use the dashboard at: https://www.idashboards.com/dashboard-examples/insurance-dashboard/
9) Have more males or females had accepted auto claims in the past 45 days? – Males have accepted more number of auto insurance
10) Who is the oldest customer with a business claim that is in progress? – Paki wood
11) How many claims are currently in progress at the insurance company? - 4
12) Which type of claim has the highest profit? – Auto has the highest profit
For 13-15, use the dashboard at: https://www.idashboards.com/dashboard-examples/transportation-logistics- dashboard-fleet-management/
13) Which vehicle type had the highest fuel cost the previous March? – Box truck
14) Which vehicle type makes up the greatest percentage of insurance costs? – Semi Trailer
15) How many empty miles did the company experience for all vehicles the previous June? – 2436.85
16) What percentage of rigid trucks are currently available? Is this good or bad? – 40%, which is bad for the comany
Homework Sourse
