The Power BI Whisky Experience 12-23-2017 15:27 PM

[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

[RyanBentham]

@Anonymous   Thanks for the kind words 🙂   Happy you enjoyed using the report.     

[Anonymous]

Amazing presentation and great inspiration for me.

You've made use of PowerBI using it's full potential.

If you are willing to share it so we can see how it's done that would be amazing.

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

[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 😄

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

[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 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

[anuarmn]

Wow, this is excellent. Congrats!

How you do the age input validation?

[jasent]

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

Is this What if analyzes ?

[RyanBentham]

@jasent    Thanks.   That's right,  the data entry on the first page (age verification) is using a What IF Parameter.   It's not perfect but does the job 

[stretcharm]

Very nice.  I've tried a quite a lot and visited a few distillaries but still got a lot to go.

I've got fond memories of staying at Bunnahabhain and sampling all of Islay's delights.

Phil

[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

[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 🙂