Work Data Analyst Interview Questions and Answers

Technica questions related to sql

Q1. Some technical questions related to sql and advance excel .
Add your answer

Q1. Some questions related to cars insurance and second cars
Add your answer

Q1. Salary discussion and some hr questions
Add your answer

A dataset was shared for analysis

Q1. What is an inactive relationship in PBI
Ans. 
An inactive relationship in Power BI is a relationship that is not being used in any visualizations or calculations.
• Inactive relationships can occur when a relationship is created but not utilized in any measures or visuals.

• These relationships do not impact the data model or query performance, but can clutter the model view.

• To remove an inactive relationship, you can delete it from the relationship view in Power BI.

• Ina...read more
Answered by AI
Add your answer
Q2. Import vs Direct Query vs Live connection
Ans. 
Import vs Direct Query vs Live connection
• Import: Data is imported into the tool for analysis, suitable for small datasets or when real-time data is not required

• Direct Query: Data is queried directly from the source in real-time, suitable for large datasets or when up-to-date data is needed

• Live connection: Data is connected live to the source, allowing for real-time updates and analysis without storing data locally
Answered by AI
Add your answer

Q1. Basic sql questions
Add your answer
Q2. Basic tableau questions
Add your answer

Q1. Questions were based on DSA and C
Add your answer
Q2. It was basically a coding round with simple logic
Add your answer

Simple assessment includes logical reasoning and general aptitude

Includes simple programs

Q1. Tell me about yourself
Add your answer
Q2. Compare strings from 2 files and store distinct strings in a different file
Ans. 
The solution compares strings from 2 files and stores distinct strings in a different file.
• Read the contents of both files into separate arrays

• Loop through the first array and check if each string is present in the second array

• If not present, add the string to a new array

• Write the contents of the new array to a different file
Answered by AI
Add your answer

Q1. DAX Related Syntax and Codes
Add your answer
Q2. Data Modelling, SQL, Python
Add your answer

Q1. No Response from HR after calling of selection after Round 1
Add your answer