Day 24: Data Analyst SQL Project ๐Ÿ” | Customer + Orders Analysis in PostgreSQL | Real-World Business

Channel:
India Tech With Nicks
Subscribers:
10,900
Published on ● Video Link: https://www.youtube.com/watch?v=hQJtpeTFAeM


Duration: 0:00
40 views
1

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



Other Videos By Tech With Nicks


2025-07-12Highlights duplicate values in excel
2025-07-12progress bar I'm excel using conditional formatting
2025-07-12Create a dynamic Drop down filter based on another cell
2025-07-07Day 30: Full SQL Revision for Data Analysts | PostgreSQL Recap from Basics to Advanced ๐Ÿ’ป๐Ÿ”ฅ
2025-07-06Day 29: Excel for Data Analysis โ€“ Full Revision | From Formulas to Dashboard in 1 Day ๐Ÿ’ป
2025-07-05Day 28: How I Created My Data Analyst Resume Using a Template | Beginner-Friendly Resume Tips!
2025-07-05Day 27: Optimizing LinkedIn + Naukri for Data Analyst Jobs | 645 HR Searches & 18 Invites in 1 Month
2025-07-04Day 26: CRM Business Performance | Zoho Analytics + SQL + Excel | CRM Churn & Revenue Insights
2025-07-02Day 25: HR Analyst Dashboard in Power BI | Employee Insights Project for Data Analyst Portfolio
2025-07-01Day 24: Data Analyst SQL Project ๐Ÿ” | Customer + Orders Analysis in PostgreSQL | Real-World Business
2025-07-01Day 23: Mastering CTEs in SQL | WITH Clause & Common Table Expressions in PostgreSQL
2025-07-01Day 22: SQL JOINS Explained | INNER, LEFT, RIGHT, FULL JOIN in PostgreSQL with Real Examples
2025-06-25Day 21: Learn Window Functions in SQL | RANK(), ROW_NUMBER(), PARTITION BY in PostgreSQL
2025-06-24Day 20: COALESCE Function in SQL Explained with Examples | PostgreSQL Data Cleaning Tip ๐Ÿ’ก
2025-06-24Day 19: Mastering CASE Function in SQL | PostgreSQL Logic Building with Real Examples | Learn SQL
2025-06-21How to Make Drop-Down List in Excel | Data Validation Excel Tip
2025-06-20IF with AND in Excel | Apply Multiple Conditions Easily
2025-06-19Excel Progress Bar with Conditional Formatting | Dashboard Tricks
2025-06-19Day 18: Date & Time Functions in SQL | Extract, NOW(), AGE(), CURRENT_DATE & More | Learn SQL Fast
2025-06-19Day 17: Master SQL String Functions | Learn UPPER, LOWER, LENGTH, SUBSTRING, TRIM | 30-Day SQL
2025-06-18Remove Duplicates in Excel with One Click | Excel Tips for Beginners