A comprehensive learning resource for data analytics, covering Python, SQL, statistics, and advanced visualization techniques with hands-on projects and datasets. Guides learners from foundational concepts to advanced methods like predictive modeling and dashboard creation.

End-to-end data analytics project using Python and SQL. Utilized Kaggle API to fetch retail data, pandas for cleaning and transformation, and SQL Server for storage and querying. Advanced SQL queries provided actionable insights, showcasing skills in data processing, database management, and analytical problem-solving for real-world datasets.

This is my project for Intermediate SQL for Data Analytics, using the Contoso dataset to analyze sales, customers, and products with advanced queries.

Advanced SQL analytics project extending prior EDA work. Includes change-over-time, cumulative trends, performance benchmarking, segmentation, part-to-whole analysis, and customer/product analytical reporting using window functions and real-world data warehouse logic.

بسم الله الرحمن الرحيم C.V. NAME: SHA'BAN YOUSEF MOHAMMAD ELQASASS TELE PHONE NO. : 0799455189 NATIONALITY: JORDANIAN ADDRESS: JORDAN-AMMAN E-MAIL: SHBNQ422@YAHOO.COM WWW.SHAABANALQASSAS.COM CERTIFICATES: • HIGHER DIPLOMA IN INFORMATION TECHNOLOGY ( THE UNIVERSITY OF JORDAN) • B.CS IN CHEMISTRY AND COMPUTER FROM YARMOUK UNIVERSITY JORDAN • MCAD.NET (MICROSOFT CERTIFIED APPLICATION DEVELOPER 2003) • ADO.NET; ASP.NET ; MVC :LINQ :VB.NET : C# • MS SQL SERVER DATABASE 2005-2008-2012-2014 • ACCESSING DATA WITH MICROSOFT .NET FRAMEWORK 4 CERTIFICATE -MICROSOFT • JOOMLA WEBSITES DEVELOPER • PHP; MYSQL DATABASE; • MICROSOFT CERTIFIED TECHNOLOGY SPECIALIST (MCTS 2013) • CERTIFICATE DEVELOPING DATA ACCESS SOLUTIONS- MICROSOFT • CERTIFICATE DEVELOPING WEB APPLICATIONS – MICROSOFT • CERTIFICATE ADMIN TEAM FOUNDATION SERVER – MICROSOFT • CERTIFICATE DEVELOPING SILVERLIGHT – MICROSOFT • OFFICIAL TRANING IN ARCGIS 10.1 (I) – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 ( II) – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 ( III) performing analysis – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 ( BUILDING GEODATABASE) – BY ESRI • OFFICIAL TRANING IN IMPLEMENTING VERSIONED WORKFLOWS IN A MULTIUSER GEODATABASE – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 ( BUILDING WEB APPLICATION USING THE ARCGIS API ) – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 ( INTRODUCTION TO ARCGIS SERVER) – BY ESRI • OFFICIAL TRANING IN ARCGIS 10.1 (CONFIGURING & MANAGING THE MULTIUSER GEODATABASE (SDE)) – BY ESRI • CERTIFICATE MAINTAINING MICROSOFT SQL SERVER DATABASE-MICROSOFT • CERTIFICATE IMPLEMENTING MICROSOFT SQL SERVER DATABASE REPORTING SERVICES- MICROSOFT • CERTIFICATE SHAREPOINT SERVER ADMINISTRATION- MICROSOFT • CERTIFICATE SHAREPOINT SERVER DEVELOPMENT- MICROSOFT • BUSINESS INTELLIGENCE TOOLS :DATA ANALYSIS SERVICES, DATA TRANSFORMATION SERVICES (DTS), DATA MIGRATION SERVICES, ETL (EXTRACT, TRANSFORM, AND LOAD) SERVICES, • ONLINE ANALYTICAL PROCESSING (OLAP) AND DATA-MINING TOOLS • CERTIFICATE WRITING QUERIES USING MICROSOFT SQL SERVER TRANSACT SQL –MICROSOFT • CERTIFICATE IMPLEMENTING AND MAINTAINING MICROSOFT SQL SERVER ANALYSIS SERVICES –MICROSOFT • CERTIFICATE IMPLEMENTING AND MAINTAINING MICROSOFT SQL SERVER INTEGRATION SERVICES –MICROSOFT • CERTIFICATE ADMINISTERING TEAM FOUNDATION SERVER • SYSTEM ADMINISTRATOR • Adobe program (graphics & design) • MS - SQL SERVER REPORTING SERVICE-OLAP-BI • SPSS ADVANCED TRAINING • ICDL CERTIFICATE • GEOMEDIA PROFESSIONAL GIS • GEOMEDIA WEBMAP GIS • GEOMEDIA TRANSPORTAION GIS • INTEL CERTIFICATE FUTURE FOR LEARNING • A+ COMPUTER MAINTENANCE (HARDWARE & SOFTWARE) • NETWORK + • SPECIALIZED COURSE IN METHODS OF CALCULATING THE RATE OF POPULATION GROWTH / DEPARTMENT OF STATISTICS • COURSE COMPLETION DEMOGRAPHIC / DEPARTMENT OF STATISTICS • SPECIALIZED COURSE IN THE MEASUREMENT OF IMMIGRATION / DEPARTMENT OF STATISTICS. • Develop GIS websites using GIS SILVERLIGHT asp.net technology. • Develop GIS websites using GIS flex technology. • Certificate projection methods and simulation models-UNESCO • Specialized course in fertility / Department of Statistics. • Specialized course in the measurement of levels and patterns of DEATH / DEPARTMENT OF STATISTICS • COURSE CODE POPULATION PROJECTIONS / DEPARTMENT OF STATISTICS • SPECIALIZED COURSE IN THE PREPARATION OF PROJECTIONS IN CRISES AND STRATEGIC PLANNING - UNESCO • WEB DESIGN USING DREAM WAVER • ASSOCIATE REGIONAL WORKSHOP ON EDUCATION STATISTICS - UNESCO INSTITUTE FOR STATISTICS • USING SPSS PROGRAM • ADVANCED COURSE IN STRATEGIC PLANNING AND THE PREPARATION OF INDICATORS • ADVANCED COURSE IN-DEPTH DEMOGRAPHIC ANALYSIS (U.S.BUREAU OF CENSUS) • ADVANCED COURSE IN POPULATION PROJECTIONS (U.S.BUREAU OF CENSUS) • EMIS EDUCATIONAL MANAGEMENT INFORMATION SYSTEM EXPERIENCES: • HEAD OF EMIS AND GIS DIVISION ) EDUCATIONAL MANAGEMENT INFORMATION SYSTEM( • HEAD OF PLANNING AND STATISTICS DIVISION • SUPERVISOR IN THE STATISTICS OF THE POPULATION IN THE KINGDOM IN 2004 AND DESIGNED STATISTICAL SOFTWARE.PARTICIPANT IN THE DEVELOPMENT OF DATABASES AND SOFTWARE EDUCATIONAL INDICATORS SIDE WITH GIS MAPS OF SCHOOL • TEAM LEADER IN DEVELOPMENT OF INFORMATION SYSTEM PROJECT ERSP • TEAM LEADER IN DEVELOPMENT OF INFORMATION SYSTEM PROJECT OPENEMIS • PARTICIPANT IN THE DEVELOPMENT OF DATABASES AND SOFTWARE STATISTICAL INFORMATION AND SURVEY FOR SCHOOL FOOD.. UNITED NATIONS WORLD FOOD PROGRAMME (WFP) • PARTICIPANT IN THE DEVELOPMENT OF DATABASES AND SOFTWARE STATISTICAL INFORMATION EMIS-EDUWAVE. • DEVELOP AND MANAGE IMPLEMENTATION OF PROJECT COMMUNICATION STRATEGIES AND COORDINATE CHANGE MANAGEMENT. • NATIONAL COORDINATOR OF THE EDUCATION INDICATORS WEI "WORLD EDUCATION INDICATOR" -UNESCO • DATABASE SPECIALISTS OF PARLIAMENTARY ELECTIONS • DATABASE ADMINISTRATION • DATABASE DESIGN, IMPLEMENTATION, TRANSACTION PROCESSING, REFERENTIAL INTEGRITY, PERFORMANCE TUNING AND MONITORING WITH AN EMPHASIS IN MS SQL. • MONITOR, REVIEW, AND VERIFY BACKUPS, RECOVERY, AND DISASTER RECOVERY PROCESSES. • CONTROL AND MONITOR USER ACCESS TO DATABASES AND MAINTAIN DATABASE SECURITY. • TROUBLESHOOT JOB FAILURES, PERFORMANCE ISSUES, DATABASE INTERGRITY, ETC. • MONITOR ALERTS AND TAKE CORRECTIVE ACTION OR ESCALATE ISSUES. • RESOLVE DATABASE REQUESTS AND ISSUES. • PERFORM DATABASE TUNING FOR OPTIMAL PERFORMANCE. • WORK CLOSELY WITH DEVELOPMENT AND NETWORK TEAMS ON RESOLVING ISSUES. • MAINTAIN DOCUMENTATION OF SYSTEMS AND STANDARD OPERATING POLICIES AND PROCEDURES. • ASSOCIATE IN THE DEVELOPMENT OF PARLIAMENTARY ELECTIONS SCHEDULES FOLLOW-UP AND THE RESULTS. • PARTICIPANTS IN THE INFORMATION SYSTEMS INTEGRATION PROJECT IN THE MINISTRY OF EDUCATION. • PARTICIPANT IN THE DEVELOPMENT OF DATABASES AND APPLICATION FOR SYRIAN REFUGEES CRISIS INFORMATION SYSTEM • PARTICIPANT IN THE LAMP (LITERACY ASSESSMENT AND MONITORING PROGRAM) –UNESCO • PARTICIPANT IN THE OUT OF SCHOOL CHILDREN STUDY – WITH UNICEF AND UNESCO • PARTICIPANT IN THE DEVELOPMENT OF THE DIRECTORATE AND THE SCHOOL (SDDP), • PARTICIPANT IN WORKSHOP FOR CHANGE MANAGEMENT –USAID • PARTICIPANT IN WORKSHOP FOR STATISTICAL INFORMATION –UNESCO &ALECSO- TUNIS • PARTICIPANT IN WORKSHOP FOR MONITORING AND EVALUATION -USAID • DESIGN AND CONSTRUCTION OF APPROPRIATE EDUCATIONAL POLICIES. • ADVANCED COURSE IN LEADERSHIP IN STRATEGIC COMMUNICATION • ADVANCED COURSE IN USING SPSS FOR DATA ANALYSIS • ADVANCED COURSE IN USING SPSS FOR DEMOGRAPHIC HEALTH SURVEYS • DESIGNER STATISTICAL SOFTWARE ESPECIALLY IN THE CAMPAIGN PROVIDES YALA MAY IN AMMAN IN 2009. • WEB SITE DEVELOPER AND DESIGN • PREPARE AND PARTICIPATE IN WORKSHOPS, INTERNATIONAL INDICATORS AND STRATEGIC PLANNING AND THE USE OF SOFTWARE AND DEVELOPMENT • PROGRAMMER IN PLANNING DIVISION SINCE 1/2004 • TEACHER FOR COMPUTER AND CHEMISTRY FROM 8/1995 • TRAINER FOR VISUAL BASIC.NET ADO.NET ASP.NET AND ICDL CERTIFICATE الاسم: شعبان يوسف محمد القصاص هاتف: 0799455189 فاكس :5666492 الجنسية: أردني العنوان: الأردن -عمان البريد الالكتروني: SHBNQ422@YAHOO.COM WWW.SHAABANALQASSAS.COM المؤهل العلمي: دبلوم عالي في تكنولوجيا المعلومات الجامعة الأردنية بكالوريوس كيمياء و حاسوب من جامعة اليرموك الأردنية عام 1993 شهادة مطور برمجيات ميكروسوفت من شركة ميكروسوفت العالمية ( MCAD .NET ) MS SQL server DATABASE 2005-2008-2012-2014 /ASP.NET/ ADO.NET/ VB.net C#: MVC : LINQ PHP ; MYSQL DATABASE دورة "أخصائي تكنولوجيا معتمد من مايكروسوفتMCTS MS - SQL SERVER REPORTING SERVICE –OLAP-BI MS ANALYSIS SERVICE System administrator Joomla website developer شهادةNETWORK + الدولية في شبكات الحاسوب شهادة التعليم للمستقبل INTEL لحوسبة التعليم شهادةA+ الدولية في صيانة الحاسوب شهادة نظم إدارة المعلومات التربوية EMIS وشهادة الخرائط الجغرافية GIS تدريب متخصص ArcGIS10.1 (I) شركة ESRI العالمية تدريب متخصص ArcGIS10.1 (II) شركة ESRI العالمية تدريب متخصص ArcGIS10.1 (III) performing analysis شركة ESRI العالمية تدريب متخصص ArcGIS10.1 (building geodatabase) شركة ESRI العالمية تدريب متخصص SharePoint إدارة وتطوير GEOMEDIA PROFESSIONAL GIS GEOMEDIA WEBMAP GIS GEOMEDIA TRANSPORTAION GIS دورة استخدام برمجيات المؤشرات والتحليل الاحصائي devinfo spectrum -- دورة متخصصة في اساليب حساب معدل النمو السكاني / دائرة الاحصاءات العامة دورة متخصصة في الاستكمال الديمغرافي / دائرة الاحصاءات العامة دورة متخصصة في قياس الهجرة / دائرة الاحصاءات العامة دورة متخصصة في الخصوبة / دائرة الاحصاءات العامة دورة متخصصة في قياس مستويات وانماط الوفاة / دائرة الاحصاءات العامة دورة متخصصة في برمجية الاسقاطات السكانية / دائرة الاحصاءات العامة Adobe program (graphics & design) تصميم مواقع الانترنت باستخدام Dream Waver استخدام برمجية SPSS في التحليل الاحصائي دورة متقدمة في التخطيط الاستراتيجي واعداد المؤشرات دورة متخصصة في اعداد الاسقاطات في الازمات والتخطيط الاستراتيجي - يونيسكو دورة متقدمة في التحليل الديمغرافي المعمق U.S.BUREAU OF CENSUS دورة متقدمة في الاسقاطات السكانية U.S.BUREAU OF CENSUS الخبرات: • رئيس قسم نظام إدارة المعلومات التربوية EMIS والخرائط GIS في وزارة التربية • رئيس قسم التخطيط والاحصاء التربوي في وزارة التربية والتعليم من تاريخ 2006 . • اعداد والمشاركة في ورش المؤشرات الدولية والتخطيط الاستراتيجي واستخدام برمجياتها وتطويرها • مشرف في الاحصاءات العامة للسكان في المملكة للعام 2004 ومصمم برمجيات احصائية. • تطوير مواقع انترنت الجغرافية باستخدام تقنية GIS SILVERLIGHT asp.net • تطوير مواقع انترنت الجغرافية باستخدام تقنية GIS flex • اخصائي قواعد بيانات في الهيئة المستقلة للانتخاب –الأردن • مدير فريق تطوير نظام إدارة المعلومات التربوي والمؤشرات التربية ERSP • مدير فريق تطوير نظام إدارة المعلومات التربوي والمؤشرات التربية OpenEMIS • مشارك في تطوير قواعد بيانات و معلومات الطلبة اللاجئين السوريين • مشارك في ورشة عمل في إدارة التغيير – USIAD • مشارك في ورشة عمل في المتابعة والتقييم - USIAD • مشارك في تطوير قواعد بيانات و برمجيات المؤشرات التربوية باستخدام الخرائط المدرسية GIS • مشارك في الانتخابات النيابية تطوير جداول المتابعة واصدار النتائج. • مشارك في تطوير قواعد بيانات وبرمجيات المعلومات الاحصائية EMIS-Eduwave • مشارك في مشروع تطوير المديرية والمدرسة (SDDP) ورسم وبناء السياسات التربوية . • مشارك في مشروع تكامل انظمة المعلومات في وزارة التربية والتعليم • مشارك في مشروع احصائيات معرفة القراءة والكتابة برنامج تقييم وتتبع مستويات القرائية LAMP • دورة متقدمة في القيادة في استراتيجية الاتصال . جامعة ميتشغان الامريكية • المنسق الوطني لمؤشرات التعليم WEI "World Education Indicator " -UNESCO • مشارك في ورشة عمل الاقليمية حول احصاءات التعليم – معهد اليونسكو للاحصاء • مصمم برمجيات احصائية خاصة في حملة يالا نوفر مي في عمان للعام 2009 • مطور ومصمم مواقع انترنت • مبرمج في قسم التخطيط في مديرية التربية والتعليم .تطوير برامج الحاسوب لحوسبة أعمال القسم من تاريخ 2004 • مدرس لمادتي الكيمياء والحاسوب للمرحلة الثانوية والأساسية من تاريخ 1995 • مدرب لبرمجية visual basic .net asp.net ado.net من تاريخ 2004 • مدرب لشهادة الحاسوب الدولية ICDL)) من تاريخ 2001

