TechSci Research Data Associate Interview Questions and Answers

Three sections are there 1) Aptitude Test 2) SQL 3) DSA

Q1. What is DSA , sorting , difference between array and linked list
Ans. 
DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.
• DSA stands for Data Structures and Algorithms

• Sorting is the process of arranging data in a particular order

• Arra...read more
Answered by AI
Add your answer
Q2. Written a SQL query
Add your answer

Q1. Coding question like add numbers
Add your answer
Q2. Experience on your project
Ans. 
I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.
• Developed predictive models to forecast customer behavior and optimize marketing strategies

• Conducted market research to identify trends and opportunities for growth

• Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns
Answered by AI
Add your answer

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. Questions related to BI tools like PowerBI and Tableau , writing few dax for specific scenario. Then few theory questions in SQL followed by 3-4 not so queries. At last discussion on cloud technology,answe...read more
Add your answer

Q1. Basics of power bi and sql
Add your answer
Q2. What are joins and types of join
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of 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 table

• FULL JOIN...read more
Answered by AI
Add your answer
Q3. How to add date table in power bi
Ans. 
To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.
• Create a new table in Power BI with a list of dates

• Add columns for day, month, year, etc. for additional analysis

• Establish relationships between the date table and other tables in the data model
Answered by AI
Add your answer

Q1. Sql scenario based question on joins
Add your answer
Q2. Window function questions
Add your answer
Q3. Performance tuning
Add your answer
Q4. Power bi dax question
Add your answer

Q1. Hr asked me basics details like Role and responsibilities, About overall experience, About notice period, About Current CTC and ectc.
Add your answer

Hr round+ assessment+manager round

Q1. They asked about work experience And role & responsibility and apart from that they asked case study Formula from Excel and some questions from power bi and 2 questions from sql
Add your answer

Q1. They negotiated salary
Add your answer

Q1. How good are you with numbers
Add your answer

Q1. Vlookup, pivot table, sumif, average, graphs
Add your answer

Q1. Do you know the role and responsibility of this position
Add your answer

It was eassy so don't worry.

Q1. They ask about previous projects which i have worked and question relted that, they some scenario based question was there.
Add your answer

Q1. What is the number of tourist per day in jaipur
Ans. 
The number of tourists per day in Jaipur varies depending on the season and events happening in the city.
• Tourist numbers fluctuate based on time of year (peak season vs off-peak season)

• Events like festivals or cultural events can attract more tourists

• Historical sites like Amer Fort and Hawa Mahal are popular attractions

• Tourist numbers can be estimated based on hotel occupancy rates and ticket sales for attractions
Answered by AI
Add your answer