![https://images.unsplash.com/photo-1633412802994-5c058f151b66?ixlib=rb-4.0.3&q=80&fm=jpg&crop=entropy&cs=tinysrgb](https://images.unsplash.com/photo-1633412802994-5c058f151b66?ixlib=rb-4.0.3&q=80&fm=jpg&crop=entropy&cs=tinysrgb)
Table of Contents
👩🏽💻 Solve Business Problems with Instagram Data
🗣️ Introduction
- The purpose of this project is to help a business to optimize its marketing campaigns by analyzing Instagram data using SQL.
- The Marketing Team has identified several key problems, and we (Analytics Team) will use data to provide insights and recommendations to improve marketing campaigns, and ultimately increase user engagement.
🎯 Objective
- Explore and analyze Instagram database.
- Transform the business by using SQL analytical skills to provide accurate data and increase user engagement.
- Be the go-to person for all mission-critical analyses, making you an invaluable asset to the company and a vital member of the team.
📊 Entity Relationship Diagram
![IG_Project_ERD.png](https://s3-us-west-2.amazonaws.com/secure.notion-static.com/96134fdb-9c4b-4e6c-8a7b-bf54d91d72ef/IG_Project_ERD.png)
🛠️ Create Tables
Pro Tip → The reason why I create users and photos tables prior to the other tables is that they rely on users and photos tables.