Instagram Data Analysis

This project is about using Panoply as an ETL tool to explore Instagram data for marketing use (i.e. promotion, segmentation and etc.).

Introduction

This project is built on top of the data challenge that Panoply has released. Panoply is a cloud data warehouse that you could gather data from different data sources (i.e. AWS S3, Google analytics and etc.) easily into one place and then connect to different Business Intelligence tools (i.e. Chartio, Mode and etc.) for analytics and insights.

Panoply has recently integrated their data warehouse with Instagram API to collect data. This challenge is about using Panoply as an ETL tool to explore Instagram data for marketing use (i.e. promotion, segmentation and etc.).

I want to use SQL for data analytics, Panoply for data warehouse and Mode for BI visualization tool.

For complete write-up and code of this project, please go to my post on medium.

Project Design

1. Explore Panoply, using resources it provided for the challenge and documentations on its own website.
2. Create Panoply free trial account, connect to provided data source, connect to BI tool.
3. Explore the datasets, understand the schemas and relationships.
4. Research and come up with questions/KPI that an Instagram owner would like to track and have them answered. So they could get insights to grow their brand.
5. Lastly, use Mode to build visualizations and submit to the challenge.

References

• https://panoply.io
• https://www.instagram.com/
• https://mode.com/
• https://learn.panoply.io/instagram-data-challenge?hsCtaTracking=e1b846c2-34ad-47b7-bb07-0df8fd097604%7C91cf5c09-a1da-4592-9a8b-cb24c2be6900
• https://blog.panoply.io/analyzing-your-instagram-data-with-panoply
• https://sproutsocial.com/insights/instagram-metrics/
• https://www.wordstream.com/blog/ws/2018/11/01/instagram-analytics
• https://www.youtube.com/watch?v=I7usrwLqGV4
• https://www.youtube.com/watch?v=IRyH6Ui8cu8
• https://www.youtube.com/watch?v=KeXDG6LfoiY