Want to learn how to make this dashboard? Images for Dead/Alive – BandCollectables website. Character data and Images – From Game of Thrones Wiki.Screen time – Posted in a forum by a user “Sellsword”.I have used multiple sources to collate the data. Go ahead, download this dashboard (~17 MB) and let me know your thoughts, comments, feedback… Use radio buttons to sort the episode list based on episode number, rating, or viewership.Double Click on characters name to get the profile, which shows character’s picture, allegiance, and how the character died (if he/she did).Use check-boxes to get the list of characters with screen time, status, and the name of the person portraying the character (in the selected season(s)).How to play with this Game of Thrones Dashboard? Some back-end Excel functions to make it all work.VBA to get the profile when double-clicking on character’s name.Check Boxes to show selected data only.Scroll bar to go through the list of characters.Character’s Profile – picture, allegiance, and how he/she died (if dead).Episode titles with rating and viewership (and the functionality to sort based on it).Major characters with their total screen time, dead or alive status, and the person’s name who portrayed the character.Alive in prominent families (such as Baratheon, Lannister) Join the Excel Dashboard Course.ĭata Points used to create this dashboard: Learn to Create World Class Dashboards in Excel. Give me the Dashboard right away (~17 MB) Here is how the final Dashboard looks like: There are many wonderful people/forums/wikis that helped me compile this dataset (credits at the end). Using my substandard secondary skills, I was somehow able to find enough data points to create an awesome Excel dashboard. As the world goes crazy (including me) over the new season of Game of Thrones, I thought it would be a good idea to visualize its data by creating an Excel Dashboard.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |