An Internship Report

On

PROCESS MINING VIRTUAL INTERNSHIP

Submitted in partial fulfillment of requirements for the award of degree of

Bachelor of Technology

In

Information Technology
By

YARRAMREDDY PRUDHVI - 20BQ1A12I5

Department of Information Technology

VASIREDDY VENKATADRI INSTITUTE OF TECHNOLOGY
Approved by AICTE, Permanently Affiliated to JNTU, KAKINADA
Accredited by NBA & Accredited by NAAC with ‘A’ Grade
Nambur (V), Peda Kakani (M), Guntur (Dt) – 522508
 Department of Information Technology
VASIREDDY VENKATADRI INSTITUTE OF TECHNOLOGY
Approved by AICTE, Permanently Affiliated to JNTU, KAKINADA
Accredited by NBA & Accredited by NAAC with ‘A’ Grade
Nambur (V), Peda Kakani (M), Guntur (Dt) – 522508

BONAFIDE CERTIFICATE

This serves to confirm that the internship report submitted is the genuine work of
"YARRAMREDDY PRUDHVI (20BQ1A12I5)," who successfully completed the internship under
my supervision in the academic year 2022-2023, as part of the fulfillment of the criteria for the Bachelor
of Technology in Information Technology degree awarded by Jawaharlal Nehru Technological
University, Kakinada.

Signature of the SPOC Signature of the Head of the Department

Mr. Md. Shakeel Ahmed Dr KALAVATHI ALLA [Link];Ph.D;
Associate Professor, IT. Professor, IT.

Submitted for Viva voce Examination held on

EXTERNAL EXAMINER
 VASIREDDY VENKATADRI INSTITUTE OF TECHNOLOGY

Department of IT

CERTIFICATE OF AUTHENTICATION
I solemnly declare that this Internship report “PROCESS MINING VIRTUAL
INTERNSHIP” is Bonafide work done purely by me, carried out under the Single PointOf Contact
of Mr. Md. Shakeel Ahmed, Assoc. Prof., towards partial fulfillment of therequirements of the
Degree of Bachelor of Technology in IT from Jawaharlal Nehru Technological University,
Kakinada during the year 2022-23.

Signature of the Student

YARRAMREDDY PRUDHVI - 20BQ1A12I5

 ABSTRACT
The objective of this Process Mining Internship provides a strong foundation about Process
Mining Fundamentals and Experts which offers basic concepts of the analysis and process explorer,
case explorer, and Celonis platform, including available services and their common usecases, Process
Mining principles (at the conceptual level), processing the data.

Solution architecture forms the foundation for software development initiatives by customizing
IT solutions to meet precise business requirements and delineating their functional prerequisites and
phases of execution. It encompasses several subprocesses influenced by diverse enterprise architecture
perspectives, aiding individuals in comprehending data mining requisites and procedures. The Celonis
Platform, in this regard, furnishes the means for navigating, analyzing, and leveraging the process
explorer while facilitating data export.

In light of this, the Capstone Project proposal focuses on a case study of Pizzeria Mamma Mia.
This solution will streamline data processing at various levels, employing distinct parameters through
the utilization of tools available within the Celonis platform.

Efficient utilization of the Celonis platform enables the processing of extensive data volumes
and facilitates the extraction of insights and conclusions from the analyzed data.
 LETTER OF UNDERTAKING
To
The Principal
Vasireddy Venkatadri Institute of Technology
Namburu, Guntur.

Subject: Submission of Internship Report on Process Mining Virtual Internship on

Eduskills platform.
Dear Sir,
I am pleased to submit my internship report on “Process Mining Virtual Internship” as
per your instruction to fulfill the requirements of the Degree of Bachelor of Technology in IT
fromJawaharlal Nehru Technological University, Kakinada. While preparing this report, I have
triedmy level best to include all the relevant information, explanations, things I learned from the
Internship Courses, my contribution to this program to make the report informative and
comprehensive. It would not have been possible to complete this report without your assistance,
for which I am very thankful. Working for two months on Process Mining Virtual Internship in
online was amazing and a huge learning opportunity for me. Also, it was a great experience to
prepare this report and I will be available for any clarification if required.

Therefore, I pray and hope that you would be kind enough to accept my Internship Report
and oblige thereby.
Yours Obediently,
YARRAMREDDY PRUDHVI

ID: 20BQ1A12I5

Email:20BQ1A12I5@[Link]
CERTIFICATE OF INTERNSHIP
 ACKNOWLEDGEMENT
