Exercise
Data Warehouse and Business Intelligence Exercises
Audience Voting at the Olympics The Olympics Planning Committee wishes to explore the use of audience voting in several events at the next games. Voter interfaces will be installed in every seat in the selected venue. Spectators must be able to cast their votes easily and quickly. A voter can only cast one vote per event. The voting devices must be cheap, waterproof, and hard to steal. The device’s display must be language independent with font size no less than 18 pt. Thousands of spectators may be voting concurrently for an event. Administrators need to set up events and reconfigure event parameters during an event. Must include adding, modifying, deleting events as well as their respective participants; signaling spectators to begin voting; closing event voting; disabling voting devices for a specific seat or range of seats. The voting results must be displayed on large screens.
The Interview Stakeholder: I want a report Analyst: What do you hope to use the report for? Stakeholder: I want to see how the audience is voting Analyst: What specifically do you want to know about how the audience is voting? Stakeholder: I want to see if there are any trends in how the audience votes. Such as if women or men give higher scores for a particular event, if people in the audience can be impartial to athletes from other countries or see if age impacts how they vote. I’d also like to compare this information to the judges’ score to see if there is any consistency. Analyst: What do you plan to do with this information? Stakeholder: It will help me with some research on the wisdom of crowds. Also, I want to determine whether or not we can extend the use of audience voting to other events in future Olympic Games, and whether or not we may be able to replace judges with the audience. Analyst: You want to replace the judges huh? What do they think about that? Stakeholder: They don’t know yet, and I would prefer to keep it that way. Completely getting rid of judges is a long ways off, but I’m thinking that this may help us identify if there are any… shall we say irregularities with the judging. 1|Page
Data Warehouse and Business Intelligence Exercises Analyst: Ok. So you mentioned some trends that you would like to be able to look at. What are all the trends you were thinking of? Stakeholder: Well I mentioned a couple. Do men score certain events higher than women, do people score athletes from their home country higher, do they vote differently depending on how old they are… I guess it would be helpful to know the same things for the judges, especially the country aspect – that would be helpful to know for each individual judge. You know, show how a judge rates athletes from their country compared to all the other judges for that same athlete. On top of that, It would be helpful to know in aggregate how the audience rates the athletes compared to the judges. Analyst: Aren’t some of the scoring rules pretty arcane? Would the audience be able to understand all of the various scoring rules? Stakeholder: Yeah, I know the scoring scheme for gymnastics is particularly screwy… No, I wouldn’t expect the audience to know all the ins and outs of the scoring system. I think it would be fine to compare the scores relatively. The audience would use a 1 – 10 scale, the judges would use their same judging system. Analyst: Are you sure about that? When I talked to Hans Richards, he said that the voting system was going to mirror the same scoring approach as the judges. Stakeholder: Oh really? That would be great. I was just assuming that we weren’t going to twist the audience’s head like that. But if we can get them to do it, great! Oh, you know what, with you mentioning Han’s name, that made me realize that this is a pilot. All that stuff I mentioned before is great, but what we probably should focus on first is how people are using the voting system. Analyst: what do you mean exactly by “how people are using the voting system”? (do air quotes here if you like) Stakeholder: Oh, you know, how long does it take people to vote after each event – we need to make sure that 10 to 15 seconds is sufficient. Do people stop voting after a while, so comparing the number of voting devices that are active compared to the number of votes we get. And I think it would be good to get that information by country, age, and man or woman, to see if there are certain parts of the audience that are more successful using the system than others. Yeah, that’s probably going to be the most valuable off the bat, though I would really like to know how the audience votes compare to the judges.
2|Page
Data Warehouse and Business Intelligence Exercises Oh darn, look at the time. I’ve got another meeting to go to. Did I get you enough information to get started? Great. Bye. Analysis: Uh sure, no problem. I’ll call you if I have any more questions. Stakeholder: Yeah, sure.
Exercise – Key Reporting Requirements Based on the interview you recently heard, identify key reporting requirements for the Olympic Scoring application. What requirements did you hear in the conversation between the analyst and stakeholder? Use this format: As A <Stakeholder> I want So That <Business Value>
Exercise – Prioritize Your Requirements Prioritize the requirements you identified in the last exercise, considering value and feasibility. Refer back to the interview for guidance on what is valuable.
Exercise – Details of the Highest Priority Requirements For the highest priority requirement you identified in the previous exercise, identify all the relevant details you need to know. Think about what questions you would ask the busy stakeholder to get that information.
Exercise – Creating Examples Given the requirement you dove into detail in the previous exercises, determine what examples you could use to communicate the requirements to the delivery team and test the resulting solution.
Contact Information Kent J. McDonald email: [email protected] | Twitter: @beyondreqs web: www.kbridgepartners.com Blog: www.beyondrequirements.com Presentation: http://bit.ly/IMYfy6
3|Page
Audience Voting at the Olympics The Olympics Planning Committee wishes to explore the use of audience voting in several events at the next games. Voter interfaces will be installed in every seat in the selected venue. Spectators must be able to cast their votes easily and quickly. A voter can only cast one vote per event. The voting devices must be cheap, waterproof, and hard to steal. The device’s display must be language independent with font size no less than 18 pt. Thousands of spectators may be voting concurrently for an event. Administrators need to set up events and reconfigure event parameters during an event. Must include adding, modifying, deleting events as well as their respective participants; signaling spectators to begin voting; closing event voting; disabling voting devices for a specific seat or range of seats. The voting results must be displayed on large screens.
The Interview Stakeholder: I want a report Analyst: What do you hope to use the report for? Stakeholder: I want to see how the audience is voting Analyst: What specifically do you want to know about how the audience is voting? Stakeholder: I want to see if there are any trends in how the audience votes. Such as if women or men give higher scores for a particular event, if people in the audience can be impartial to athletes from other countries or see if age impacts how they vote. I’d also like to compare this information to the judges’ score to see if there is any consistency. Analyst: What do you plan to do with this information? Stakeholder: It will help me with some research on the wisdom of crowds. Also, I want to determine whether or not we can extend the use of audience voting to other events in future Olympic Games, and whether or not we may be able to replace judges with the audience. Analyst: You want to replace the judges huh? What do they think about that? Stakeholder: They don’t know yet, and I would prefer to keep it that way. Completely getting rid of judges is a long ways off, but I’m thinking that this may help us identify if there are any… shall we say irregularities with the judging. 1|Page
Data Warehouse and Business Intelligence Exercises Analyst: Ok. So you mentioned some trends that you would like to be able to look at. What are all the trends you were thinking of? Stakeholder: Well I mentioned a couple. Do men score certain events higher than women, do people score athletes from their home country higher, do they vote differently depending on how old they are… I guess it would be helpful to know the same things for the judges, especially the country aspect – that would be helpful to know for each individual judge. You know, show how a judge rates athletes from their country compared to all the other judges for that same athlete. On top of that, It would be helpful to know in aggregate how the audience rates the athletes compared to the judges. Analyst: Aren’t some of the scoring rules pretty arcane? Would the audience be able to understand all of the various scoring rules? Stakeholder: Yeah, I know the scoring scheme for gymnastics is particularly screwy… No, I wouldn’t expect the audience to know all the ins and outs of the scoring system. I think it would be fine to compare the scores relatively. The audience would use a 1 – 10 scale, the judges would use their same judging system. Analyst: Are you sure about that? When I talked to Hans Richards, he said that the voting system was going to mirror the same scoring approach as the judges. Stakeholder: Oh really? That would be great. I was just assuming that we weren’t going to twist the audience’s head like that. But if we can get them to do it, great! Oh, you know what, with you mentioning Han’s name, that made me realize that this is a pilot. All that stuff I mentioned before is great, but what we probably should focus on first is how people are using the voting system. Analyst: what do you mean exactly by “how people are using the voting system”? (do air quotes here if you like) Stakeholder: Oh, you know, how long does it take people to vote after each event – we need to make sure that 10 to 15 seconds is sufficient. Do people stop voting after a while, so comparing the number of voting devices that are active compared to the number of votes we get. And I think it would be good to get that information by country, age, and man or woman, to see if there are certain parts of the audience that are more successful using the system than others. Yeah, that’s probably going to be the most valuable off the bat, though I would really like to know how the audience votes compare to the judges.
2|Page
Data Warehouse and Business Intelligence Exercises Oh darn, look at the time. I’ve got another meeting to go to. Did I get you enough information to get started? Great. Bye. Analysis: Uh sure, no problem. I’ll call you if I have any more questions. Stakeholder: Yeah, sure.
Exercise – Key Reporting Requirements Based on the interview you recently heard, identify key reporting requirements for the Olympic Scoring application. What requirements did you hear in the conversation between the analyst and stakeholder? Use this format: As A <Stakeholder> I want So That <Business Value>
Exercise – Prioritize Your Requirements Prioritize the requirements you identified in the last exercise, considering value and feasibility. Refer back to the interview for guidance on what is valuable.
Exercise – Details of the Highest Priority Requirements For the highest priority requirement you identified in the previous exercise, identify all the relevant details you need to know. Think about what questions you would ask the busy stakeholder to get that information.
Exercise – Creating Examples Given the requirement you dove into detail in the previous exercises, determine what examples you could use to communicate the requirements to the delivery team and test the resulting solution.
Contact Information Kent J. McDonald email: [email protected] | Twitter: @beyondreqs web: www.kbridgepartners.com Blog: www.beyondrequirements.com Presentation: http://bit.ly/IMYfy6
3|Page
