Yash Raj's Work | ContraWork by Yash RajYash Raj
Data Analyst | SQL & Power BI | Open to Global Contracts
KPI Generation for Data Analysis Dashboarding for Excellent use of data Cleaned a 1,000-row messy HR dataset using PostgreSQL, handling inconsistent missing values, whitespace, mixed numeric/text data, and five different date formats. Built a reproducible SQL pipeline using CASE, regex, TRIM, type casting, and TO_DATE(), followed by validation checks to ensure the cleaned data remained accurate and analysis-ready. My Data Cleaning project using Excel
Where I fix Whitespaces, Handling missing values, Fixed multi date formats into one and Made it into a formal worksheet