Numerator Data Analyst Interview Questions and Answers

Q1. Power BI Difference between ALL() and ALLSELECTED()
Ans. 
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
• ALL() removes all filters from the specified column or table.

• ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

• Example: ALL('Table') would remove all filters on the 'Table' in the query context.

• Example: ALLSELECTED('Column') would remove filte...read more
Answered by AI
Add your answer
Q2. Excel Difference between COUNT() and COUNTA()
Ans. 
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
• COUNT() counts only cells with numerical values.

• COUNTA() counts all non-empty cells, including text and errors.

• Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
Answered by AI
Add your answer

Q1. Resume based questions like explain the projects that you have done.
Add your answer
Q2. Sample dataset questions
Add your answer

Q1. Walk through your project?
Ans. 
Developed a predictive model to forecast sales based on historical data
• Collected and cleaned historical sales data

• Performed exploratory data analysis to identify trends and patterns

• Built and trained a machine learning model using regression techniques

• Evaluated model performance using metrics like RMSE and MAE
Answered by AI
Add your answer
Q2. Behavioral questions?
Add your answer

Q1. Questions based on Advanced Excel like Vlookup, Index match, sumifs, pivot tables
Add your answer
Q2. Behavioral questions
Add your answer

Q1. Salary negotiation
Add your answer

Q1. What are the SQL commands can you explain it
Ans. 
SQL commands are used to interact with databases to perform various operations like querying, updating, and deleting data.
• SELECT: Retrieves data from a database

• INSERT INTO: Adds new records to a table

• UPDATE: Modifies existing records in a table

• DELETE: Removes records from a table

• CREATE TABLE: Creates a new table in the database

• ALTER TABLE: Modifies an existing table structure

• DROP TABLE: Deletes a table from the databas
Answered by AI
Add your answer

SQL and python questions are very easy.

Q1. Introduce yourself
Add your answer

Medical knowledge based questions

Q1. General medical questions
Add your answer
Q2. Antidiabetics , gerd, antihypertension,gout,bones,fracture
Add your answer

Q1. Introducation salary expectation skills personality
Add your answer

Basic aptitude questions and coding questions.

Some basic data related questions, coding questions