You will get messy E-commerce CSV or Excel inventory data cleaned and formatted
Project details
Project Description:
Are you spending hours fixing messy inventory files instead of running your store?
I specialize in cleaning and formatting messy e-commerce data so you can upload your products to Shopify, Amazon, or WooCommerce without errors. With hands-on experience in advanced Excel, Google Sheets, and SQL, I work fast and with 100% accuracy.
What I will do for you:
Remove duplicates and blank rows.
Fix formatting issues (proper capitalization, fixing dates/numbers).
Split or merge columns (e.g., separating addresses or names).
Standardize product categories and tags.
Consolidate multiple messy CSVs into one clean master sheet.
Send me a message if your file is exceptionally large or complex, and we can discuss a custom approach!
Are you spending hours fixing messy inventory files instead of running your store?
I specialize in cleaning and formatting messy e-commerce data so you can upload your products to Shopify, Amazon, or WooCommerce without errors. With hands-on experience in advanced Excel, Google Sheets, and SQL, I work fast and with 100% accuracy.
What I will do for you:
Remove duplicates and blank rows.
Fix formatting issues (proper capitalization, fixing dates/numbers).
Split or merge columns (e.g., separating addresses or names).
Standardize product categories and tags.
Consolidate multiple messy CSVs into one clean master sheet.
Send me a message if your file is exceptionally large or complex, and we can discuss a custom approach!
What's included
| Service Tiers |
Starter
$9
|
Standard
$18
|
Advanced
$36
|
|---|---|---|---|
| Delivery Time | 1 day | 2 days | 3 days |
Number of Revisions | 0 | 0 | 0 |
1 review
(0)
(0)
(1)
(0)
(0)
This project doesn't have any reviews.
PK
Prashant K.
Jun 11, 2026
Google BigQuery and Dashboard Creation
Rohit apparently knew what he was doing, but never took accountability for the work. Communicating with him was a MAJOR headache. I hired a new resource and he did the same task within a day. I think he is busy with other projects and lacked availability for my project. I wish him luck in his future projects.
About Rohit
Data Analyst, Looker Studio, Power BI Expert, Excel, Python, G Sheet
Solapur, India - 9:11 am local time
As a Google Certified Data Analyst with a verified Credly professional badge, I specialize in end-to-end data pipelines—from writing optimized SQL queries in BigQuery to building interactive visual stories that answer critical business questions.
🎯 HOW I HELP YOUR BUSINESS SAVE TIME & GROW
Automate Manual Reporting: Replace tedious, repetitive daily/weekly Excel tasks with auto-refreshing dashboards.
Centralize Data: Connect and clean data from e-commerce platforms, databases, and marketing channels into a single source of truth.
Identify Growth Opportunities: Uncover hidden trends in customer behavior, sales pipelines, and product performance.
📊 PROVEN EXPERTISE (Featured Case Studies)
E-Commerce Sales Performance (Amazon Analysis): Engineered a multi-layer data pipeline in Google BigQuery to clean and process a 42K-item Amazon sales dataset. Implemented custom business logic flags, systematically handled null values, and built an interactive Looker Studio dashboard tracking core e-commerce health metrics and inventory usability.
Customer Segmentation & ROI Optimization (Retail): Developed a comprehensive RFM (Recency, Frequency, Monetary) scoring model for a UK Retailer, identifying high-value customer tiers to optimize marketing spend.
Consumer Trend Analysis & Product Strategy (Wellness): Systematically cleaned and analyzed complex wellness datasets to uncover behavioral patterns, translating data into strategic product recommendations.
📑 MY TECHNICAL TOOLKIT
Data Cleaning & Cloud Warehousing: SQL, Google BigQuery, Python (Pandas/NumPy), Power Query.
Interactive Visualizations: Power BI (Advanced DAX, MTD/QTD/YTD tracking), Tableau Desktop, Looker Studio (Data blends & joins).
Analytics Methodologies: Exploratory Data Analysis (EDA), Statistical Analysis, RFM Modeling, KPI Governance, Custom Business Logic Mapping.
💼 WHY WORK WITH ME?
I don't just build charts; I build reporting systems you can actually trust to guide your business decisions. I am deeply committed to data accuracy, clean documentation, and clear, proactive communication.
Steps for completing your project
After purchasing the project, send requirements so Rohit can start the project.
Delivery time starts when Rohit receives requirements from you.
Rohit works on your project following the steps below.
Revisions may occur after the delivery date.
2
Client will send Raw Data