PT. HM. SAMPOERNA, Tbk. - Pasuruan Jawa Timur

Inhouse Training Microsoft Excel VBA Macro Programming


Inhouse Training Android Apps. Development with phonegap

O-Shop, SCTV, Infotech (Jakarta)

Public Training Magento E-Commerce Advanced Level


Training IT Project Management based on PMBOK 5

Bank Fama International - Bandung

Inhouse Training Open Office Calc

Monday, August 31, 2020

Trainer Togaf 92 Enterprise Architect Training

Hery Purnama 081223344506 is trainer for TOGAF Foundation training, for inquiry please contact by whatsapp.

Syllabus TOGAF Foundation

Descriptions :
TOGAF (The Open Group Architecture Framework) adalah sebuah framework yang bersifat generik untuk mengembangkan arsitektur yang dapat memenuhi kebutuhan bisnis. Jadi perlu dicatat di sini bahwa TOGAF adalah sebuah framework dan bukan arsitektur.
TOGAF sendiri merupakan standard dari Open Group dan awalnya berdasarkan TAFIM (Technical Architecture Framework for Information Management).
TOGAF pertama kali dirilis pada tahun 1996 dan saat ini sudah sampai di versi 9.2.
Mengapa TOGAF banyak digunakan sebagai framework untuk pembuatan arsitektur enterprise?, Saat ini memang TOGAF sangat populer di dunia sebagai framework untuk pembuatan arsitektur enterprise. Tentunya ada beberapa alasan mengapa TOGAF menjadi begitu populer.  Berikut ini beberapa diantaranya:
TOGAF merupakan standard terbuka dan tidak tergantung dari vendor ataupun teknologi yang digunakan
Mendukung keselarasan antara IT dan bisnis
Berdasarkan praktik-praktik terbaik
Dapat disesuaikan sesuai kebutuhan organisasi yang menerapkannya
Merupakan metoda umum yang komprehensif

Objectives :Peserta Memahami metode, fase, teknik , tool pengembangan Arsitektur IT menggunakan TOGAF 9.2

Participants :
- Corporate IT Policy & Governance
- IT Consultant
- IT Manager
- IT Staff

Details :
What Is Enterprises Architecture
The TOGAF . Standard
Overview of Core Concepts
Definition of Enterprise
The Four Architecture Domains - BDAT
Architecture Development Method - ADM
Architecture Work Products - Deliverables, Artifacts and Building Blocks
Enterprise Continuum
Architecture Repository
Architecture Capability
Core Concepts Quiz
Introduction to the ADM
ADM Cycle
Preliminary Phase
ADM Quiz Preliminary and Phase A
Phase B - Business Architecture
Phase C - Information Systems Architecture
Phase C - Data Architecture
Phase C - Application Architecture
Phase D - Technology Architecture
Phase E - Opportunities and Solutions
Phase G - Implementation Governance
Phase H - Architecture Change Management
Requirements Management Phase
Final ADM Quiz
Introduction to ADM Guidelines and Tools
ADM with Architecture Styles
Architecture Principles
Stakeholder Management
Architecture Patterns
Business Scenarios
Gap Analysis
Migration Planning
Business Readiness Transformation Assessment BRTA
Risk Management
Capability Planning
Architecture Capability Framework and Architecture Governance

Sunday, August 30, 2020




Microsoft Power BI telah diganti dengan versi yang jauh lebih kuat — Power BI — yang menggabungkan Layanan Power BI, Desktop, dan Mobile menjadi paket intelijen bisnis dan analitik yang tangguh. Dalam kursus ini, pelatih purnamaacademy akan menunjukkan bagaimana dan mengapa untuk mendapatkan hasil maksimal dari perangkat ini, termasuk Power BI Publisher dan aplikasi seluler Power BI. Dalam kursus ini, pelatih menunjukkan bagaimana dan mengapa mendapatkan yang terbaik dari paket ini: Power BI, Penerbit Power BI, dan aplikasi seluler Power BI. Pelajari cara menyambungkan ke sumber data eksternal dan mengunggah file CSV dan Excel, lalu gunakan Power BI Pro untuk membuat laporan, visualisasi, dan dashboard yang berwawasan luas, lengkap dengan bagan dan peta. Dapatkan wawasan lebih lanjut dari data Anda dengan Power BI Q&A dan Microsoft Cortana, lalu bagikan hasilnya dengan kolega. Trainer juga akan mencakup versi desktop dan mobile dari perangkat lunak, yang memungkinkan Anda untuk melakukan analisis secara offline atau saat bepergian.

