Tiger Analytics Interview Questions, Process, and Tips

General aptitude & domain quiz

Analytics case study & ppt submission

Q1. Technical interview & presentation
Add your answer

Basic data structures, puzzles questions and statistics problems

Q1. What was your previous company project
Add your answer
Q2. What are different types of indexing
Ans. 
Different types of indexing include primary indexing, secondary indexing, clustered indexing, and non-clustered indexing.
• Primary indexing: Index based on the primary key of a table, typically implemented using a B-tree structure.

• Secondary indexing: Index based on a non-primary key column, allowing for faster retrieval of data based on that column.

• Clustered indexing: Physically reorders the table based on the indexed co...read more
Answered by AI
Add your answer
Q3. How does random forest work
Ans. 
Random forest is an ensemble learning method that builds multiple decision trees and merges their predictions.
• Random forest creates a set of decision trees from randomly selected subsets of the training data.

• Each tree in the random forest independently predicts the outcome, and the final prediction is made by averaging the predictions of all the trees.

• Random forest is effective in handling high-dimensional data and can...read more
Answered by AI
Add your answer
Q4. Explain over fitting
Ans. 
Overfitting occurs when a model learns the noise in the training data rather than the underlying pattern.
• Overfitting happens when a model is too complex and captures noise in the training data.

• It leads to poor generalization to new, unseen data.

• Regularization techniques like L1/L2 regularization can help prevent overfitting.

• Cross-validation can be used to detect and prevent overfitting.

• Example: A decision tree with too...read more
Answered by AI
Add your answer
Q5. Explain macros inExcel
Ans. 
Macros in Excel are automated sequences of commands that can be created to perform repetitive tasks.
• Macros can be recorded or written using Visual Basic for Applications (VBA)

• They can automate tasks such as formatting, data manipulation, and calculations

• Macros can be assigned to buttons or keyboard shortcuts for easy access

• They can save time and reduce errors in repetitive tasks
Answered by AI
Add your answer

It was 1 hour coding test with 2 questions. One was easy and another was medium level coding question.

Q1. Few SQL Queries
Add your answer
Q2. Explain null hypothesis and p-value in terms of probability
Ans. 
Null hypothesis is a statement that assumes no relationship or difference between variables. P-value is the probability of obtaining results as extreme as the observed data, assuming the null hypothesis is true.
• Null hypothesis is a statement that assumes no effect or relationship between variables

• P-value is the probability of obtaining results as extreme as the observed data, assuming the null hypothesis is true

• Null hy...read more
Answered by AI
Add your answer
Q3. Explain Linear and Logistic Regression
Ans. 
Linear regression is used for predicting continuous numerical values, while logistic regression is used for predicting binary categorical values.
• Linear regression models the relationship between a dependent variable and one or more independent variables using a linear equation.

• Logistic regression models the probability of a binary outcome using a logistic function.

• Linear regression is used for tasks like predicting hou...read more
Answered by AI
Add your answer

Q1. Pyspark questions
Add your answer
Q2. Rank, dense rank, row number difference
Add your answer

Q1. Project relatdd questions
Add your answer

Q1. Salary, behavioural
Add your answer