j
joleo7

Johnny Saputra

@joleo7

Data Analyst for SQL, Data Cleaning and Business Insights

Indonesien
Englisch
Einige Informationen werden in englischer Sprache angezeigt.
Über mich
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.... Mehr lesen

Kompetenzen

j
joleo7
Johnny Saputra
offline • 

Meine Dienstleistungen

Datenbereinigung
I will clean, organize and analyze your data using excel and sql
Makros & Formeln
I will clean messy excel or CSV data and fix date issues

Portfolio

Arbeitserfahrung

Freelancing_Career

Data Analyst

Freelancing Career • Selbstständig

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.