ITI Data Analytics Track - Advanced PL/SQL Project

This project showcases the end to end data analysis—from data ingestion and transformation to advanced analytics using SQL & Python and interactive data visualization using Tableau.

SQL Server database project with advanced analytics, data integrity logic, and Power BI dashboards for inventory and sales insights.

Discover a portfolio of comprehensive data analytics projects featuring SQL, Python, and Power BI. Uncover critical insights and data-driven solutions to real-world challenges through advanced data extraction, in-depth analysis, and dynamic visualization. Perfect for both novices and seasoned professionals aiming to elevate their data analytics.

📚 An End-to-End Advanced SQL Project covering Data Warehousing, ETL Pipeline (Bronze → Silver → Gold), Star Schema Modeling, EDA, and Advanced SQL Analytics. Built using PostgreSQL, this project simulates a real-world Data Engineering + Data Analytics workflow using raw ERP & CRM data to generate production-ready customer and product insights.

Online Bookstore SQL Analytics project using PostgreSQL for database design, data import, and business insights through advanced SQL queries.

An advanced data analytics project using Power BI and SQL to analyze and visualize global development indicators sourced from the World Bank API.

The HR Analytics Project with Advanced Excel and SQL Queries is a comprehensive initiative designed to harness the power of data for strategic human resources management.

