Exusia 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