Decathlon 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

Q1. Python questions dataframe creata
Add your answer
Q2. SQL questions joins , windows function,cte
Add your answer

Pandas, python, SQL based questions

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

Q1. Difference between where and having clause?.
Ans. 
WHERE clause filters rows before grouping while HAVING clause filters groups after grouping.
• WHERE clause is used to filter rows based on a condition before grouping them.

• HAVING clause is used to filter groups based on a condition after grouping them.

• WHERE clause is used with SELECT, UPDATE, DELETE statements while HAVING clause is used with GROUP BY clause.

• WHERE clause is faster than HAVING clause as it filters rows be...read more
Answered by AI
Add your answer
Q2. Lead lag questions . Explain windows functions and stored procedure
Add your answer

Q1. Explain about one of your projects
Add your answer
Q2. Technical questions regarding SQL, Python
Add your answer
Q3. What is the current role in your company
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