Develop a modern data warehouse using SQL Server, incorporating a full ETL (Extract, Transform, Load) pipeline, optimized data modeling, and advanced analytics. The project will involve designing a scalable schema, integrating data from multiple sources, implementing efficient ETL processes using SQL Server Integration Services (SSIS).

The Caffeine Club is a complete end-to-end SQL project designed to simulate a real-world café sales and analytics system. This project focuses on **database design, data insertion, and advanced analytical queries** to derive business insights.

Data Cleaning & Analytics project using SQL to streamline and prepare raw datasets for analysis. Implemented advanced queries, data validation, and transformation techniques to identify inconsistencies, remove duplicates, and enhance data quality, enabling accurate insights and informed business decisions.

A comprehensive business intelligence solution for e-commerce analytics, demonstrating advanced SQL querying techniques combined with Python data analysis. This project analyzes customer behavior, sales performance, and business metrics to derive actionable insights.

Hospital Management Analytics Project — End-to-End ETL Pipeline using Python, MySQL Relational Database Design, and Power BI Interactive Dashboard for operational insights. Includes data cleaning, transformation, automated loading (ETL), SQL schema + advanced queries, and complete BI reporting.

This repository contains a comprehensive SQL-based analysis of UEFA competition data, focusing on teams, players, matches, goals, and stadiums. The project is designed to answer a series of specific, complex analytical questions using advanced SQL concepts, including joins, aggregations, subqueries, and window functions.

