Randstad Data Analyst Interview Questions and Answers

Q1. Joins and null value handling
Add your answer
Q2. Tableau server in depth
Ans. 
Tableau Server is a business intelligence tool that allows organizations to share and collaborate on data visualizations.
• Tableau Server is a platform for sharing and distributing Tableau workbooks and dashboards.

• It allows users to access and interact with visualizations through a web browser.

• Administrators can manage permissions, schedules, and data sources on Tableau Server.

• Tableau Server can be integrated with other ...read more
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a highly skilled and experienced Business Analyst with a strong background in data analysis and problem-solving.
• Over 5 years of experience in analyzing business processes and identifying areas for improvement

• Proficient in gathering and documenting requirements from stakeholders

• Expertise in data analysis and using tools such as SQL and Excel

• Strong communication and presentation skills, able to effectively convey co...read more
Answered by AI
Add your answer

Scenario based questions

Q1. SQL,Excel, power bi
Add your answer

Q1. Project related to resume
Add your answer

Logical reasoning, aptitude

Q1. Projects of last companies
Ans. 
I have worked on various projects in my previous companies, ranging from system implementations to process improvements.
• Led a team in implementing a new CRM system to improve customer relationship management

• Analyzed data to identify bottlenecks in the supply chain and proposed solutions for optimization

• Collaborated with cross-functional teams to streamline communication processes and increase efficiency
Answered by AI
Add your answer
Q2. Financial analysis
Add your answer
Q3. MS Excel main fuctions
Add your answer

Aptitude test based on RS Agarwal and similar numerical types

Q1. Reverse a link list and reverse a string
Ans. 
Reverse a linked list and reverse a string
• To reverse a linked list, iterate through the list and change the pointers to reverse the order

• To reverse a string, use a loop to iterate through the characters and build a new string in reverse order

• Example: Linked list 1->2->3->4 can be reversed to 4->3->2->1

• Example: String 'hello' can be reversed to 'olleh'
Answered by AI
Add your answer
Q2. Check for weighted sum
Ans. 
The question is asking to calculate the weighted sum of a set of values.
• Calculate the product of each value with its corresponding weight

• Sum up all the products to get the weighted sum

• Example: Values [2, 3, 4] with weights [0.5, 0.3, 0.2] would result in (2*0.5) + (3*0.3) + (4*0.2) = 1 + 0.9 + 0.8 = 2.7
Answered by AI
Add your answer