{"id":3354,"date":"2025-06-10T07:46:03","date_gmt":"2025-06-10T07:46:03","guid":{"rendered":"https:\/\/ganeshakuwera.co.id\/?p=3354"},"modified":"2025-06-17T20:08:09","modified_gmt":"2025-06-17T20:08:09","slug":"dashboard-training","status":"publish","type":"post","link":"https:\/\/ganeshakuwera.co.id\/?p=3354","title":{"rendered":"Dashboard Training"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"3354\" class=\"elementor elementor-3354\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"has_eae_slider elementor-element elementor-element-25ea8177 e-flex e-con-boxed e-con e-parent\" data-id=\"25ea8177\" data-element_type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;ekit_has_onepagescroll_dot&quot;:&quot;yes&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dd87c6e elementor-widget elementor-widget-text-editor\" data-id=\"dd87c6e\" data-element_type=\"widget\" data-settings=\"{&quot;ekit_we_effect_on&quot;:&quot;none&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.23.0 - 25-07-2024 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<!-- wp:paragraph -->\n<p>File ini berfungsi sebagai <strong>dashboard pelatihan karyawan<\/strong>, yang mencakup rekap data pelatihan, statistik internal\/eksternal, jam pelatihan, serta pengeluaran yang terkait. Dashboard ini cocok digunakan oleh departemen HR atau Training &amp; Development untuk memantau efektivitas dan cakupan pelatihan sepanjang tahun.<\/p>\n<!-- \/wp:paragraph --><!-- wp:separator --><hr class=\"wp-block-separator has-alpha-channel-opacity\" \/><!-- \/wp:separator --><!-- wp:heading {\"level\":3} -->\n<h4 class=\"wp-block-heading\"><strong>\ud83d\udcc4<\/strong>\u00a0Deskripsi Per Sheet<\/h4>\n<p>\u00a0<\/p>\n<!-- \/wp:heading --><!-- wp:heading {\"level\":4} -->\n<h4 class=\"wp-block-heading\">1. Sheet: Dashboard<\/h4>\n<p>\u00a0<\/p>\n<!-- \/wp:heading --><!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>Fungsi: Menampilkan ringkasan visual (dashboard) dari keseluruhan data pelatihan.<\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Konten utama:<!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>Total Employees Trained (Jumlah Karyawan yang Dilatih)<\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Number of Internal Trainings (Jumlah Pelatihan Internal)<\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Number of External Trainings (Jumlah Pelatihan Eksternal)<\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Total Training Hours (Total Jam Pelatihan)<\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Select Project (Filter proyek untuk melihat statistik per proyek)<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><\/li>\n<!-- \/wp:list-item --><!-- wp:list-item --><!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><!-- wp:heading {\"level\":4} -->\n<h4 class=\"wp-block-heading\">2. Sheet: Data<\/h4>\n<p>\u00a0<\/p>\n<ul>\n<li>Fungsi: Database utama berisi seluruh riwayat pelatihan individu.<\/li>\n<\/ul>\n<ul class=\"wp-block-list\"><!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Kolom penting:<!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li><code>Project Name<\/code>, <code>Employee Name<\/code>, <code>Designation<\/code> (proyek, nama, jabatan)<\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li><code>Training Name<\/code>, <code>External\/Internal<\/code>, <code>Training Hours<\/code>, <code>Training Date<\/code><\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li><code>Training Expiry Date<\/code>, <code>Amount Spent<\/code><\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Sheet ini menjadi sumber utama untuk pengolahan data dan visualisasi dashboard.<\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Contoh isi: Employee A dari Project 1 mengikuti pelatihan &#8220;Risk Assessment&#8221; selama 6 jam secara eksternal pada 23 September 2019.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><!-- wp:heading {\"level\":4} -->\n<h4 class=\"wp-block-heading\">3. Sheet: Input Here First<\/h4>\n<p>\u00a0<\/p>\n<!-- \/wp:heading --><!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>Fungsi: Input awal data referensi untuk dropdown\/form formula.<\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Konten:<!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>Daftar nama proyek dan jabatan.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Sheet ini\u00a0 menjadi <strong>referensi data validasi<\/strong> pada sheet data utama (dropdown validation di Excel).<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><!-- wp:heading {\"level\":4} -->\n<h4 class=\"wp-block-heading\">4. Sheet: Formulas<\/h4>\n<!-- \/wp:heading --><!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>Fungsi: Kalkulasi dan rekap bulanan secara otomatis.<\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Konten:<!-- wp:list -->\n<ul class=\"wp-block-list\"><!-- wp:list-item -->\n<li>Per bulan: jumlah pelatihan yang dilakukan, total jam pelatihan, pelatihan internal, dan eksternal.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Data ini digunakan sebagai dasar visualisasi di dashboard utama.<\/li>\n<!-- \/wp:list-item --><!-- wp:list-item -->\n<li>Format tabel per bulan: Januari hingga Desember.<\/li>\n<!-- \/wp:list-item --><\/ul>\n<!-- \/wp:list --><!-- wp:paragraph -->\n<p>Silahkan download dashboard ini dalam bentuk excel<\/p>\n<!-- \/wp:paragraph --><!-- wp:paragraph -->\n<p>\u00a0<\/p>\n<!-- \/wp:paragraph --><!-- wp:file {\"id\":3355,\"href\":\"https:\/\/ganeshakuwera.co.id\/wp-content\/uploads\/2025\/06\/739597600-Training-Dashboard.xlsx\"} -->\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-5c00bad9-8f1d-456c-89e6-b517eadb306a\" href=\"https:\/\/ganeshakuwera.co.id\/wp-content\/uploads\/2025\/06\/739597600-Training-Dashboard.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">739597600-Training-Dashboard<\/a><a class=\"wp-block-file__button wp-element-button\" href=\"https:\/\/ganeshakuwera.co.id\/wp-content\/uploads\/2025\/06\/739597600-Training-Dashboard.xlsx\" download=\"\" aria-describedby=\"wp-block-file--media-5c00bad9-8f1d-456c-89e6-b517eadb306a\">Download<\/a><\/div>\n<!-- \/wp:file -->\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"has_eae_slider elementor-element elementor-element-4538282 e-flex e-con-boxed e-con e-parent\" data-id=\"4538282\" data-element_type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;ekit_has_onepagescroll_dot&quot;:&quot;yes&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a1e9cdf elementor-widget elementor-widget-bae-excel-viewer\" data-id=\"a1e9cdf\" data-element_type=\"widget\" data-settings=\"{&quot;ekit_we_effect_on&quot;:&quot;none&quot;}\" data-widget_type=\"bae-excel-viewer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"only_excel\">\n\t\t\t     \t\t<div class=\"download\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<div class=\"only_excel_viewer\">\n\t\t\t<iframe src=\"https:\/\/view.officeapps.live.com\/op\/embed.aspx?src=https:\/\/ganeshakuwera.co.id\/wp-content\/uploads\/2025\/06\/739597600-Training-Dashboard.xlsx\" >\n\t\t\t<\/iframe>\n\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>File ini berfungsi sebagai dashboard pelatihan karyawan, yang mencakup rekap data pelatihan, statistik internal\/eksternal, jam pelatihan, serta pengeluaran yang terkait&#8230;. <\/p>\n<div class=\"art-el-more\"><a href=\"https:\/\/ganeshakuwera.co.id\/?p=3354\" class=\"art-link art-color-link art-w-chevron\">Read more<\/a><\/div>\n","protected":false},"author":1,"featured_media":3461,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jet_sm_ready_style":"","_jet_sm_style":"","_jet_sm_controls_values":"","_jet_sm_fonts_collection":"","_jet_sm_fonts_links":"","footnotes":"","_links_to":"","_links_to_target":""},"categories":[65,63],"tags":[],"class_list":["post-3354","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-people-development","category-tools"],"acf":[],"_links":{"self":[{"href":"https:\/\/ganeshakuwera.co.id\/index.php?rest_route=\/wp\/v2\/posts\/3354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ganeshakuwera.co.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ganeshakuwera.co.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ganeshakuwera.co.id\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ganeshakuwera.co.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3354"}],"version-history":[{"count":19,"href":"https:\/\/ganeshakuwera.co.id\/index.php?rest_route=\/wp\/v2\/posts\/3354\/revisions"}],"predecessor-version":[{"id":3500,"href":"https:\/\/ganeshakuwera.co.id\/index.php?rest_route=\/wp\/v2\/posts\/3354\/revisions\/3500"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ganeshakuwera.co.id\/index.php?rest_route=\/wp\/v2\/media\/3461"}],"wp:attachment":[{"href":"https:\/\/ganeshakuwera.co.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ganeshakuwera.co.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ganeshakuwera.co.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}