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

Inhouse Training Microsoft Excel VBA Macro Programming

PT. PLN PERSERO MALUKU / MALUKU UTARA

Inhouse Training Android Apps. Development with phonegap

O-Shop, SCTV, Infotech (Jakarta)

Public Training Magento E-Commerce Advanced Level

PT. ASKRINDO - JAKARTA

Training IT Project Management based on PMBOK 5

Bank Fama International - Bandung

Inhouse Training Open Office Calc

SEARCH

Tuesday, March 30, 2021

Jadwal Puasa Bandung Sekitarnya 2021 / 1442H

Download Informasi Jadwal Puasa Ramadhan Di bandung jawa barat dan sekitarnya 13 April 2021 , Jadwal imsyakiyah 1442 H , Selamat menjalankan ibadah puasa



Sumber :

http://falakiyah.nu.or.id/JadwalImsakiyahPuasa.aspx

Monday, March 15, 2021

Part 5 - Excel VBA Macro, Object Addressing

 Excel VBA Macro, Object Addressing by Hery Purnama

Part 3 - Excel VBA Macro, Relative References

PART 3 - RELATIVE REFERENCES, EXCEL VBA MACRO BY HERY PURNAMA

Part 2 - Excel VBA Macro, Recording Macro

Tutorial Excel VBA Macro, Recording Macro by Hery Purnama

Part 1 - Excel VBA Macro, Overview and Macro Preparations

Part 1 - Excel VBA Macro, Overview and Macro Preparations by Hery Purnama

Friday, March 5, 2021

TRAINING PYTHON DATA ANALYTICS AND DATA VISUALIZATION

 Hery Purnama 081223344506 is trainer for TRAINING PYTHON DATA ANALYTICS AND DATA VISUALIZATION in Bandung, Jakarta, Surabaya, Palembang, Medan.

Python for Data Analysis and Visualization

 

DURATION (ONLINE) : 3 DAYS (09.00 – 14.00)

LEVEL : BASIC TO INTERMEDIATE

 

DESCRIPTIONS :

Di dalam pelatihan ini Anda akan mempelajari dasar-dasar Python untuk bisa menjelajahi berbagai jenis data. Anda akan belajar bagaimana menyiapkan data untuk analisis, melakukan analisis statistik, membuat visualisasi data yang informatif dan bermakna, memprediksi tren di masa yang akan datang dari data tersedia, dan banyak hal lainnya lagi yang akan Anda dapatkan selama pelatihan.

 

OBJECTIVES :

Setelah pelatihan ini Anda diharapkan memiliki skill dasar dalam hal

           Dasar Pemograman Python

           Predictive Modelling

           Data Analysis

           Data Visualization (DataViz)

           Model Selection.

 

PREREQUISITES :

Tidak dibutuhkan keahlian minimal khusus untuk bisa mengikuti pelatihan ini, setidaknya Anda telah terbiasa menggunakan komputer, memiliki ketertarikan dalam dunia pengolahan data dan pemograman

PARTICIPANTS

·         Data Science

·         Data Analyst

·         Software Engineer / Programmer

 

TOPICS:

INTRO & SETUP

·         Installation Setup and Overview

·         IDEs and Course Resources

·         iPython/Jupyter Notebook Overview

·         Basic Python

LEARNING NUMPY

·         Intro to numpy

·         Creating arrays

·         Using arrays and scalars

·         Indexing Arrays

·         Array Transposition

·         Universal Array Function

·         Array Processing

·         Array Input and Output

 

INTRO TO PANDA

·         Series

·         DataFrames

·         Index objects

·         Reindex

·         Drop Entry

·         Selecting Entries

·         Data Alignment

·         Rank and Sort

·         Summary Statistics

·         Missing Data

·         Index Hierarchy

 

DATA READING

·         Reading and Writing Text Files

·         JSON with Python

·         HTML with Python

·         Microsoft Excel files with Python

·         Merge

·         Merge on Index

·         Concatenate

·         Combining DataFrames

·         Reshaping

·         Pivoting

·         Duplicates in DataFrames

·         Mapping

·         Replace

·         Rename Index

·         Binning

·         Outliers

·         Permutation

·         GroupBy on DataFrames

·         GroupBy on Dict and Series

