Exponentia.ai Senior Consultant Interview Questions and Answers

Q1. Datawarehouse Concepts
Add your answer
Q2. ETL Scenarios , pipeline management
Add your answer

Q1. General Project level understanding
Add your answer

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

It was related to a Food & Beverage Industry Data

SQL + Python test. 8 questions. Need to get 5 correct at least. Moderate difficulty.

Q1. Questions on profile background and details of projects delivered
Add your answer

Q1. 3 to 5 year goals
Ans. 
To become a recognized expert in the field of consulting and contribute to the growth and success of the organization.
• Obtain advanced certifications in consulting methodologies

• Lead and successfully deliver complex consulting projects

• Develop strong relationships with clients and become a trusted advisor

• Mentor and guide junior consultants to help them grow professionally

• Contribute to thought leadership by publishing arti
Answered by AI
Add your answer
Q2. Preferred mode of working
Ans. 
I prefer working in a collaborative environment that encourages open communication and feedback.
• I enjoy working in a team where everyone's ideas are valued and considered.

• I appreciate a work culture that fosters open communication and encourages feedback.

• I am comfortable working independently as well, but I believe that collaboration leads to better results.

• I am adaptable and can work in different modes depending on th...read more
Answered by AI
Add your answer
Q3. Background about fractal
Add your answer

Q1. Questions related to SAP BW and HANA
Add your answer

Q1. Questions related to SAP BW and HANA
Add your answer

Q1. Reason for Job Change
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