Open to work · Remote / Hybrid · Indonesia

DATA ANALYST · BUSINESS INTELLIGENCE

Turning raw data into clear business decisions.

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.

dwiarnawan@gmail.com
Portrait of Arnawan Dwi Nugraha
Arnawan Dwi NugrahaOgan Komering Ulu, South Sumatra
Latest achievement BI Analyst Internship Rakamin × Bank Muamalat · Score 90.09
Projects
7

end-to-end case studies

Data scale
10K+

rows per dataset

Credentials
15+

certifications & programs

Content
125+

educational data posts

SQLGoogle BigQueryMySQLPythonPandasNumPySeabornPower BIDAXLooker StudioTableauExcelGoogle SheetsMacro VBAMS Access

01 / ABOUT

Analysis that starts with a question, not a chart.

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.

  • Based inSouth Sumatra, Indonesia
  • Work styleRemote · Hybrid · Project-based
  • LanguagesIndonesian · English · Arabic
01

Data Cleaning & Preparation

Text functions, lookups, validation and Power Query to turn messy records into analysis-ready tables.

Excel · Sheets · Power Query · Pandas
02

SQL & Data Querying

JOINs, aggregation, subqueries and CASE WHEN logic on relational data in BigQuery and MySQL.

BigQuery · MySQL · MS Access
03

Python Analysis

Exploratory analysis, pivoting and visual diagnostics in Google Colab notebooks.

Pandas · NumPy · Matplotlib · Seaborn
04

BI Dashboards & Storytelling

Executive dashboards with KPI cards, slicers and maps — paired with clear, actionable recommendations.

Power BI · DAX · Looker Studio · Tableau
  1. 01QuestionDefine the business goal & metric
  2. 02PrepareClean, validate & model data
  3. 03AnalyzeQuery, segment & find patterns
  4. 04VisualizeBuild focused dashboards
  5. 05RecommendTurn findings into actions

02 / SELECTED WORK

Case studies built to answer business questions.

Every project follows the same path: problem → approach → result → recommendation.

lookerstudio.google.com · Bank Muamalat Sales Dashboard
FeaturedProject-Based Internship · Rakamin × Bank Muamalat

Bank Muamalat — Business Intelligence Sales Dashboard

Problem
Sales data was fragmented across four separate tables, with no single view of performance.
Approach
Modeled a relational database in MS Access to build a Master Data query, then designed an executive dashboard with KPI cards, geo maps and category/city slicers.
Result
Training Videos & eBooks identified as top revenue drivers; Washington and Houston flagged as priority markets. Final score 90.09 (Excellent).
Looker StudioMS AccessGoogle Sheets
Automotive · End-to-end01

IDR 3.09Tsales analyzed across 10 branches

10-Branch Automotive Showroom Analysis

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.

BigQueryPythonPower BI
Retail · Dashboard02

1,911units from the top category

Retail Sales Dashboard — Toko Sepatu

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.

Google SheetsExcelPivot Table
E-commerce · SQL03

1,667unique buyers in Smartphones

E-Commerce Sales & Customer Analytics

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.

SQLBigQuery
Omni-channel · Automation04

10K+records with automated reporting

Bandung Souvenir Store Omni-Channel

SUMIFS, INDEX MATCH and nested IF across sales channels, interactive pivot dashboards, and Macro VBA scripts that auto-format and export reports to PowerPoint.

ExcelPivot TableMacro VBA
HR Analytics · Python05

Attritiondrivers & retention strategy

IBM HR Analytics — Employee Attrition

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.

PandasPower BIDAX
Research data · BI06

Researchturned into an interactive dashboard

Al-Ahruf Al-Muqaththaah Analysis

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.

MySQLPythonPower BI

03 / EXPERIENCE