We take this opportunity to express our deepest gratitude and appreciation to all
those people who made this Internship work easier with words of encouragement, motivation,
discipline, and faith by offering different places to look to expand my ideas and help me
towards the successful completion of this Internship work.

First and foremost, we express our deep gratitude to Mr. Vasireddy Vidya Sagar,
Chairman, Vasireddy Venkatadri Institute of Technology for providing necessary facilities
throughout the Information Technology program.

We express our sincere thanks to Dr. Y. Mallikarjuna Reddy, Principal, Vasireddy

Venkatadri Institute of Technology for his constant support and cooperation throughout the
Information Technology program.

We express our sincere gratitude to Dr. A. KALAVATHI, Professor & HOD,

Information Technology, Vasireddy Venkatadri Institute of Technology for his constant
encouragement, motivation and faith by offering different places to look to expand my ideas.
We would like to express our sincere gratitude to our VVIT-INTERNSHIP I/C Mr.
Md. Shakeel Ahmed and our Intership Coordinators Ms. SK. Mulla Almas & Mr. B
Avinash for his insightful advice, motivating suggestions, invaluable guidance, help and support in
successful completion of this Internship.
We would like to take this opportunity to express our thanks to the teaching and non-
teaching staff in the Department of Information Technology, VVIT for their invaluable help and
support.

YARRAMREDDY PRUDHVI 20BQ1A12I5

 Table of Contents
Celonis Process Mining Fundamentals:
Stipulated Completion
Module Module Contents
Date Date
Introduction
• Introduction to Process
Mining Fundamentals
Module 1 18-12-22
track
• Introduction to Process
Mining
Review and Interpret Analysis
• Get to know Celonis
Analysis
• Navigate to an Analysis
• Use variant Explorer
• Use the Process
Explorer
• Use charts and tables,
Review KPIs
Module2 • Use Selection Views 05-01-23
• Use the Case Explorer
• Use the Conformance
Checker
• Save and share Analysis
Section,
Export Data
• Wrap up: Review and
Interpret
Build Analyses-Basics
• Get Ready to Build
Analyses
• Create theAnalysis
Assest
• Add the First Analysis
Sheet and Publish
• Configure Single KPI,
Selection & Design
Component
Module 3 13-01-23
• Configure Standard
Process KPIs in the
Visual Editor
• Configure Custom KPIs
in the Visual Editor
• Configure a
conformance Checker
Sheet
• Wrap-up: Build
Analyses-Basics
 Case Study
Module 4 Case Study: Pizzeria 20-01-23
Mamma Mia
Identify and Realize
Execution Gaps
• Introducing the Path to
Value
Module 5 • Frame Value 20-01-23
• Realize Value: Execute
Improvement Action
• Sustain Value

Celonis Process Mining Experts:

Stipulated Completion
Module Module Contents
Date Date

Kick of Webinar
Module 1 27-01-23
• Webinar
Analyst
• Review and interpret
analyses
• Configure single
Module 2 KPI,Selection 27-01-23
and Design
components
• Configure tables
andcharts
Data Engineer
• Load a data model
• Data Integration basics
Module 3 • Basic coding with PQL 04-02-23
• Connect to systems
Extract Data
• Transform Data

Business User
• Celonis Studio
• Intro to Action Flows
• Schedule data jobs
Module 4 10-02-23
• Multiple process
and systems
• Monitor and validate
your data pipeline
About Celonis:
Celonis is the global leader in execution management. The Celonis Execution
Management System provides companies with a modern way to run their business processes
entirely on data and intelligence. We pioneered the process mining category 10 years ago when
we first developed the ability to automatically X-ray processes and find inefficiencies.

Celonis has developed software that does process mining. Process mining is a
technology that allows processes to be analysed based on data. Processes such as deliveries,
productions, or even orders can be recorded and evaluated. The aim behind this is to uncover
inefficiencies and uncover potential areas for improvement. Especially in huge companies with
cross-departmental processes, it is almost impossible to know, let alone understand, the entire
process at a certain point.

Celonis software is called an "Execution Management System". In concrete terms, this means
that digital processes are automatically recorded and mapped. This is to create a completely
objective and data-driven picture of the company's internal processes. The data for this is
usually already available in software such as SAP.
EduSkills with VVIT
 Work Samples
Capstone Project:

This project provides me with an opportunity to demonstrate the solution design skills
that I have developed throughout this course.
Assignment is to design and deploy a solution for the following case:

Pizzeria Mamma Mia

