Welcome to my SQL portfolio! This repository showcases various SQL projects I have worked on, covering data analysis, querying, and optimization techniques. Below, you will find descriptions of my projects along with key insights and SQL scripts used to analyze different datasets.
1. Advanced Data Analysis | Advanced Data Analysis
-
Dataset: Contains Sales, Products and Customers Table.
-
Objective: Analyze Change Over Time Analysis, Cummulative Analysis, Performance Analysis, Data Segmentation, Customer Report and Product Report
-
Key SQL Techniques: Window functions, CTEs, JOINs, and aggregate functions.
2. Data Warehousing | DataWareouse
This Data Warehouse and Analytics Project showcases a complete modern data warehousing solution using SQL Server and Medallion Architecture (Bronze, Silver, Gold layers). It involves building robust ETL pipelines, creating analytical data models, and delivering SQL-based insights into customer behavior, product performance, and sales trends.
🔧 Key Features:
-
Integrates ERP and CRM datasets
-
Implements a clean star schema in the Gold layer
-
Provides clear documentation, test scripts, and BI-ready data
-
Designed with best practices in data engineering and analytics
Ideal for professionals in:
-
Data Engineering
-
SQL Development
-
ETL Development
-
Data Architecture
-
Business Intelligence
3. Global COVID-19 Impact Analysis: Deaths and Vaccination Trends | COVID-19 Impact Analysis
SQL portfolio dedicated to the analysis of global COVID-19 data, specifically focusing on deaths and vaccination trends. In this repository, I leverage SQL queries to dive into the intricate details of the pandemic's impact worldwide, exploring patterns, correlations, and insights that can be derived from the available data.
4. Data Cleaning using MySQL | Data Cleaning
This project showcases a comprehensive SQL-based data cleaning process performed on a dataset containing global tech layoffs. The primary goal was to prepare the data for analysis by handling duplicates, nulls, inconsistencies, and formatting issues.
5. Data Job Analysis | Data Job Analysis
This project analyzes the data job market using SQL, focusing on salaries and skill demands. By querying job postings, we uncover insights that can guide aspiring and current data professionals in navigating their careers effectively.
- Top 10 Highest-Paying Remote Data Analyst Jobs
- Top-Paying Data Analyst Jobs & Required Skills (2023)
- What Are the Most In-Demand Skills for Data Analysts (2023)
- Top Skills for Data Analysts Based on Salary
- Top Skills for Data Analysts: High Demand and High Pay
6. HR Employee Distribution Report | HR Employee Distribution Report
The HR Employee Distribution Report project showcases a full data warehousing pipeline—from sourcing and transforming HR data into a star schema, to running analytics with SQL and visualizing insights in Power BI. It emphasizes best practices like dimensional modeling, ETL workflows, and KPI reporting to deliver actionable business intelligence on employee demographics and department structures.
Data Architecture
- Bronze Layer: Stores raw data as-is from the source systems. Data is ingested from CSV Files into SQL Server Database.
- Silver Layer: This layer includes data cleansing, standardization, and normalization processes to prepare data for analysis.
- Gold Layer: Houses business-ready data modeled into a star schema required for reporting and analytics.