EDA analytics and advanced SQL projects showcasing data analysis skills

SQL Project for the course (Data Science and Advanced Analytics Master)

SQL Project for the course (Data Science and Advanced Analytics Master)

Advanced SQL project analyzing SaaS subscription data with cohort and revenue analytics.

This project unifies three SQL-based analytics projects - Data Warehouse and Analytics, Exploratory Data Analysis (EDA), and Advanced Retail Sales Analytics - into one comprehensive end-to-end data analytics solution.

SQL Data Analytics project showcasing real-world data exploration, segmentation, and reporting using advanced SQL queries and analytical techniques used by data analysts and BI professionals.

End-to-end SQL Data Analytics project transforming raw transactional data into business insights with ETL, EDA, and advanced analytical views.

This repository showcases an SQL data analytics project demonstrating Exploratory Data Analysis (EDA) and Advanced Analytics (CTEs, Window Functions, Subqueries, Views) in PostgreSQL.

End-to-end SQL data analytics project covering Exploratory Data Analysis (EDA), Advanced Analytics, and performance insights, with modular scripts for easy reuse.

A structured learning journey from basic to advanced SQL with real-world data engineering projects. Master SQL for data pipelines, analytics, and data engineering interviews.

BCA Final Year Student | Data Analytics Enthusiast Advanced Excel | Python | SQL | CCNA | POWER BI Building data-driven projects & dashboards