See the World with Travel Photographer @kirstenalana
A visualization of Panoply’s Instagram Data Challenge to explore popular posts, location and the best time to visit from @kirstenalana Instagram data
It is really hard to analyze what kind of post would be popular because of the subjectivity of photos posted on Instagram. However, with the selection of certain time range and locations, an influencer can analyze the details of the image posted that garnered more likes and comments (which means people “talked” about it) and decide the type of images he/she should post next.
This dashboard is also useful for travelers that they could check what kind of locations are worth to visit in a certain time range. It can also give travelers an idea about hotels and/or places that are worth visiting in a specific location (e.g., New York = Central Park). Therefore, the category of “Most impactful data insight” might contain this.
select k_media.id, k_media.link, k_media.likes_count, k_media.type, k_media.filter, k_media.created_time, k_media.user_has_liked, k_media.comments_count,
k_med_loc.latitude, k_med_loc.longitude, k_med_loc.name, k_med_loc.instagram_media_id,
from kirstenalanainstagram_instagram_media as k_media
left join kirstenalanainstagram_instagram_media_location k_med_loc
on k_media.id = k_med_loc.instagram_media_id
left join kirstenalanainstagram_instagram_media_tags as k_med_tags
on k_media.id = k_med_tags.instagram_media_id
and k_med_loc.instagram_media_id = k_med_tags.instagram_media_id;
Feel free to like and comment, enjoy!