Day 24: Data Analyst SQL Project 🔍 | Customer + Orders Analysis in PostgreSQL | Real-World Business

Welcome to Day 24 of my 30-Day SQL Challenge!
Today, I started working on a real-world SQL Project — perfect for data analyst portfolios 💼

💡 Project Overview:
📂 Dataset: Customers, Orders, Products
💻 Tool: PostgreSQL (pgAdmin)
📊 Objective: Analyze sales trends, top customers, order frequency, and product performance using structured SQL queries.

🔍 Skills Applied:
JOINS across multiple tables

GROUP BY & aggregate functions

CTEs for query simplification

CASE for conditional logic

Window Functions (ROW_NUMBER, RANK)

📌 Ideal for data analyst resumes, internships, and GitHub portfolios
📅 #Day24 of #30DayDataChallenge
📺 Channel: Tech With Nicks
🔒 All data shown is fictional & used for educational purposes

Видео Day 24: Data Analyst SQL Project 🔍 | Customer + Orders Analysis in PostgreSQL | Real-World Business канала Tech With Nicks