For the second day of Dashboard Week, we were given data on gambling habits and revenue for a variety of games and forms of wagering. Not knowing really anything about gambling, I just chose Keno since I had some vague idea of how the game worked (if it could even be called a game), and the information itself was quite in-depth, going over metrics such as percentage of household disposable income, percentage of government revenue, as well as the usual to-be-expected turnover and expenditure.

This time, the Alteryx work was much more concise, only requiring some manual work of copying in the data into text input tools (mainly due to the lack of consistent table formatting in the initial Excel spreadsheets), and transforming columns so that I could join everything together.

After that, it was a simple matter of importing the sheet into Power BI, and this was the first time I could see the argument of Power BI being “easier” to create visuals at a basic level. With only one sheet, it was surprisingly simple to throw together charts, and the lack of dimension or fact tables meant that there were no real issues with relationships or connections.

The one pitfall I had with today’s dashboard was an over-emphasis on striking visuals, and trying very hard to be as far removed from the typical corporate business dashboard as possible, which meant that I had much less time to try and find insights, though I am quite proud of the overall visual look emulating Keno as much as possible. I spent more time trying to improve at PowerBI visuals, including using an image as a background as way to add some flavour, using coloured backgrounds, and continuing to use my measure swaps and drill throughs where applicable.

For insights, I mainly discovered that Keno could be described as the ultimate loser’s game, the odds of any return or winning are incredibly slim (NSW boasts a woeful 75% of total loss in Keno), and that while the numbers can be quite surprising if not depressing to a non-gambler, at least the percentage of money spent on Keno from the average household’s disposable income is extremely negligible. Gamble responsibly kids.

Daniel Yam
Author: Daniel Yam