TRAINING POWER BI BERSAMA DISHUB KOTA BANDUNG

Training Microsoft Power BI Bersama Bapak Ridho dari Dishub Bandung yang diselenggarakan di Meeting Office Purnama Academy Bandung dengan tetap mengutamakan protokol kesehatan, terima kasih semoga bermanfaat.

Read More

EXCEL VBA MACRO , SILABUS , JADWAL TRAINING PURNAMA ACADEMY

Berikut Silabus training Excel VBA Macro yang diselenggarakan oleh Purnama Academy , tersedia metode pelatihan Online/ Offline / Inhouse training di jakarta, bandung, surabaya, dan beberapa kota besar lainnya di indonesia, silahkan hubungi tim sales Purnama Academy 0838-0838-0001 (Call/ Whatsapp) untuk mengetahui detail , jadwal dan biaya training serta mekanisme pendaftaran training

 

EXCEL VBA MACRO PROGRAMMING

Durasi	:	3 Hari (09.00 – 16.00) – Online/ Offline / Inhouse
Deskripsi	:	Microsoft® Excel Macro adalah sebuah tool yang dapat membuat pekerjaan menjadi lebih mudah untuk ditangani, di share, dan dibaca. Fungsi utama  bahasa Macro untuk mengefesienkan langkah dalam pembuatan report di MS Excel hingga cukup dengan satu klik saja.  Visual Basic Application merupakan bahasa yang powerful untuk mempermudah proses kerja dari awalnya terdiri beberapa langkah menjadi cukup satu langkah saja. Sekarang Anda tidak lagi frustrasi dalam membuat dokumen, reports, kalkulasi dan juga project.
Tujuan Training	:	Melalui training ini diharapkan peserta setelah selesai dapat membuat excel macro untuk meningkatkan kemampuan file excel nya dengan bekal  pengetahuan : 1.        Mengenal Konsep Pembuatan Macro and VBA 2.        Cara Record, Store and Run a Macro 3.        Membuat Procedure, Functions, Event Programming Handling Errors 4.        Membuat Object Form dalam Macro 5.        Automation antar workbook 6.        Membuat User Defined Function dan AddOns Excel sendiri
Target Peserta	:	1.        Office Staff 2.        Data Analyst 3.        Desktop Programmer 4.        Public
Prasyarat	:	Memiliki pengetahuan mendalam di Microsoft Excel
Materi Training	:	I.                     Persiapan                •              Developer Ribbon   •              Macro Security        •              Macro Enabled Workbook (.xlsm)          II.             Recording Macro    •              Record Macro         •              Manage Macro       •              Relative References               •              Edit Macro              III.            VBE, Module & Procedures    •              Mengakses VBE      •              Module    •              Procedures              IV.            Object & Addressing               •              Object Addressing  V.             Property Format     •              Format menggunakan .Address             VI.            With … End With    •              Penggunaan With.. End With VII.           Formula R1C1         •              Penggunaan R1C1   VIII.          Variable  •              Fase Variable          •              Local Variable         •              Public Variable        •              Constant Variable   •              Object Variable       IX.            Inputbox  •              Penggunaan Inputbox             X.             Conditional If          •              Penggunaan Conditional IF     •              UCASE/LCASE  Function         XI.            User Defined Function (UDF) •              Pembuatan UDF     XII.           Msgbox   •              Penggunaan Msgbox              XIII.          Anatomi Script & Project Password       •              Anatomi script        •              Project Password    XIV.         Subrutin & Error Handling      •              Penggunaan SUBRUTIN         •              Penggunaan ERROR HANDLING            XV.          Array & Looping      •              Jenis Array ·                     Jenis Looping          •              For .. Next               •              Do... Loop                •              isEmpty function     XVI.         Object Form & Control           •              Form       •              Toolbox   •              Lable       •              Textbox   •              Enabled = False      •              ComboBox               •              Command Button   •              TabIndex Property   •              Text Property          •              Event & Private Sub                XVII.        Run Macro from Excel           •              Menambahkan Control Button Form di Sheet

 

 

Read More

IBM Cognos Analytics Silabus , Jadwal Training, Tempat Pelatihan

Training Syllabus IBM Cognos Analytics Fundamental in Purnama Academy (IT & Management Training), Please call/whatsapp to : 0838-0838-0001 for details and registration, Purnama Academy menyediakan metode pelatihan IBM Cognos Analytics secara online, offline (Tatap muka) ataupun inhouse training di Jakarta, Bandung, Bogor, Surabaya, Yogya dan seluruh kota di indonesia

IBM Cognos Analytics Fundamental

 

Durations : 4 Days (09.00 – 16.00)

Method     : Online/ Offline/ Inhouse Training

Description

The latest version of IBM Cognos Business Intelligence is Cognos Analytics and it brings IBM right back into the game against new-age competitors such as QlikView and Tableau. This sleek, next-generation, unified tool provides you with a fast, intent-driven dashboard and report-authoring interface on top of the strong foundation that IBM Cognos has provided over decades.

The highlights of this Learning Path are
Explore Cognos and it’s high level architecture
Augment enterprise data with your offline data to produce stunning dashboards and presentations without IT costs
Learn to secure your data with advanced filters

 

What you'll learn

Learn to build stunning Dashboards with Cognos Analytics
Learn how and when to use visualization
Create tabbed dashboards and stories using the new Dashboard tool of Cognos
Master the full-fledged Report Authoring tool
Understand how a dashboard is different from a report, and when to use both
Understand the Reporting Interface
Implement crosstabs and SQL queries

Requirements

-      Basic knowledge of data and relationship between variety of data

-      IBM Cognos Analytics  CloudTrial Account

Who this course is for

This Learning Path is targeted at
Accountants, managers, controllers, sales heads, and so on will find this Learning Path useful for their day to day work and career progression
Developers, business analysts, testers, product owners of reporting system / data warehouse / MIS can use Cognos Analytics (Cognos) to author dashboards and stories within IT department

 

Course content

Day 1

PRETEST

INTRODUCTION

·         IBM Cognos Analytics Overview

·         Reports Versus Dashboards

·         Detailed Properties of Visualizations

·         Drill-Through to Another Report

·         Master-Detail Relationship/Repeaters

·         Case Study

REPORT INTERFACE

·         Opening the Report Interface

·         Adding Data

·         Adding Report Pages and Prompt Pages

·         Using Toolbox

·         Crosstab in Detail

·         Case Study Continue

Day 2

CROSSTABS AND SQL QUERIES

·         Nested Crosstab

·         Discontinuous Crosstab

·         Examining and Overriding SQL Queries

·         Crosstabs and SQL Queries

·         Case Study Continue

 

Day 3
FILTERING

·         Populating Values in Prompt Control

·         Using Prompt Parameters

·         Mandatory and Optional Prompts

·         Cascading Prompt

·         Prompts on Report Page

·         Case Study Continue

VISUALIZATIONS

 

·         Difference between Charts and Extensible Visualizations

·         Heatmap Visualization

·         Gauge Control

·         Sparkline

·         Case Study Continue

 

Day 4
DRILL-THROUGH AND MASTER DETAIL RELATIONSHIP

·         Container within Container

·         Drill-Through to Another Report (Drill-Through Links)

·         Finishing Touches

·         Drill-Through and Master-Detail Relationship

·         Case Study Final

POST TEST

Trainer : Purnama Academy Trainer

Next Training Recommendation : IBM COGNOS ANALYTICS ADVANCED

Read More