Data Cleaning & Preparation
Text functions, lookups, validation and Power Query to turn messy records into analysis-ready tables.
Excel · Sheets · Power Query · PandasDATA ANALYST · BUSINESS INTELLIGENCE
I'm Arnawan — I clean, query and visualize 10K+ row datasets with SQL, Python, Excel and BI tools, then translate the numbers into recommendations teams can act on.
end-to-end case studies
rows per dataset
certifications & programs
educational data posts
01 / ABOUT
I connect business questions to the right data, query it carefully, and explain what the result means — in plain language that decision-makers can use.
My background in teaching, writing and editing shapes how I work as an analyst: clear structure, careful detail, and storytelling that lands with non-technical audiences.
Text functions, lookups, validation and Power Query to turn messy records into analysis-ready tables.
Excel · Sheets · Power Query · PandasJOINs, aggregation, subqueries and CASE WHEN logic on relational data in BigQuery and MySQL.
BigQuery · MySQL · MS AccessExploratory analysis, pivoting and visual diagnostics in Google Colab notebooks.
Pandas · NumPy · Matplotlib · SeabornExecutive dashboards with KPI cards, slicers and maps — paired with clear, actionable recommendations.
Power BI · DAX · Looker Studio · Tableau02 / SELECTED WORK
Every project follows the same path: problem → approach → result → recommendation.
IDR 3.09Tsales analyzed across 10 branches
Cleaned 10K transactions and 16 features, then built a Power BI dashboard. Found an 89.7% completion rate and 76%+ reliance on credit financing — pointing to leasing partnerships and SUV-focused stock allocation.
1,911units from the top category
Prepared a 10K+ row dataset with text functions, XLOOKUP and SUMIFS, then built KPI cards, trend charts and slicers. Sneakers Casual led revenue — informing stock and bundling recommendations.
1,667unique buyers in Smartphones
Multi-table JOINs, aggregation and CASE WHEN on 10K rows to study ratings, corporate payment behavior and regional shipping costs — Smartphones emerged as the main retention driver.
10K+records with automated reporting
SUMIFS, INDEX MATCH and nested IF across sales channels, interactive pivot dashboards, and Macro VBA scripts that auto-format and export reports to PowerPoint.
Attritiondrivers & retention strategy
End-to-end analysis of the Kaggle IBM HR dataset to identify the key drivers of employee turnover, with a Power BI dashboard and actionable retention recommendations.
Researchturned into an interactive dashboard
Structured personal Qur'anic research data in MySQL, explored it with Python, and presented the findings as a Power BI dashboard — bridging domain expertise and analytics.
03 / EXPERIENCE
Rakamin Academy × Bank Muamalat
@nugrahtheanalyst · Instagram
Pesantren Qur'an Lentera Iman · Ruangguru · SCL Learning
Genmuslim.id · Walisongoonline.com
Madrasah Diniyyah Al-Hikam, Depok
04 / CERTIFICATIONS
Click a certificate to view it full size. Use ← → to browse.
05 / CONTENT CREATION
As @nugrahtheanalyst, I publish daily English-language tutorials on practical analytics — Excel formulas, data cleaning, outlier detection, and my own learning journey in public.
06 / LET'S TALK
Open to data analyst, BI, and project-based roles — remote or hybrid. I usually reply within 24 hours.