TRAINER ITIL | COBIT | POWER BI | ISO 27001 CISA | COGNOS | MS PROJECT | CISM | CISSP | CRISC

E-mail : inhousetrainer@yahoo.com, hery.purnama@gmail.com

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.

Pasar Ponsel dikuasai samsung

September 09, 2020 No comments

Penjualan ponsel secara global di tahun 2020 telah diperkirakan akan mengalami penurunan. Tapi Samsung tetap akan menguasai pangsa pasar ponsel global.
Berdasarkan laporan terbaru dari Strategy Analytics, pengapalan ponsel global tahun ini akan jatuh sekitar 11% menjadi 1,26 miliar unit pada tahun ini. Angka ini sedikit lebih baik dari perkiraan sebelumnya sebesar 15,6%.

Pasar ponsel diperkirakan baru akan pulih pada tahun 2021 mengikuti pemulihan ekonomi dan semakin luasnya adopsi jaringan 5G. Pengapalan ponsel di tahun 2021 akan meningkat 9%, dengan angka pengapalan tahun 2019 (1,41 miliar unit) akan kembali dicapai pada tahun 2022.

pasar ponsel global 2020
Samsung Masih Akan Rajai Pasar Ponsel Tahun Ini Foto: Strategy Analytics
Untuk pangsa pasar tahun ini, Samsung masih akan berada di posisi pertama dengan mengapalkan 265,5 juta unit ponsel tahun ini, turun dari 295,5 juta unit pada tahun lalu. Tapi performa raksasa Korea Selatan ini akan pulih pada tahun 2021 ketika pengapalan kembali mencapai angka 295 juta unit.

Sementara itu di posisi kedua ada Huawei yang mengapalkan 192,7 juta unit di tahun 2020. Tapi posisi Huawei akan terjun bebas di tahun 2021 menjadi 59 juta unit karena masalah ketersediaan chipset.

4 Produsen Smartphone China Kuasai Pasar Indonesia Versi Counterpoint
Padahal pada awal tahun ini Huawei sempat menyalip posisi Samsung dan menjadi vendor ponsel terbesar di dunia. Tapi pencekalan dari pemerintah AS membuat Huawei kehilangan posisinya.

Di posisi ketiga ada Apple yang diperkirakan akan menjual 190,1 juta unit ponsel tahun ini. Tapi di tahun 2021 Apple akan menggeser Huawei dan mengambil alih posisi kedua dengan mengapalkan 235,7 juta unit.

Terakhir ada Xiaomi yang diperkirakan akan mengapalkan 129,1 juta unit ponsel tahun ini. Vendor asal China ini akan menggusur Huawei di tahun 2021 dan mengapalkan 166,8 juta unit ponsel.

Sumber : detik.com

Regards,

HERY PURNAMA

Certified IT Trainer

E-mail : inhousetrainer@yahoo.com, hery.purnama@gmail.com

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.

Trainer Togaf 92 Enterprise Architect Training

August 31, 2020 Bandung, hery purnama togaf trainer, togaf silabus, togaf trainer jakarta, TRAINING TOGAF No comments

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

Syllabus TOGAF Foundation

Syllabus
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 :
OVERVIEW
What Is Enterprises Architecture
The TOGAF . Standard
CORE AND BASIC CONCEPT
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
THE ADM
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
CONTINUING WITH THE ADM
Phase H - Architecture Change Management
Requirements Management Phase
Final ADM Quiz
ADM GUIDELINES AND TOOLS
Introduction to ADM Guidelines and Tools
ADM with Architecture Styles
Architecture Principles
Stakeholder Management
Architecture Patterns
Business Scenarios
Gap Analysis
Migration Planning
Interoperability
Business Readiness Transformation Assessment BRTA
Risk Management
Capability Planning
OTHER IMPORTANT TOGAF CONCEPT
Architecture Capability Framework and Architecture Governance
EXAM PRACTICE

TRAINER DATA ANALYTICS USING POWER BI AND POWER QUERY TRAINING

August 31, 2020 DATA ANALYTICS, POWER BI, POWER QUERY, Trainer, training No comments

DATA ANALYTICS USING POWER BI AND POWER QUERY

DURATIONS : 4 DAYS (ONLINE TRAINING 09.00 – 15.00)

*Deskripsi*	:	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*	:	USING POWER BI 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 USING POWER QUERY 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 VISUALIZE YOUR DATA ANALYTICS 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

POWER QUERY TRAINER, EXCEL BUSINESS INTELEGENCE JAKARTA BANDUNG

August 31, 2020 Bandung, DAX TUTORIAL, EXCEL POWER QUERY, Jakarta, POWER PIVOT, silabus, SILABUS POWER QUERY, training No comments

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

BUSINESS INTELEGENCE USING POWER QUERY & EXCEL POWER PIVOT

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

Requirements

· 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

COURSE DESCRIPTION:

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

Preview

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

· DAX Demo COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS

· 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

Preview

HERY PURNAMA TRAINER FOR IT TRAINING

August 27, 2020 No comments

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
DATA MANAGEMENT BODY OF KNOWLEDGE (DMBOK)
SAD UML (System Analysis Design with UML 2.0
BUSINESS ANALYSIS WITH BABOK V.2
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)
INDEKS KAMI (KEAMANAN INFORMASI) – KOMINFO INDONESIA
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
DEVOPS (DEVELOPMENT & OPERATIONS )
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

GIS

· 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

DataOps

· 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

Database

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

Programming

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

Regards,

HERY PURNAMA

Certified IT Trainer

E-mail : inhousetrainer@yahoo.com, hery.purnama@gmail.com

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.

Regards,

HERY PURNAMA

Certified IT Trainer

E-mail : inhousetrainer@yahoo.com, hery.purnama@gmail.com

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

Social Net :