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: Then 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. Use Mode to build visualizations and submit to the challenge.So they could get insights to grow their brand. Research and come up with questions/metrics/KPIs that an Instagram owner would like to track and have them answered.Explore the datasets, understand the schemas and relationships.Create Panoply free trial account, connect to provided data source, connect to BI tool.Explore Panoply, using resources it provided for the challenge and documentations on its own website.The final deliverable of this challenge will be in English, data visualization(s) for communicating your findings and the SQL queries that you have used. Then you can use any of your choice of BI tools for data visualization. Shinesty: An innovative and edgy apparel brand.Kirsten Alana: A top Instagram Influencer.Or if you prefer to use the data provided by Panoply, you can choose from 2 accounts: If you have an Instagram account, you can use the data from your own Instagram account. In this challenge, challengers are asked to set up a Panoply account, and connect to self Instagram or provided Instagram data to perform analyses, draw insights and build visualization for storytelling. This challenge is about using Panoply as an ETL tool to explore Instagram data for marketing use (i.e. Panoply has recently integrated their data warehouse with Instagram API to collect data. Chartio, Mode and etc.) for analytics and insights. AWS S3, Google analytics and etc.) easily into one place and then connect to different Business Intelligence tools (i.e. Panoply is a cloud data warehouse that you could gather data from different data sources (i.e. This project is built on top of the data challenge that Panoply has released in Apr 2019.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |