AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
DecisionTree Analytics Data Analyst Interview Questions, Process, and Tips
Top DecisionTree Analytics Data Analyst 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?
- Q2. write a query to retrive all the employee names who have joined in last 30 days
- Q3. what are joins expalin different joins
DecisionTree Analytics Data Analyst Interview Experiences
2 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
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
Interview questions from similar companies
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:
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 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.....................
(1 Question)
- Q1. All basic concepts of pthon sql and ml
Apptitude, tecncal, cognitiive
I applied via Campus Placement and was interviewed in Nov 2023. There were 4 interview rounds.
Blood Relations, Pipes and Cisterns, Time and work etc.
Question based on hashmap
Is Artificial Intelligence boon or ban.
(2 Questions)
- Q1. Python and SQL questions
- Q2. Python and Numpy, Pandas
Interview Preparation Tips
I applied via LinkedIn and was interviewed before Oct 2021. There were 3 interview rounds.
8 python coding
With 2 aptitude
Game based assessment.
More than 8 games need to play
(2 Questions)
- Q1. Questions from python and also from SQL. SQL is must to place LatentView. Some projects related questions
- Q2. How many joins are in SQL what is lamda function in python Difference between tuples and list
- Ans.
Answering questions related to SQL joins, lambda function in Python, and difference between tuples and lists.
There are four types of joins in SQL: inner join, left join, right join, and full outer join.
Lambda function is an anonymous function in Python that can take any number of arguments, but can only have one expression.
Tuples are immutable and ordered collections of elements, while lists are mutable and ordered col...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Nov 2022. There were 5 interview rounds.
Get questions from all topics and medium level questions
They give one topic and provide one minute for thinking its overall 30 min discussion
(2 Questions)
- Q1. Total technical rounds 1)basic resume questions, python and sql questions. 2)same round 1 but a little bit extra dose 3) managerial round
- Q2. List, tuple, oops concept. joins from sql
(1 Question)
- Q1. Why latent view why analytics best achivemnts
- Ans.
Latent view and analytics are essential for data-driven decision making. My best achievement is developing a predictive model for customer churn.
Latent view helps to uncover hidden patterns and insights in data that are not immediately apparent.
Analytics provides a systematic approach to analyzing data and extracting meaningful insights.
My best achievement is developing a predictive model for customer churn that helped
Interview Preparation Tips
Selected
I applied via Campus Placement
It was easy to approach!
Discussions about common topics like boon or bane to society
Asked about the scenarios
(1 Question)
- Q1. Technical round related to skills and resume
(1 Question)
- Q1. Discussions regarding work culture and compensations
DecisionTree Analytics Interview FAQs
Some of the top questions asked at the DecisionTree Analytics Data Analyst interview -
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
DecisionTree Analytics Data Analyst Interview Process
based on 2 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
DecisionTree Analytics Data Analyst Reviews and Ratings
based on 6 reviews
Rating in categories
|
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 >
- DecisionTree Analytics Data Analyst Interview Questions
