Beginner Data Analyst Project | SQL + Business Impact + GitHub | Real Retail Use Case

Time codes 0:00 - Intro to the Channel & Instructor 1:05 - Step 1: What This Project Is About (Retail Use Case, Why SQL, Tools Overview) 11:22 - Step 2: Data Analysis + Cleaning + Feature Engineering (SQL) 54:18 - Step 3: Key Insights & Recommendations 57:10 - Uploading Project to GitHub (Portfolio Tip!) 🎯 About this Project This beginner-friendly SQL project walks you through a real-world retail use case—from understanding business problems to extracting actionable insights. We use a customer shopping trends dataset sourced from Kaggle and simulate the role of a Customer Analytics Specialist brought in to help a large retail store improve sales and reduce lost sales and dead stock. 💡 What You’ll Learn ✔️ How to approach real business problems as a data analyst ✔️ Writing SQL queries to answer key business questions ✔️ Analyzing seasonal trends, customer behavior, and location performance ✔️ Making strategic recommendations based on data ✔️ Uploading your work to GitHub to showcase your skills 🛠 Tools Used SQL (MySQL) Kaggle dataset GitHub (for project upload & version control) 📂 GitHub Link: https://github.com/StaceySamoe/customer_shopping_trends- How to load a CSV onto MySQL - https://www.youtube.com/watch?v=UOqKx8RGwDU&t=10s Link to dataset - https://www.kaggle.com/datasets/iamsouravbanerjee/customer-shopping-trends-dataset