Healthcare Power query

Key Contributions: Advanced Date Parsing: Developed a robust Custom M-Function to standardize mixed date formats (e.g., MM-DD-YYYY and DD/MM/YYYY) into a unified ISO format, ensuring 100% accuracy in temporal analysis. Surrogate Key Generation: Designed an automated patient identification system using Index Columns and Text Padding to create unique, non-null Primary Keys for incomplete records. Statistical Data Imputation: Handled missing values in critical columns (Age and Billing Amount) using Median Imputation to maintain statistical distribution and avoid bias from outliers. Business Logic Validation: Implemented conditional logic to calculate the Length of Stay (LOS) while automatically correcting logical errors (e.g., discharge dates occurring before visit dates). Data Quality Assurance: Performed bulk text cleaning, including trimming, case standardization, and removal of non-printable characters across multiple dimensions All Done Without loasing any Data.