j
joleo7

Johnny Saputra

@joleo7

Data Analyst for SQL, Data Cleaning and Business Insights

Indonésie
Anglais
Certaines informations sont présentées en anglais.
À propos de moi
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.... Plus d’infos

Compétences

j
joleo7
Johnny Saputra
hors ligne • 

Voir mes services

Nettoyage des données
I will clean, organize and analyze your data using excel and sql
Formules & Macros
I will clean messy excel or CSV data and fix date issues

Portfolio

Expérience professionnelle

Freelancing_Career

Data Analyst

Freelancing Career • Indépendant

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.