Shopify Customer & Sales Analysis 📊

Data Analytics Project (Excel + Power BI)

📌 Project Overview

This project focuses on analyzing Shopify sales and customer data to understand business performance, customer behavior, revenue trends, and product-level insights.

The analysis helps answer key business questions related to sales growth, taxation, order value, customer distribution, and product performance, using structured data and interactive dashboards.

---

🗂️ Repository Contents

• Shopify Sales.xlsx – Raw sales and customer dataset exported from Shopify
• Shopify Project.pbix – Power BI dashboard with interactive visualizations
• Shopify - Data Terminology.docx – Detailed explanation of dataset columns
• README.md – Project documentation

---

🧠 Business Objectives

• Analyze overall sales and revenue trends
• Understand customer distribution by location
• Identify high-performing products and categories
• Study order quantity, taxes, and total price behavior
• Support data-driven decision-making for e-commerce businesses

---

🛠️ Tools & Technologies

• Microsoft Excel – Data inspection and preparation
• Power BI – Data modeling and dashboard creation
• Shopify Sales Data – Real-world e-commerce dataset

---

📊 Dataset Description

The dataset includes transaction-level Shopify data with attributes such as:

• Order Number & Invoice Date
• Customer ID & Billing Address details
• Product ID, Variant ID, Product Type
• Quantity, Subtotal Price, Total Tax
• Total Price (USD), Currency
• Payment Gateway

A detailed explanation of each column is provided in
Shopify - Data Terminology.docx.

---

🔍 Analysis Performed

• Sales and revenue analysis
• Customer-wise and location-based insights
• Product and category performance
• Tax and pricing breakdown
• Order quantity and value distribution

---

📈 Power BI Dashboard Highlights

• Total sales & revenue KPIs
• Customer and order trends over time
• Country / city-wise sales distribution
• Product-level sales performance
• Tax contribution analysis

The dashboard allows interactive filtering to explore insights dynamically.

---

🚀 How to Use This Project

1. Open Shopify Project.pbix using Power BI Desktop
2. Load or refresh data if required
3. Use slicers and filters to explore insights
4. Refer to the terminology document for column clarity

---

📌 Project Type

• Data Analytics Project
• Business Intelligence (BI) Dashboard
• E-commerce Sales Analysis

---

🔮 Future Enhancements

• Add customer cohort analysis
• Perform RFM segmentation
• Integrate time-series forecasting
• Automate data refresh with live Shopify API

---

👤 Author

Muhammed Althaf K
B.Tech – Computer Science & Engineering Lovely Professional University