01-05-2018 12:27 PM
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 🙂
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.
How do you make the images zoom on mouseover? I assume it is a custom visualization, but if not can you share that technique?
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
@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
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.
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 🙂