Fractal Analytics Business Intelligence Consultant Interview Questions and Answers

Q1. Questions about SQL
Add your answer
Q2. Questions about python dataframes
Add your answer
Q3. Difference between random forest and decision tree
Ans. 
Random forest is an ensemble learning method using multiple decision trees to improve accuracy and reduce overfitting.
• Random forest uses multiple decision trees to make predictions.

• Decision tree is a single tree structure used for classification and regression.

• Random forest reduces overfitting by averaging the predictions of multiple trees.

• Decision tree can be prone to overfitting if not pruned properly.

• Random forest i...read more
Answered by AI
Add your answer

Python coding and sql coding

Q1. List all the string which start with 'a'
Ans. 
List of strings starting with 'a'
• Use a loop to iterate through each string

• Check if each string starts with 'a'

• Add the string to the list if it starts with 'a'
Answered by AI
Add your answer
Q2. Find out max value from the given table
Ans. 
Use SQL query to find max value from a table
• Use SQL query SELECT MAX(column_name) FROM table_name;

• For example, SELECT MAX(salary) FROM employees;

• Ensure proper column name and table name are used in the query
Answered by AI
Add your answer

Basic python sql questions, mcq based and coding questions.

Q1. They asked the projects which I am working on and had discussion on the same. Asked few statistical questions like boxplots and normal distribution. Also asked basic questions on advance SQL
Add your answer

Q1. Problem solving questions. Gave a case study to check presence of mind
Add your answer

Q1. Basic salary discussion
Add your answer

Python sql basic questions