Data Analisa Baru
File: ai_direktur_v2_export.csv | Model: custom / 10.00%
Skor Awal
60/100
Total Baris
43
Total Kolom
4
Model Data
CUSTOM
Insight Awal PHP
✅ Model data belum spesifik. Sistem tetap menyimpan data dan membuat prompt general data analyst.
Ringkasan Kolom Numerik
| Kolom | Total | Rata-rata | Jumlah Data |
|---|---|---|---|
| upload_id | Rp 125 | Rp 3 | 43 |
| row_number | Rp 199 | Rp 5 | 43 |
| data_json | Rp 13.509.705.440.257.288.201.245.624.633.393.152 | Rp 314.179.196.285.053.209.793.061.384.617.984 | 43 |
Preview Data
| upload_id | report_type | row_number | data_json |
|---|---|---|---|
| 1 | neraca | 1 | {"?Akun":"Kas","Nilai":"250000000"} |
| 1 | neraca | 2 | {"?Akun":"Bank","Nilai":"450000000"} |
| 1 | neraca | 3 | {"?Akun":"Piutang Usaha","Nilai":"180000000"} |
| 1 | neraca | 4 | {"?Akun":"Persediaan","Nilai":"320000000"} |
| 1 | neraca | 5 | {"?Akun":"Aset Tetap","Nilai":"800000000"} |
| 1 | neraca | 6 | {"?Akun":"TOTAL ASET","Nilai":"2000000000"} |
| 1 | neraca | 7 | {"?Akun":"Hutang Usaha","Nilai":"220000000"} |
| 1 | neraca | 8 | {"?Akun":"Hutang Bank","Nilai":"280000000"} |
| 1 | neraca | 9 | {"?Akun":"TOTAL LIABILITAS","Nilai":"500000000"} |
| 1 | neraca | 10 | {"?Akun":"Modal","Nilai":"1200000000"} |
| 1 | neraca | 11 | {"?Akun":"Laba Ditahan","Nilai":"300000000"} |
| 1 | neraca | 12 | {"?Akun":"TOTAL EKUITAS","Nilai":"1500000000"} |
| 2 | rugi_laba | 1 | {"?Akun":"Penjualan","Nilai":"1800000000"} |
| 2 | rugi_laba | 2 | {"?Akun":"Harga Pokok Penjualan","Nilai":"-900000000"} |
| 2 | rugi_laba | 3 | {"?Akun":"LABA KOTOR","Nilai":"900000000"} |
| 2 | rugi_laba | 4 | {"?Akun":"Biaya Gaji","Nilai":"-220000000"} |
| 2 | rugi_laba | 5 | {"?Akun":"Biaya Marketing","Nilai":"-90000000"} |
| 2 | rugi_laba | 6 | {"?Akun":"Biaya Operasional","Nilai":"-180000000"} |
| 2 | rugi_laba | 7 | {"?Akun":"Biaya Administrasi","Nilai":"-40000000"} |
| 2 | rugi_laba | 8 | {"?Akun":"LABA OPERASIONAL","Nilai":"370000000"} |
| 2 | rugi_laba | 9 | {"?Akun":"Pajak","Nilai":"-70000000"} |
| 2 | rugi_laba | 10 | {"?Akun":"LABA BERSIH","Nilai":"300000000"} |
| 3 | arus_kas | 1 | {"?Akun":"Kas Bersih Operasional","Nilai":"280000000"} |
| 3 | arus_kas | 2 | {"?Akun":"Kas Investasi","Nilai":"-80000000"} |
| 3 | arus_kas | 3 | {"?Akun":"Kas Pendanaan","Nilai":"-50000000"} |
| 3 | arus_kas | 4 | {"?Akun":"Kenaikan Kas","Nilai":"150000000"} |
| 3 | arus_kas | 5 | {"?Akun":"Kas Awal","Nilai":"550000000"} |
| 3 | arus_kas | 6 | {"?Akun":"Kas Akhir","Nilai":"700000000"} |
| 4 | marketing | 1 | {"?Campaign":"Facebook Ads Campaign 01","Budget":"50000000","Realisasi":"48500000","Leads":"1250","Closing":"180","Omzet":"165000000","ROAS":"3.4","Status":"Baik"} |
| 4 | marketing | 2 | {"?Campaign":"Google Ads Campaign 02","Budget":"35000000","Realisasi":"34000000","Leads":"720","Closing":"95","Omzet":"98000000","ROAS":"2.88","Status":"Baik"} |
| 4 | marketing | 3 | {"?Campaign":"TikTok Ads Campaign 03","Budget":"20000000","Realisasi":"21000000","Leads":"950","Closing":"82","Omzet":"76000000","ROAS":"3.62","Status":"Baik"} |
| 4 | marketing | 4 | {"?Campaign":"Instagram Ads Campaign 04","Budget":"15000000","Realisasi":"14500000","Leads":"540","Closing":"48","Omzet":"39000000","ROAS":"2.69","Status":"Cukup"} |
| 4 | marketing | 5 | {"?Campaign":"TOTAL","Budget":"120000000","Realisasi":"117500000","Leads":"3460","Closing":"405","Omzet":"378000000","ROAS":"3.22","Status":"Profit"} |
| 5 | karyawan | 1 | {"?NIK":"CS001","Nama":"Andi","Departemen":"Sales","Kehadiran (%)":"98","KPI (%)":"96","Leads":"180","Closing":"165","Closing Rate (%)":"91.7","Status":"Sangat Baik"} |
| 5 | karyawan | 2 | {"?NIK":"CS002","Nama":"Budi","Departemen":"Sales","Kehadiran (%)":"96","KPI (%)":"94","Leads":"160","Closing":"145","Closing Rate (%)":"90.6","Status":"Baik"} |
| 5 | karyawan | 3 | {"?NIK":"CS003","Nama":"Citra","Departemen":"Sales","Kehadiran (%)":"100","KPI (%)":"98","Leads":"210","Closing":"198","Closing Rate (%)":"94.3","Status":"Sangat Baik"} |
| 5 | karyawan | 4 | {"?NIK":"CS004","Nama":"Dina","Departemen":"Sales","Kehadiran (%)":"97","KPI (%)":"95","Leads":"170","Closing":"152","Closing Rate (%)":"89.4","Status":"Baik"} |
| 5 | karyawan | 5 | {"?NIK":"CS005","Nama":"Eko","Departemen":"Sales","Kehadiran (%)":"95","KPI (%)":"93","Leads":"150","Closing":"132","Closing Rate (%)":"88.0","Status":"Baik"} |
| 6 | stok | 1 | {"?Kode":"BRG001","Nama Barang":"Laptop Bisnis","Kategori":"Elektronik","Stok Awal":"50","Masuk":"20","Keluar":"15","Stok Akhir":"55","Minimum":"20","Harga Modal":"8500000","Nilai Persediaan":"467500000","Status":"Aman"} |
| 6 | stok | 2 | {"?Kode":"BRG002","Nama Barang":"Printer","Kategori":"Elektronik","Stok Awal":"30","Masuk":"10","Keluar":"12","Stok Akhir":"28","Minimum":"10","Harga Modal":"2500000","Nilai Persediaan":"70000000","Status":"Aman"} |
| 6 | stok | 3 | {"?Kode":"BRG003","Nama Barang":"Mouse Wireless","Kategori":"Aksesoris","Stok Awal":"120","Masuk":"50","Keluar":"90","Stok Akhir":"80","Minimum":"40","Harga Modal":"120000","Nilai Persediaan":"9600000","Status":"Fast Moving"} |
| 6 | stok | 4 | {"?Kode":"BRG004","Nama Barang":"Keyboard","Kategori":"Aksesoris","Stok Awal":"80","Masuk":"30","Keluar":"45","Stok Akhir":"65","Minimum":"25","Harga Modal":"250000","Nilai Persediaan":"16250000","Status":"Aman"} |
| 6 | stok | 5 | {"?Kode":"BRG005","Nama Barang":"Monitor 24","Kategori":"Elektronik","Stok Awal":"25","Masuk":"15","Keluar":"10","Stok Akhir":"30","Minimum":"10","Harga Modal":"1800000","Nilai Persediaan":"54000000","Status":"Aman"} |