·         Agreration  

·         Splitting Applying and Combining

·         Cross Tabulation

 

DATA VISUALIZATION

·         Installing Seaborn

·         Histograms

·         Combining Plot Styles

·         Box and Violin Plots

·         Regression Plots

·         Heatmaps and Clustered Matrices

 

PROJECT EXAMPLE PRACTICE

Tuesday, March 2, 2021

SQL Server Reporting Services (SSRS) SDK for PHP



 
The SQL Server Reporting Services (SSRS) SDK for PHP is a library that uses the SQL Server Reporting Services SOAP APIs to enable PHP developers to leverage the SSRS Business Intelligence/Reporting features in their application.

The library is designed to make simple for developers to call the SSRS remote APIs to perform the following operations:

    Query for the list of reports available on the server
    Query for the list of parameters required for each report with the list of valid values
    Query the list of Formats supported by the Server
    Execute a Report


Additional links and information can be found on the Interoperability Bridges website: http://www.interoperabilitybridges.com/projects/sql-server-reporting-services-sdk-for-php



Code Sample

// include the SSRS library
require_once 'SSRSReport.php';

define("REPORT", "/AdventureWorks 2008 Sample Reports/TopStoresBegin");
$settings = parse_ini_file("app.config", 1);
// Create a connection to the SSRS Server
$rs = new SSRSReport(new Credentials($settings["UID"], $settings["PASWD"]),$settings["SERVICE_URL"]);

// Load the report and specify the params required for its execution
$executionInfo = $rs->LoadReport2(REPORT, NULL);
$parameters = array();
$parameters[0] = new ParameterValue();
$parameters[0]->Name = "ProductCategory";
$parameters[0]->Value = "1";
$parameters[1] = new ParameterValue();
$parameters[1]->Name = "StartDate";
$parameters[1]->Value = "1/1/2003";
$parameters[2] = new ParameterValue();
$parameters[2]->Name = "EndDate";
$parameters[2]->Value = "12/31/2003";
$parameters[3] = new ParameterValue();
$parameters[3]->Name = "ProductSubcategory";
$parameters[3]->Value = "2";
$rs->SetExecutionParameters2($parameters);

// Require the Report to be rendered in HTML format
$renderAsHTML = new RenderAsHTML();

// Set the links in the reports to point to the php app

$renderAsHTML->ReplacementRoot = getPageURL();

// Set the root path on the server for any image included in the report
$renderAsHTML->StreamRoot = './images/';

// Execute the Report
$result_html = $rs->Render2($renderAsHTML,
                                 PageCountModeEnum::$Actual,
                                 $Extension,
                                 $MimeType,
                                 $Encoding,
                                 $Warnings,
                                 $StreamIds);

// Save all images on the server (under /images/ dir)
    foreach($StreamIds as $StreamId)
    {
        $renderAsHTML->StreamRoot = null;
        $result_png = $rs->RenderStream($renderAsHTML,
                                    $StreamId,
                                    $Encoding,
                                    $MimeType);

        if (!$handle = fopen("./images/" . $StreamId, 'wb'))
        {
            echo "Cannot open file for writing output";
            exit;
        }

        if (fwrite($handle, $result_png) === FALSE)
        {
            echo "Cannot write to file";
            exit;
        }
        fclose($handle);
    }
// include the Report within a Div on the page
echo '<html><body><br/><br/>';
echo '<div align="center">';
echo '<div style="overflow:auto; width:700px; height:600px">';
    echo $result_html;
echo '</div>';
echo '</div>';
echo '</body></html>';


Follow SSRS PHP training with Hery Purnama 081223344506, Certified IT Trainer 


MEMAHAMI ITIL ROLES

ITIL ROLES digunakan untuk menentukan tanggung jawab. Secara khusus, ITIL ROLES digunakan untuk menugaskan pemilik role ke berbagai proses ITIL, dan untuk menentukan tanggung jawab atas aktivitas dalam definisi proses yang terperinci.
 