Tujuan Training
Training Ini akan membahas penggunaan Power BI  yang merupakan pengganti Microsoft Power BI untuk kebutuhan Business Intelegence dan analisa data, peserta juga akan mengenal paket apa saja yang ada di dalam power BI seperti power BI Publisher atau Power BI Mobile Apps. Juga cara terhubung ke data external dan menampilkannya dalam bentuk CSV/ Excel file

Target Peserta
-          Database Administrator
-          IT Staff
-          Data Analyst
-          Management Level
-          Public

Materi Training
  • Signing up for Power BI
  • Connecting to data sources
  • Uploading data such as CSV and XLS files
  • Creating reports, visualizations, charts, and maps
  • Filtering, sorting, copying, and pasting visualizations
  • Downloading custom visuals from the gallery
  • Modifying existing reports
  • Creating and managing data dashboards
  • Querying data with Power BI Q&A and Microsoft Cortana
  • Sharing report and dashboards
  • Using Power BI Desktop

  • DAX in Microsoft Power BI
  • DAX Warm up - create our first measures
  • Advanced DAX - cummulative sales and year to date measures
  • DAX - Timeintelligence - How to get previous Sales
  • DAX - Timeintelligence How to compare any timeframe
  • DAX - Timeintelligence - How to calculate the first and last day sales
  • DAX - All country sales and filter explained
  • Important information for the next lecture
  • What was the best selling weekday on average - Advanced DAX
  • What is the contribution of our top  sales people in our company
  • How many customers did we lose during a  day timeperiod
  • DAX or not to DAX that is the question

  • Report best practices and WOW effect
  • Report creation tips and tricks bookmarks in action
  • Report creation tips and tricks - get additional insights in your report
  • Create  final report
  • How to create a KPI
  • Leverage multiple data inputs
  • How to create Datestables in DAX
  • SUMX vs SUM in Power BI Whats the difference and when to use which example
  • How to create your own BUMP chart in Power BI


HERY PURNAMA 081223344506 Business Intelegence and data Analytics Trainer Jakarta Bandung.


What you'll learn

·         Get up & running with Excel's changing data modeling & business intelligence tools

·         Learn how to use Power Query, Power Pivot & DAX to absolutely revolutionize your workflow in Excel

·         Master unique tips, tools and case studies that you won't find in ANY other course, guaranteed

·         Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor

·         Get LIFETIME access to project files, quizzes and exercises

·         Build pro-quality business intelligence solutions to blend and analyze data from multiple sources


·         IMPORTANT: You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)

·         This course is designed for PC users (Power Pivot is currently NOT available for Mac)

·         Experience with Excel PivotTables and formulas & functions is strongly recommended


This course introduces Microsoft Excel's powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). If you're looking to become a power Excel user and absolutely supercharge your Excel analytics game, this course is the A-Z guide that you're looking for.

I'll introduce the "Power Excel" landscape, and explore what these Excel tools are all about and why they are changing the world of self-service business intelligence. Together, we'll walk through the Excel BI workflow, and build an entire Excel data model from scratch:

·         First we'll get hands-on with Power Query; a tool to extract, transform, and load data into Excel from flat files, folders, databases, API services and more. We'll practice shaping, blending and exploring our project files in Excel's query editor, and create completely automated loading procedures inside of Excel with only a few clicks.

·         From there we'll dive into Data Modeling , and cover the fundamentals of database design and normalization (including table relationships, cardinality, hierarchies and more). We'll take a tour through the Excel data model interface, introduce some best practices and pro tips, and then create our own relational database to analyze throughout the course.

·         Finally, we'll use Power Pivot and DAX to explore and analyze our Excel data model. Unlike traditional Excel Pivot Tables, Power Pivot allows you to analyze hundreds of millions of rows across multiple data tables (inside of Excel!), and create supercharged calculated fields using a formula language called Data Analysis Expressions (or "DAX" for short). We'll cover basic DAX syntax, then introduce some of the most powerful and commonly-used functions -- CALCULATE, FILTER, SUMX and more.

