[go: up one dir, main page]

0% found this document useful (0 votes)
19 views21 pages

Intermediate Report - (Darshan J Ronad-027)

The document is an internship report submitted by Darshan J Ronad for a Data Analytics internship at Palle Technologies, detailing the objectives, activities, and learnings from the internship. It provides an overview of Palle Technologies, including its offerings, infrastructure, and student success stories, alongside a structured account of the training received in programming, data analysis, and Excel. The report outlines various programming concepts and tools learned during the internship, emphasizing practical applications and challenges faced.

Uploaded by

pcabhilash67
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
19 views21 pages

Intermediate Report - (Darshan J Ronad-027)

The document is an internship report submitted by Darshan J Ronad for a Data Analytics internship at Palle Technologies, detailing the objectives, activities, and learnings from the internship. It provides an overview of Palle Technologies, including its offerings, infrastructure, and student success stories, alongside a structured account of the training received in programming, data analysis, and Excel. The report outlines various programming concepts and tools learned during the internship, emphasizing practical applications and challenges faced.

Uploaded by

pcabhilash67
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 21

VISVESVARAYA TECHNOLOGICAL UNIVERSITY

JNANA SANGAMA, BELAGAVI

An Internship Report - 1 (Intermediate)


On
“Data Analytics”

Submitted in partial fulfillment for the award of the degree of

BACHELOR OF ENGINEERING
In
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Submitted By
Darshan J Ronad
4GM21CS027

Internship Carried Out


At
Palle Technologies
No 15/6, Manish Complex, Main Road, Bommanahalli, above SBI Mangaammanapalya, Rajiv
Gandhi Nagar, HSR Layout, Bengaluru, Karnataka 560068

Internal Guide External Guide/mentor


Dr. Shankarayya Shastri Mr. Satish Reddy
Assistant Professor Senior Software Engineer
Department of CS&E Palle technologies

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING


GM INSTITUTE OF TECHNOLOGY, DAVANGERE
(Affiliated to VTU, Belagavi, Approved by AICTE -New Delhi & Govt. of Karnataka)
(Accredited by NBA New Delhi, Valid upto 30.06.2025)

2024-2025
CONTENTS

Offer Letter by the Company

Attendance Report

1. About the Company 01 - 02


1.1 About the Company Facilities
1.2 Infrastructure and Accreditation
1.3 Leadership and Team
1.4 Student Success and Testimonials
1.5 Contact Information

2. Objectives of the Internship 02

3. Activities Carried Out Till Date 02 - 16

4. Challenges Faced and Solutions 16

5. Key Learnings and Outcomes So Far 17


Intermediate Report

1. Introduction to the organization


Palle Technologies is a prominent IT training and software development company based in
Bengaluru, Karnataka, India. Established in 2010, the organization specializes in providing
placement-oriented training programs tailored for fresh engineering graduates and
professionals aiming to enhance their technical skills. With a commitment to bridging the gap
between academic knowledge and industry requirements, Palle Technologies has successfully
trained and placed over 35,000 students into various software companies.

1.1 Core Offerings and Specializations

Palle Technologies offers a diverse range of courses in high-demand technologies,


including:

 Programming Languages: Java, .NET, Python, C#, and SQL

 Web and Mobile Development: Android, Angular, JavaScript, and UI


Development

 Data Science and Machine Learning

 Software Frameworks: Spring, Hibernate, and MVC

1.2 Infrastructure and Accreditation

Located in Bommanahalli, Bengaluru, Palle Technologies boasts a state-of-the-art training


facility equipped with modern classrooms and labs. The organization is ISO 9001:2015
certified and is a member of NASSCOM, reflecting its adherence to quality standards in
education and training.

1.3 Leadership and Team

Under the leadership of CEO Lokanatha Reddy, Palle Technologies has expanded its team to
over 300 professionals, including experienced trainers and developers working on cutting-edge
technologies . The company's development wing actively engages in software projects,
providing additional practical exposure to students.

1.4 Student Success and Testimonials

1
Intermediate Report

