AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
DecisionTree Analytics Interview Questions, Process, and Tips
Top DecisionTree Analytics Interview Questions and Answers
- Q1. a men fell in 50m well he climbs 4m up and slips 3 m down in a day.how many days would it take him to come out of the well?asked in Data Analyst interview
- Q2. write a query to retrive all the employee names who have joined in last 30 daysasked in Data Analyst interview
- Q3. what are joins expalin different joinsasked in Data Analyst interview
DecisionTree Analytics Interview Experiences
5 interviews found
Anonymous
I applied via Approached by Company and was interviewed in May 2024. There were 4 interview rounds.
The frist round was aptitude test where u needed 20+marks to qualify to the next level
(4 Questions)
- Q1. What is SQL ?
- Ans.
SQL is a programming language used for managing and manipulating relational databases.
SQL stands for Structured Query Language
It is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables
Common SQL commands include SELECT, INSERT, UPDATE, DELETE
Example: SELECT * FROM customers WHERE city = 'New York';
- Q2. What are joins expalin different joins
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them.
Inner Join: Returns rows when there is a match in both tables.
Left Join: Returns all rows from the left table and the matched rows from the right table.
Right Join: Returns all rows from the right table and the matched rows from the left table.
Full Outer Join: Returns all rows when there is a match in either table.
Self Join: Jo...
- Q3. Write a query to retrive all the employee names who have joined in last 30 days
- Ans.
Query to retrieve employee names who joined in last 30 days
Use the current date and subtract 30 days to get the date 30 days ago
Join the employee table with the date joined column to filter employees who joined in the last 30 days
- Q4. A men fell in 50m well he climbs 4m up and slips 3 m down in a day.how many days would it take him to come out of the well?
(2 Questions)
- Q1. Questions about joins
- Q2. Few aptitude questions
(1 Question)
- Q1. Why do you wanna join data analytics team
Interview Preparation Tips
Skills evaluated in this interview
Data Analyst Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. Puzzles were asked
- Q2. Basic sql qtns and definitions
Interview Preparation Tips
- SQL
- puzzles
Data Analyst Interview Questions asked at other Companies
(2 Questions)
- Q1. They will ask basic SQL queries and about your project and experience.
- Q2. Prepare for logical quiz questions.
Senior Data Analyst Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.
30 mins test. 15 questions. 3 sections. 1st section was basic aptitude covering topics like TSD, Percentage, 2nd section were puzzles and 3rd section comprised of Data Interpretation questions.
(1 Question)
- Q1. Started with introduction and asked me to rate myself in SQL and python 1. Basic SQL questions like difference between having and where. 2.Told to write 6-7 queries based upon that. 3. Types of joins in S...
Interview Preparation Tips
DecisionTree Analytics interview questions for popular designations
I applied via Recruitment Consulltant and was interviewed before Sep 2021. There were 5 interview rounds.
(1 Question)
- Q1. Basic questions were asked regarding sql
Aptitude plus coding test was there on a sheet of paper
(1 Question)
- Q1. Puzzles and technical.questioms were asked
(1 Question)
- Q1. This was done with the CEO
(1 Question)
- Q1. Questions related to salary expectation
Interview Preparation Tips
Senior Data Analyst Interview Questions asked at other Companies
Interview questions from similar companies
Interview Preparation Tips
Experience: The questions were of medium to high difficulty. What set this test apart was the fact that each question had different weightage ranging from 0.5 to 3 marks per question. Time was a major factor. So my strategy was to attempt all the 1 and 1.5 marks questions which constitute the major chunk of the paper in around 40 minutes and spend the remaining 20 minutes for the 2 and 3 mark questions. I did not even bother reading the 0.5 mark questions. The 2 and 3 mark questions were difficult and those will differentiate you from others. 1600 students wrote the test and only 86 got shortlisted for the next round.
Duration: 60 minutes
Total Questions: 40
Round: Technical Interview
Experience: I was asked to write a C program to print the Fibonacci sequence and a basic SQL query. Apart from this I was asked a puzzle and other questions related to my resume. Out of the 86, only 26 students were called for the next round which again was a technical interview.
Round: Technical Interview
Experience: This was similar to the first technical interview. I had to write a C program to print the prime numbers between 1 and 100 and a puzzle was asked again. Apart from this a guesstimate to find the number of cars between 2 places was asked and a scenario based question too was asked. These were followed by resume related questions.
Round: HR Interview
Experience: All the 26 students who attended the second technical round were allowed to attend HR round as well. This was just for 4 - 5 minutes. I was asked about my family background and why I should be hired. My fondest memories from school days were asked too. Finally offer letter was given to 10 students out of the 1600 who wrote the test :P
General Tips: Just keep a calm head and attempt the questions. Ask for time to think if you are not able to answer the questions immediately. Be bold and confident. That is sufficient :)
Skills: Puzzle Solving Capability, Ability To Think, SQL, C Programming
College Name: VIT Vellore
I was interviewed in Mar 2017.
Interview Questionnaire
1 Question
- Q1. Views on their recruiting process
- Ans.
I believe the recruiting process is thorough and well-organized.
The company uses a combination of resume screening, interviews, and assessments to evaluate candidates.
They have a clear timeline for the hiring process and keep candidates informed of their progress.
Feedback is provided to candidates after interviews to help them improve for future opportunities.
Interview Preparation Tips
Experience:
I applied via Naukri.com and was interviewed in Sep 2022. There were 3 interview rounds.
SQL test has been conducted nearer to 12-15 questions.
(2 Questions)
- Q1. Normal discussion, about salary negotiation
- Q2. Asked about my past company experience
Interview Preparation Tips
They have lots of opportunities.....................
I applied via Campus Placement and was interviewed in Nov 2023. There were 2 interview rounds.
It was a 3 hour test with 144 questions
(1 Question)
- Q1. Why did you select this company?
I applied via Campus Placement and was interviewed in Jul 2023. There were 5 interview rounds.
Multiple sections on cognitive ability, quant and logical reasoning.
1 coding question
Easy
50% went to next round
(3 Questions)
- Q1. Technical: SQL, DBMS, Basic programming questions- palindrome, fibonacci, discussion on projects and internships
- Q2. Difference between UNION and UNION ALL
- Ans.
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
UNION merges the results of two or more SELECT statements and removes duplicates.
UNION ALL merges the results of two or more SELECT statements without removing duplicates.
UNION is slower as it has to remove duplicates, while UNION ALL is faster.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column...
- Q3. Types of SQL commands
- Ans.
SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
SELECT: retrieves data from a database
INSERT: adds new records to a table
UPDATE: modifies existing records in a table
DELETE: removes records from a table
CREATE: creates a new table, view, or index
DROP: deletes a table or index
(1 Question)
- Q1. Common HR questions
Interview Preparation Tips
Skills evaluated in this interview
DecisionTree Analytics Interview FAQs
Some of the top questions asked at the DecisionTree Analytics interview -
Tell us how to improve this page.
Interview Questions for Popular Designations
DecisionTree Analytics Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
DecisionTree Analytics Reviews and Ratings
based on 13 reviews
Rating in categories
10-15 Yrs
Not Disclosed
|
Data Analyst
32
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Data Analyst
12
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Engineer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Lead Data Analyst
4
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Lead Presales Consultant
3
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics
- Home >
- Interviews >
- DecisionTree Analytics Interview Questions