Who this course is for:

·         Excel users who want to learn advanced data modeling & business intelligence tools

·         Students looking for a comprehensive, engaging, and highly interactive approach to Excel training

·         Anyone looking to become an Excel POWER USER and supercharge their analytics skillset

·         Students looking to pursue a career in data analysis or business intelligence

Course content

Intro to “Power Excel"

·         Understanding the “Power Excel” Workflow

·         Power Query + Power Pivot "Best Thing to Happen to Excel in  Years"

·         When to use Power Query & Power Pivot

Connecting & Transforming Data with Power Query in Excel

·         Introduction

·         Getting to Know Power Query in Excel

·         Exploring Excel's Power Query Editor Preview

·         Power Query Data Loading Options

·         IMPORTANT Updating Locale Settings

·         Applying Basic Table Transformations with Power Query

·         Power Query Demo Text Tools

·         Power Query Demo Number & Value Tools

·         Power Query Demo Date & Time Tools

·         PRO TIP Creating a Rolling Calendar with Power Query

·         Power Query Demo Generating Index & Conditional Columns

·         Power Query Demo Grouping & Aggregating Records

·         Modifying Excel Workbook Queries

·         Merging Queries with Power Query

·         Appending Queries with Power Query

·         Power Query Demo Connecting to a Folder of Files

·         Excel Power Query Best Practices

Building Table Relationships with Excel's Data Model

·         Introduction

·         Meet Excel's "Data Model"

·         The Data Model Data vs. Diagram View

·         Principles of Database Normalization

·         Understanding Data Tables vs. Lookup Tables

·         Benefits of Relationships vs. Merged Tables

·         Creating Table Relationships in Excel's Data Model

·         Modifying Data Model Table Relationships

·         Managing Active vs. Inactive Table Relationships

·         Understanding Relationship Cardinality

·         Connecting Multiple Data Tables in the Data Model

·         Understanding Filter Flow

·         Hiding Fields from Excel Client Tools

·         Defining Hierarchies in a Data Model

·         Excel Data Model Best Practices

Analyzing Data with Power Pivot & DAX

·         Creating a "Power" Pivot Table

·         Power Pivots vs. “Normal” Pivots in Excel


Introducing Data Analysis Expressions (DAX)

·         Understanding DAX Calculated Columns

·         Understanding DAX Measures

·         Creating Implicit DAX Measures

·         Creating Explicit DAX Measures with AutoSum

·         Creating Explicit DAX Measures with Power Pivot

·         Understanding DAX Filter Context

·         Step-by-Step DAX Measure Calculation

·         RECAP Calculated Columns vs. DAX Measures

·         Excel Power Pivot & DAX Best Practices

Common DAX Formulas & Functions

·         Understanding DAX Formula Syntax & Operators

·         Common DAX Function Categories

·         DAX Demo Basic Math & Stats Functions


·         HOMEWORK Math & Stats Functions

·         DAX Demo Logical Functions (IF/AND/OR)

·         DAX Demo SWITCH & SWITCH(TRUE)

·         DAX Demo Common Text Functions

·         Logical & Text Functions

·         DAX Demo CALCULATE

·         DAX Demo Adding Filter Context with FILTER (Part )

·         DAX Demo Adding Filter Context with FILTER (Part )

·         DAX Demo Removing Filter Context with ALL

·         DAX Demo Joining Data with RELATED

·         DAX Demo Iterating with SUMX

·         DAX Demo Iterating with RANKX

·         Practice Iterator ("X") Functions

·         DAX Demo Basic Date & Time Functions

DAX Demo Time Intelligence Formulas

Practice Time Intelligence

·         DAX Speed & Performance Considerations

·         DAX Best Practices

Wrapping Up

·         Data Visualization Options in Excel

·         Sneak Peek Microsoft Power BI


Thursday, August 27, 2020


Hery Purnama Certified IT Trainer for topics :

