topic Re: The Power BI Whisky Experience in Data Stories Gallery

The Power BI Whisky Experience

RyanBentham — Mon, 25 Jun 2018 18:41:54 GMT

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

Re: The Power BI Whisky Experience

jeloma — Sat, 23 Dec 2017 08:47:55 GMT

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

Re: The Power BI Whisky Experience

RyanBentham — Sat, 23 Dec 2017 23:27:45 GMT

Thanks Jeloma :-)

Re: The Power BI Whisky Experience

anuarmn — Fri, 05 Jan 2018 03:12:55 GMT

Wow, this is excellent. Congrats!

How you do the age input validation?

Re: The Power BI Whisky Experience

kschaefers — Fri, 05 Jan 2018 08:50:32 GMT

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?

Re: The Power BI Whisky Experience

hymieho — Fri, 05 Jan 2018 20:27:58 GMT

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?

Re: The Power BI Whisky Experience

RyanBentham — Sat, 06 Jan 2018 10:01:46 GMT

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

Re: The Power BI Whisky Experience

RyanBentham — Sat, 06 Jan 2018 10:53:16 GMT

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

Re: The Power BI Whisky Experience

RyanBentham — Sat, 06 Jan 2018 10:55:45 GMT

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

Re: The Power BI Whisky Experience

jasent — Mon, 08 Jan 2018 08:58:00 GMT

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

Is this What if analyzes ?

Re: The Power BI Whisky Experience

stretcharm — Mon, 08 Jan 2018 21:36:36 GMT

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

Re: The Power BI Whisky Experience

Anonymous — Tue, 09 Jan 2018 10:33:43 GMT

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.

Re: The Power BI Whisky Experience

Anonymous — Mon, 15 Jan 2018 20:34:57 GMT

Congratulations!

This is incredibly fun and I can't wait to take this list to the store and find my next bottle based on your recommendations. It's so unfortunate that the data entry is a manual process. If you ever find a way to automate it, consider adding in a relative price ($ - $$$$, knowing that prices vary by location).

Even without the upcoming feature to find a bottle similar to one I like, I was able to see the score for one I like and use that to find others. Nice job and thanks for making my Monday a bit more fun!

Re: The Power BI Whisky Experience

RyanBentham — Wed, 31 Jan 2018 22:33:16 GMT

Anonymous Thanks for the kind words :-) Happy you enjoyed using the report.

Re: The Power BI Whisky Experience

Yeguo — Thu, 15 Feb 2018 14:55:18 GMT

I have to say this is sooooo amazing! thanks for sharing and inspiration!

Re: The Power BI Whisky Experience

RyanBentham — Mon, 19 Feb 2018 10:32:08 GMT

Thanks Yeguo happy you like it :-)

Re: The Power BI Whisky Experience

ravalib — Wed, 28 Feb 2018 06:48:56 GMT

Amazing dashboard! It will be great if you can share the report with us so that we can see how you have worked around some exciting features.

Very impressed!

Re: The Power BI Whisky Experience

roederfletcher — Mon, 26 Mar 2018 01:32:50 GMT

Hi Ryan, any chance you can share the pbix file so we can take a look at how you created this experience?

Re: The Power BI Whisky Experience

JaneM — Wed, 28 Mar 2018 09:37:16 GMT

Hi Ryan, great dashboard. I really like the image grid app you've used. Can you tell me how you've managed to set it up so that when you click on a whisky bottle the label appears below? Thanks.

Re: The Power BI Whisky Experience

RyanBentham — Wed, 09 May 2018 08:01:36 GMT

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