INTERNSHIP REPORT

An internship report submitted in partial fulfilment of the requirements of II B. Tech II Semester of

BACHELOR OF TECHNOLOGY

in

COMPUTER SCIENCE AND ENGINEERING

by

Kompella Venkata Aditya Ram

21ME1A0591

Under Supervision of

Mr. Y. Nagendra Kumar

Assistant Professor,
Department of CSE

Department of Computer Science & Engineering

Ramachandra College of Engineering (Autonomous)

Approved by AICTE, Permanently Affiliated to JNTUK, Recognized by UGC 2(f) & 12(B),
Accredited by NAAC A+, Accredited by NBA, ISO 9001:2015 Certified
NH-16, Bypass Road, Vatluru (V), Eluru – 534007, W.G. Dt., A.P.
2022-23

1
 Ramachandra College of Engineering (Autonomous)
Approved by AICTE, Permanently Affiliated to JNTUK, Recognized by UGC 2(f) & 12(B),
Accredited by NAAC A+, Accredited by NBA, ISO 9001:2015 Certified
NH-16, Bypass Road, Vatluru (V), Eluru – 534007, Eluru Dt., A.P.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING

CERTIFICATE

This is to certify that the “Internship report” submitted by KOMPELLA

VENKATA ADITYA RAM (Regd. No.: 21ME1A0591) is work done by him/her and

submitted during 2023 – 2024 academic year in partial fulfilment of the requirements for the

award of the degree of BACHELOR OF TECHNOLOGY in COMPUTER SCIENCE AND

ENGINEERING, at EduSkills, NEAT Cell, AICTE.

Mr. Y. Nagendra Kumar Dr. P. M. Prasuna

Assistant Professor, Dept. of CSE Head, CSE

External Examiner

2
 ACKNOWLEDGEMENT

I would like to take the opportunity to express our deep gratitude to all the people who
have extended their cooperation in various ways during my internship. It is my pleasure and
responsibility to acknowledge the help of all those individuals.
I have extended our sincere thanks to Mr. Y. Nagendra Kumar, Assistant Professor
in the Department of CSE for helping me the in successful completion of my internship.
I am very grateful to Dr. P.M. Prasuna, Head of the Department, Department of
Computer Science & Engineering for his assistance and encouragement in all respects in
carrying throughout my internship.
I would like to express my deepest gratitude to Dr. V. Srinivasa Rao, Principal,
Ramachandra College of Engineering, Eluru for his valuable suggestions during the
preparation of draft in our document.
I express my deepest gratitude to The Management of Ramachandra College of
Engineering, Eluru for their support and encouragement in completing my internship and
providing me necessary facilities.
I sincerely thank all the faculty members and staff of the Department of CSE for their
valuable advices, suggestions and constant encouragement which played a vital role in
carrying out my internship.
Finally, I thank one and all who directly or indirectly helped me to complete my internship
successfully.

Kompella Venkata Aditya Ram

21ME1A0591

3
 Abstract
The Data Analytics Process Automation Virtual Internship offers a hands-on and
immersive experience in the dynamic field of data analytics and process automation.
Participants engage in real-world projects, applying data-driven methodologies to extract
insights, streamline processes, and drive informed decision-making. Through virtual
simulations and interactive modules, interns gain proficiency in utilizing cutting-edge
analytics tools and automation technologies.

This internship equips participants with practical skills in data manipulation,

visualization, and automation scripting, fostering a deep understanding of end-to-end data
analysis workflows. It provides a valuable opportunity to enhance problem-solving abilities,
critical thinking, and collaboration within a virtual work environment. Ultimately,
participants emerge with a comprehensive understanding of the data analytics and automation
landscape, empowering them to navigate and contribute to this rapidly evolving field.

4
Organization Information
EduSkills is a platform promoting education and skill development. NEAT
Cell (National Educational Alliance for Technology) focuses on using technology to enhance
learning. AICTE (All India Council for Technical Education) is a regulatory body in India,
ensuring quality in technical education and fostering innovation in institutions.

Programs and opportunities at the organization

