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
Top trending discussions
Interview questions from similar companies
Rishu Paul
They will ask aptitude, reasoning and other questions as an online test to know your problem solving skills.
They will give a topic where either we have to speak or write on that topic
(2 Questions)
- Q1. Intro, questions related to python, guesstimate questions
- Q2. Behavorial questions and other hr questions included
Selected
I applied via Job Portal and was interviewed in Apr 2024. There were 3 interview rounds.
Critical question in maths
General topic about current situation
(1 Question)
- Q1. About ourselves and resume
(2 Questions)
- Q1. Self introduction
- Q2. Knowledge of data handling
Interview Preparation Tips
Selected
I applied via AmbitionBox and was interviewed in May 2023. There were 4 interview rounds.
Mathametics and statistics besed on the subject .
This test also i interested.
(2 Questions)
- Q1. I knlw the statistical technical skill.
- Q2. Data analysis with statistical tools
- Ans.
Data analysis involves using statistical tools to analyze and interpret data.
Statistical tools help in summarizing and visualizing data
They can be used to identify patterns, trends, and relationships in the data
Common statistical tools include regression analysis, hypothesis testing, and clustering
Statistical tools help in making data-driven decisions and predictions
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Dec 2022. There were 4 interview rounds.
(1 Question)
- Q1. Capital budgeting & cash flow statement
(2 Questions)
- Q1. Fundamentals, financial statements
- Q2. Project details, intrests
(2 Questions)
- Q1. Introduction . project
- Q2. General information , Finance knowledge
Interview Preparation Tips
I applied via Referral and was interviewed in Jan 2023. There was 1 interview round.
(2 Questions)
- Q1. What is difference between Link list and arrays 😁
- Ans.
Arrays are fixed in size and store data in contiguous memory locations, while linked lists are dynamic and store data in nodes with pointers to the next node.
Arrays have random access to elements, while linked lists require traversal to access elements.
Insertion and deletion are faster in linked lists as compared to arrays.
Arrays are better suited for small datasets with fixed size, while linked lists are better for la...
- Q2. They give suggestions to prepare more and apply after 6 months
Interview Preparation Tips
- Python
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed before May 2023. There was 1 interview round.
(1 Question)
- Q1. SQL questions mostly around CTE
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed before May 2022. There were 4 interview rounds.
(4 Questions)
- Q1. About data science basics
- Q2. About sql and basic question like 2nd highest salary
- Ans. Use sub query to get only two records and then reverse it and limit to 1 record output
- Q3. Python code for factorial
- Ans.
Python code to calculate factorial of a number.
Use a loop to iterate from 1 to the given number.
Multiply each number with the previous result.
Return the final result.
- Q4. What is recursion, list, and few more basic questions
Some random case study related to fraud analytics , like how to prevent fraud in bank. If u know certain places show high fraud numbers getting reported, wht will you do to prevent.
Answer: confirm if there is really fraud going on or some tech glitch. If yes report . Do deep dive analysis.
Find areas where high fraud frequency is found. Find its located to certain machines or shops ( if its localized ) or distributed over various shops or channels like atm, bank ,shop card swiping etc.
Once analysed either out these sources on hold until further investigation is complete.
(1 Question)
- Q1. This was basically salary Negotiation
Interview Preparation Tips
- Python
- Sql
- Data science
Be true
Be confident
Skills evaluated in this interview
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
31
salaries
|  ₹6 L/yr - ₹12.5 L/yr |
|
Senior Data Analyst
12
salaries
| ₹10.5 L/yr - ₹26.5 L/yr |
|
Data Engineer
7
salaries
| ₹7.5 L/yr - ₹10 L/yr |
|
Lead Data Analyst
4
salaries
| ₹27 L/yr - ₹33 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics
- Home >
- Interviews >
- DecisionTree Analytics Interview Questions >
- DecisionTree Analytics Data Analyst Interview Questions
