12-22-2017 13:05 PM - last edited 06-25-2018 11:41 AM
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 🙂
This is really amazing. You have used some good features and techniques.
I would be greatful if you could share the PBIX file with me @email@example.com.
Are you referring to this one?
This is done using the Synoptic Panel visual (https://powerbi.microsoft.com/es-es/blog/visual-awesomeness-unlocked-using-the-synoptic-panel/)
I created the SVG map using Inkscape where you can give each vector/area on the map an ID which can correspond to your data points in PowerBI. The possibilites are endless really!! Have a read up on it......
Give me a shout if have any questions...i've worked with it quite a bit now
I have a question, how do you hide the Pages tabs and hid the page scroller (in below image) from your report. I am not able to do it through Publish to web option.
You have done the excellent work. I have a few questions
I will be very thankful for your suggestion.
Great Report.No question after viewing this report. Great work and inspiration. lot of things to learn. Please share your .pbix file, so that we can learn something from you. Thank you very much for sharing this wonderful dashboard.
Will it be possible to email the .pbix file on firstname.lastname@example.org.. Please, it is for learning purpose.
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.
Thanks. Are you referreing to the Whisky recommendation page that shows the 3 bottles?
Underneath the image grid there's a table that shows the list of Whisky products based on your selection from the prior page. The table is filtered though by a measure which counts the number of rows in the table and only shows where the measure = 1. So by default it will not show anything but when the user clicks on a single image (resulting in the measure = 1) the data will then show in the table, which will only be the 1 row selected. With it being a table it then also allows the user to drill-through
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!
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.
@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?
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?