Barclays Senior Data Analyst Interview Questions and Answers

Q1. No of atm machines in your locality. Basic statistics questions and CPC based questions
Add your answer

Q1. Work experience driven questions
Add your answer

Q1. Explain different type of SQL query?
Add your answer

Easy on cyber security

Q1. Introduce yourself this is
Add your answer
Q2. What is your work experience
Add your answer

Q1. Tell me about your self
Add your answer
Q2. SQL basics
Add your answer
Q3. Banking terms
Add your answer

Q1. What is data analyst
Ans. 
A data analyst is a professional who collects, processes, and analyzes data to provide insights and support decision-making.
• Collects data from various sources

• Cleans and processes data to ensure accuracy

• Analyzes data using statistical methods and tools

• Interprets data to identify trends and patterns

• Presents findings and recommendations to stakeholders
Answered by AI
Add your answer
Q2. Asked question regarding project mention
Add your answer

Q1. Sas proc format
Add your answer
Q2. How have you debug macros
Ans. 
I have debugged macros by reviewing code, checking for errors, using print statements, and stepping through code.
• Reviewing the macro code line by line to identify any syntax errors or logical mistakes

• Using print statements to output variable values and check for unexpected results

• Stepping through the code using a debugger tool to track the flow of execution and pinpoint issues

• Testing the macro with different inputs to
Answered by AI
Add your answer
Q3. How big data handled by you
Ans. 
I handle big data by using advanced analytics tools and techniques to extract valuable insights.
• Utilize data visualization tools like Tableau or Power BI to analyze and present data

• Use programming languages like Python or R for data manipulation and statistical analysis

• Implement machine learning algorithms to uncover patterns and trends in large datasets

• Leverage cloud computing platforms like AWS or Google Cloud for sc...read more
Answered by AI
Add your answer

Q1. Automation done
Add your answer

Basic python ,sql questions

Q1. What is list,tuple,set,dict comprehension
Ans. 
List, tuple, set, and dict comprehensions are concise ways to create these data structures in Python.
• List comprehension: [x for x in range(10)]

• Tuple comprehension does not exist in Python, as tuples are immutable.

• Set comprehension: {x for x in range(10)}

• Dict comprehension: {x: x**2 for x in range(10)}
Answered by AI
Add your answer
Q2. What is Dax query
Ans. 
DAX (Data Analysis Expressions) is a formula language used in Power BI, Excel, and other Microsoft tools for data analysis.
• DAX is used to create custom calculations, measures, and columns in data models.

• It is similar to Excel formulas but optimized for data analysis.

• DAX functions can be used to manipulate and analyze data in Power BI reports.

• Examples of DAX functions include SUM, AVERAGE, CALCULATE, and RELATED.
Answered by AI
Add your answer