A collection of SQL analytics projects built using PostgreSQL to solve real-world business problems through data analysis, customer analytics, and job market intelligence.
- PostgreSQL
- SQL
- Joins
- Common Table Expressions (CTEs)
- Window Functions
- Aggregate Functions
- GROUP BY & HAVING
- Customer Segmentation
- Cohort Analysis
- Retention Analysis
- Salary & Skill Demand Analysis
- Business Intelligence
Business-focused customer analytics project examining customer lifetime value, cohort performance, retention patterns, and churn behavior.
- Customer Segmentation
- Cohort Revenue Analysis
- Customer Retention Analysis
- Customer Lifetime Value (LTV)
- Revenue is heavily concentrated among high-value customers.
- Customer value varies significantly across acquisition cohorts.
- Retention rates decline consistently over time.
- Long-term customer retention strongly impacts customer lifetime value.
📂 Open: SQL_Customer_Cohort_Analysis
SQL project analyzing salary trends, skill demand, and compensation patterns across thousands of Data Analyst job postings.
- Top Paying Jobs
- Top Paying Skills
- Most In-Demand Skills
- Optimal Skills Analysis
- Salary vs Demand Comparison
- SQL remains the most valuable foundational Data Analyst skill.
- Python, Tableau, and Power BI continue to show strong market demand.
- Cloud technologies command premium salaries.
- The best career opportunities balance both demand and compensation.
📂 Open: SQL_Data_Job_Analysis
SQL_Projects_Data_Analytics
│
├── SQL_Customer_Cohort_Analysis
│ ├── Customer Cohort & Retention Analysis
│ └── README.md
│
├── SQL_Data_Job_Analysis
│ ├── Data Analyst Job Market Analysis
│ └── README.md
│
└── README.md
These projects demonstrate how SQL can be used to solve business problems through customer analytics, market research, cohort analysis, retention analysis, and salary intelligence.
The repository focuses on practical analytical workflows commonly used by Data Analysts, Business Intelligence Analysts, and Reporting Analysts.