Popular ITIL roles
Incident Manager
The Incident Manager is responsible for the effective implementation of the Incident Management process and carries out the corresponding reporting.
Problem Manager
The Problem Manager is responsible for managing the lifecycle of all Problems. His primary objectives are to prevent Incidents from happening, and to minimize the impact of Incidents that cannot be prevented.
Change Manager
The Change Manager controls the lifecycle of all Changes. His primary objective is to enable beneficial Changes to be made, with minimum disruption to IT services.
Business Relationship Manager
The Business Relationship Manager is responsible for maintaining a positive relationship with customers, identifying customer needs and ensuring that the service provider is able to meet these needs with an appropriate catalogue of services.
Project Manager
The Project Manager is responsible for planning and coordinating the resources to deploy a major Release within the predicted cost, time and quality estimates.
Service Level Manager
The Service Level Manager is responsible for negotiating Service Level Agreements and ensuring that these are met.
 
ITIL 4 roles
The roles described here follow the specifications of ITIL V3 and are grouped by Service Lifecycle stage.
Organizations that wish to adopt ITIL 4 will find that the latest edition of ITIL is less prescriptive about processes - and roles. Instead of specifiying a fixed set of processes, ITIL V4 introduces a holistic approach and shifts the focus on 34 'practices'. For each practice, ITIL 4 describes the key activities, inputs, outputs and exemplary roles. This gives organizations more freedom to define tailor-made processes and responsibilities.
Organizations looking for a set of ITIL 4 roles and responsibilities can still use the roles defined here in the IT Process Wiki, since the processes and roles defined in ITIL V3 have not been invalidated with the release of ITIL V4.
What is more, in our YaSM Wiki we describe leaner set of 19 service management processes that are more in tune with ITIL 4 and its focus on simplicity and "just enough process". The YaSM service management model includes a complete set of service management roles that is a good starting point for organizations that wish to adopt ITIL 4.
In the YaSM Service Management Wiki you can learn more about these roles. You can also download a complete RACI matrix for service management roles and processes.
 
ITIL roles and responsibilities
ITIL roles - Service Strategy
________________________________________
Business Relationship Manager
•    The Business Relationship Manager is responsible for maintaining a positive relationship with customers, identifying customer needs and ensuring that the service provider is able to meet these needs with an appropriate catalogue of services.
•    The Business Relationship Manager works closely with the Service Level Manager.
Demand Manager
•    The role Demand Manager has been introduced to perform the activities in the Demand Management process.
•    The Demand Manager is responsible for understanding, anticipating and influencing customer demand for services.
•    The Demand Manager works with capacity management to ensure that the service provider has sufficient capacity to meet the required demand.
Financial Manager
•    The Financial Manager is responsible for managing an IT service provider's budgeting, accounting and charging requirements.
IT Steering Group (ISG)
•    The IT Steering Group (ISG) sets the direction and strategy for IT Services. It includes members of senior management from business and IT.
•    The ISG reviews the business and IT strategies in order to make sure that they are aligned.
•    It also sets priorities of service development programs/ projects.
Service Portfolio Manager
•    The Service Portfolio Manager decides on a strategy to serve customers in cooperation with the IT Steering Group, and develops the service provider's offerings and capabilities.
Service Strategy Manager
•    The Service Strategy Manager supports the IT Steering Group in producing and maintaining the service provider's strategy.
•    This role is also responsible for communicating and implementing the service strategy.
 
