![]() ![]() Because this query is using when a post is created to calculate the numbers of likes and comments. The purpose of me showing this query is because I think it is not appropriate to use this insight to make a recommendation to post a IG post during the 7am to 4pm of a day. SELECT TO_CHAR(created_time, ‘HH24’) as hour, SUM(comments_count) AS total_comments, AVG(comments_count) AS avg_comments, SUM(likes_count) AS total_likes, AVG(likes_count) AS avg_likes, count(distinct id) as nums_of_post FROM public.shinestyinstagram_instagram_media GROUP BY 1 ORDER BY 1 Finding performance by hour of day using when the post is created:.Create a Panoply accountīelow is the flow for singing up an Panoply account: PANOPLY DESIGNS TRIALThen I created the free trial of Panoply account and follow their documentations to connect to Amazon S3 to collect the provided Instagram data. I started by reading the resources that Panoply provided and explore their website to better understand what Panoply is and how it plays a role in data analytics process. The tools and technologies that I am going to use in this project would be Panoply, Instagram data, SQL and Mode.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |