![]() You can quickly see locations of these cities on the globe as well as their locations relative to each other. The map provides visual information that you can take in quickly.But you will be much slower at #1, #2, and #6 using the infographic. If you have been looking at the infographic for a while, you might be pretty fast at #3, #4, and #5. I think the Power View would answer all of these questions quicker or just as quick as the infographic. Which country has the lowest average hotel rate?.In what country is Kuala Lumpur located? (I’m hoping you know this off the top of your head, but let’s pretend you need to look it up.).How many visitors does Dubai get per year?.What tourist attractions are in Hong Kong?.If I were to plan a trip to visit 3 of the cities on this list, which ones would be most convenient to visit in one trip?.How many of the most visited cities are in the United States?.See how long it takes you to answer the following questions with the infographic and then with the Power View. Let’s try an experiment: open the file in Excel and then open the infographic in your browser. The table is sorted by visitors per year descending. If you hover over a bubble you can see the city name and visits per year. If you click on a bubble you filter the table below to see just the information for that location. In the map, the bubble size represents number of visits. I used a map and cards to display the data. Click to enlargeĪnd finally, I built my report. Since there is one row per country in my Country Flags table, this was as easy as relating the country field in the Most Visited Cities table to the country field in the Country Flags table. Next I had to relate my most visited cities data to the appropriate flag. The important part is to set the default image to the flag image. You can find this on the Advanced tab in Power Pivot. You’ll notice on the Country Flags table, I had to change the table behavior properties to get the images to render properly in Power View. Here are my tables in Power Pivot: Click to enlarge Click to enlarge I had originally split out the hotel price and the hotel name as two separate fields, but I found that I liked them together when I was building my Power View so I made a calculated field in Power Pivot to take care of that. See yesterday’s post for info on how to import images into Power Pivot. I had a vision of where I was going with my Power View, so I also imported a table of countries and flag images into Power Pivot. I imported that into my Power Pivot model by selecting the table and clicking the Add to Data Model button on the PowerPivot tab. You could split it out and put it into several tables (especially if you split the tourist attractions into 3 individual fields per city), but I didn’t need it for what I was making and the data was all at the same level of granularity in my single table. I just copied the info from the infographic and put it in a single table in Excel. I know I could make a great Power View from this data that could deliver information more efficiently, and I think it would look pretty cool.įirst, I had to get the data and put it in a Power Pivot model.You lose a lot of the opportunities for preattentive processing with a format like this. But I hate when they make them really large/long with a lot of text where you have to read through every bit of text to really get the info. I know infographics are cool, and I love that they communicate an interesting data point to the general public in an easily consumable manner.Most Visited Cities Infographic from Īfter a second or two of looking at it, my BI and dataviz nerdiness kicked in. I’m interested in travel, and I like data, so I looked through it. Someone on Twitter posted a link to an infographic on the 10 most visited cities in the world, which you can see below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |