AR Achmad Rizqi Ilham

Jakarta Selatan · Data Analyst

I turn scattered business data into decisions teams can act on.

I build reliable data pipelines, decision-ready dashboards, and practical automations across sales, marketing, e-commerce, finance, inventory, and operations.

3Power BI reports maintained
8Power Apps delivered
25+Automated workflows built
400+Hours of live training
440+Participants supported

01 / Selected work

Systems built for real business questions.

Watch two dashboard walkthroughs, then explore the systems and workflows behind the wider portfolio.

Power BI · Video walkthrough

Sales Visit Dashboard

A reporting view built from Power Apps and SharePoint List data to monitor visit activity, regional status, follow-ups, and operational bottlenecks.

Play on this page

Power BI · Interactive prototype

Company Sales Dashboard

An interactive prototype for exploring customer-level sales, profit, purchasing volume, delivery delays, and performance over time.

Play on this page

Data engineering · Business intelligence

B2B Sales Data Platform

Owned and deployed the path from distributor submissions to Power BI, with replayable inputs, repeatable transformations, and separate models for sales and stock.

AWS S3PostgreSQL / RDSn8nPower BISQL
Read case study →
Distributor files
→
Scheduled extraction
Normalization
→
Safe repeatable load
S3 archive
→
PostgreSQL views
POWER BI · REUSABLE ANALYSIS

Finance analytics · Dashboard product

Finance Analytics Platform

Built a read-only dashboard and kiosk platform for executive finance users, keeping revenue, returns, launch performance, and data freshness visible. Explore the anonymized sample-data build in the interactive demo.

ReactNode / ExpressPostgreSQLAWS EC2

Data quality · Financial control

Inventory Movement Reconciliation

Owned a production platform that validates operational reports, reconciles warehouse movement with marketplace data, and turns exceptions into finance-facing review queues.

PythonAWS GlueAthenan8n
Read case study →

Workflow automation

Document generation and SharePoint routing

Automated the path from Google Sheets records to generated DOCX and PDF files, routed outputs to SharePoint, and wrote processing metadata back to the source.

Google SheetsOAuth 2.0DOCX / PDFSharePoint

Analytics · Commerce

Marketing and e-commerce performance analysis

Supported analysis across KOL management, short-form video commerce, affiliate and livestream performance, product performance, and regional sales.

Marketing analyticsE-commerceKPI monitoringTrend analysis

Microsoft Power Platform

Operational reporting and app ecosystem

Translated stakeholder requirements into dashboards, applications, and automated workflows that improved process visibility and consistent reporting practices.

Power AppsPower AutomatePower FxDAX

02 / Experience

Business context, technical depth.

I work between stakeholders and systems—clarifying the question, shaping the data, and delivering something teams can keep using.

Indonesia

Data Analyst

Facetology

Manage multi-source analytics across marketing, e-commerce, B2B sales, inventory, and finance. Build pipelines, analytical views, dashboards, and automations that make channel and product performance easier to monitor.

Jakarta Selatan

Training Specialist, Power Platform Developer & Analyst

PT Sarana Solusindo Informatika

Developed and maintained reporting and workflow solutions across Power BI, Power Apps, Power Automate, SharePoint, DAX, and Power Fx—while delivering hands-on Microsoft technology training.

Bekasi

MIS Trainee

PT Aisin Indonesia

Supported operational visibility projects in automotive manufacturing, including RFID-based pallet and box tracking and MQTT-based task-completion indicators.

03 / Toolkit

Built across the full data workflow.

Tools change. The core stays the same: reliable inputs, clear models, useful analysis, and delivery that fits how people actually work.

01

Analysis

SQL, Python, PySpark, data cleaning, transformation, exploratory analysis, KPI monitoring, and trend analysis.

02

Business intelligence

Power BI, DAX, Power Query, Metabase, dashboard design, data modeling, and stakeholder reporting.

03

Data engineering

ETL design, AWS Glue, AWS S3, PostgreSQL on RDS, scheduled extraction, normalization, and idempotent loads.

04

Automation

n8n, Power Automate, Power Apps, Power Fx, SharePoint, Microsoft Graph API, and OAuth 2.0.

04 / About & contact

Let’s make the data easier to trust—and easier to use.

I’m Achmad Rizqi Ilham Shaleh, a data analyst based in Jakarta Selatan. I enjoy solving the connective work between raw operational data, clear reporting, and automation that removes repetitive effort.

Have a data, BI, or automation problem worth solving?

achmadrizqiale@gmail.com linkedin.com/in/achmadrizqiale ↗ github.com/achmadrizqiale ↗ View ATS résumé ↗

Microsoft Certified: Power BI Data Analyst Associate
Microsoft Office Specialist: Excel Expert

05 / Credits

Built on an original idea.

This portfolio adapts the 3D workstation concept and open-source foundation created by Henry Heffernan. Explore the original portfolio repository. The original MIT License and attribution remain included with this project.