You will get Data Cleaning Project to Clean Existing Data With Google Sheet Spread Sheet
Project details
I specialize in data cleaning using spreadsheet tools like Excel , Libre Calc and Google Sheets. I'll eliminate duplicates, standardize formats, and correct errors efficiently. I ensure data integrity and accuracy, delivering a polished dataset ready for your analysis. I can handle large datasets and diverse data types. Expect clear communication and timely delivery. Let's make your data work for you!
Data Tool
Google SheetsWhat's included
| Service Tiers |
Starter
$30
|
Standard
$45
|
Advanced
$75
|
|---|---|---|---|
| Delivery Time | 2 days | 4 days | 6 days |
Number of Revisions | 2 | 3 | 5 |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$15 - $35
Additional Revision
+$5About Irawan
Data Analysis , Data Cleaning
Malang, Indonesia - 4:10 pm local time
I offer a complete suite of data services, from meticulous cleaning and insightful analysis to compelling visualizations and custom code prompting. Leveraging R, Python, and spreadsheet tools, I transform raw data into actionable intelligence, enabling you to make informed decisions and drive strategic growth.
Services Offered:
Data Preparation & Cleaning:
-Removal of duplicates, inconsistencies, and errors.
-Standardization of data formats and validation.
-Research and population of missing data fields.
-Data Transformation & Formatting:
-Data type and format setting (numeric, date, text, etc.).
-String manipulation (name/address parsing).
-City, state, and ZIP code separation and validation.
-Performing necessary calculations and creating derived variables.
Data Manipulation & Analysis:
-Data aggregation and summary statistics.
-Exploratory data analysis (EDA).
-Statistical analysis and hypothesis testing.
-Identifying trends, patterns, and outliers.
-Generating actionable insights and recommendations.
Data Export & Delivery:
-Exporting cleaned data in various formats (Excel, CSV, TXT, JSON, etc.).
-Customized data delivery based on your specific requirements.
Data Visualization:
-Creating informative charts, graphs, and dashboards.
-Utilizing spreadsheet tools, R (ggplot2, plotly, etc.), and Python (matplotlib, seaborn, plotly, etc.).
-Developing interactive data visualizations for dynamic exploration.
-Communicating data insights through clear and compelling visuals.
Code Prompting (R and Python):
-Creating custom R and Python prompts for data manipulation, analysis, and visualization.
-Providing efficient and tailored code solutions for specific data tasks.
-Assisting in automating data related tasks.
Skills:
Data Analysis
Google Sheets, Excel, LibreOffice Calc
SQL
RStudio
Tableau
AirTable
Data Visualization
Trend Identification
Related Skills:
Team Collaboration
Proficiency in Indonesian and English
Technical Thinking
Experience:
Bella Beat Wellness Wearable Smart Device: Analyzed user habit data and survey data to gain insights and apply them to Bella Beat products, increasing market share and product awareness.
Online Shop Sales Analysis: Analyzed shop data to gain insights and develop strategies, resulting in a 60% increase in product visitor traffic and improved conversion rates.
Education and Certification:
Santa Maria Elementary School (1993-1999)
Santa Maria Junior and High School (1999-2005)
Architecture at Petra University Surabaya (2005-2009)
Google Junior Data Analysis Certification (2024)
Drawing
I also can do Architectural drawing as needed.
I am a Architect graduated in Petra University Indonesia. I have been doing my job as an architect and construction about 5 years. I can use Autocad and experienced in drafting 2d autocad drawing, make 3d modeling for housing and rendered picture for presentation.
I will offer you quality with a reasonable price.
Working Hour : I can give you quick response at 2.00- 10.00 GMT/UTC
I have done some work both offline and online . People are quite satisfied with my work.You can see my current portfolio for the work I have done. Please Contact me if you need someone to help with your work.
I can do House design, 2d drafting , 3d modeling ,and rendering.
Thank you
Irawan Go
Steps for completing your project
After purchasing the project, send requirements so Irawan can start the project.
Delivery time starts when Irawan receives requirements from you.
Irawan works on your project following the steps below.
Revisions may occur after the delivery date.
Consultation and discussing the work range
Consultation and discussing the work range of the project , what needed to be done and what do you expect for the final data to be .
Cleaning Dataset
Doing the cleaning of datasets to the required result