EduSkills offers diverse programs and opportunities aimed at fostering holistic
education and skill development. It provides online courses, workshops, and certification
programs to enhance learners' knowledge and employability. Additionally, EduSkills
collaborates with industry experts and educational institutions to create a dynamic learning
ecosystem, ensuring alignment with current industry needs.
NEAT Cell, under the AICTE, focuses on leveraging technology to revolutionize
education. It facilitates the integration of Artificial Intelligence in learning platforms,
promoting personalized and adaptive learning experiences. NEAT Cell also connects students
with internships, mentorship programs, and industry-relevant projects, enhancing their
practical skills and preparing them for the demands of the modern workforce. AICTE, as a
regulatory body, ensures quality standards and facilitates innovation in technical education
institutions, contributing to a robust and responsive education system in India.

Methodologies
In the Data Analytics Process Automation Virtual Internship, I leverage Alteryx
Designer Tools Software. Tasks include efficient data exploration and quality assurance
through Alteryx cleaning processes. Statistical analysis, visualization, and machine learning
are seamlessly executed within Alteryx. Process automation is streamlined with Alteryx's
workflow design. Collaborative projects thrive using the software, enhancing teamwork.
Alteryx's intuitive interface facilitates problem-solving and communication. Agile
methodologies guide project management, emphasizing continuous improvement through
Alteryx's feedback and iteration features. This immersive experience provides a practical
understanding of data analytics and automation through Alteryx Designer Tools Software

5
Key parts of the report
Explored data, utilized Alteryx for analytics and automation. Enhanced collaboration,
problem-solving, and practical skills. Applied agile methodologies for improvement.

Benefits of the Company/Institution through my report

EduSkills offers diverse education and skill programs, while NEAT Cell and AICTE
focus on technology-driven learning and quality technical education. The collaboration
ensures a dynamic, industry-aligned ecosystem, enhancing practical skills and preparing
individuals for the evolving workforce, fostering a well-rounded and future-ready skill set.

6
7
 INDEX

S. No Contents Page No

1 Abstract 4

2 Introduction to Company/Institution 5-6

3 Internship Certificate 7

4 Learning Objectives/Internship Objectives 9

5 Weekly overview of internship activities 10-11

6 Introduction to Internship Topic 12

6.1 Modules, if any 13-21

7 Analysis 22

8 Software Requirement Specification 23

9 Conclusion 24
10 Bibliography 25

8
Learning Objectives/Internship Objectives

 Internships are generally thought of to be reserved for college students looking to gain
experience in a particular field. However, a wide array of people can benefit from
Training Internships in order to receive real world experience and develop their skills.

 An objective for this position should emphasize the skills you already possess in the area
and your interest in learning more.

 Internships are utilized in a number of different career fields, including architecture,

engineering, healthcare, economics, advertising and many more.

 Some internship is used to allow individuals to perform scientific research while others
are specifically designed to allow people to gain first-hand experience working.

 Utilizing internships is a great way to build your resume and develop skills that can be
emphasized in your resume for future jobs. When you are applying for a Training
Internship, make sure to highlight any special skills or talents that can make you stand
apart from the rest of the applicants so that you have an improved chance of landing the
position.

9
 WEEKLY OVERVIEW OF INTERNSHIP ACTIVITIES

Week Date Day Name of topic / Module completed

10-9-2023 Sunday Module1 – Overview, Designer Basics
11-9-2023 Monday Module1 – What is Data?
12-9-2023 Tuesday Module1 – Using Designer
I 13-9-2023 Wednesday Module1 – Benefits of Designer
14-9-2023 Thursday Module1 – First Steps in Designer
15-9-2023 Friday Module1 – Working with Your Data
16-9-2023 Saturday Module1 – Solving in Designer

Week Date Day Name of topic / Module completed

17-9-2023 Sunday Module2 – Basic Data Prep
18-9-2023 Monday Module2 – Formatting Data
19-9-2023 Tuesday Module2 – Sorting Data
II 20-9-2023 Wednesday Module2 – Filtering Data
21-9-2023 Thursday Module2 – Sampling Data
22-9-2023 Friday Module2 – Practice Exercise1
23-9-2023 Saturday Module2 – Practice Exercise1

Week Date Day Name of topic / Module completed

