Deskripsi
MATERI PELATIHAN:
1. Introduction of Mining Business Process
● Tahapan Pertambangan
● Tahapan Penambagan
2. Production, Productivity and Equipment Performance
● Konsep dan perhitungan produksi
● Konsep dan perhitungan productivity
● Konsep dan perhitungan PA, UA, MA & EU
● Studi Kasus
3. Flow of Data
● Data reporting, Data recording & Data Cleansing
4. Waterfall Analysis
● Konsep dan perhitungan waterfall analysis
● Membuat chart Waterfall di Ms Excel
5. Question & Answer
● Tanya jawab seputar konsep dan/atau perhitungan parameter
6. Introduction of basic formula in Ms Excel
● Pengenalan formula (SUM, AVERAGE, COUNT, RANK, SUMIFS, AVERAGEIFS, HLOOKUP, VLOOKUP, INDEXMATCH, MAX, MIN)
7. Introduction of Pivot Table
● Pengenalan Pivot table
● Membuat Table, Grafik, Slicer, dan Timeline
8. Practice of create the Dashboard Performance
● Data Visualization
● Flow of Data
● Create Dashboard