j
joleo7

Johnny Saputra

@joleo7

Data Analyst for SQL, Data Cleaning and Business Insights

Indonesia
English
About me
I am a Data Analyst specializing in SQL, data cleaning, and transforming raw data into clear, reliable insights. I have experience working with large datasets (500K+ rows), helping businesses: - Clean and structure messy data - Remove duplicates and inconsistencies - Prepare data for reporting and dashboards - Analyze sales and customer trends I focus on accuracy, clarity, and delivering results that are ready to use for business decisions. If you need clean, well-structured data and actionable insights, I’m here to help.... Read more

Skills

j
joleo7
Johnny Saputra
Offline • 

See my services

Data Cleaning
I will clean, organize and analyze your data using excel and sql
From$15 / projectMore details
Formulas & Macros
I will clean messy excel or CSV data and fix date issues
From$10 / projectMore details

Portfolio

Work experience

Freelancing_Career

Data Analyst

Freelancing Career • Self-employed

Jan 2025 - Present • 1 yr 5 mos

DATA PROJECTS Ecommerce Sales Dashboard — Tableau | SQL | Excel Processed 500K+ transactions, built KPI dashboard (sales $10.6M, 38 countries), analyzed seasonal trends and top-selling products. Loan Risk Analysis — SQL | Tableau Used SQL CTE, joins, and window functions to segment risk and identify key default indicators. Sales & Inventory Dashboard — Power BI Automated GMV, stock-out, and forecasting reports using Power Query & DAX.