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
🛠️ 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.