Landmark Group Data Analyst Interview Questions and Answers

Q1. Average totals for last 3 months
Add your answer
Q2. Running totals in a year using dax
Ans. 
Running totals in a year using DAX
• Use the DAX function CALCULATE to create running totals

• Use the FILTER function to specify the date range for the running total

• Example: CALCULATE(SUM(Sales[Amount]), FILTER(ALL('Date'[Date]), 'Date'[Date] <= MAX('Date'[Date])))
Answered by AI
Add your answer

Write a a python code to reverse string without slicing.

Pandas, python, SQL based questions

Q1. Pandas, python, sql, business case study and logical reasoning
Add your answer

Q1. Find top 3 students in a class
Ans. 
Identify the top 3 students based on their grades in a class.
• Calculate the average grade for each student

• Sort the students based on their average grades in descending order

• Select the top 3 students
Answered by AI
View 1 more answer

Guesstimate questions

Q1. Directors ask behavioural questions
Add your answer

SQL questions
Window functions
Joins
Self joins

Q1. P value explanation
Ans. 
P value is a statistical measure that helps determine the significance of results in hypothesis testing.
• P value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.

• A small P value (typically ≤ 0.05) indicates strong evidence against the null hypothesis, leading to its rejection.

• A large P value (> 0.05) suggests weak evidence against the null hypothesis, leadi...read more
Answered by AI
Add your answer
Q2. Statistical modeling questions
Add your answer

Q1. Salary discussion
Add your answer

Basic SQL and tableau questions

Q1. How do you work in a team?
Add your answer

Medium SQL, Statistics ,Guesstimate round

Supply and demand price increase, decrease related case study

Domain knowledge and SQL

10 sql and 10 python questions