ITIL roles - Service Design
________________________________________
Applications Analyst
•    The Applications Analyst is an Application Management role which manages applications throughout their lifecycle.
•    There is typically one Applications Analyst or team of analysts for every key application.
•    This role plays an important part in the application-related aspects of designing, testing, operating and improving IT services.
•    It is also responsible for developing the skills required to operate the applications required to deliver IT services.
Availability Manager
•    The Availability Manager is responsible for defining, analyzing, planning, measuring and improving all aspects of the availability of IT services.
•    He is responsible for ensuring that all IT infrastructure, processes, tools, roles etc. are appropriate for the agreed service level targets for availability.
Capacity Manager
•    The Capacity Manager is responsible for ensuring that services and infrastructure are able to deliver the agreed capacity and performance targets in a cost effective and timely manner.
•    He considers all resources required to deliver the service, and plans for short, medium and long term business requirements.
Compliance Manager
•    The Compliance Manager's responsibility is to ensure that standards and guidelines is followed, or that proper, consistent accounting or other practices are being employed.
•    This includes to make sure that external legal requirements are fulfilled.
Enterprise Architect
•    The Enterprise Architect is responsible for maintaining the Enterprise Architecture (EA), a description of the essential components of a business, including their interrelationships.
•    Bigger organizations may opt to introduce specialist EA roles like Business Architect, Application Architect, Information Architect, or Infrastructure Architect.
Information Security Manager
•    The Information Security Manager is responsible for ensuring the confidentiality, integrity and availability of an organization’s assets, information, data and IT services.
•    He is usually involved in an organizational approach to Security Management which has a wider scope than the IT service provider, and includes handling of paper, building access, phone calls etc., for the entire organization.
IT Service Continuity Manager
•    The IT Service Continuity Manager is responsible for managing risks that could seriously impact IT services.
•    He ensures that the IT service provider can provide minimum agreed service levels in cases of disaster, by reducing the risk to an acceptable level and planning for the recovery of IT services.
Risk Manager
•    The Risk Manager is responsible for identifying, assessing and controlling risks.
•    This includes analyzing the value of assets to the business, identifying threats to those assets, and evaluating how vulnerable each asset is to those threats.
Service Catalogue Manager
•    The Service Catalogue Manager is responsible for maintaining the Service Catalogue, ensuring that all information within the Service Catalogue is accurate and up-to-date.
Service Design Manager
•    The Service Design Manager is responsible for producing quality, secure and resilient designs for new or improved services.
•    This includes producing and maintaining all design documentation.
Service Level Manager
•    The Service Level Manager is responsible for negotiating Service Level Agreements and ensuring that these are met.
•    He makes sure that all IT Service Management processes, Operational Level Agreements and Underpinning Contracts are appropriate for the agreed service level targets.
•    The Service Level Manager also monitors and reports on service levels.
Service Owner
•    The Service Owner is responsible for delivering a particular service within the agreed service levels.
•    Typically, he acts as the counterpart of the Service Level Manager when negotiating Operational Level Agreements (OLAs).
•    Often, the Service Owner will lead a team of technical specialists or an internal support unit.
Supplier Manager
•    The Supplier Manager is responsible for ensuring that value for money is obtained from all suppliers.
•    He makes sure that contracts with suppliers support the needs of the business, and that all suppliers meet their contractual commitments.
Technical Analyst
•    The Technical Analyst is a Technical Management role which provides technical expertise and support for the management of the IT infrastructure.
•    There is typically one Technical Analyst or team of analysts for every key technology area.
•    This role plays an important part in the technical aspects of designing, testing, operating and improving IT services.
•    It is also responsible for developing the skills required to operate the IT infrastructure.
 
ITIL roles and boards - Service Transition
________________________________________
Application Developer
•    The Application Developer is responsible for making available applications and systems which provide the required functionality for IT services.
•    This includes the development and maintenance of custom applications as well as the customization of products from software vendors.
Change Advisory Board (CAB)
•    A group of people that advises the Change Manager in the assessment, prioritization and scheduling of Changes.
•    This board is usually made up of representatives from all areas within the IT organization, the business, and third parties such as suppliers.
Change Manager
•    The Change Manager controls the lifecycle of all Changes.
•    His primary objective is to enable beneficial Changes to be made, with minimum disruption to IT services.
•    For important Changes, the Change Manager will refer the authorization of Changes to the Change Advisory Board (CAB).
Configuration Manager
•    The Configuration Manager is responsible for maintaining information about Configuration Items required to deliver IT services.
•    To this end he maintains a logical model, containing the components of the IT infrastructure (CIs) and their associations.
Emergency Change Advisory Board (ECAB)
•    A sub-set of the Change Advisory Board who makes decisions about high impact Emergency Changes.
•    Membership of the ECAB may be decided at the time a meeting is called, and depends on the nature of the Emergency Change.
Knowledge Manager
•    The Knowledge Manager ensures that the IT organization is able to gather, analyze, store and share knowledge and information.
•    His primary goal is to improve efficiency by reducing the need to rediscover knowledge.
Project Manager
•    The Project Manager is responsible for planning and coordinating the resources to deploy a major Release within the predicted cost, time and quality estimates.
Release Manager
•    The Release Manager is responsible for planning and controlling the movement of Releases to test and live environments.
•    His primary objective is to ensure that the integrity of the live environment is protected and that the correct components are released.
Test Manager
•    The Test Manager ensures that deployed Releases and the resulting services meet customer expectations, and verifies that IT operations is able to support the new service.
 
