Valentine's Analysis [Dummy Dataset]

This repository contains the Valentine's Analysis project, which uses SQL queries to explore and analyze data on Valentine-related trends and behaviors. The project focuses on deriving insights from the dataset and presenting findings in a structured manner.

Repository Contents

• Dataset/: Contains the dataset used for the analysis.
  • valentine_purchases.csv: The dataset used for exploratory data analysis.
• MySQL_Scripts/: Includes SQL scripts for analysis.
  • valentine_purchases.sql: SQL queries used for the exploratory data analysis.
• Documentation/: Comprehensive PDF document explaining the process.
  • Valentine's Day Sales Analysis.pdf: Details the exploratory analysis with SQL queries.

Objectives

1. Analyze Revenue and Sales Performance.
2. Evaluate Customer Demographics and Buying Behavior.
3. Identify Shopping Trends and Best-Selling Products.
4. Assess Search Behavior and Conversion Rates.
5. Analyze Geographical Performance Meetup Points.
6. Evaluate Customer Spending and Values.

How to Use

1. Clone the repository:

   git clone https://github.com/your-username/Valentine_Analysis.git

2. Import the dataset into a SQL database (e.g., MySQL Workbench).
3. Run valentine_purchases.sql in the MySQL_Scripts/ folder for analysis.