A

SUMMER INTERSHIP PROJECT REPORT

ON

“A Study On Big Data Analytics Of the company

In Customer Service Using SQL”
At
Company name

SUBMITTED BY

Student name

To

SAVITRIBAI PHULE PUNE UNIVERSITY, PUNE

IN PARTIAL FULFILLMENT OF THE REQUIREMENT FOR THE

AWARD OF THE DEGREE OF
MASTER OF BUSINESS ADMINISTRATION

THROUGH

MBA DEPARTMENT
College name
(2022-24

ACKNOWLEDGEMENT
 INDEX

Chapter
Particulars Page No
No

Acknowledgement
Declaration
Certificate From The College
Certificate from The Organization

Company Guide Feedback Letter

Executive Summary
1. Introduction

2. Company Profile

3. Research Methodology

4. Literature Review

5. Data Analysis and Interpretation

6. Conclusion

7. Learning From SIP

8. Contribution to the Host Organisation

9. References

10. Annexure
 Executive summary
Pratik Tourism - Our business is of travels as it says. We provide luxury
cars by rent to customer as per there need. Washed and completely clean
car, including news paper & water bottles is provided. As a travels we
provide cars for companies, family trips, Airport pickup-drop, functions,
meetings, etc.
As we get an opportunity to serve, internally we intend to create and
nurture a healthy, respectful, and enjoyable environment. We focus more
on quality over anything.
Rates do vary as per packages. We provide cars for outstation as well as
for local use.
Pratik Travels is established by 2002. As compared to before there’s a
decent growth in business. Propreitor of business is Mr. Sadashiv Patil. As
of experience, its 20+ year now.
Assistant Director is Ms. Yogada Patil. She is managing account department
and business analysis.
Today business environment is changing rapidly with increasing turbulence
and uncertainty. Companies are under pressure to seek new strategies and
to make quick decision to overcome changes. As the rate of changes
increases, so does the need for fast and immediate response, which implies
higher flexibility. Such condition increase the importance of providing better
service to the customer and to take their feedback to improve your service.
Providing better service help the company to gain acceptance in the market
as well as increase the brand value which also help to make their employees
in a better manner. It also provides opportunity to companies to improves
in areas where they are lacking behind.
The purpose of undertaking of this project was to compare and measure
the service of both the cab service provider Pratik tourism through the
facilities and satisfaction they are providing to the customer and the factors
affecting the choice of both of them.
Concluding, the summary my project finding were respondents are satisfied
with service of Pratik tourism still better and they are providing better
service in term of cost effectiveness, timeliness, communication, reliability,
and expression and attitude. And people are attracted toward the feature
of these cab service providers of tracking the driver and traceability of
driver and safety and they booking Pratik Tourism late night travel and
business travel. The limitation were the sample size because of limited
region study.
By carrying out this analysis, we are able to understand the how we can
use the various tools clearly and accurately so that it can helps the company
in their growth and by the analysis how we can generate the various
insights that helps in the various decisions making so that it helps in
improving the services that is provided by the company.
By this project , we can bale to get knowledge about R Programmimg Language
and software and also we get knowledge of how R software working and uses of
this software for various purposes and in the analysis of the data so that we can
generate

the various insights from that data that can be useful for various purposes and in
the various decisions making that helps in improving the services of the company.

From this projects we are able to understand how the analysis of the company can
be done using various tools and softwares so that we can get key insights about
various things.

While working in the Pratik tourism company , we can able to understand the
which skills one`s should have to survive in this competitive world and for getting
the good job.
 Chapter 01

INTRODUCTION
The travel industry is the big business in the modern world and travel
agencies make up an important part of the industry. As well as able to
access details about hundreds of package holidays, flights,
accommodations and excursions, travel agencies have the expert
knowledge to put all of this information into plain English to help their
customers find and book a holidays to suit them or a travel agency is a
private retailer or public service that provides tourism related services to
the public on behalf of suppliers such as airlines, car lines, hotels, railways,
and package tours.
There are many different types of travel agencies (travel agents), including
holiday travel agents, such as going places and first choice, which help
customers, choose and book their summer family holidays, group ski break
or city sightseeing tour. But other specialist travel agencies are also
available, such as business travel agents, which help businesses and
business people plan and book their conference, flights and foreign
business travel, and location specialists, who will offer expert advice, great
deals and a reliable booking service for certain location in the world,
including Australia travel agents, Caribbean travel agents and India travel
agents.

In addition to all this there are independent travel agencies, such as trail
finders and co-op travel, and many of these specialize in certain types of
holidays, such as booking round the world trips for students heading off on
a gap year, and travel agents who only book cruises travel agencies are
trained to give advice on destinations worldwide and make arrangements
for transportation, hotel accommodation, car rental and sightseeing tours,
as well organizing travel insurance or your holiday and advising you on
customs regulations, required papers, such as passports and visas, and
currency exchange rates.
In recent years there has been a huge increase in the number of online
travel agencies, but online travel agencies sometimes struggle to compete
with airlines and hotels which have also taken a more direct approach to
winning customers by using the internet and no longer rely on the travel
agency to fill their aero planes and hotels. However, you will still find that
whether you use a high street travel agencies or an online travel agencies,
they will have expert knowledge on booking holidays and will be able to
organize the entire holiday package at once, without you having to speak
to airlines, hotels, tourism, companies, car rental firms, etc., personally.
Data analytics is important to recoding data for any new innovation idea in
future. Fit for any the reasons for existing also outlined particularly to work
inside. Data analytics will be undertaking which key of part in creating
electronic tools. This project will a chance to be formed in place will provide
an incorporated answer
For 22 years Travels has been providing an unrivalled full spectrum of
business and leisure travel service that our satisfied customers will certainly
attest to. We pride ourselves in offering world class service in the regions
we operate. Our well experienced consultants offer clients with most
economical practical and convenient travel solutions.
Travels was incorporated on 02 Feb 2000 and has received numerous
awards and recognitions since date. We have established a reputation in
the industry for having strong and long lasting relationships with both our
suppliers and clients.

All India Permitted licensing

In many state, all travel agencies are required to be licensed by the All India
permit license (AITP) All India Tourist Permit.

The Function of a modern travel agency

A retail travel agency provides necessary travel information to the general
public. The intending tourists come to the office of the travel agent and
seek information regarding their proposed visit.
The travel agent should be a very knowledgeable man and should supply
up to date and concrete information relating to travel.
He must have great communication skill and he should be through in the
art of catching the potential customers. The knowledge of foreign
language is a desirable qualification for those working in a travel agency.
Preparation of itineraries
Liaison with Providers of service
Planning and costing tours
Ticketing
Insurance

Business Background
Present Business analytics need to changes your practical knowledge &
goal. As use recording details in the bill book, voucher & note book in use
manual. Also it required of labor work is utilized time & there is no
appropriate work. That time not easy to handle business recorded because
no recording business need, expenses, sale, purchase etc. and no
calculating annual turnover. These work is not effective for this business.
When you choose future idea & technology to best way achievement
business goal.

Strategies
Strategy 1:- Concentrate less paper work. By changing the current SQL to
a brought together software for easy to work
Strategy 2:- our make more other company type of new offer base.

Scope
This system helps the user to identify the positive, neutral and negative
sentiments.

Infrastructure
Big data analytics in customer service, you’ll need scalable data collection,
storage, and processing systems, real time processing, machine learning
capabilities, data visualization tools, strong security measures, and
integration with existing systems.

Objective
-To study explores how SQL- based big data analytics in customer service enhance customer
satisfaction & optimizes support processes.
-To study utilize SQL databases or big data solutions like hadoop for efficient storage &
management of big data.
-Employ SQL queries to transform & clean the data preparing it for analysis.
 Chapter 02

Organizational Profile

We believe the industry must focus on a business and distribution model

that always puts the customer at the center and produces great products.
However, to deliver an outstanding travel experience, the strength, skills,
and resources of all partners in the value chain must be respected and
understood. At Pratik Travel we believe the industry can achieve this goal
by focusing on a business model that combines customer insight with great
product and, most importantly, places the travels experience at its core. At
our core we aim to enable the above by valuing impartiality, independent
thought, openness and cooperation. We hope that these qualities allow us
to foster dialogue, guide business decisions, build partnerships and conduct
thorough research directly with the industry. These principles have guided
us since 2004 and will continue to keep us at the forefront of the industry
as a vibrant travel community for many more years to come. Our Services
Our events are the heart of Pratik Travel.

Vision & Mission

Mission:-
Pratik Travels Agency is committed to providing our clients with exceptional service a
complete end to end booking solution covering all aspects of your travel needs tailored in
house at an affordable prize with pro-active customer service.

Vision:-
To be leaders of multi-national travel management in the region and our clients’ best partner,
always providing the best possible product, with the highest quality of services, and
demonstrating faithfully our commitment towards social and environmental responsibility.

After that Improvement

Innovation and technology in travel agency business-Travel agencies are focusing on more
personalized and empathetic interactions with customers. In the new normal, people are
looking for personalized service along with convenience of technology. There is a large
opportunity to empower agents and small travel firms with best priced inventory, websites,
digital payments and other tools.

Accounting & Financial

Management have also evolved with the integration of software that helps in efficient
tracking of expenses, revenue, and profitability. Automation has simplified these processes
and reduced the likelihood of errors.

Travels Packages & Deals:-

1.)Travels Packages
A).Car Rental Agencies: Pratik Travels car rental companies offer various packages and
deals. These can include discounts for booking in advance, weekend specials, or long-term
rental discounts.

B).Online Travel Agencies: Websites like Girikand and IVY Pvy Ltd. often have partnerships
with car rental agencies and offer package deals that car rental for additional savings.

C).Credit Card Benefits: Some credit cards offer rental car insurance and discounts as a
cardholder benefit. Check your credit card terms to see if you have any such perks.

2.)Deals
A).Book in Advance: Generally, booking your rental car well in advance can result in lower
prices compared to last-minute bookings.

B).Join Loyalty Programs: Many rental car companies have loyalty programs that offer
discounts and benefits to members. Sign up for these programs to access exclusive deals
and earn rewards.
Pratik Travels By the Number

70000+ Database contact

100000+ Monthly online Reach

200+ Car holding capacity

200+ Night Halt Charges providing

Customer relationship management (CRM)

System have become essential tools for travel agencies to manage their interactions to
manage their interactions with clients, track inquiries, and maintain a database of customer
preferences. This aids in delivering a more personalized experience and building long-term
relationships.
Overall, these improvement in Technology, behavior, management, accounting, and
customer relations have contributed to a more efficient, customer-centric, and competitive
travel agency industry.

Future Vision
Since 2000 is business started that time is very trouble situation. Go to that situation
different things analysis. Cost measurement, quotation, packaging cost, expenses, losses,
need material, man power, equipment, related document etc.
We are focusing business on our customer what need & what can I do customer. The
customer demanded a price offer & travelling for the need. But don’t focus only on that.
You have to recognize the customer which offers affordable for customer.

Future Facilities
- Official Websites
- Best price to other compare
- Benefits
- Expanded Business
- Driver allowance /Night halt Charges for better services
- Panic Button Facilities
- GPS button system

Clients/Customer
- Wipro pvt. ltd
- Star Union Dai-chi Life Insurance Company Limited
- TCS
- Income Tax
- Infosys
- Hindustan Unilever (HUL)
- Tata Telecom

Type company
- IVY Tours & Travels
- Girikand Pvt. ltd
- Raj Tours
- K.K Travels
- Neeta Travels
 Chapter 3

Research Method
Research is a process of systematic inquiry that entails collections of data; documentation of
critical information and analysis and interpretation of that data/information, in accordance
with suitable methodologies set by specific professional field and academic disciplines. In
this article the role of My SQL is discussed in research.

Research Methodology
The data can be collected in two ways that is primary and secondary data, the primary data
consists of collecting data directly from customers through questionnaire, interviews,
observation and other methods. The other type of data collection is secondary data, in this
method the data is collected through journals, magazines and other types of sources. In this
research secondary data is considered for the study.
The data is collected through secondary sources like journals, magazines, online resources
available etc.

Data Research
Most research can be divided into three different categories; exploratory, descriptive and
casual. Each serves a different end purpose and can only be used in certain ways.
A).Exploratory research
Exploratory research is defined as a research used to investigate a problem which is not clearly
defined. It is conducted to have a better understanding of the existing problem, but will not
provide conclusive results. For such a research, a researcher starts with a general idea and
uses this research as a medium to identify issues that can be the focus for future research.
Collecting information on a previously unexploratory topic can be challenging. Exploratory
research can help you narrow down you topic and formulate a clear hypothesis and problem
statement, as well as giving you the “Lay of the Land” on your topic.
Survey methodology
Focus groups
interview
3.1).Data Collection:
A).Primary Data :
Primary data are surveys, observations, questionnaires, focus group, case study and interview
as highlighted
Primary data collection was carried out through direct interactions with Pratik tourism’s
internal stakeholders. This involved the acquisition of financial records, operational reports,
marketing campaign data, and customer feedback. To delve into the intricate details of the
company’s cost structure and operational practices, structured interviews were conducted
with key personnel from various departments, including finance, operations, and marketing.
During the interviews, specific questions were tailored to elicit information related to the
company’s major cost centers, allocation of resources, marketing strategies, and revenue
streams. Additionally, qualitative insights were gathered on challenges faced by the
organization in term of cost management, operational efficiency, and customer satisfaction.
Questionnaire given to respondents .
Respondents:-120
Respondents: https://forms.gle/CBJVAGqdK7eUA42c9

B).Secondary data:
The secondary data collection process involved sourcing information from diverse external
sources. Industry reports, scholarly articles and market research databases were consulted to
gain a broader perspective on the tourism industry’s financial landscape, industry
benchmarks, and emerging trends. Financial statements and reports from other companies
operating with in the tourism sector were analyzed to establish benchmarks for performance
comparison.

• Website
• Online Journals
• Published Report
• Company Report
• Financial Statement

:
3.2). Business analytics
Business analytics is the process of collecting sorting, processing, and studying business data
and using statistical models.
Data for Business Analytics
Business Analytics utilizes big data, statistical analysis, & data visualization to implement
organization changes, predictive analytics is an important aspect of this work as it involves
available data to create statistical models. These models can be used to predict outcomes and
inform decision making. Conduct data mining (explore data to find new patterns and
relationships) complete statistical analysis and quantitative analysis to explain why certain
results occur. Test previous decisions using A/B testing and multivariate testing. Make use of
predictive modeling and predictive analytics to forecast future results.

A).Data Analysis
Qualitative analysis in the travel agency industry often requires continuous monitoring and
adjustment to meet changing customer preferences and industry dynamics. It's essential to combine
qualitative analysis with quantitative data, such as revenue, costs, and market share, for a
comprehensive understanding of the agency's performance and potential areas for improvement. To
extract meaningful insights from the qualitative data, text mining techniques were applied using SQL
language.

3.3).Future Predictive Analysis

A).Real-time Analytics: Real time analytics are data collected and reported on in-the-
moment, or in real time. An example of this might be that an ecommerce store owner could
witness a sale coming through the owner’s website as it happens.
B).Big data: With huge chunks of historical data available in conjunction with real-time cloud
data drawn from a tremendous user base, big data is groundbreaking in its ability to move
the evolution of business analytics forward.
C).Predictive analytics: Based on past trends, predictive analytics looks to big data collected
over time to predict future actions.

3.4).Period Of Study :
The duration of study is from August 2023 to Octomber 2023 which is a three months of
study.
3.5). Accessibility:
Accessibility data will significantly help organization foster productivity and bring value to
businesses. With accessibility, user have the ability to copy,move,modify or retrieve data from
IT system from any location in an authenticated manner.

3.6). Ethical Considerations :

Throughout the research process, ethical considerations were paramount. To ensure the
confidentiality of sensitive financial and operational data, all information was handled in strict
accordance with established ethical guidelines. Additionally, in the case of customer feedback
analysis, all data was anonymized
 Chapter 4

Literature Review

1) Title : “Cost of Implementation”.

Publication Year : 2017

Author : Todd H. Wagner, Ties Hoomans

This study the literature cost of implementation Identify the costs

associated with implementing sustainable tourism practices, such as
infrastructure upgrades, training, and marketing.

2) Title : “Technology and Tourism”.

Publication Year : 2020

Author: Hassan & Sharma

This study review the literature Technology and tourism Discuss the
impact of technology on tourism, including online booking
platforms, virtual reality, and augmented reality in enhancing the
tourist experience.

3) Title: “Quantitative Data and Analysis”.

Publication Year: 2019

Author : Donal J. Treiman

The study review the literature Quantitative data and analysis

Present quantitative data on economic gains and losses,
environmental impacts, and other relevant metrics.
Use cost benefit analysis techniques to calculate the net benefits of
sustainable tourism.
4) Title : “Environment Costs and Benefits”.
Publication Year : 2014

Author : David A. Fennell

The study review the literature Environment cost and benefits

Analyze the direct and indirect economic benefits of sustainable
tourism, including revenue generation, job creation and increased
local business opportunities.

5) Title : “Future Prospects in tourism”.

Publication Year : 2016

Author : Pro Pralok Gupta

This study reviews the literature on Future prospects Speculate on

the future of sustainable tourism, considering factors like evolving
consumer preferences, technological advancements, and global
environmental challenges.

6) Title : “Cost Benefit Analysis of Tourism

Infrastructure project”.

Publication Year : 2015

Author : Luis A.R. De Albuquerque and Joao F.M Neto.

This study reviews the literature on cost-benefit analysis of tourism

infrastructure project. It finds that there is a lack of consensus on
the best way to conduct CBA for tourism infrastructure projects.

7) Title : " The Environmental Impacts of Tourism "

Publication Year : 2019.

Author : David Weaver .

 This study reviews the literature on the environmental impacts of
tourism. It finds that tourism can have a significant negative impact
on the environment, but that there are a number of ways to overcome
this impacts.

8) Title : “Marketing and Promotion Strategies”.

Publication Year : 2021
Author : Phillp Kotler
This study reviews the literature on the marketing and promotion
strategies Research investigates marketing strategies employed by
travel agencies, including digital marketing, social media, and the
use of user-generated content to attract customers.

9) Title: “Sustainability in Travel Agencies”.

Publication Year:- 1987.

Author:- E Hazarhun.

This study reviews the literature on the Sustainability in travel

agencies There is a growing focus on sustainability and responsible
tourism in the travel industry. Studies examine how travel agencies
are adopting eco-friendly practices and promoting sustainable
travel.

10) Title : “Consumer Behavior and Travel Agency

Selection”.

Publication Year:- 2018

Author:- Leon Schiffman and Leslie Kanuk

This study reviews the literature on the Research investigates the

decision-making processes of travelers when choosing a travel
agency, as well as the influence of online reviews and word-of-mouth
recommendations.
11) Title : " Tourism and Sustainable Development "

Publication Year : 2015

Author : David B. Weaver

This study reviews the literature on tourism and sustainable

development. It finds that tourism can be a force for sustainable
development, but that it is important to manage tourism in a way that
minimizes its negative impacts.

12) Title : “Impact of External Factors”.

Publication Year : 1983
Author : G.D. Sardana
This study reviews the literature on Studies may examine how
external factors, such as economic conditions, geopolitical events, or
changes in regulations, affect the travel agency industry.
 Chapter 5

Data Analysis & Interpretation

Different mathematical forms like pie chart, histogram, camparison graph

etc. The loaded
Data is explored and analysed in ways such that to attain objective. This
part includes the actual representation of data.
Visual force is part based system for the pg admin 4. The system
incorporates a tag-based like SQL.
In the fiercely competitive travel landscape, data analytics can be a
game-changer. It allows travel companies to delve into vast oceans of
data, from booking trends to traveller perferences, to optimize various
aspects of their operations and services. With big data in tourism, travel
busiensses can not only predict and meet customer demands effectively
but also identify opportunities for improvement and innovation.
Data analysis is a systematic process of examining, cleansing,
transforming, and modeling data to uncover meaningful patterns,
relationships, and insights. It is a fundamental step in extracting
knowledge from raw data and plays an important role in various fields
such as business, science, and research. The process typically begins with
data collection, where relevant data is gathered from multiple sources to
ensure its accuracy and completeness.
Once the data is collected, the next step is data cleaning. Here, errors,
discrepancies, and missing values in the data set are identified and
corrected. This step is essential to ensure data quality and reliability.
After data cleaning, exploratory data analysis (EDA) is performed to gain
a deeper understanding of the dataset. Descriptive statistics and
visualizations such as histograms and scatterplots are used to examine
distributions and patterns in data
Data transformation is another important aspect of data analysis. This
includes preparing data for analysis by standardizing units, normalizing
values, or coding categorical variables as appropriate. Once your data is
in the right format, you can apply a variety of data modeling techniques.
These techniques include statistical techniques such as regression
analysis, machine learning algorithms, and time series analysis,
depending on the type of data and purpose of the analysis.
Hypothesis testing can be used when you need to clarify a particular
question or hypothesis. Tests are performed to assess the significance of
relationships or differences in the data. Furthermore, pattern recognition
is extremely important in data analysis because it allows you to identify
meaningful trends, correlations, or anomalies within a data set.
Once data analysis is complete, the next step is data interpretation. Data
interpretation is about understanding the results of your analysis. This
includes providing context for results, summarizing key findings, and
comparing results to benchmarks or industry standards to assess
significance. It is important to identify trends and patterns in the data,
and these patterns need to be explained in terms of their relevance and
impact.
To effectively interpret data, you need to use visualization tools such as
charts, graphs, and tables to present results clearly and easily.
Communicating interpreted data and insights to stakeholders is a critical
final step to ensure that knowledge gained from data analysis is
incorporated into decisions, strategies, and actions. Overall, data analysis
and interpretation is an essential part of a data-driven decision-making
process, allowing organizations and individuals to derive valuable insights
from their data.

There different vendor available for RDBMS. Most common and

most used ones are:
• Oracle (Oracle Corporation)
• Microsoft SQL Server (Microsoft)
• My SQL (Oracle Corporation)
• PostgreSQL (PostgreSQL Global Development Group)
• SQLite (Developed by D. Richard Hipp)
The Customer Table has Customer number (empno), Customer name
(ename),
Column Aliases and concatenation
In above output, that the column name is the same as the database field
or the expression you select. Sometimes, while generating reports you
want to give your own names to headers. This can be done using aliases.
Conditional Operators

Operator meaning
= Equal to
!=OR<> Not Equal to
> Greater Than
>= Greater than and equal to
< Less than
<= Less than and equal to
Between. And Allows to define range between
100 and 500
In (Value1, Value2,) Match to any of the items in list
Is Null Return
Like Match given pattern

Logical Conditional Operators

Operator Meaning
And Return True if all conditions are
true
Or Return true if any one of the
conditions is true
Not Return true if conditions is false
 1. To study explores how SQL based big data analytics in customer
service enhance customer satisfaction & optimizes support
processes.

The data type of the columns may vary from on data base to another. For
example NUMBER is supported in Pgadmin database for integer value
whereas INT is supported in MYSQL.
‘CREATE TABLE’
The create table command is a part of the data definition language, a
sub-language of sql that enables the creation and modification of the
structures of database objects. This command allows us to create and
define the structure of tables.
Create table_name( column 1 data type, Column 2 data type, column 3 );
Create employee table
 Amount
110
120
90
100
Employee Name

80
70
80 60
50
60
30
40
20
0
Aman Rahul Rakesh Mohan Rupesh Akshay Rushik
esh
Amount 60 30 110 70 80 90 50
Month Payment

Interpretation :- he SQL code is a representation of how a "Customer" table might be created

in a database, and sample customer data is inserted into this table.

The table structure includes columns for customer information, and each INSERT INTO
statement adds a new customer record to the table.
This SQL code can be executed in a database management system to create the table and
populate it with sample data. You can later modify and expand this table with real customer
information as needed.
Que.: Age of the Respondents :
Sr.No Particulars No. Of Respondents Percentage

1 15 to 20 16 13

2 20 to 30 36 30.3

3 30 to 40 28 23.7

4 40 to 50 18 15

5 50 - above 22 18

Chart Title

40 36
30.3
28
30 23.7 22
Axis Title

16 18 18
20 13 15

10 3 4 5
10 20 0 0 0
0
1 2 3 4 5
Sr.No 1 2 3 4 5
Particulars 0 0 0 0 0
No. Of Respondents 16 36 28 18 22
Percentage 13 30.3 23.7 15 18
Axis Title

Sr.No Particulars No. Of Respondents Percentage

Interpretation :- From the above table it is interpreted that the number of respondents
between 15 to 20 age of respondents are 13 %, between 20 to 30 age of respondents are 30.3 %,
between 30 to 40 age of respondents are 23.7 %, between 40 to 50 age of respondents are 15 %, 50
above age of respondents are 18 %.

Que. Gender Of the Respondents :

 Sr.No Particular No.of Respondent Percentage%

1 Male 46 39

2 Female 74 61

Total 120 100.00

Particular
100%
90%
80% 39 61 100
70%
Percentage

60%
50%
40%
30% 46 74 120
20%
10%
0% 0 0
1 2 Total
Percentage% 39 61 100
No.of Respondent 46 74 120
Particular 0 0
Respondent

Particular No.of Respondent Percentage%

Interpretation - From the above table it is interpreted that the number of respondents of
Male are 39 % and Females are 61 % .

Que. Have you ever interacted with a customer service department ?

Sr.No. Particulars No. of Percentage %

Respondents
1 Online Search 60 50%

2 Social Media 15 12.5%

 3 Referral from 30 25%
friends/Family
4 Advertisement 15 12.5%

Sr.No.
1
10% 2
3
40% 20% 4
5
6
7

30% 8
9

Que. Are you familiar with SQL

Sr. No Particular Are you familiar Percentage %

with SQL
1 Yes 55 65%

2 No 35 25%

3 Maybe 10 10%
 Chart Title
60 55 70%
65%
50 60%
40 35 50%
Axis Title

Axis Title
40%
30
30%
20 25%
10 20%
10 1 0 2 0 3 0 10% 10%
0 0%
1 2 3
Sr.No 1 2 3
Particular 0 0 0
Are you familiar with SQL 55 35 10
Percentage % 65% 25% 10%
Axis Title

Sr.No Particular Are you familiar with SQL Percentage %

Interpretation - From the above table it is interpreted that the number of

respondents Yes are 65 % and for No are 25 % or Maybe are 10%.

Que - Did you feel that the benefit (e.g., convenience, confort, support)
of using the products of the company outweighed the costs ?
Sr. No Particular No of Respondents Percentage %
1 Yes 65 75%

2 No 25 25%

3 Maybe 5 1%

Chart Title

1%
Percentage % 25%
75%

5
No of Respondes 25
65

0
Particular 0
0

3
Sr. No 2
1

0 10 20 30 40 50 60 70

Series5 Series3 Series1

Interpretation:- From the above table it is interpreted that the number of respondents
Yes are 75 % and for No are 25 % or maybe 1%.

2. To study utilize SQL databases or bigdata solutions like hadoop for efficient
storage & management of bigdata.

Que Did you comfort travel packages and deals to be competitive and
good value for money ?
Sr. No Particular No of Respondents Percentage %
1 Yes 120 85%

2 No 55 25%

3 Maybe 0 0%

Chart Title

140
120 85%

100
Axis Title

80
60 120 25%
40 55
20
0
1 0
2 0%
0
3
0
1 2 3 4 5 6
Axis Title

Sr. No Particular No of Respondes Percentage %

Interpretation:- From the above table it is interpreted that the number of respondents Yes
are 75 % and for No are 25 % or maybe 1%.
Que - How likely are you to recommend the company to a friend or
family member ?

Sr.No. Scale range No. of Respondents Percentage

1 1 0 0
2 2 0 0
3 3 0 0
4 4 12 5
5 5 0 0
6 6 33 12
7 7 24 9
8 8 25 10

Chart Title
35 33

30
2425
25
Axis Title

20
15 12 12
8 8 9 10
10 67 67
5 5 5
5 34 34
12 12 000 0 000 0
0
Sr.No. Scale range No. of Respondents Percentge
Axis Title

Series1 Series2 Series3 Series4 Series5 Series6 Series7 Series8

Interpretation :- From the above table it is interpreted that the number of respondents
which says that they are satisfied with the quality of the services , the respondants which
gives 6 scale are 12 % , for 7 are 9 % , for 8 are 10 %.

Que. In a recent trip, which destinations did you visit using our services
?
Sr. No Particular No. of respondents Percentage
1 Excellent 22 26%
2 Good 15 8%
3 No 13 5%
 Chart Title

30
Axis Title

20
10 Series3

Axis Title
0 Series2
Sr. No
Particular Series1
No. of
respondents Percentage

Axis Title

0-10 10-20 20-30

Interpretation :- From the above table it is interpreted that the number of respondents
who responded Excellent are26 % and for good are 8 % or No 5%.

Que - How satisfied were you with the accommodations provided

during your trip (e.g., hotel, resort, airbnb) ?
Sr.No Particular No of respondents Percentage
1 1 0 0
2 2 0 0
3 3 28 55%
4 4 24 25%

Chart Title
30

25

20

15

10

0
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5

Series1 Series2 Series3 Series4

Interpretation :- From the above table it is interpreted that the number of respondents
which says that they are satisfied with the quality of the services , the respondants which
gives 3 scale are 55 % , for 4 are 25 %.
Interpretation :-
Hadoop is a powerful framework for handling and analyzing large
datasets. It's used for tasks like processing historical data, analyzing
streaming data in real-time, storing massive datasets, preparing data for
analysis, training machine learning models, and more. It's particularly
valuable in scenarios where data volumes are large and varied. Hadoop's
versatility makes it applicable in various fields, from genomics and social
network analysis to log processing and content indexing.
From above analysis table it is interpreted that the number & analysis ms-
excel.
Hadoop is well-suited for organizations dealing with large and diverse
datasets, particularly in scenarios where data storage, processing, and
analytics are central to business operations. It's commonly used in
industries like e-commerce, finance, healthcare, and more, for a wide
range of applications, from batch processing and data warehousing to
real-time data analysis and machine learning. The decision to use Hadoop
should be based on the specific needs and goals of an organization and its
ability to manage the complexity and resource requirements of a Hadoop
ecosystem.

3. Employ SQL queries to transform & clean the data preparing it

for analysis .
 Particulars Amount (Rs.)
Current Assets 650,000/-
Current Liabilities 40,000/-
Net Profit 520,000/-
Initial Investement 20,00,000/-
Total Assets 650,000/-
Total Expenses 14,20,000/-
Total Revenue 617,000/-

Net Profit Ratio= (net profit/sales)*100

= 520000/617000*100
= 84.27%
Return on assets = net profit/total assets
= 520000/650000
= 80%
Current ratio = Current assets / current liabilities
= 650000/40000
= 16.25.
Cost benefit Ratio = Total cost/Total benefits
= 1420000/617000
=2.30
Interpretation :-
The net profit ratio is 84% and return on asstes is 80% and current ratio is 16.25 and the
cost benefit ratio is 2.30 and this ratio is more than one and company is running smoothly
 Chapter 6

Findings and Suggestions

Findings:
1. It was found that research methodology analysis can be done by the
MySQL commands apart from the existing packages like SPSS
2. MySQL consists of commands like standard deviation, correlation,
variance and other commands useful for the research methodology.
3. The data collected through research can be stored in the columns and
it can be retrieved depending on the requirement, the above said
commands can be used on the data collected for the purpose of
research methodology.
4. It was also found that the data collected cane be stored in data marts
and data warehouses and can be analysed in various ways using
MySQL commands.

Suggestions:
The MySQL used in this article is helpful in storing the huge amount of data
in the form of data warehouse, data mart, big data etc., whereas other
packages may not support huge data again it has to be stored in databases
like MySQL
One of the advantage of MySQL when compared to other packages is that
the time taken for retrieval of data is minimized because the data and the
commands are in the same location, but whereas the packages like SPSS
requires separate data management techniques.
There are several commands in MySQL which are helpful for research
methodology like standard deviation, variance and correlation. The
research will be at an advantageous position when using MySQL.
 Chapter 7

Conclusion
Travellers continue to seek authentic experiences. The tools they use to
research and book these experiences are constantly changing due to
innovations in technology. Destinations are also challenged by limited
financial resources and strong competition for tourist dollars from other
iconic and even lesser known locations. The personalisation of travel
suggests that independent travel will have a stronger presence than group
travel, however, we must always consider the type of traveller. The travel
services sector is being forced to innovate at a startling rate.

In the past, face to face consultations with a travel agent was paramount
for booking both leisure and business travel. Technology and global
circumstances, such as pandemics, financial collapses, and terrorism, have
put pressure on tourism and travel services. With the development of OTAs
and emerging and disruptive technologies, the travel services landscape is
constantly changing.

So far we have discussed the elements of the five sectors of tourism:

transportation, accommodation, food and beverage, recreation and
entertainment, and travel services. With this foundation in place, let’s delve
deeper into the industry by learning more about how these sectors are
promoted to customers on services marketing.

The tourism industry is known for being sensitive to market fluctuations,

regulatory changes and consumer preferences. To meet these challenges,
our tourism company has initiated a strategic planning process that
includes evaluating potential projects and investments. Furthermore if
some more technological advancement is done at company then the
customer base can be increased by providing better experience to the
customer. We have to do the more attractive advertisement through
various media platforms like social media, newspapers, etc.
 Chapter 8

LEARNING FROM SIP

One of the main benefits of a summer internship project is the practical

application of your knowledge. This is the moment when the concepts
learned in the classroom come to life in the professional field. For example,
marketing interns can experience first-hand how market research
influences product development and advertising strategy, while
engineering interns can apply complex theory to real-world engineering
challenges. You can learn how to. Additionally, internships often provide
opportunities to develop subject-specific skills. For example, a software
development intern may improve programming skills, while a finance intern
may become proficient in using financial analysis tools. These technical
skills will be a valuable asset not only during your internship, but also in
your future career projects.

Strategic planning is another area where analytics can make a significant

contribution. Insights gained from analytics that helps in understanding the
market trends, customer preferences or competitive advantages that
influence the development of strategic goals and objectives. This alignment
between analysis and strategy is necessary to achieve the organization's
vision.

This analysis helps in the understanding the financial condition and status
of an organisation. For example, a cost-benefit analysis can show the
financial benefits of a specific investment or project. By calculating the
potential return on investment (ROI), this analysis can influence the
financial decisions, leading to increased revenue and cost savings.

This analysis contributes to the long-term sustainability of the organization

by identifying growth opportunities and areas of risk. By considering these
factors, organizations can adapt to changing conditions and maintain their
viability over time.

One of the most important contributions an individual makes to a host

organization is their expertise and knowledge. Everyone has specific skills,
whether it's data analysis, marketing, engineering, or any other field. You
can use this expertise to solve complex problems, drive innovation, and
improve processes within your organization. By leveraging their knowledge,
individuals become valuable assets to their teams and the company as a
whole.

Collaboration and teamwork are also areas where individual contributions

can shine. Effective communication and the ability to work seamlessly with
co-workers fosters a positive and productive work environment. Individuals
actively participate in team dynamics, share ideas, and respect different
perspectives, contributing to a harmonious and efficient workplace

Leadership and mentoring play an important role in helping individuals

contribute to an organization. Those with experience and expertise often
take on the role of mentor, guiding less experienced colleagues and
fostering a culture of continuous learning. Effective leadership and
mentoring is critical to the professional development of the entire team and
contributes to the long-term success of the organization.

In summary, contributing to a host organization is a complex and dynamic

process. This includes expertise, teamwork, creativity, commitment,
leadership, and external relationships. When individuals are actively
involved in an organization, they become agents of positive change and
foster an environment of growth, innovation, and excellence. In doing so,
they not only advance their own careers, but also contribute to the overall
success and reputation of their organizations.

Effective problem solving is an important aspect of individual contribution.

When challenges arise, such as operational bottlenecks, market changes,
or customer concerns, individuals bring their analytical skills to bear. Be a
catalyst for organizational improvement by analyzing problems, identifying
root causes, and recommending practical solutions

Communication skills and influence are valuable assets in any professional

environment. Effective communication skills allow individuals to
communicate ideas, inspire colleagues, and foster collaboration.
Contributes to harmonious teamwork and achieving common goals by
building relationships and persuading others.

Commitment and dedication to the organization's mission and values are

important aspects of contribution. By aligning personal goals with the
organization's mission, individuals become more motivated and more
invested in their work. This commitment leads to improved performance,
better customer service, and overall job satisfaction.

Effective resources allocation is an essential factor for the business success.

Analysis helps resources allocation and ensures that resources are allocated
to projects and initiatives that have the high potential to achieve positive
results. This efficient allocation maximizes the organization's ability to
achieve its goals within budget constraints.

This analysis contributes to the long-term sustainability of the organization

by identifying growth opportunities and areas of risk. By considering these
factors, organizations can adapt to changing conditions and maintain their
viability over time
 Chapter 9

Contribution to the Host Organisation

One of the most important contributions is that the ability to make
informed decisions. Data-driven analytics can provides a valuable insights
to decision makers. By presenting clear, evidence-based results, analytics
can help leaders to choose strategies, allocate resources, and set
priorities with more confidence.

This analysis helps in the understanding the financial condition and status
of an organisation. For example, a cost-benefit analysis can show the
financial benefits of a specific investment or project. By calculating the
potential return on investment (ROI), this analysis can influence the
financial decisions, leading to increased revenue and cost savings.

Effective resources allocation is an essential factor for the business success.

Analysis helps resources allocation and ensures that resources are allocated
to projects and initiatives that have the high potential to achieve positive
results. This efficient allocation maximizes the organization's ability to
achieve its goals within budget constraints.

Contribution to a host organization is a central aspect of any professional

endeavor. When people join an organization, whether they're employees,
interns, or consultants, they bring unique skills, experiences, and
perspectives that can have a significant impact on an organization's success
and growth.

Collaboration and teamwork are also areas where individual contributions

can shine. Effective communication and the ability to work seamlessly with
co-workers fosters a positive and productive work environment. Individuals
actively participate in team dynamics, share ideas, and respect different
perspectives, contributing to a harmonious and efficient workplace.

Commitment and dedication to the organization's mission and values are

important aspects of contribution. By aligning personal goals with the
organization's mission, individuals become more motivated and more
invested in their work. This commitment leads to improved performance,
better customer service, and overall job satisfaction.

Leadership and mentoring play an important role in helping individuals

contribute to an organization. Those with experience and expertise often
take on the role of mentor, guiding less experienced colleagues and
fostering a culture of continuous learning. Effective leadership and
mentoring is critical to the professional development of the entire team and
contributes to the long-term success of the organization.

In summary, contributing to a host organization is a complex and dynamic

process. This includes expertise, teamwork, creativity, commitment,
leadership, and external relationships. When individuals are actively
involved in an organization, they become agents of positive change and
foster an environment of growth, innovation, and excellence. In doing so,
they not only advance their own careers, but also contribute to the overall
success and reputation of their organizations.

Additionally, individuals often bring new insights and creativity to the

organization. Their unique experience and perspective can lead to
innovative solutions and fresh approaches to long-standing challenges. By
fostering a culture of creativity and openness employees can contribute to
the development of new products, services, or strategies.
 Chapter 10

References
1). https://www.techtarget.com/searchbusinessanalytics/definition/big-data-
analytics
2). https://www.tableau.com/learn/articles/big-data-analytics
3). https://www.coursera.org/in/articles/big-data-analytics
4). https://www.simplilearn.com/what-is-big-data-analytics-article
5). https://www.altexsoft.com/blog/big-data-analytics-explained/
6). https://www.javatpoint.com/big-data-technologies
7). https://www.knowledgehut.com/blog/big-data/big-data-technologies
8). https://www.edureka.co/blog/top-big-data-technologies/
9). https://www.datamation.com/big-data/big-data-technologies/
10). https://www.analytixlabs.co.in/blog/big-data-technologies/
 Chapter 11

Annexure