A

SUMMER INTERSHIP PROJECT REPORT

ON

“A Study On Big Data Analytics Of Pratik Tourism Pvt. Ltd.

In Customer Service Using SQL”
At
Pratik Tourism Pvt. Ltd.

SUBMITTED BY

Patil Prateek Sadashiv

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
MATRIX SCHOOL OF MANAGEMENT STUDIES,
PUNE-41
(2022-24
 ACKNOWLEDGEMENT
I am highly indebted to Matrix School of Management Studies for giving me
the required support in completing my project.
I would like to thank my external Guide GUIDE’S NAME OF THE COMPANY for
giving me this opportunity to do my internship project in their esteemed
organization. It has contributed immensely to my learning.
I express my profound gratitude towards our Director, Prof. (Dr) Satish S.
Ubale for giving me valuable guidance, suggestions and advice without which
this project could not have been completed.
I would also like to thank my internal Guide Prof.(Dr.) Harshali Gomase for
giving me the necessary insight into my study.

Patil Prateek Sadashiv

 DECLARATION
I, the undersigned hereby declare that this report entitled “ A Study on the use
of Big data analytics in customer Pratik Tourism Pvt.Ltd. using SQL
programming Language ” is genuine & bonafide work prepared by me under
the guidance of Prof.(Dr.) Harshali Gomase & is my original work.
The empirical findings in the report are based on the data collected by me. The
matter presented in this project is not copied from anywhere the university
authorities deem to be fit. This work has not been submitted for the award of
any diploma or degree or any other University.
This work is humbly submitted to Savitribai Phule Pune University for the
award of the Master of Business Administration.

Place:
Date:
Patil Prateek Sadashiv
 The Matrix Educational Foundation’s
Matrix School of Management Studies
S.No.9/1/5 & 9/2/4, Off Westerly Bypass Road,
Ambegaon (BK.), Pune 411041. Tel.: 020264703332/24356637

Certificate
This is to certify that the project Report entitled “ A Study on Cost Benefit
Analysis of Pratik Tourism Pvt.Ltd. using “SQL Programming language” is a
bonfide work carried out by Patil Prateek sadashiv a student of Matrix School
of Management Studies Pune, which is being submitted to the Savitribai Phule
Pune University, Pune in partial fulfillment of requirements for the award of
degree of MASTER OF BUSINESS ADMINISTRATION under my supervision and
guidance.
To the best of my knowledge and belief the work embodied in this project
report has not been submitted earlier for the award of any degree or similar
title of this or any other university or examining body.

Signature Of Director Signature of Guide

Prof. (Dr.) Satish Ubale Prof.(Dr.) Harshali Gomase

Date: / /2023
 Date:05/10/2023

TO WHOMSOEVER IT MAY CONCERN

This is to certify that Patil Prateek Sadashiv a student of Matrix School

of Management Studies has successfully completed Summer Internship
Project Report from 01-08-2023 to 01-10- 2023, in partial fulfillment of the
Degree “ Master of Business Administration”. He has completed a project
work “A Study on Big Data Analytics in customer services of Pratik Tourism
Pvt.Ltd. using SQL programming Language ” under my guidance. During the
tenure of training with us, we found him/her to be diligent and hard working.

We Wish him/her success for his/her future Endeavors.

Name of the Firm/ Company: Pratik Tourism Pvt.Ltd.

Address of the Company:

Contact details:

Name and designation of the Company Guide:

( 5- Excellent , 4- Very Good , 3- Good , 2-Satisfactory, 1- Averag

Rate the student of our institute working in your organization

Sr.No Particular 5 4 3 2 1
.
1 Obedience and relationship with seniors
2 Leadership, team spirit and initiative
3 Realtionship with the peer/subordinate
4 Wilingness to learn new techniques, adopt new idea etc.
5 Ability to use workplace equipment
6 Ability to solve workplace problem
7 Innovativeness, creativity
8 Respect for values in life
9 Learning outcomes of the SIP
10 Utility of the SIP to the Organisation
 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 Methods
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

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
110 90
80
90 70
60
Employee Name

70 50
50 30
30
10
Aman Rahul Rakesh Mohan Rupesh Akshay Rushikes
h
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
36
37.5 30.3
32.5 28
23.7 22
27.5
22.5 16 18 18
13 15
17.5
12.5 5
4
Axis Title

7.5 1 0 2 0 3
0 0 0
2.5
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

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

Particular
Q 95% ue.
85%
75% 39 61 100
65%
55%
45%
Percentage

35%
25% 46 74 120
15%
5%
0 0
1 2 Total

Particular NaN 0 NaN 0 NaN NaN NaN

No.of Respondent NaN 46 NaN 74 NaN 120 NaN
Percentage% NaN 39 NaN 61 NaN 100 NaN

Respondent

Particular No.of Respondent Percentage%

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%
Que. Are you familiar with SQL

Sr.No.

10% 1
2
3
40% 20% 4

30%

Sr. No Particular Are you familiar Percentage %

with SQL
1 Yes 55 65%

2 No 35 25%

3 Maybe 10 10%
 Chart Title
55
65% 65%
45 35 45%
25 25% 25%
10
1 0 2 0 3 0 10%
5 5%
1 2 3 1 2 3
Axis Title

Axis Title
Sr.No 1 2 3
Particular 0 0 0
Are you famil- 55 35 10
iar with SQL
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
pratik tourism pvt ltd outweighed the costs ?
Sr. No Particular No of Percentage %
Respondents
1 Yes 65 75%

2 No 25 25%

3 Maybe 5 1%

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

Chart Title
0.01
Percentage % 0.25
0.75

5
No of Respondes 25
65

0
Particular 0
0

3
Sr. No 2
1
0 10 20 30 40 50 60 70

Series3 Series2 Series1

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 Percentage %
Respondents
1 Yes 120 85%

2 No 55 25%

3 Maybe 0 0%

Chart Title
140
0.85
120
100
Axis Title

80
120 0.25
60
40 55
20
0
1 0
2 0
3
0
1 2 3
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 pratik tourism pvt ltd 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

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 %.

Chart Title
35 33
30
25 2425
Axis Title

20
15 12 12
9 10
10 78 78
4 56 4 56 5
5 3 3
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

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

20
10
Series3
Axis Title

0
Series2
o r Series1
.N ul
a ts
Sr en
rtic d g e
Pa on ta
en

Axis Title
sp rc
re Pe
. of
No
Axis Title

Series1 Series2 Series3

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.5 1 1.5 2 2.5 3 3.5 4 4.5

Series2 Series4 Series6 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 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