AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Everest Fleet Interview Questions and Answers for Freshers
Everest Fleet Interview Experiences for Freshers
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Aug 2023. There were 3 interview rounds.
(1 Question)
- Q1. First was Hr round, where he asked about myself, my experience, salary expectations, current salary.
(3 Questions)
- Q1. Then the second round was with Arun Sir, who has asked advanced excel formulas, advanced google sheets formulas, SQL basics. And later told that will let you know, but haven't updated yet.
- Q2. Dcount function ABS function Excel remove minus sign from integer using a formula.
- Ans.
Dcount function counts the number of unique values in a dataset. ABS function returns the absolute value of a number. To remove minus sign from an integer in Excel, use a formula like =ABS(A1).
Dcount function counts unique values in a dataset
ABS function returns absolute value of a number
To remove minus sign from an integer in Excel, use formula like =ABS(A1)
- Q3. Filters Transfer data from 1 sheet to other Join , inner, outer, self, left right Along with the syntax Colene function in SQL Show top value show values between a date range Sumifs countifs
- Ans.
Answering questions related to data filtering, transferring, joining, and SQL functions for a Data Analyst role.
To transfer data from one sheet to another, you can use functions like VLOOKUP or INDEX/MATCH in Excel.
Different types of joins in SQL include INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN, and SELF JOIN.
Syntax for INNER JOIN: SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Synta...
Interview Preparation Tips
- Power Bi
- SQL
- Advanced Excel
Skills evaluated in this interview
Data Analyst Interview Questions asked at other Companies
Jobs at Everest Fleet
Top trending discussions
Interview questions from similar companies
Selected
I applied via Referral and was interviewed before Jun 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Explain Joins in SQL?
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column between them
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
...
- Q2. What is Normalisation?
- Ans.
Normalisation is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalisation involves breaking down data into smaller, more manageable tables
It helps in reducing data redundancy by storing data in a structured way
It improves data integrity by ensuring that each piece of data is stored in only one place
Normalization is usually done in multiple stages (1NF, 2NF, 3NF, etc.) t...
Questions mostly revolved around pandas and numpy.
Interview Preparation Tips
- SQL
- Pandas
Skills evaluated in this interview
Test duration of 1 hour based on probability and control statements
(2 Questions)
- Q1. Ml algorithms that you have prior knowledge about
- Ans.
I have prior knowledge about various machine learning algorithms.
Linear Regression
Logistic Regression
Decision Trees
Random Forests
Support Vector Machines
Naive Bayes
K-Nearest Neighbors
Gradient Boosting
Neural Networks
- Q2. Data visualization techniques you have studied and used
- Ans.
I have studied and used various data visualization techniques including bar charts, line graphs, scatter plots, and heat maps.
I have experience creating bar charts to compare data across categories
I have used line graphs to show trends over time
I have created scatter plots to identify correlations between variables
I have used heat maps to visualize data density and identify patterns
Interview Preparation Tips
Skills evaluated in this interview
Selected
Sql test in Hackerrank
(1 Question)
- Q1. Questions on SQL was asked
(1 Question)
- Q1. Managerial round. I was asked questions on case study for captain acquisition
It was easy consisting of sql and excel questions
I applied via Campus Placement and was interviewed before Aug 2022. There were 3 interview rounds.
The aptitude questions were bit easy and there were questions about SQL, and also excel sheets.
(1 Question)
- Q1. Questions about sql
Interview Preparation Tips
- SQL
- Excel
Selected
I applied via LinkedIn and was interviewed before Feb 2023. There were 4 interview rounds.
Approx 30 questions which are to be solved in 1 hour. Questions include logical and mathematical questions along with basic ML and stats questions
(1 Question)
- Q1. Basic questions related to Python and SQL
(1 Question)
- Q1. Advance SQL questions and 1 case study
(1 Question)
- Q1. Basic ML questions and Business acumen questions
Selected
I applied via Approached by Company and was interviewed before Jun 2023. There were 3 interview rounds.
It was basic MCQ related to Javascript
(1 Question)
- Q1. Asked basic questions related to array and SQL
(1 Question)
- Q1. Asked question to test the business context
Basic Apititude Questions
(2 Questions)
- Q1. Difference between WHERE and HAVING??
- Ans.
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
WHERE is used with SELECT statement to filter rows based on a condition
HAVING is used with GROUP BY statement to filter groups based on a condition
WHERE is applied before data is grouped, HAVING is applied after data is grouped
Example: SELECT * FROM table WHERE column = 'value'
Example: SELECT column, COUNT(*) FROM table GROUP B
- Q2. Where- Row Level Filters Having-Aggregate Filters
- Ans.
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
Row level filters are used to filter individual rows of data before any aggregations are performed.
Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.
Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...
(2 Questions)
- Q1. Why do you wanna join Uber?
- Q2. Best Company Ever
Interview Preparation Tips
Skills evaluated in this interview
I applied via Referral and was interviewed before Jul 2023. There were 2 interview rounds.
It was about common analytics concepts
(2 Questions)
- Q1. How many red cars estimate in bangalore
- Ans.
It is impossible to accurately estimate the number of red cars in Bangalore without specific data.
Estimating the number of red cars in Bangalore would require access to vehicle registration data, which is not readily available.
Factors such as the total number of cars in Bangalore, the percentage of red cars among them, and the distribution of red cars across the city would need to be considered.
One could potentially co...
- Q2. What will be approach to estimate next year revenue
- Ans.
To estimate next year revenue, I would analyze historical data, market trends, and potential growth opportunities.
Analyze historical revenue data to identify patterns and trends
Consider market trends and economic indicators that may impact revenue
Evaluate potential growth opportunities such as new product launches or market expansions
Use forecasting techniques such as regression analysis or time series analysis
Consult ...
Everest Fleet Interview FAQs
Some of the top questions asked at the Everest Fleet interview for freshers -
The duration of Everest Fleet interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Everest Fleet Interviews By Designations
- Everest Fleet Data Analyst Interview Questions
- Everest Fleet Onboarding Executive Interview Questions
- Everest Fleet Customer Support Executive Interview Questions
- Everest Fleet Manager Interview Questions
- Everest Fleet Relationship Manager Interview Questions
- Everest Fleet Customer Support Associate Interview Questions
- Everest Fleet Sourcing Executive Interview Questions
- Everest Fleet CAR Driver Interview Questions
- Show more
Interview Questions for Popular Designations
Everest Fleet Interview Process for Freshers
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Everest Fleet Reviews and Ratings
based on 148 reviews
Rating in categories
|
Relationship Manager
46
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Data Analyst
40
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Driver
30
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager Operations
19
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Operations Manager
16
salaries
| ₹0 L/yr - ₹0 L/yr |
Ola Cabs
Uber
Meru cabs
Zoomcar
- Home >
- Interviews >
- Everest Fleet Interview Questions >
- Everest Fleet Interview Questions for Fresher