ITIL roles and boards - Service Operation
________________________________________
1st Level Support
•    The responsibility of 1st Level Support is to register and classify received Incidents and to undertake an immediate effort in order to restore a failed IT service as quickly as possible.
•    If no ad-hoc solution can be achieved, 1st Level Support will transfer the Incident to expert technical support groups (2nd Level Support).
•    1st Level Support also processes Service Requests and keeps users informed about their Incidents' status at agreed intervals.
2nd Level Support
•    2nd Level Support takes over Incidents which cannot be solved immediately with the means of 1st Level Support.
•    If necessary, it will request external support, e.g. from software or hardware manufacturers.
•    The aim is to restore a failed IT Service as quickly as possible.
•    If no solution can be found, the 2nd Level Support passes on the Incident to Problem Management.
3rd Level Support
•    3rd Level Support is typically located at hardware or software manufacturers (third-party suppliers).
•    Its services are requested by 2nd Level Support if required for solving an Incident.
•    The aim is to restore a failed IT Service as quickly as possible.
Access Manager
•    The Access Manager grants authorized users the right to use a service, while preventing access to non-authorized users.
•    The Access Manager essentially executes policies defined in Information Security Management.
Facilities Manager
•    The Facilities Manager is responsible for managing the physical environment where the IT infrastructure is located.
•    This includes all aspects of managing the physical environment, for example power and cooling, building access management, and environmental monitoring.
Incident Manager
•    The Incident Manager is responsible for the effective implementation of the Incident Management process and carries out the corresponding reporting.
•    He represents the first stage of escalation for Incidents, should these not be resolvable within the agreed Service Levels.
IT Operations Manager
•    An IT Operations Manager will be needed to take overall responsibility for a number of Service Operation activities.
•    For instance, this role will ensure that all day-to-day operational activities are carried out in a timely and reliable way.
IT Operator
•    IT Operators are the staff who perform the day-to-day operational activities.
•    Typical responsibilities include: Performing backups, ensuring that scheduled jobs are performed, installing standard equipment in the data center.
Major Incident Team
•    A dynamically established team of IT managers and technical experts, usually under the leadership of the Incident Manager, formulated to concentrate on the resolution of a Major Incident.
Problem Manager
•    The Problem Manager is responsible for managing the lifecycle of all Problems.
•    His primary objectives are to prevent Incidents from happening, and to minimize the impact of Incidents that cannot be prevented.
•    To this purpose he maintains information about Known Errors and Workarounds.
Service Request Fulfilment Group
•    Service Request Fulfilment Groups specialize on the fulfillment of certain types of Service Requests.
•    Typically, 1st Level Support will process simpler requests, while others are forwarded to the specialized Fulfilment Groups.
 
ITIL roles - Continual Service Improvement
________________________________________
CSI Manager
•    The Continual Service Improvement (CSI) Manager is responsible for managing improvements to IT Service Management processes and IT services.
•    He will continually measure the performance of the service provider and design improvements to processes, services and infrastructure in order to increase efficiency, effectiveness, and cost effectiveness.
Process Architect
•    The Process Architect is responsible for maintaining the Process Architecture (part of the Enterprise Architecture), coordinating all changes to processes and making sure that all processes cooperate in a seamless way.
•    This role often also supports all parties involved in managing and improving processes, in particular the Process Owners. Some organizations combine this role with the Enterprise Architect role.
Process Owner
•    A role responsible for ensuring that a process is fit for purpose.
•    The Process Owner’s responsibilities include sponsorship, design, and continual improvement of the process and its metrics.
•    In larger organizations there might be separate Process Owner and Process Manager roles, where the Process Manager has responsibility for the operational management of a process.
 
ITIL roles outside the IT organization
________________________________________
Customer
•    Someone who buys IT services.
•    The Customer of an IT service provider is the person or group who defines and agrees the service level targets.
Service User
•    A person who uses one or several IT services on a day-to-day basis. Service Users are distinct from Customers, as some Customers do not use IT services directly.