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.