Niva Bupa Health Insurance Company Data Analyst Interview Questions and Answers

Candidates preparing for aptitude tests should practice all the topics related to quantitative aptitude as they all are of equal importance but the most important ones are:
Time, Speed, and distance.
Permutation and combination.
Speed and distance.
Percentage.
Number.
Ratio and Proportion.
Profit and Loss

As soon as you click on Log In button you will be shown the details of the exam name, programming exam name, Start date, End date Total number of questions Total duration associated with exam you can click on Proceed button to proceed ahead.

As soon as you click on Proceed button you will be shown the details of the exam your name, your Roll number. You need to confirm that your name and Roll number is valid. Then you can click on Confirm button to proceed.

3. Exam questions and coding text area would be shown to you during the exam

Question has got various information attributes

Problem Statement : it would provide you the detailed description

Example : It would provide example of the program code

Functional Description: It would provide functional details of the code to be written

Returns: It would provide details of expected output of the code (what code should return after execution)

Coding Exam Question
4. Coding area has been provided to type program.

online coding test code typing area
5.You can click on Run button under test cases section to execute the program. If there is compile time error then system would show you errors in your code. You need to fix compiler errors and then again click on Run. As soon as your test cases get executed system would show it as Success or Failure.

A case study is a self-contained story about how a real customer overcame their problems using your products or services. Notice how I used the word story. Marketers are obsessed with the notion of “storytelling” (usually without actually telling stories), but a good case study is a story with protagonist (your customer) who has a problem but who wins out in the end.

Excel typing speed
Ms word

Q1. What is joins in SQL?
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
Answered by AI
Add your answer

Q1. How do you maintain your work life balance?
Add your answer

Q1. What do you know about Co.?
Add your answer
Q2. What type of insurance are included in General Insurance?
Ans. 
General Insurance includes various types of non-life insurance policies.
• Types of insurance included in General Insurance are property insurance, liability insurance, motor insurance, travel insurance, home insurance, marine insurance, etc.

• Property insurance covers damage or loss of property due to fire, theft, etc.

• Liability insurance covers legal liabilities arising due to injury or damage caused to a third party.

• Motor...read more
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer

Number series
Simplification

Questions based on Python & SQL

Case study round was good and interactive

Q1. Type of sql Joints
Ans. 
SQL Joins are used to combine rows from two or more tables based on a related column between them.
• Types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left tab...read more
Answered by AI
Add your answer
Q2. Write DAX for create data modeling on inactive relationship?
Ans. 
Use DAX to create data modeling on inactive relationship in Power BI.
• Use USERELATIONSHIP function to create an inactive relationship between two tables.

• Specify the relationship between the tables and the columns to be used in the relationship.

• Use CALCULATE function along with USERELATIONSHIP to perform calculations using the inactive relationship.
Answered by AI
Add your answer

Duration - 60 Minutes
Topic - Advance DAX, Joints using DAX, all except all