AbsolutData Consultant Interview Questions and Answers

Q1. Questions were all related to the role i.e Market Mix Modeling . Structure of a model, types of KPI that are reported to Client ( ROI, effectiveness etc), Statistical parameters to verify model, how to fin...read more
Add your answer

Q1. Python plus SQL , machine learning,mmm
Add your answer

Case study on different aspects of analytics

Do select test

Q1. Sum and sumx in power bi
Ans. 
Sum and SumX are DAX functions used in Power BI to calculate the sum of values in a column or table.
• Sum calculates the sum of values in a column or table.

• SumX calculates the sum of an expression evaluated for each row in a table.

• Both functions can be used in measures and calculated columns.

• Example: Sum(Sales[Revenue]) calculates the total revenue for the Sales table.

• Example: SumX(Orders, [Quantity]*[Price]) calculates ...read more
Answered by AI
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. Share details of your previous job.
Add your answer

Test was very simple having 4 sql questions and 4 python questions. Total time given was 90 minutes.

Pyrhon questions was one liner code.
Sql questions was related to join, group by, where and order functions

Q1. This round lasted for 1 hour questions was related to work experience. Explain properly what all algorithms you have used and what all projects you have worked on. In last 10 minutes interviewers shown so...read more
Add your answer

Q1. This round was related to domain knowledge lasted for 15 minutes. Questions testing business sense.
Add your answer

Q1. Basic hr questions like why analytics?, any mistake you have done in past?, Any achievement?, Why fractal?
Add your answer

A technical test for whatever technical round you are applying for. Will be conceptual test rather than hard/coded test

Q1. For almost 1.5 hrs where technical questions being asked. level is easy to medium but mainly they focus on how fast are you while you stuck in a problem and your concepts
Add your answer
Q2. How can you derive (%share) in power bi
Ans. 
To derive % share in Power BI, use the 'Group By' function and create a measure using the 'Divide' function.
• Use the 'Group By' function to group the data by the desired category

• Create a measure using the 'Divide' function to calculate the percentage share

• Add the measure to a visual to display the % share

• Example: = DIVIDE(SUM(Sales[Revenue]), CALCULATE(SUM(Sales[Revenue]), ALL(Sales)))
Answered by AI
Add your answer

Q1. This was with the Project Manager to see how well you can provide solutions and interact with client.
Add your answer

Q1. Salary discussion and all
Add your answer