24-9-2023 Sunday Module3 – Basic Data Combining and Cleansing
25-9-2023 Monday Module3 – Foundational Articles
26-9-2023 Tuesday Module3 – Separating Data
III 27-9-2023 Wednesday Module3 – Removing Duplicates
28-9-2023 Thursday Module3 – Blending Data
29-9-2023 Friday Module3 – Blending Data
30-9-2023 Saturday Module3 – Joining Data

Week Date Day Name of topic / Module completed

1-10-2023 Sunday Module3 – Practice Exercise 2
2-10-2023 Monday Module3 – Practice Exercise 2
3-10-2023 Tuesday Module3 – Practice Exercise 2
IV 4-10-2023 Wednesday Module3 – Prep Guide
5-10-2023 Thursday Module3 – Get Certified
6-10-2023 Friday Module4 – Path to Core Certification
7-10-2023 Saturday Module4 – Path to Core Certification

Week Date Day Name of topic / Module completed

8-10-2023 Sunday Module4 – Date Time
9-10-2023 Monday Module4 – Rows vs Columns
10-10-2023 Tuesday Module4 – Functions
V 11-10-2023 Wednesday Module4 – Expressions
12-10-2023 Thursday Module4 – Summarizing Data
13-10-2023 Friday Module4 – Practice Exercise 3
14-10-2023 Saturday Module4 – Practice Exercise 3

10
Week Date Day Name of topic / Module completed
15-10-2023 Sunday Module5 – Transforming Your Dataset
16-10-2023 Monday Module5 – Changing Data Layouts
17-10-2023 Tuesday Module5 – VLookups
VI 18-10-2023 Wednesday Module5 – Append Fields
19-10-2023 Thursday Module5 – Writing Data
20-10-2023 Friday Module5 – Writing Data
21-10-2023 Saturday Module5 – Practice Exercise 4

Week Date Day Name of topic / Module completed

22-10-2023 Sunday Module5 – Practice Exercise 4
23-10-2023 Monday Module5 – Capstone Project
24-10-2023 Tuesday Module5 – Capstone Project
VII 25-10-2023 Wednesday Module5 – Capstone Project
26-10-2023 Thursday Module5 – Capstone Project
27-10-2023 Friday Module5 – Capstone Project
28-10-2023 Saturday Module5 – Capstone Project

Week Date Day Name of topic / Module completed

29-10-2023 Sunday Weekly Challenges- Unofficial Holidays
30-10-2023 Monday Weekly Challenges- Unofficial Holidays
31-10-2023 Tuesday Weekly Challenges- Popular Baby Names
VIII 1-11-2023 Wednesday Weekly Challenges- Prep a Shoe List
2-11-2023 Thursday Weekly Challenges- Prep a Shoe List
3-11-2023 Friday Weekly Challenges- Eurovision
4-11-2023 Saturday Weekly Challenges- Retail Therapy

Week Date Day Name of topic / Module completed

5-11-2023 Sunday Weekly Challenges- Where There’s a Whale There’s a
Way
6-11-2023 Monday Weekly Challenges- Formatting a Date from an
Integer
IX 7-11-2023 Tuesday Weekly Challenges- Data Blending for Batch Output
8-11-2023 Wednesday Weekly Challenges- Data Blending for Batch Output
9-11-2023 Thursday Weekly Challenges- Where is the party?
10-11-2023 Friday Weekly Challenges- Elapsed Classroom Times
Saturday Weekly Challenges- Elapsed Classroom Times

Week Date Day Name of topic / Module completed

X 11-11-2023 Sunday Weekly Challenges- Let’s Summarize!
12-11-2023 Monday Weekly Challenges- Parsing out the New-line
character
13-11-2023 Tuesday Weekly Challenges- Preparing Delimited Data
14-11-2023 Wednesday Weekly Challenges- Time for College!
15-11-2023 Thursday Weekly Challenges- Movie Decisions

11
 16-11-2023 Friday Module-6 Prep Guide
17-11-2023 Saturday Module-6 Get Certified

Introduction to Internship Topic:

