This was a side experiment while searching for a solution for a Wheel Of Fortune concept.
Investing in Financial markets has risk, projecting possible future outcomes is difficult. We have built annualized returns going back to 1950, so thats 66 datapoints.
We want to present a user with a question about how much risk they want to take on.
Then we spin the Wheel Of Fortune and randomly pick a year and multiply out what the hypothetical return would be.
I haven't come up with a BI solution for this. One idea I had was to Auto-Refresh data every second for 5 seconds and stop on the last iteration. While the data is refreshing I want to see gauges, barcharts, linecharts all changing to give the feeling someone on The Price Is Right would experience while spinning the Wheel Of Fortune. The Price Is Right is an American game show. The Wheel Of Fortune is a huge wheel the contestant spins and when it stops, the results can be bad or good.
Another idea I have toyed with is using a Table visualization with no header or borders and highlight different cells, maybe while playing a fun sounding game show music for 5 seconds.
If you have any ideas I'd love to hear them.