TRAINING TOGAF ENTERPRISE ARCHITECT FOUNDATION

PURNAMA ACADEMY 0838-0838-0001 TRAINING TOGAF JAKARTA BANDUNG BALI YOGYA

Syllabus

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

Read More

BUSINESS INTELEGENCE USING POWER QUERY AND EXCEL POWER PIVOT

BUSINESS INTELEGENCE USING  POWER QUERY & EXCEL POWER PIVOT

SYLLABUS TRAINING 

DURATIONS : 4 DAYS (ONLINE TRAINING 09.00 – 15.00)

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 by Purnama Academy 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

Read More

TRAINING SENCHA EXTJS FUNDAMENTAL

SENCHA EXTJS FUNDAMENTAL TRAINING

Purnama Academy Bandung , Jakarta Training Provider
Method : Online Training , Offline Public Training, Inhouse training
Duration : Call/WA 0838-0838-0001

What is : 
Sencha Ext JS is the most comprehensive JavaScript framework for building data-intensive, cross-platform web and mobile applications for any modern device. Ext JS includes 140+ pre-integrated and tested high-performance UI components


What You will learn :
Getting Started with Sencha Extjs
Fundamental Classes
MVC & MVMM
Event Handling
Component Model
Laying out your GUI
Hands-on Experience w/ Common Components
Working with Data
Getting on the Grid
Visualizing Data
Persisting UI State
Utility Functions
Creating & Extending Classes
Internationalization
Application Architecture
Building Ext And Your Project

Syllabus Details PLEASE  Call/ Whatsapp 0838-0838-0001 , http://www.purnamaAcademy.com
ALL THE BEST TRAINING YOU CAN GET WITH OUR BEST TRAINER
COVID-19 COMPLIANT


Other Recommendation training in Purnama Academy :
Javascript Framework
• Sencha ExtJS
• Angular Js
• Backbone Js
• Ember Js
• Ajax JQuery
• React Js, React Native
• Xamarin

Read More

TRAINING PHONEGAP MOBILE APPS DEVELOPMENT

PHONEGAP MOBILE APPS DEVELOPMENT TRAINING

Purnama Academy Bandung , Jakarta Training Provider
Method : Online Training , Offline Public Training, Inhouse training
Duration : Call/WA 0838-0838-0001

What is : 
Creating seamless, effective and beautiful mobile apps is not easy, and making them run on various different platforms is even less easy. You’ll need to be fluent in several programming languages and have a wide-ranging selection of skills from HTML to Java and everything in between. PhoneGap takes all of these different elements and streamlines them into one easy to use platform; so you can create those seamless, effective and beautiful apps in a flash. This course will show you how.

What You will learn :
Setup the development environment for the PhoneGap framework
Create a basic PhoneGap application to runs on most mobile devices(iOS, Android, Windows Mobile, and more)
Deploy it onto a live and emulator device
Implement the framework API'S

Syllabus Details PLEASE  Call/ Whatsapp 0838-0838-0001 , http://www.purnamaAcademy.com
ALL THE BEST TRAINING YOU CAN GET WITH OUR BEST TRAINER
COVID-19 COMPLIANT


Other Recommendation training in Purnama Academy :
Mobile Apps. Development
• Android Studio
• Phonegap / Cordova
• HTML 5 , CSS 3
• Jquery Mobile / IONIC
• Sencha Touch
• Swift – IOS

Read More

TRAINING ADOBE PREMIERE

ADOBE PREMIERE TRAINING

Purnama Academy Bandung , Jakarta Training Provider
Method : Online Training , Offline Public Training, Inhouse training
Duration : Call/WA 0838-0838-0001

What is : 
Adobe Premiere Pro is a timeline-based video editing software application developed by Adobe Systems and published as part of the Adobe Creative Cloud licensing program. ... It is geared towards professional video editing, while its sibling, Adobe Premiere Elements, targets the consumer market

What You will learn :
The process to complete a video editing project start to finish
Use the many different Premiere Pro panel windows
Importing media & create custom sequence presets for different resolutions
File organization & workflows for efficient & professional video editing
Edit footage, images, music & audio together across multiple editing tracks
The basics of color correction and color grading
Create text titles, effects and lower third titles
How to speed up Premiere Pro CC with proxies to fix lag
Various video editing frame rates, resolutions & aspect ratios
Keyboard shortcuts to edit videos more efficiently
How to work with slow motion footage & how to speed ramp
How to get smooth and nice looking skin tones with color correction
How to use masks to create a mask wipe transition
Professional video editing terms & definitions
Finalize & export media using custom presets

Syllabus Details PLEASE  Call/ Whatsapp 0838-0838-0001 , http://www.purnamaAcademy.com
ALL THE BEST TRAINING YOU CAN GET WITH OUR BEST TRAINER
COVID-19 COMPLIANT


Other Recommendation training in Purnama Academy :
End User ,  Graphics, Web Design
• Word, Excel, PowerPoint
• Corel Draw , Photoshop, In Design, Illustrator
• Web Design with Dreamweaver & Fireworks
• Adobe Premiere Pro

