Brigade Group Senior Data Analyst Interview Questions and Answers

Q1. What are joins and its types?
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 ...read more
Answered by AI
Add your answer
Q2. What are aggregate functions?
Ans. 
Aggregate functions are functions in databases that perform a calculation on a set of values and return a single value.
• Aggregate functions are used to perform operations on a group of rows and return a single result.

• Common aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• For example, SUM function calculates the total of a column, AVG calculates the average, COUNT counts the number of rows, MIN finds the minimu
Answered by AI
Add your answer

Q1. Coding questions in python eda part
Add your answer

Q1. Where do u see in next 5 years
Add your answer

Q1. About previous projects.
Add your answer

Q1. Salary negotiations.
Add your answer

Dressing and personality

Q1. Site questions and finishing work
Add your answer

Q1. Structure work going on at site
Ans. 
The structure work at the site involves the construction of a new building using steel beams and concrete columns.
• Steel beams are being used for the framework of the building

• Concrete columns are being installed to support the structure

• The construction process includes pouring concrete, welding steel beams, and erecting walls
Answered by AI
Add your answer
Q2. Survey related questions
Add your answer
Q3. Planning related
Add your answer
Q4. About Relocation nearby site
Add your answer
Q5. Manage site works
Ans. 
Managing site works involves overseeing construction activities, coordinating with contractors, ensuring safety regulations are followed, and meeting project deadlines.
• Coordinate with contractors and subcontractors to ensure work is completed on time and within budget

• Monitor progress of construction activities and address any issues that may arise

• Ensure compliance with safety regulations and quality standards

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

Q1. Related to QA/QC and IS standards
Add your answer