As a Data Analyst, I specialize in cleaning, transforming, and preparing raw data for analysis using SQL and Microsoft Excel. My responsibilities include identifying and correcting data quality issues, removing duplicates, handling missing values, standardizing formats, and validating data accuracy. Using SQL, I extract, filter, and clean large datasets through queries, joins, aggregations, and data transformation techniques. In Excel, I use functions, Pivot Tables, Power Query, and data validation tools to organize and prepare data for reporting and visualization. Key Responsibilities : * Clean and preprocess raw datasets. * Remove duplicates and inconsistent records. * Handle missing and inaccurate data. * Standardize data formats and structures. * Write SQL queries to extract and transform data. * Perform data validation and quality checks. * Create Excel reports and Pivot Table analyses. * Prepare datasets for dashboards and business intelligence tools. Tools: SQL, Microsoft Excel, Power Query, Pivot Tables, Tableau. Goal: Deliver accurate, reliable, and analysis-ready data to support business decision-making.

Hi, I can help clean and structure your dataset quickly using Excel, Google Sheets, or Python depending on the file format. I can remove duplicates, standardize columns, handle missing values, fix inconsistent formatting, and return a clean dataset ready for analysis. I will also include a short summary of the cleaning steps and any useful observations, so you can clearly see what was changed. For a dataset up to 5,000 rows, I can usually complete the first clean version within a few days after receiving the file and any rules you want applied.

Machethe.sammy@gmail.com