Celonis Consultant Interview Questions and Answers

Consisted of MCQs on Python and SQL

Q1. Based on job experience
Add your answer

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

Case study on different aspects of analytics

Medium to difficult level

Q1. -----------SQL BASED
Add your answer
Q2. ------EXPERIENCE BASED
Add your answer

Q1. Culture fit check
Add your answer
Q2. Behavioral questions
Add your answer

Q1. Pandas based basic Data Manipulation Tasks
Add your answer
Q2. Handling Jsons in python
Ans. 
Python provides built-in libraries like json to handle JSON data easily.
• Use json module to load and parse JSON data

• Use json.dumps() to convert Python objects into JSON strings

• Use json.loads() to convert JSON strings into Python objects
Answered by AI
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

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

Q1. I was provided with a Marketing Mix Model problem statement and I have to provide the complete solution in excel and powerpoint presentation. In first round, The Question were all around my previous projec...read more
Add your answer
Q2. What is adstock, decay, Due tos Contributions? How do you evaluate the model? What is seasonality and the formula for seasonality? Do seasonality have any contribution?
Ans. 
Explanation of adstock, decay, Due tos Contributions, seasonality and its formula.
• Adstock is the measure of the lasting impact of advertising on consumer behavior.

• Decay refers to the reduction in the effectiveness of advertising over time.

• Due tos Contributions is the attribution of sales to different marketing channels.

• Seasonality is the pattern of sales or other metrics that repeat over a fixed period of time.

• The form...read more
Answered by AI
Add your answer

Q1. Second round was improvement on the model provided by me as the solution for MMM question. Technical questions were more on reasoning for the variables selected and understanding of the concepts of MMM. L...read more
Add your answer

Q1. Salary Discussion and stuff related to that
Add your answer