The Data Analytics Process Automation Virtual Internship introduces participants to
the dynamic convergence of data analytics and process automation. In this immersive
experience, interns embark on real-world projects, applying state-of-the-art tools and
methodologies to extract actionable insights from data.
The internship emphasizes the strategic use of data for informed decision-making and
explores the integration of automation to streamline complex workflows efficiently. Through
hands-on exploration, participants gain practical skills, navigating the intricacies of data-
driven processes.
This comprehensive learning journey equips interns with a nuanced understanding of
the symbiotic relationship between data analytics and process automation, preparing them for
the challenges of a rapidly evolving technological landscape.

Data Analytics:
Data Analytics is a transformative field leveraging statistical methods and technology
to extract actionable insights from large datasets. It plays a vital role in informing strategic
decisions, uncovering patterns, and optimizing processes across various industries, driving
innovation and efficiency in today's data-centric landscape.

Process Automation:
Process Automation involves using technology to streamline and optimize repetitive
tasks, reducing manual effort and enhancing efficiency. It employs tools like workflow
automation platforms to automate complex processes, improving accuracy and speed. Process
Automation is integral to modern industries, enhancing productivity and enabling
organizations to focus on strategic initiatives.

Data Analytics Process Automation:

Data Analytics Process Automation synergizes data analysis and workflow
optimization. It entails leveraging analytics tools to extract insights from data and using
automation technologies to streamline processes. This integrated approach enhances decision-

12
making efficiency, reduces manual intervention, and drives innovation in data-driven
environments across various industries.

Modules in Data Analytics Process Automation Virtual Internship:

There are 6 modules present in the Data Analytics Process Automation Virtual Internship.
1) Getting Started
2) Data Preparation
3) Combining and Cleansing Data
4) Core Topics
5) Continuing Core Topics
6) Designer Core Prep

Module-1
Getting Started
In this module, Designer Basics like what is data, using designer, benefits of designer,
first steps in designer, working with your data and also solving in designer.
The mentioned concepts are covered in this module.
This module also gives Introduction on Alteryx Designer Software and its setup.
Working with the workflow in Designer Software for Data Analysing. It also provided a
hands-on experience for initially taking of input data and viewing the data.
From this module, I learnt that how an input data can be entered and inputting the data
into my workflow using the tools provided by the Alteryx Designer Software.

13
Module-2
Data Preparation
This module provides the information on the Data Preparation. There are four sub-
modules and one practice exercise available in this module. They are
1) Formatting Data
2) Sorting Data
3) Filtering Data
4) Sampling Data.
From this module, I learnt that how a data can be Formatted, Sorted, Filtered and
Sampled using the tools provided by the Alteryx Designer Software.
In this module there is a practice Exercise 1, which gives a hands-on experience by
creating a workflow using the tools like format, filter, sorting, etc.

14
 My solution towards the exercise was submitted and that submitted file page.

Module-3
Combining and Cleansing Data
This module provided the Basic Data Combining and Cleansing concepts. There are
five sub-modules and one practice exercise in this module. They are:
1) Foundational Articles
2) Separating Data
3) Removing Duplicates
4) Blending Data
5) Joining Data.
From this module, I learnt that how a data can be Separated, Removal of Duplicates,
Blending and Joining using the tools provided by the Alteryx Designer Software.

15
 This module contains another practice exercise called as Practice Exercise 2 and its
declaration towards my submission.

This module contains a quiz program which is provided with 40 questions in a time
span of 60minutes and named as Alteryx Foundation Micro-Credential. After completion of
this quiz with 80.5%, I got a badge, certificate and my exam result to my mail.

16
Module-4
Core Topics
This module provides a clear path to Core Certification. It consists of 6 sub-modules
and one practice exercise. They are:
1) Data in the cloud
2) Date Time
3) Rows vs Columns
4) Functions
5) Expressions
6) Summarizing Data.
This module gives information in detail that how the formats of Date Time can be
arranged, Functions like Summations, Selecting, Sorting, Summarize, etc.

17
Module-5
Continuing Core Topics
This module is the continuation module for the Core Topics Module. In Core Topics
Module, I learnt about Functions, Expressions, Summarization, etc. But in this module, I
learnt and this module provided about the Transforming my Dataset.
In this module, there are four sub-modules, one practice exercise and one project also.
They are
1) Changing Data Layouts
2) VLookups (Find Replace Tool)
3) Append Fields
4) Writing Data

