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 pageJakarta Selatan · Data Analyst
I build reliable data pipelines, decision-ready dashboards, and practical automations across sales, marketing, e-commerce, finance, inventory, and operations.
01 / Selected work
Watch two dashboard walkthroughs, then explore the systems and workflows behind the wider portfolio.
Power BI · Video walkthrough
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 pagePower BI · Interactive prototype
An interactive prototype for exploring customer-level sales, profit, purchasing volume, delivery delays, and performance over time.
Play on this pageData engineering · Business intelligence
Owned and deployed the path from distributor submissions to Power BI, with replayable inputs, repeatable transformations, and separate models for sales and stock.
Read case study →Finance analytics · Dashboard product
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.
Data quality · Financial control
Owned a production platform that validates operational reports, reconciles warehouse movement with marketplace data, and turns exceptions into finance-facing review queues.
Read case study →Workflow automation
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.
Analytics · Commerce
Supported analysis across KOL management, short-form video commerce, affiliate and livestream performance, product performance, and regional sales.
Microsoft Power Platform
Translated stakeholder requirements into dashboards, applications, and automated workflows that improved process visibility and consistent reporting practices.
02 / Experience
I work between stakeholders and systems—clarifying the question, shaping the data, and delivering something teams can keep using.
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.
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.
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
Tools change. The core stays the same: reliable inputs, clear models, useful analysis, and delivery that fits how people actually work.
SQL, Python, PySpark, data cleaning, transformation, exploratory analysis, KPI monitoring, and trend analysis.
Power BI, DAX, Power Query, Metabase, dashboard design, data modeling, and stakeholder reporting.
ETL design, AWS Glue, AWS S3, PostgreSQL on RDS, scheduled extraction, normalization, and idempotent loads.
n8n, Power Automate, Power Apps, Power Fx, SharePoint, Microsoft Graph API, and OAuth 2.0.
04 / About & contact
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
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.