Edureka Research Analyst Interview Questions and Answers

Q1. Subject knowledge
Add your answer

Q1. Salary negotiation
Add your answer

Q1. What is DAX and its use in power bi
Ans. 
DAX (Data Analysis Expressions) is a formula language used in Power BI for data modeling and analysis.
• DAX is used to create calculated columns and measures in Power BI.

• It allows for advanced data analysis, such as time intelligence functions (e.g., YEAR, MONTH).

• Example: A measure to calculate total sales could be defined as: Total Sales = SUM(Sales[Amount]).

• DAX supports filtering and context manipulation, enabling dyna...read more
Answered by AI
Add your answer
Q2. Role of power query in power bi
Add your answer

Q1. Introduction about yourself
Add your answer
Q2. Work experience details
Add your answer

Was asked to prepare a financial model woth given assumptions

Q1. About yourself and work experience
Add your answer

Q1. Interview by CFO of the company
Add your answer
Q2. It was more about work experience
Add your answer

Coding test around front end using react

Round duration - 120 minutes
Round difficulty - Easy

It was a mix of mathematical aptitude, logical ability, and puzzles along with 2 programming questions of easy and medium level. Time was enough and no sectional time was present. 1-2 MCQs on SQL were also present.

This round was immediately followed by an SHL aptitude test which was basically a quick limited time check of your verbal ability and math because many questions were to be done in 1 hour.

Q1. 
Boolean Matrix Transformation Challenge
Given a 2-dimensional boolean matrix mat of size N x M, your task is to modify the matrix such that if any element is 1, set its entire row and column to 1. Specifi...read more
Ans. 
Modify a boolean matrix such that if any element is 1, set its entire row and column to 1.
• Iterate through the matrix and mark rows and columns to be modified

• Use additional arrays to keep track of rows and columns to be modified

• Update the matrix in-place based on the marked rows and columns
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

It was an online video interview round on HackerEarth with simultaneous code option. It was mostly justifying your resume in the first 15 minutes. After that OOPS was majorly asked. Basics of programming including questions on STL were asked. A class which required inheritance was asked by the interviewer to write. I was helped by the interviewer if i got stuck somewhere, Some questions on implementation of hashmaps and priority queues were also asked. A puzzle was asked which luckily struct to me at that moment.

Q1. Sales process and team handling
Add your answer
Q2. Calls till demo and closure
Add your answer

Q1. Sales process and team handling
Add your answer
Q2. Calls till closure and weekly achievement
Add your answer

Q1. Question on Binary trees: if symmetric, easy string question using hashmap
Add your answer
Q2. If we are hosting a live test how to show real time ranking, HLD for this and what algorithms can we use
Add your answer

Q1. Database schema design for a feature where user can be free, gold, platinum.
Ans. 
Use a user table with a column for user type (free, gold, platinum)
• Create a user table with columns for user ID, name, email, user type

• Use a separate table for user types with columns for type ID and type name

• Establish a one-to-many relationship between user and user type tables

• Example: user table - user_id, name, email, type_id; user_type table - type_id, type_name
Answered by AI
Add your answer

Q1. HLD for live rank dashboard for a live test where millions of users are doing test
Ans. 
High-level design for a live rank dashboard for a live test with millions of users.
• Use a scalable architecture to handle millions of users concurrently.

• Implement real-time data processing to update ranks dynamically.

• Utilize caching mechanisms to improve performance and reduce load on the database.

• Design a user-friendly interface with intuitive data visualization.

• Include features for filtering, sorting, and searching to
Answered by AI
Add your answer