Behind every bad customer experience lies an inefficient process. Example First we had to wait
several hours and when the pizza arrived it was completely cold. Never ordering here again!
The Pizzeria Mamma Mia has been opened about a year ago and the business is generally going
well with customers praising the good quality and taste of the pizza. However, their customer
ratings have been very low, and they are making negative profits for some of their deliveries.
Following are the tasks that can be achieved by doing Pizzeria Mamma Mia:-

• Finally you can see how your processes really run. Get full transparency of your as-is
processes and explore every step and deviation to identify points of friction.
• Improve your processes one skill at a time. Automate tasks and get suggestions for
intelligent actions to ensure that you set the right priorities and run your processes in
the most efficient way.
• Track your processes with full transparency, and benefit from internal and external
process benchmarking.

Detailed View of User interface:

1. This is the starting page for the user to interact. This page contains various options like add
a section, variant explorer, process explorer, revenue analysis, other options, details, etc.
[Link] page is visible when we click on the process explorer option on the bottom of the screen:

[Link] the Revenue analysis is clicked, it reviews the orders cancelled and average cycle time:
Experts Module Work Samples :
Configure tables and Charts with Dimensions and KPI’s:
Dimension:
Dimensions are used to determine which attributes from the analysis are displayed; for
example, vendor name, customer name, date, region, or document type. Dimensions represent
the columns of the data tables (for example, Dimension = Customer name, Attribute = Acme
Bread Company).
Key Performance Indicators (KPI):
KPIs, or Key Performance Indicators, are used to calculate and add aggregated values;
for example, case count, order value, invoice value, throughput time, or automation rate. KPIs
are functions that consolidate a set of values belonging to a single occurrence inside a dimension
into one single value.

Configuring a pie chart using Dimensions and KPI’s

Load A Data Model :

To create a Data model follow the below steps:

1. Click on “New Data Model”

2. All the raw data tables extracted will be displayed. Select the table and click on
continue. Select the required activity table

3. Select the essential columns of the activity table and click on finish.

4. Now we have this activity table in the data model once we load the model we can
see the activities in the analyses.
Process Query Language(PQL):

The Process Query Language (PQL) is a domain-specific language tailored

towards a special process data model and designed for business [Link] enables the
user to translate process- related business questions into queries, which are then
executed on a custom-built query [Link] covers a broad set of operators, ranging
from process-specific functions to aggregations and mathematical operators. Its syntax
is inspired by SQL, but specialized for process-related queries.

Best Practices in PQL:

1. Costs associated with the functions in PQL are given in the below image.
Connect Multiple Systems:
There are two types of Connections in systems:

1. Parallel
Parallel or horizontal scenario . In this scenario, the same exact process is executed in
parallel in different systems. Companies with branches in different countries are a perfect
example of this since they often have dedicated source systems per each country they operate
in.

2. Sequential

Then there is the sequential or vertical scenario. “Sequential” refers to the fact that
different steps of a process are tracked in different source systems. For example,
information on “Activity A” is stored in “Source system 1” and information on
“Activity D” in “Source System 3”.
Sample Visual Editor and Selection Views:

Selecting the right builder in the Visual Editor

Selection Views
Conformance checker
 Conclusion

In conclusion, my internship has played a pivotal role in not only broadening my

theoretical understanding but also in enhancing my practical skills. One of the most
noteworthy aspects of this internship has been the acquisition of knowledge related to data
processing. This is particularly significant given the increasing prominence of process mining
technology in today's rapidly evolving business landscape.

The internship experience has illuminated the significance of process mining and its
potential impact in various industries. With well-established platforms, including robust
databases and intuitive interfaces, this technology stands out as a user-friendly and easily
accessible solution.

Through hands-on experiences during the internship, I've come to appreciate the real-
world applications of theoretical concepts I've learned. This practical knowledge has not only
increased my proficiency but also instilled confidence in my ability to apply these skills in
future endeavors.

Furthermore, the exposure to process mining technology has reinforced my belief in its
long-term relevance and potential for future growth. As industries continue to seek more
efficient and data-driven solutions, process mining offers an avenue for organizations to gain
valuable insights into their operations and make data-informed decisions.

In summary, my internship has been a transformative experience, equipping me with

both theoretical and practical knowledge that will undoubtedly prove beneficial as I move
forward in my career. Process mining, with its user-friendly platforms, promises to be a
valuable asset in the evolving landscape of data processing and analysis, and I am excited
about the possibilities it holds for the future.