This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.
-
Updated
Dec 12, 2025 - TSQL
This repository contains a collection of SQL scripts demonstrating various analytical techniques, such as changes over time, cumulative, performance, data segmentation, part-to-whole analysis.
Building a modern data warehouse with SQL server including ETL processes, data modeling and analytics.
Exploratory Data Analysis on a Supply Chain Database using T-SQL. Includes multi-layered data architecture, key metrics, ranking analysis, and actionable business insights.
End-to-end SQL Data Warehouse project using T-SQL and ETL pipeline (Bronze → Silver → Gold)
A scalable and optimized data warehouse solution designed for efficient data integration, transformation, and analytics. This project demonstrates ETL workflows, dimensional modeling, and query performance tuning using modern data warehousing practices.
This project cleans and prepares a layoffs dataset using SQL by removing duplicates, standardizing text, handling null/blank values, and dropping unnecessary columns. The result is a consistent, high-quality dataset ready for reporting, analysis, and visualization.
This project analyzes a coffee shop’s transaction dataset to uncover sales trends, customer behavior, and product performance. It combines SQL queries for data exploration with a Power BI dashboard for interactive visualization. The goal is to demonstrate beginner-to-intermediate level skills in SQL data analysis and Power BI reporting.
This project presents a comprehensive data analysis for the Information Technology Institute (ITI) training system, which includes 9 branches (Smart Village , Alexandria, Assiut, Mansoura ,Ismailia , Luxor , Aswan , Beni Suef , Port Said) across different locations. The data involves students from various countries
E-Commerce Consumer Behavior Analysis & Business Insights
🎯 Sales Dashboard Project using SQL + Power BI | Built on AdventureWorksDW2019 | Cleaned, transformed, and visualized internet sales data to practice real-world Data Analyst skills
An exploratory marketing analysis using SQL Server, Excel, and Tableau to uncover key customer traits, top-performing products, and campaign success. Two dashboards reveal marketing and customer insights, highlighting campaign performance, underperforming channels, and behavioral patterns driving web purchases. Data sourced from Maven Analytics.
Building a modern data warehouse with SQL Server, including data modeling, analytics and ETL processes.
An in-depth Exploratory Data Analysis (EDA) project that leverages Python libraries like Pandas, Matplotlib, and Seaborn to uncover trends, patterns, and insights from datasets, preparing the data for further analysis or modeling.
Welcome to my repository featuring solutions to the SQL 50 challenge from LeetCode. Whether you're practicing for technical interviews or just looking to sharpen your SQL skills, this collection covers a wide range of topics from basic to complex queries.
Modern Data Warehouse with SQL Server, including ETL process, data modeling and analytics.
The Sales Analysis Project extracts and models data from the AdventureWorks database to visualize key metrics like Total Sales, Budget, and Net Profit. It includes bar charts for top products and customers, pie charts for category breakdowns, and tables for monthly spending and sales trends.
My final project for my Data Analytics trainings course
A Full Data Analysis project where a sales data is ask,prepare,process,analyze,share and act through data analysis process
🚀 Excited to share my latest project, a Bank Loan Analysis Dashboard developed in Power BI. This dashboard provides a consolidated view of key metrics, offering deep insights into loan applications, funding, and repayments.
collection of SQL - Tableau integration projects for Data Analytics and Business Intelligence
Add a description, image, and links to the dataanalysis topic page so that developers can more easily learn about it.
To associate your repository with the dataanalysis topic, visit your repo's landing page and select "manage topics."