See the World with Travel Photographer @kirstenalana
Dashborad Link
Short Description:
A visualization of Panoply’s Instagram Data Challenge to explore popular posts, location and the best time to visit from @kirstenalana Instagram data
Long Description:
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.
SQL code:
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,
k_med_tags.value
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!