j
joleo7

Johnny Saputra

@joleo7

Data Analyst for SQL, Data Cleaning and Business Insights

Indonesia
Inglese
Alcune informazioni sono riportate in lingua inglese.
Chi sono
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.... Continua a leggere

Competenze

j
joleo7
Johnny Saputra
offline • 

Consulta i miei servizi

Pulizia dei dati
I will clean, organize and analyze your data using excel and sql
Formule e macro
I will clean messy excel or CSV data and fix date issues

Portfolio

Esperienza lavorativa

Freelancing_Career

Data Analyst

Freelancing Career • Lavoratore autonomo

Jan 2025 - Present1 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.