Jackline Mwangi
Entry level data & Admin support | Excel & Data Entry
New to Contra
Jackline is building their profile!
Cleaned and prepared a healthcare dataset containing 55,501 records using SQL. I created a stagingtable to preserve the original dataset before making changes. I performed data-quality checks, identified and removed 534 duplicates using a CTE, standardized inconsistent patient names , and checked for nulls and blank values. I also cleaned hospital names by removing trailing commas and unnecessary characters, changed the date column format from text to Time,and created an Age columnusing CASE statement to help with the analysis. The cleaned dataset was then prepared for further analysis.
0
6
Created and analyzed a large car sales dataset containing 558,838 records using Excel. I created a staging table, reviewed the dataset for quality issues, identified 25 rows of corrupted rows, checked for missing dats, and developed a dashboard to summarize key sales insights.
0
18