Analytics, built on a foundation of communication.

  1. Oct – Nov 2026

    Business Intelligence Analyst · Project-Based Internship

    Rakamin Academy × Bank Muamalat

    • Connected 4 fragmented datasets in MS Access into a single Master Data query.
    • Designed an executive sales dashboard in Looker Studio with KPIs, maps and slicers.
    • Delivered final presentation and video walkthrough — average score 90.09 (Excellent).
  2. Jun 2026 – Present

    Data Analytics Content Educator

    @nugrahtheanalyst · Instagram

    • Published 125+ daily English tutorials on Excel, data cleaning and analytics workflows.
    • Built a 25-stage interactive Excel Obstacle Course for entry-level analysts.
    • Track content performance metrics to align topics with employer expectations.
  3. 2026 – Present

    Educator — Islamic Studies, Mathematics & English

    Pesantren Qur'an Lentera Iman · Ruangguru · SCL Learning

    • Mentored 20+ students and tracked academic progress to adapt teaching strategies.
    • Delivered Singaporean Math (PCA method) and personalized English instruction.
  4. 2022 – 2025

    Content Writer & Article Editor

    Genmuslim.id · Walisongoonline.com

    • Published 20+ SEO-based articles and edited 20+ articles for multiple contributors.
  5. 2021 – 2022

    School Secretary & Teacher

    Madrasah Diniyyah Al-Hikam, Depok

    • Managed student records in Excel and Word, ensuring data accuracy and accessibility.

04 / CERTIFICATIONS

Credentials that support the work.

Click a certificate to view it full size. Use ← → to browse.

NOV 2026 · RAKAMIN × BANK MUAMALAT90.09

Business Intelligence Analyst — Project-Based Internship

Verify credential ↗
NOV 2026 · KARIRNEXEXPERT

Data Analyst Using Excel, SQL, Python & Google Looker Studio

OCT 2026 · KARIRNEXINTERMEDIATE

Data Visualization Bootcamp: Power BI, Tableau & Looker Studio

Verify credential ↗
OCT 2026 · KARIRNEXELITE

Final Project — Microsoft Excel Bootcamp Series

OCT 2026 · KARIRNEX · 62 HRSEXPERT

Microsoft Excel Bootcamp Series: Basic to Advanced Fullstack

Verify credential ↗

Additional credentials

  • 2026
    Power BI Dashboard SpecialistKarirNex · 20K+ cinema transactions, Power Query & DAX
    Verify ↗
  • 2026
    Python for Data Analyst & Google ColabKarirNex · Pandas, pivot tables, Seaborn
    Verify ↗
  • 2026
    SQL for Data Analyst & BigQuery SpecialistKarirNex · aggregation & analytical queries
    Verify ↗
  • 2026
    Bootcamp Data AnalystKarirNex · SQL, Python, Power BI end-to-end
    Verify ↗
  • 2026
    Microsoft Office Specialist — Excel, Word & PowerPointKarirNex · lookups, pivots, dashboards, VBA intro
    Verify ↗
  • 2026
    DQLab Learning PathPython, Pandas EDA, SQL fundamentals, Data Analyst Bootcamp, ML intro
    Completed
  • 2026
    Jobstreet Excel Series (3 certificates)Excel for Admin Professionals · Error-Free Excel · Formula & Data Management
    Completed
  • 2026
    Career Preparation — CV, Portfolio & InterviewKarirNex · professional branding, soft & hard skills, workplace adaptation
  • 2023
    ASEAN Data Science ExplorersASEAN Foundation × SAP · SAP Analytics Cloud enablement
    Completed

05 / CONTENT CREATION

Sharing data insights & daily progress.

As @nugrahtheanalyst, I publish daily English-language tutorials on practical analytics — Excel formulas, data cleaning, outlier detection, and my own learning journey in public.

125+daily posts
25stage Excel course
ENglobal audience

06 / LET'S TALK

Have data that needs a story?

Open to data analyst, BI, and project-based roles — remote or hybrid. I usually reply within 24 hours.

Start a conversation