Palle Technologies has garnered positive reviews from its alumni, many of whom have
transitioned into successful careers in the IT industry. Testimonials highlight the institute's
effective training methodologies, supportive faculty, and robust placement support. Notably,
students from non-IT backgrounds have also found success through the programs offered,
securing positions in reputable companies like Tech Mahindra and Cognizant.

1.5 Contact Information

o Website: www.techpalle.com
o Address: No. 15/6, 3rd Floor, Manish Complex, Mangammanapalya Main Road,
Bommanahalli, Bengaluru, Karnataka 560068
o Phone: +91 80 4164 5630

2. Objectives of the internship


1. To apply data analysis techniques on real-world datasets to derive actionable business
insights.
2. To gain proficiency in tools such as Excel, SQL, Python, and Power BI through hands-
on project work.
3. To understand and contribute to data-driven decision-making processes within a
professional setting.

3. Activities carried out till date


WEEK 1 (Feb17 – Feb22) : Programming Fundamentals and basics of python.

Day 1 : About Programming

Programming is the process of writing instructions that a computer can understand and execute
to perform specific tasks.

Key aspects of Programming:

 Logic & Problem Solving – Breaking down a problem into steps that a computer can
follow.

2
Intermediate Report

 Syntax & Semantics – Using the correct structure (syntax) and meaningful logic
(semantics) in a programming language.

 Algorithms – A set of rules or steps to solve a problem efficiently.

 Debugging – Finding and fixing errors (bugs) in the code.

 Execution – Running the program so the computer performs the

Day 2: Introduction to python programming and installation

Python is a high-level, interpreted programming language known for its simplicity, readability,
and versatility.

IDE – Integrated development Environment

Installation: downloaded the pycharm for the code running environment.

Day 3: Operators

Operators in Python are special symbols used to perform operations on variables and values.

i]. Arithmetic Operators (Perform mathematical operations)

+ (Addition) - (Subtraction)

* (Multiplication) / (Division)

% (Modulus) → Remainder ** (Exponentiation) → Power

// (Floor Division) → Quotient

Ii]. Comparison (Relational) Operators (Compare values, return True or False)

== (Equal to) != (Not equal to)

3
Intermediate Report

> (Greater than) < (Less than)

>= (Greater than or equal to) <= (Less than or equal to)

Day 4: Logical Operators Bitwise operators and Assignment Operators.

 Logical Operators (Used for logical conditions)

and (Returns True if both conditions are true)

or (Returns True if at least one condition is true)

not (Reverses the condition)

 Bitwise Operators (Operate at the binary level)

& (AND)

| (OR)

^ (XOR)

~ (NOT)

<< (Left shift)

>> (Right shift)

 Assignment Operators (Assign values to variables)

= (Assign)

+= (Add and assign)

-= (Subtract and assign)

*= (Multiply and assign)

/= (Divide and assign)

%= (Modulus and assign)

**= (Exponentiation and assign)

4
Intermediate Report

//= (Floor division and assign)

Day 5 : About print and input function and some of the basic programmers.

 The print() function is used to display output on the screen.

 The input() function is used to take user input as a string.

Example code :

# sum of two numbers

num1 = float(input("Enter first number: "))

num2 = float(input("Enter second number: "))

sum_result = num1 + num2

print("The sum is:", sum_result)

Day 6 : Test on Aptitude and basic programming Questions.

WEEK 2 (FEB 24 – MARCH 1) : Slicing Techniques and python data types.

In the Second week, we learned about data types and slicing in Python. Data types help us
understand what kind of information a variable holds. For example, numbers like 10 or 3.5 are
stored as integers and floats, while words and sentences are stored as strings. Lists and
dictionaries help organize multiple values efficiently.We also explored slicing, which allows us
to pick specific parts of a word or list. If we have the word "Python," slicing it from position 1
to 4 gives "yth." We can even reverse a word using slicing. These concepts make handling data
easier and more flexible in Python programming.

Day 1 : About Slicing in python.

Slicing used for the accessing the characters or elements from the sequence data.

There are 3 techniques of slicing :

5
Intermediate Report

 Technique 1 : Variable[index]

This technique is used for the accessing single elements.

 Technique 2 : Variable[Start index : End Index]