Read More

TRAINING MICROSOFT EXCEL VBA MACRO PROGRAMMING

MICROSOFT EXCEL VBA MACRO PROGRAMMING TRAINING

Purnama Academy Bandung , Jakarta Training Provider
Method : Online Training , Offline Public Training, Inhouse training
Duration : Call/WA 0838-0838-0001

What is :
MS Excel is the integral part of MIS profession and one of the most useful Application for reporting and analysis. However to be successful in in this field only having the knowledge of MS Excel is not sufficient, the aspirant has to be well versed with Excel VBA as well. You may get to know about VBA at the time of learning and working with Macro itself. Macro recording enable the user to create a function it often requires. While the user records macros the Excel do a VBA programming for you. You may work on very advance level projects if you have got the knowledge of VBA. Our course curriculum has been considered as one of the most advance one. Download the content for more details. Moreover it enables the user to do what can be one in Excel itself but thousand times faster.

What You will learn :
earn how to automate daily routine tasks within Excel
Learn best practices when creating macros
Learn to use the Macro Recorder effectively
Learn how to write custom VBA Macros to create more robust automation
Reduce manual routine tasks to the click of a button
Create simple solutions to complex problems by levering Excel functionality with Macros
Learn to create interactive Userform
Learn to make customized functions through VBA

Syllabus Details PLEASE  Call/ Whatsapp 0838-0838-0001 , http://www.purnamaAcademy.com
ALL THE BEST TRAINING YOU CAN GET WITH OUR BEST TRAINER
COVID-19 COMPLIANT


Other Recommendation training in Purnama Academy :

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

Read More

TRAINING MICROSOFT EXCEL ADVANCED

MICROSOFT EXCEL ADVANCED TRAINING

Purnama Academy Bandung , Jakarta Training Provider
Method : Online Training , Offline Public Training, Inhouse training
Duration : Call/WA 0838-0838-0001

What is :
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

What You will learn :
Able to use and apply Database function
Able to use and apply Logical function (IF, AND)
Able to use and apply Statistical function (COUNTIF, AVERAGEIF, COUNTIFS, AVERAGEIFS)
Able to use and apply Mathematical function (SUMIF, SUMIFS)
Able to use and apply Lookup function (VLOOKUP)
Able to use Auto and Advanced Filter command
Able to validate data
Able to apply Conditional Formatting
Able to Protect worksheet and workbook
Upon completion of this program, participants should be able to:

Advance Chart function and PowerPivot Function
Analyze data Using Pivot Tables
Perform What If Analysis using:
Goal Seek
Solver
Input Table
Scenarios
Use VLOOKUP function to extract data
Nesting INDEX and MATCH Function
Combining & Consolidating Data
Create Hyperlink in a workbook


Syllabus Detail : Call/ Whatsapp 0838-0838-0001 , http://www.purnamaAcademy.com
ALL THE BEST TRAINING YOU CAN GET WITH OUR BEST TRAINER
COVID-19 COMPLIANT


Other Recommendation training in Purnama Academy :

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

Read More

TRAINING AUTOCAD 2D/3D FUNDAMENTAL

AUTOCAD 2D/3D FUNDAMENTAL TRAINING

Purnama Academy Bandung , Jakarta Training Provider
Method : Online Training , Offline Public Training, Inhouse training
Duration : Call/WA 0838-0838-0001

What is :
AutoCAD is a commercial computer-aided design (CAD) and drafting software application Since 2010, AutoCAD was released as a mobile- and web app as well, marketed as AutoCAD 360. AutoCAD is used in industry, by architects, project managers, engineers, graphic designers, city planners and other professionals.

What You will learn :
Students will be able work on complex design projects
Students will learn how to use keyboards as a better alternative to mouse
Students will able to make 3-dimensional models
Students will able to understand shortcut keys
More sub topics :
1.   Basics Review the basic AutoCAD controls.
2.     Viewing Pan and zoom in a drawing, and control the order of overlapping objects.
3.     Geometry Create basic geometric objects such as lines, circles, and hatched areas.
4.     Precision Ensure the precision required for your models.
5.     Layers Organize your drawing by assigning objects to layers.
6.     Properties You can assign properties such as color and linetype to individual objects, or as default properties assigned to layers.
7.     Modifying Perform editing operations such as erase, move, and trim on the objects in a drawing.
8.     Blocks Insert symbols and details into your drawings from commercial online sources or from your own designs.
9.     Layouts Display one or more scaled views of your design on a standard-size drawing sheet called a layout.
10. Notes and Labels Create notes, labels, bubbles, and callouts. Save and restore style settings by name.
11. Dimensions Create several types of dimensions and save dimension settings by name.
12. Printing Output a drawing layout to a printer, a plotter, or a file. Save and restore the printer settings for each layout.


Syllabus Detail : Call/ Whatsapp 0838-0838-0001 , http://www.purnamaAcademy.com
ALL THE BEST TRAINING YOU CAN GET WITH OUR BEST TRAINER
COVID-19 COMPLIANT


Other Recommendation training in Purnama Academy :

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

Read More