I will fix your data quality problems and perform data entry
About this Gig
My 6 years experience can help you fix your data problem. Perform data quality check to define necessary treatments, like data formatting, removing duplicate values, missing data imputation, fixing incorrect value, transform unstructured data to structured data, data encoding/ categorization for rich and many more.
What this gig includes :
- Data quality check
- Data collection from opened-access sources
- Google sheet/ Ms. Excel/ CSV data cleansing : formatting values, removing duplicate values, data imputation, fixing incorrect value, etc.
- Google sheet/ Ms. Excel/ CSV data preparation : merging files/ columns, splitting files/ columns formatting columns, data sorting, etc.
- Convert PDF/ html/ other file format to csv
- Data modelling
- Long-text field cleansing and categorization
- Splitting Big Excel Files to Multiple Files
- Data reporting : pivot tables, crosstab reports
- Data visualization using Tableau, Power BI, Looker
Tools Expertise :
- Microsoft Excel & Google Sheets
- Python
- Tableau
- Power BI
- Looker
- App Script automation
- For scraping/ crawling : Selenium, Beautifulsoup
Please contact for custom request and consultancy
FAQ
What types of files can you work with?
I can work with PDF, Excel (.xls, .xlsx) and CSV files. If you have a different file format, please contact me to discuss the possibility of converting and working with it.
Will you maintain the confidentiality of my data?
Absolutely! I take data privacy and confidentiality very seriously. Your data will be safe with me, and I will not share it with anyone and delete it once the project is done.
Can you clean data with mixed formats (numbers, text, dates)?
Yes, I can standardize any data type and fix inconsistencies.
Do you work manually?
Yes. But we don't always work manually, instead, we use some smart tools/programming languages to complete the task in a smart and efficient way!
