The Power BI Whisky Experience

Regular Visitor
9234 Views
Highlighted
Regular Visitor
Posts: 27
Registered: ‎12-14-2017

The Power BI Whisky Experience

[ Edited ]

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

 

 

 

 

Advisor
Posts: 30
Registered: ‎07-11-2015

Re: The Power BI Whisky Experience

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

Regular Visitor
Posts: 27
Registered: ‎12-14-2017

Re: The Power BI Whisky Experience

Thanks Jeloma :-)

Advisor
Posts: 9
Registered: ‎07-25-2016

Re: The Power BI Whisky Experience

Wow, this is excellent. Congrats!

 

How you do the age input validation?

Regular Visitor
Posts: 28
Registered: ‎10-10-2016

Re: The Power BI Whisky Experience

[ Edited ]

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

 

Regular Visitor
Posts: 49
Registered: ‎09-28-2016

Re: The Power BI Whisky Experience

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? 

Regular Visitor
Posts: 27
Registered: ‎12-14-2017

Re: The Power BI Whisky Experience

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

 

 

Regular Visitor
Posts: 27
Registered: ‎12-14-2017

Re: The Power BI Whisky Experience

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

 

 

Regular Visitor
Posts: 27
Registered: ‎12-14-2017

Re: The Power BI Whisky Experience

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

Frequent Visitor
Posts: 5
Registered: ‎08-30-2015

Re: The Power BI Whisky Experience

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

Is this What if analyzes ?