The Power BI Whisky Experience 12-22-2017 13:05 PM - last edited 01-08-2018 09:50 AM

[RyanBentham]

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 :-)

Regards

Ryan

eyJrIjoiZjUzYWFjOWUtYWE1Ni00MDVlLWI5MTAtYTc0NzE0MTM0OWYwIiwidCI6Ijg0ODgwZjIxLWE0OGQtNDA4Zi1hZmZmLTg5NjY3ZjQ5YTJiNCJ9

boomark.PNG

[jeloma]

Hi Ryan, your submission for the contest is amazing, with all new options and visualizations in dec 2017. Congratulations and luck in the contest.

[RyanBentham]

Thanks Jeloma :-)

[anuarmn]

Wow, this is excellent. Congrats!

How you do the age input validation?

[kschaefers]

@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?

[hymieho]

Congrats!

How do you make the images zoom on mouseover? I assume it is a custom visualization, but if not can you share that technique? 

[RyanBentham]

Hi anuarmn

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 :-)

Ryan

[RyanBentham]

Hi kschaefers

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.

Thanks

[RyanBentham]

Hi Hymieho

Thanks :-)

This is done using the Image Grid custom visual.

Link:  (https://appsource.microsoft...

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

[jasent]

I Like the solution too. can you share the solution with data entry.

Is this What if analyzes ?