Best Practice (IT/ Management Public Framework)

  • ITIL v.3/2011 Foundation (IT Infrastructure Library)
  • COBIT 5.0 (Control Objectives for Information and Related Technology)
  • TOGAF (The Open Group Architecture Framework)
  • PMBOK (PMP/ CAPM) (Project Management Body of Knowledge)
  • CRISC (Certified in Risk and Information System Control) 
  • PMO (Project Management Office)
  • ISTQB (International Software Testing Qualification Board)
  • SQA (Software Quality Assuarance)
  • PRINCE2 (Projects IN Controlled Environments)
  • CISA (Certified Information Systems Auditor)
  • RDBMS Concept
  • ITAM – IT Asset Management
  • SAD UML (System Analysis Design with UML 2.0
  • SEO & Digital Marketing
  • e-Filling with EDMS (Electronic Document Management System)
  • ISO/IEC 27001:2013 (Information Security),
  • ISO/IEC 20000 (IT Service Management)
  • ISO/IEC 38500:2008 (Corporate Governance of Information Technology)
  • ISO/IEC 90003:2014 (Software Engineering)
  • Six SIGMA Foundation (Green Belt)
  • IIoT (Industrial 4.0 Internet of Things)
  • Managerial Skills and Leadership
  • KMS - Knowledge Management System
  • eLMS – Electronic Learning Management System
  • CCISO (Certified Chief Information Security Officer)
  • CISM (Certified Information Security Manager)
  • CISSP (Certified Information Systems Security Professional)

Project Tools

  • Microsoft Project / Project Web Server
  • Primavera P6
  • Project Libre


·         QGIS (Quantum GIS)

·         ArcGIS

·         ArcGIS Operations Dashboard


Big Data,  Machine Learning, Content Mining Analysis


·         Apache Hadoop (HDFS, hive, Hbase, Sqoop)

·         Apache Spark (PySpark, RDD, SparkSQL, Spark Streaming, Spark Graph, Mlib)

·         IBM Watson Explorer

·         Big Data Analyzing with Microsoft R

·         Tableau Data Visualization | Visual Analytics | Data Communications

·         IBM Cognos Analytics

·         Qlik Sense Data Analytics



·         StreamSets Fundamental (StreamSets Data Collector)

·         StreamSets Advanced (StreamSets Dataflow Performance Manager)


DevOps Tools

·         Vagrant, Ansible, Chef, Puppet, Jenkins, Docker, Kebernetes, Nagios


Software Testing Tools

·         Selenium (IDE, Client, Server), Selendroid, Appium, Google Espresso



  • Oracle DBA
  • SQL Server DBA / SRSS (Reporting Services) / Business Intelligence / Data Model/ Power BI
  • Microsoft Access 2013/2016 Fundamental & VBA Programing
  • PostGreSQL/ PostGIS DBA
  • SQLite
  • DynamoDB
  • MariaDB DBA
  • IBM DB2 Fundamental Admin


  • ASP.Net Fundamental
  • VB. Net Fundamental/ Advanced
  • PHP MySQL Fundamental/Advanced
  • Web Service (JSON, XML, SOAP, RestFull)
  • Java Web Programming Fundamental
  • Erlang Programming Fundamental
  • Python & Django Programming Fundamental/ Advanced
  • AS400 Programming


Industrial Software / IoT (Internet of Things)

·         SCADA SYSTEM (Supervisory Control And Data Acquisition)

·         Programming ESP8266  For IoT Applications Development with Thinkspeak Framework

PHP Framework

  • Codeigniter Fundamental/Advanced
  • Yii Fundamental
  • Laravel Fundamental/ Advanced
  • Zend Fundamental/ Advanced
  • Cakephp Fundamental/ Advanced

UML Tools

·         SPARX Enterprise Architect

·         Archi 4.2 Enterprise Architect


CMS / E-Commerce

  • Wordpress Fundamental/ Advanced
  • Joomla Fundamental/ Advanced
  • Magento E-Commerce Fundamental/ Advanced
  • Prestashop  Fundamental / Advanced
  • Drupal Fundamental / Advanced

Javascript Framework

  • Sencha ExtJS
  • Angular Js
  • Backbone Js
  • Ember Js
  • Ajax JQuery
  • React Js, React Native
  • Xamarin

Mobile Apps. Development

  • Android Studio
  • Phonegap / Cordova
  • HTML 5 , CSS 3
  • Jquery Mobile / IONIC
  • Sencha Touch
  • Swift – IOS

End User ,  Graphics, Web Design

  • Word, Excel, PowerPoint
  • Corel Draw , Photoshop, In Design, Illustrator
  • Web Design with Dreamweaver & Fireworks
  • Adobe Premiere Pro

Excel Advanced

  • Excel Advanced for Business & Accounting
  • Excel VBA Macro Programming
  • Excel PowerPivot , PowerView, Power BI

CAD Software

  • Autocad 2D/3D Fundamental
  • Catia 3D Fundamental
  • Google Sketchup 3D Fundamental
  • 3D Max Studio Fundamental
  • 3D Maya Fundamental


Game/ Animation Development Tools

  • Unity 5 , 3D Game Development
  • Blender , 3D DAZ

Developer Toolbox

  • Google Developer Toolbox
  • Google Map API V.3
  • SMS Gateway
  • Facebook API Graph




Certified IT Trainer

 Call/ SMS/WA :  081.223344.506 , BBM : 7DC633AA
 Social Net :

Hometown : Bandung - Jawa Barat

Please consider your environmental responsibility. Before printing this e-mail message, ask yourself whether you really need a hard copy.



Certified IT Trainer

 Call/ SMS/WA :  081.223344.506 , BBM : 7DC633AA
 Social Net :

Hometown : Bandung - Jawa Barat

Please consider your environmental responsibility. Before printing this e-mail message, ask yourself whether you really need a hard copy.

Monday, August 24, 2020


Terima kasih kepada Tranindo Pratama Mulia atas undangan mengajar Online topik Power BI bersama rekan rekan peserta dari PT HM Sampoerna, Tbk. 

Semoga bermanfaat

Hery Purnama Trainer Microsoft Power BI Jakarta Bandung Yogya Semarang Balikpapan.

Untuk undangan mengajar Power BI silahkan hubungi whatsapp 081223344506

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

Training IBM COGNOS Analytics

Terima kasih kepada Bapak Rizky dari Zona Kreatif yang telah berperan serta dalam pelatihan Online IBM Cognos analytics yang diselenggarakan oleh Purnama Academy , semoga bermanfaat

Hery Purnama IBM Cognos Analytics Trainer Jakarta Bandung Surabaya, Undangan mengajar silahkan hubungi whatsapp 081223344506

IBM Cognos Analytics Fundamental



Durations : 4 Days (09.00 – 15.00) - Online


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


Basic knowledge of data and relationship between variety of data

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

Using IBM Cognos Analytics

·         Introduction to Business Intelligence

·         Cognos and Its High-Level Architecture

·         Setting Up an Account for Cognos on the Cloud

·         Welcome Portal

·         Where's Report Studio Gone?

·         Your First Dashboard

Taking Data Modules to Next Level

·         On the Back Stage – Connecting to Databases

·         Creating Your Own Data Modules

·         Adding Your Own Data to Dashboards

·         Improving Module – Examining the Data Model

·         Refining Module – Filtering and Cleaning

·         Extending Module – Creating Custom Calculations

·         Generating Stitched Facts – How and Why?

Dashboard Authoring in Detail


·         How to Change Visualization Properties?

·         Singletons, Static Texts, and Display Order

·         Changing Widget Connections

·         Navigation Group for Drill Down


Creating a Story and Giving Finishing Touch

·         Creating a Story Using Pins

·         Changing the Theme and Background

·         Adding Multimedia and Info-Graphics

·         Sharing Story and Dashboard Using Custom URL

·         First Guide to Dashboards using IBM Cognos Analytics


Going beyond Dashboards with IBM Cognos Analytics

·         Printability

·         Crosstabs

·         Detailed Properties of Visualizations

·         Drill-Through to Another Report

·         Master-Detail Relationship/Repeaters

·         Opening the Report Interface

·         Adding Data

·         Adding Report Pages and Prompt Pages

·         Toolbox

·         Crosstab in Detail

·         Nested Crosstab

·         Discontinuous Crosstab

·         Examining and Overriding SQL Queries

·         Populating Values in Prompt Control

·         Using Prompt Parameters

·         Mandatory and Optional Prompts

·         Cascading Prompt

·         Prompts on Report Page

·         Difference between Charts and Extensible Visualizations

·         Heatmap Visualization

·         Gauge Control

·         Sparkline

·         Container within Container

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

·         Finishing Touches

·         Going beyond Dashboards with IBM Cognos Analytics