Memuat
Memuat
Set aside unusual transactions from thousands of vendor payments so auditors can focus.
0 views
This project finds unusual vendor payments among 2,500 fictional transactions using two outlier detection methods, LOF and distance to nearest neighbours. The result is a ranked list auditors can examine immediately, compared against the audit outcome.

Read CSV loads transaksi_pembayaran.csv (2,500 vendor payments). id_transaksi becomes the id; the hasil_audit column is used only to compare results at the end.
Select Attributes keeps seven numeric attributes: amount, hour, days to due date, vendor frequency, ratio to vendor average, approval level and difference from the purchase order.
Normalize (Z-transformation) ensures large-valued attributes such as the amount do not overshadow others when distances are computed.
Multiply makes two copies so the two detection methods can run on the same data.
Detect Outlier (LOF) with minimal points 30 to 50 gives a local density score. A score near 1 is normal, larger means more unusual. The MinPts range is set above the size of unusual groups so those groups are still detected.
Generate Attributes creates the tanda_lof column with the formula if(outlier>2,"anomali","wajar"). A threshold of 2 is a common starting point and can be changed.
Detect Outlier (Distances) uses the 10 nearest neighbours and flags the 75 transactions (3%) with the largest distances as outliers.
Two Write CSV operators save the scores and flags. Join them with the hasil_audit column on id_transaksi to compute precision and recall.
transaksi_pembayaran.csv
2,500 rows · 10 columns
2,500 fictional vendor payments: amount, hour, days to due date, vendor frequency, ratio to vendor average, approval level, difference from the purchase order, and the audit result (normal or anomaly).
Ready-to-run RapidMiner process (.rmp); CSV dataset with data dictionary; Practice guide and exercises (PDF/MD); Step-by-step video tutorial.
Not necessarily. The project is rated "advanced", and every step of the process is explained so you can follow how the data becomes a result.
Yes. Swap the dataset in the first step and adjust the attribute roles; the rest of the process stays the same. If you would like us to adapt it for you, message us on WhatsApp.
The project costs US$31. Use the "Buy via WhatsApp" button on this page; the project files are delivered after payment is confirmed.
Found a problem or have a suggestion for this project? Tell us on WhatsApp
Back to RapidMiner portfolio