The Power BI Whisky Experience
12-22-2017 13:05 PM - last edited 01-08-2018 09:50 AM
12-22-2017 01:05 PM - last edited on 01-08-2018 09:50 AM by mbenjamin
Here's my submission for the contest.
The Power BI Whisky Experience. Currently containing data on 242 Single Malt Whiskies. A relatively small dataset but enough dimensions to add some great insights
The report tries to showcase some good use cases for Bookmarking. Flipping between views (table / image / card), navigating to pages and clearing filters have all been used within this report [edit: the clear filtering has been removed due to some issues (which appeards to be happening in other people's reports too)]. All clickable links in this report use bookmarking
Please let me know if you have any questions :-)
01-05-2018 12:50 AM - edited 01-05-2018 12:50 AM
@RyanBentham, Really awesome solution and congratulations on winning the bookmarking contest!
As a whisky lover myself I will definitely use this report on a regular basis.
I would also be interested in where you got the data from or did you curate it manually?
Would you be able to share the pbix file?
01-06-2018 02:01 AM
Is use a What-If Parameter for the numeric input. Naming the parameter "Age" this then automatically creates a Column and a Measure called [Age] and [Age Value] respectively
Then I create another two seperate measures to control the displayed text; one for when the number entered is below 18 and another for 18 or over:
Age_Check_message_1 = if([Age Value] <18, "You must to be 18 years of age or over to use the PowerBI Whisky Experience!","")
Age_Check_message_2 = if([Age Value] <18, "", "Continue")
Hope that helps :-)
01-06-2018 02:53 AM
Thanks for the kind words and i'm happy to know there's another whisky fan on here :-)
It was quite a manually process collecting the data to be honest and I did use many sources; mostly being websites including: www.masterofmalt.com, www.whiskyshop.com, www.scotchwhiskyexperience.co.uk and www.thewhiskyexchange.com.
I managed to get about 1000 single-malt whiskies into the excel workbook from various sources. I started off using a python script to scrape data but it kept failing so I had to resort to the old cut-and-paste method into excel. Sourcing images was quite difficult due as I wanted to use PNGs to help with the interaction in the report. I gave up after 242 whiskies which is why there is only that many in the report :-D
For the Distillery and Region data, it was the same process really. Pretty much a case of crawling the web for the data.
I will be sharing the pbix file soon, I just need to tidy up some of the column and measures names in the report.
01-06-2018 02:55 AM
This is done using the Image Grid custom visual.
It's a nice visual. By default, the images you use with it will be rendered in a circle view. To show them in a row (or grid), as I did, simply go onto the visual's format tab and then within Settings you can change the render type to Grid.
All the images will have the zoom on mouse-over
Hope that helps