18
 From this module, I learnt how to change the layout of the data like from rows to
columns & columns to rows, usage of Replace, Append Fields Tools and Output Data Tool.
In this module, I got a clear idea about the Output Data and a complete workflow design.

As I informed that this module contains one project which is named as Capstone
Project. When my path reached to this project, my almost course get ready for completion.
This project was very useful to me in order to present my skills which I learned until there. I
applied my skills I learnt to complete a final Capstone Project.

19
Module-6
Designer Core Prep

20
 This is the final module which is named as Designer Core Prep, which provides
complete preparation guide for the Alteryx Designer Core Certification. There are three sub-
modules in this module. They are
1) Weekly Challenges
2) Prep Guide
3) Get Certified
In this module, there are fifteen weekly challenges which improves the great practice
on the skills that I learned in this course. This also provided the guidance to the Core
Certificate. This module contains the main exam.
The Weekly Challenges covered the entire concepts, tools used in the Alteryx
Designer Software and increased my workflow design on the process for Data Analytics.

In the prep guide there are two options while getting the preparation for the Core
Certification.

21
 I completed an exam called Alteryx Designer Core which contains 80 questions with
2 hours 30 minutes of time. This certification is the main certificate to complete my entire
internship. By attending the certification exam, I achieved 75.4% and a badge.

22
Analysis:
Data Analytics Process Automation Virtual Internship provided a comprehensive
analysis of the dynamic synergy between data analytics and process automation. Through
practical projects and exposure to tools like Alteryx, I gained hands-on experience in
extracting meaningful insights from data while optimizing workflows.
The internship emphasized the real-world application of agile methodologies,
fostering continuous improvement and adaptability. Collaborative projects enhanced
teamwork and communication skills, crucial in professional settings.
This analysis showcases the program's efficacy in equipping participants with a
versatile skill set, preparing them for the evolving demands of data-driven industries. Overall,
the internship provided a valuable and insightful exploration into the convergence of
analytics and automation in today's digital landscape.

23
Software Requirement Specification:
Data Analytics Process Automation Virtual Internship requires a computer with
internet access, supporting Windows, macOS, or Linux. Utilizing Alteryx Designer Software
(version 2023.1), participants engage in comprehensive data analytics and automation
workflows.
Basic SQL knowledge is recommended. Collaborative tools include GitHub, and the
Learning Management System (LMS) is essential for communication.

24
Conclusion:
Data Analytics Process Automation Virtual Internship has been a transformative
journey. Through hands-on projects and exposure to cutting-edge tools like Alteryx, I've
honed skills in data analysis and automation.
This experience not only deepened my understanding of industry practices but also
enhanced collaborative and problem-solving abilities. The application of agile methodologies
emphasized continuous improvement.
The internship's holistic approach, blending analytics with automation, equips me
with a versatile skill set crucial for navigating the evolving landscape of data-driven decision-
making.
Overall, it has been a valuable and practical immersion into the dynamic intersection
of analytics and automation.

25
Bibliography:
1) Bocsi, Jozsef, and Attila Tárnok. "Toward automation of flow data analysis." Cytometry
Part A 73A, no. 8 (August 2008): 679–80.
2) Krämer, Jonathan, Gregor Thiele, Theresa Johanni, and Jörg Krüger. "Automation of Life
Data Analysis Processes." IOP Conference Series: Materials Science and Engineering 1140,
no. 1 (May 1, 2021): 012022.
3) Bass, Ellen J., Leigh A. Baumgart, and Kathryn Klein Shepley. "The Effect of
Information Analysis Automation Display Content on Human Judgment Performance in
Noisy Environments." Journal of Cognitive Engineering and Decision Making 7, no. 1
(August 10, 2012): 49–65.
4) Nosova, A. D., T. T. Gazizov, A. N. Stas, and P. A. Shelupanova. "Application of
information systems for accounting and analysis of employee data." Proceedings of Tomsk
State University of Control Systems and Radioelectronics 23, no. 4 (December 25, 2020): 85–
90.
5) Spott, Martin, and Detlef Nauck. "Towards the automation of intelligent data
analysis." Applied Soft Computing 6, no. 4 (August 2006): 348–56.

26