Hello Connections! 👋 I'm Shaif Khan, a data analyst and backend developer with an MCA from Lalit Narayan Mishra Institute of Economic Development and Social Change, Patna, Bihar, affiliated to Aryabhatta Knowledge University, Patna, Bihar.
This section showcases my hands-on experience with Microsoft SQL Server Management Studio (SSMS) — where I focused on data cleaning, querying, joining, and preparing datasets for further visualization and analytics.
🧾 Project Highlights: 🦠 COVID-19 Data Cleaning in SSMS (v19.2) ✅ Imported raw COVID data into SQL Server
✅ Performed cleaning using ISNULL, CAST, CASE, and TRIM functions
✅ Removed duplicates, fixed nulls, standardized date formats
✅ Prepared cleaned dataset for BI tools (Power BI/Tableau)
🍕 Pizza Sales Data Cleaning in SSMS (v20.0) ✅ Used SQL joins to combine sales, customer, and product tables
✅ Applied GROUP BY, ORDER BY, and HAVING for insights
✅ Cleaned messy strings and invalid transaction data
✅ Ready-to-use output for dashboarding and business reporting
🏦 Bank Loan Data Analysis & Cleaning ✅ Handled missing values and formatted categorical data
✅ Segmented loan types, filtered approved vs rejected loans
✅ Used aggregate functions to summarize borrower behavior
✅ Structured dataset exported for machine learning & visualization use
🧰 Tools & Techniques Used: 🧱 SQL Server Management Studio (SSMS) v19.2 & v20.0
📊 SQL Queries – SELECT, JOIN, WHERE, GROUP BY, ORDER BY
🧹 Data Cleaning Functions – ISNULL, CAST, TRIM, CASE, COALESCE
🔁 Joins & Subqueries – For dataset integration
🏷️ Aliases, Temp Tables, and Views – For modular query building
🎯 What These Projects Demonstrate: 🧠 Strong foundation in SQL syntax and logic
🧹 Experience in cleaning and shaping data at the database level
🧑💻 Ability to prepare analysis-ready datasets
📊 Practical SQL use cases for real-world data problems
🔗 Let’s Connect! Interested in the queries, cleaned datasets, or integration with BI tools like Power BI? Let’s collaborate or discuss more!
📌 Tags & Topics #SQLServer #SSMS #DataCleaning #COVID19Data #PizzaSalesAnalysis #BankLoanSQL #SQLProjects #Joins #SQLQueries #SQLDataPreparation #BusinessIntelligence #DataWrangling #SSMS20