This Technique is used for accessing the character from left side to right side.

 Technique 3 : Variable[start index : end index : step size}

This technique is used for the accessing group of elements from right to left or left to
right(alternate order.

Day 2 : Numeric data types .

 In this class we learn about numerical data structures int ,float ,complex,Boolean.

 Integer (int) – Stores whole numbers (positive, negative, or zero) without decimal
points.

 Floating Point (float) – Stores numbers with decimal points or in scientific notation.

 Complex (complex) – Stores numbers with real and imaginary parts, represented as a
+ bj.

Day 3-Day 5 : Mahashivaratri Holydays..

Day 6 : Dictionary data type

 It stores the key value pairs.Having unique key but the values can be duplicate.It
follows insertion order

 It allows homogeneous and heterogeneous data elements and there will be no index
based operations.By the help of key values we can access the values from the dictionary.

Syntax :

Variable_name={“key1”:”value1”,”key2”:”value2”……}

We also solved the problems based on the dictionary data type

WEEK 3(MAR3-MAR6) : Sequence data types , Functions , Conditinal Statements.

6
Intermediate Report

In the third week we learned about the sequence data types like list, tuple ,
sets,range,Strings.We also learned about the functions and basic conditional statements.

Day 1 : List and Tuple data types

The day1 of week3 we learned about the list and tuple data types and how are they useful in
the python programming and what is the Syntax and how to add the values to it and how to
access the values from the

Syntax (List) :

Variable_name=[“ar”,”kv”,1,2,3]

Syntax(tuple) :

Variable_name=(1,2,3,2,5)

Day 2 : Sets ,Range,Strings

In the day2 we learned further datatypes like Sets , Strings and Range data types. We also
understand about how the syntax of this data types and how they are used in the python
programming this topics were learned.

Syntax(Sets) :

Variable_name={ }

Syntax(range) :

Variable_name=range(x,y,z(stepindex))

Day 3 : Functions

On day 3 the class was mainly focused on the functions and the syntax of the functions.the
function will be return starting by the keyword def .A function is consist of function
name,Function Body,Function calling.

Synatx :

Def function_name():

Function Body

Function Call ()

7
Intermediate Report

Day 4 : Conditinal Statements

In the day 4 of week 3 we learned about the conditional statements like if , if else , if elif
else,nested ifelse.

WEEK 4(MAR7-MAR14):

From March 7 to March 14, we covered Python If-Else statements, loops (while loop), and
problem-solving along with MS Excel basics, data entry, extraction, and key functions. Learned
sorting, filtering, formulas like SUM, AVERAGE, IF, and text functions in Excel. Python
exercises focused on conditional statements and loops for automating repetitive tasks. Holidays
were observed on March 8-9 and March 13-14 (Holi).

March 7: If-Else Statements and MS Excel Basics

 Learned about If-Else Statements in Python, which help in decision-making based on


conditions.

 Solved problems related to If-Else logic to understand real-time applications.

 Introduction to MS Excel Basics, including understanding the interface, rows, columns,


and basic operations like entering data and formatting cells.

 Cells: Where data is entered (e.g., A1, B2, etc.).

 Data Entry: Typing values, numbers, and text into Excel.

 Basic Operations: Addition, subtraction, multiplication using Excel formulas.

 Example: Print numbers from 1 to 5 using a while loop

num = 1

while num <= 5:

print(num)

num += 1

8
Intermediate Report

March 8 & 9: Holiday

March 10: Data Entry in Excel and Data Extraction & Load

Data Entry in Excel

 Entering different types of data: Text (Names, Addresses), Numbers (Sales Data,
Scores), Dates & Time (Timestamps)

 Using Autofill to quickly enter a series of numbers/dates.

Data Extraction in Excel

 Sorting & Filtering Data Sorting (Ascending/Descending) based on columns.

 Suppose we have the following Sales Data:

Name Product Sales

Alex Laptop 50000

John Phone 30000

Mary Laptop 55000

To filter only Laptop sales, apply a Filter on the "Product" column and select "Laptop."

Data Loading in Excel

 Importing data from CSV, Excel sheets, or databases.

 Saving data in different formats (CSV, XLSX, PDF).

 Exporting filtered/sorted data for reports.

March 11: Python Loops (While Loop) & MS Excel App Structure and Basic Commands

 Covered Python loops, focusing on the while loop and its applications.

9
Intermediate Report

 Practiced problems on while loops, emphasizing iteration and condition-based


execution.

 Learned about MS Excel’s structure, including the ribbon, menu options, and essential
shortcuts.

 Explored basic Excel commands like SUM, AVERAGE, and COUNT for data
manipulation.

March 12: Problems on While Loop & MS Excel Functions

 Solved more while loop problems to strengthen the concept of loop execution and
breaking conditions.

 Introduction to MS Excel Functions, including frequently used formulas such as:

 SUM(), AVERAGE(), MIN(), MAX(), IF()

 Text functions like CONCATENATE() and LEFT(), RIGHT()

 Logical functions for decision-making in Excel

 Example 1: Find the sum of numbers from 1 to 10 using a while loop

sum = 0

num = 1

while num <= 10:

sum += num

num += 1

print("Sum:", sum)

Output:

Sum:55

March 13 & 14: Holi Holidays

March 15-16 : Holidays

10
Intermediate Report

Week 5(Mar 17- Mar 23)

March 17: Formulas

o Learn how to create your own custom calculations using operators (+, -, *, /, ^, &)

o Understand the difference between formulas and functions

o Use parentheses to control the order of operations (PEMDAS)

o Combine multiple functions in a single formula (nested functions)

o Apply formulas across cells with auto-fill and drag-down.

March 18: Cell Referencing

o Use relative references (like A1) that change when copied

o Lock cells with absolute references ($A$1) to prevent changes when copied

o Combine both in mixed references (A$1, $A1)

o Reference cells from different worksheets and workbooks

o Apply references in formulas like =Sheet2!B5+A1

March 19: Data Tools

o Use Data Validation to create dropdown lists and control input

o Apply Sort & Filter to organize and extract data quickly

o Use Remove Duplicates to clean up your dataset

o Convert Text to Columns to split cell content based on delimiters

o Check for errors using Error Checking and Evaluate Formula

March 20: Logical and Lookup Functions

1. Use IF statements for decision-making in formulas

2. Combine logic using AND, OR, NOT

3. Handle errors using IFERROR() or IFNA()

4. Search and retrieve data using VLOOKUP, HLOOKUP, and XLOOKUP

11
Intermediate Report

5. Use INDEX + MATCH combo for more flexible lookups

March 21: Charts and Visualization

o Create basic charts: Column, Line, Pie, Bar

o Customize chart elements (title, labels, colors, legends)

o Use Sparklines to show trends in a single cell

o Add data labels, gridlines, and trendlines for better understanding

o Format charts dynamically based on changes in the dataset

March 22-23: Holidays

Week 6:(Mar 24- Mar 30):

March 24: Tables and Named Ranges

o Convert data into an Excel Table for structured formatting

o Use structured references (like =Table1[Sales]) in formulas

o Apply filters, banded rows, and automatic expansion in tables

o Name specific cells or ranges using Named Ranges

o Use named ranges in formulas for clarity and easy editing

March 25: PivotTables and PivotCharts

o Create PivotTables to summarize large datasets

o Drag and drop fields to Rows, Columns, Values, and Filters

o Group and filter data inside PivotTables for better analysis

o Use PivotCharts to visualize PivotTable summaries

o Add Slicers and Timelines for interactive filtering

March 26: Data Analysis Tools

o Use Goal Seek to find the input needed for a specific result

o Run What-If Analysis to explore different scenarios

12
Intermediate Report

o Save and compare multiple outcomes using Scenario Manager

o Install and use the Solver Add-in for complex optimization

o Analyze sensitivity and trends through Data Tables

March 27: Advanced Functions

o Text functions: LEFT, RIGHT, MID, LEN, TEXT, CONCAT

o Search functions: FIND, SEARCH, SUBSTITUTE, REPLACE

o Date functions: TODAY(), NOW(), DATEDIF(), EOMONTH()

o Financial functions: PMT, FV, NPV, IRR

o Information functions: ISERROR, ISNUMBER, ISTEXT

March 28: Power Query and Power Pivot

o Use Power Query to clean, transform, and load data

o Combine data from multiple sources (e.g., Excel, web, databases)

o Apply transformations: merge, split, pivot/unpivot, filter

o Use Power Pivot to create data models with relationships

o Write DAX (Data Analysis Expressions) formulas for calculated fields

March 29-30: Holidays

Week 7 (Mar 31- Apr 6):

April 31: Holiday

April 01: Advanced Charting

o Combo charts (e.g., line + column)

o Secondary axis usage

o Dynamic charts using dropdowns (with OFFSET or named ranges)

o Chart templates and custom formatting

April 02: Array Formulas & Dynamic Arrays

13
Intermediate Report

 Traditional array formulas with CTRL+SHIFT+ENTER

 New dynamic array functions (Excel 365+):

o FILTER()

o SORT()

o UNIQUE()

o SEQUENCE()

o LET()

o LAMBDA()

April 03: Importing & Connecting Data

 Importing data from:

o CSV, XML, JSON

o SQL Server / Access / web data

 Power Query (Get & Transform) for cleaning and shaping data

April 04: Power Pivot & Data Modeling

o Creating relationships between multiple tables

o Using DAX (Data Analysis Expressions)

o Building complex data models for dashboards

April 05-06 : Holidays

Week 08:(Apr 07-Apr 13)

Dashboard Design

 Interactive elements using:

o Form controls (drop-downs, sliders, buttons)

o Slicers

14
Intermediate Report

o PivotCharts and KPIs

 Best practices for visual storytelling

Week 09:(Apr 14-Apr 20)

Dashboard Design

 Interactive elements using:

o Form controls (drop-downs, sliders, buttons)

o Slicers

o PivotCharts and KPIs

 Best practices for visual storytelling

Week 10:(Apr 21-Apr 27)

April 21: Macros and VBA (Visual Basic for Applications)

o Recording macros

o Writing basic VBA scripts

o Automating tasks and creating user-defined functions

April 22: Security and Protection

o Worksheet/workbook protection

o Locking/unlocking cells

o Password encryption

o Hiding formulas

April 23: Collaboration and Sharing

o Co-authoring and shared workbooks (especially in Office 365)

o Commenting and notes

o Version history and change tracking

April 24: Excel Online and Mobile Integration

15
Intermediate Report

 Using Excel on the web or mobile devices

 Syncing with OneDrive or SharePoint

April 25-27: Integration with Other Tools

 Linking Excel with:

o Microsoft Power BI

o Word / PowerPoint (live data linking)

o Outlook (mail merge, data exports)

o Access or other databases

Week 11:(Apr 28-May 06)

Advances classes of power bi and projects.

4. Challenges faced and solutions


o Challenge:Incomplete or Missing Data
Solution: Applied data cleaning techniques such as imputation, removal of null
values, and cross-referencing with alternate sources to ensure dataset reliability.
o Challenge: Difficulty in Choosing the Right Visualization
Solution: Explored multiple chart types using Power BI and Matplotlib to determine
the most effective way to communicate insights clearly to non-technical stakeholders.
o Challenge: Managing Large Datasets and Performance Issues
Solution: Used efficient data manipulation techniques with Pandas and SQL; filtered
unnecessary data early in the pipeline to reduce processing time and improve
performance.

16
Intermediate Report

5. Key Learnings and Outcomes


o Improved Technical Skills: Gained hands-on experience with tools like Excel, SQL,
Python, and Power BI for data cleaning, analysis, and visualization.
o Analytical Thinking: Developed a structured approach to problem-solving by
interpreting data trends and translating them into actionable insights.
o Understanding Business Context: Learned to align data analysis with business
objectives and present findings in a clear, stakeholder-friendly format.
o Data Handling Proficiency: Acquired skills in managing, preprocessing, and
transforming large datasets for meaningful analysis.
o Communication Skills: Improved ability to present complex data in simple visual
formats and explain insights to both technical and non-technical audiences.

17

You might also like