Upload Button Icon Add office photos

Filter interviews by

Barclays Global Service Centre Senior Business Intelligence Analyst Interview Questions, Process, and Tips

Updated 7 Oct 2021

Barclays Global Service Centre Senior Business Intelligence Analyst Interview Experiences

1 interview found

I applied via Referral and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

11 Questions

  • Q1. What is Live Vs Extract in Tableau? What is the file generated during extract and why is it faster than Live?
  • Ans. 

    Live vs Extract in Tableau and why Extract is faster

    • Live connection directly queries the data source while Extract creates a static snapshot of the data

    • Extracts are faster because they reduce the amount of data transferred over the network

    • Extracts can be scheduled to refresh at specific intervals

    • Extracts can be compressed to reduce file size and improve performance

  • Answered by AI
  • Q2. Is it possible to update data in Tableau Extract?
  • Ans. 

    Yes, it is possible to update data in Tableau Extract.

    • Tableau Extracts can be refreshed to update data

    • Data can be added, removed or modified in the data source and then refreshed in Tableau

    • Extracts can be set to refresh automatically or manually

  • Answered by AI
  • Q3. What is the difference between Relationships and Joins in Tableau?
  • Ans. 

    Relationships are used to connect tables in Tableau Prep while Joins are used to combine tables in Tableau Desktop.

    • Relationships are used in Tableau Prep to connect tables based on common fields.

    • Joins are used in Tableau Desktop to combine tables based on common fields.

    • Relationships are used to create a flow of data between tables in Tableau Prep.

    • Joins are used to create a single table from multiple tables in Tableau D...

  • Answered by AI
  • Q4. Question about Standard Deviation and why is it used in Tableau?
  • Q5. What are Dashboard Actions and what are the steps to apply Dashboard actions?
  • Ans. 

    Dashboard Actions are interactive elements that allow users to interact with the data on a dashboard.

    • Dashboard Actions are used to filter, highlight, or navigate to other dashboards or web pages.

    • Steps to apply Dashboard Actions include selecting the element to apply the action to, choosing the type of action, and configuring the action settings.

    • Examples of Dashboard Actions include clicking on a chart to filter the dat...

  • Answered by AI
  • Q6. How to show Top 10 and Bottom 10 Rankings in single Worksheet
  • Ans. 

    Use a parameter to filter data and create two separate tables, then combine them using a union.

    • Create a parameter to select the number of top and bottom rankings to display

    • Create a table for the top rankings using the parameter and the RANKX function

    • Create a table for the bottom rankings using the parameter and the RANKX function

    • Combine the two tables using a union

    • Add a column to differentiate between top and bottom ra

  • Answered by AI
  • Q7. What is difference between Sets and Group?
  • Ans. 

    Sets are a collection of unique values while groups are a collection of related values.

    • Sets contain only unique values while groups can have repeated values.

    • Sets are used for filtering data while groups are used for aggregating data.

    • Sets are used in Tableau for creating custom fields while groups are used for creating hierarchies.

    • Example of a set: a set of customers who have made a purchase in the last month.

    • Example of...

  • Answered by AI
  • Q8. Behavioral question - Will you help your colleague if your work is still pending and you don't have time?
  • Q9. Behavioral question - What would you do if you are unable to complete the task assigned to you in the required timeline?
  • Q10. How can you improve speed of Data Extractions in Tableau?
  • Ans. 

    Optimize data source, reduce number of rows/columns, use extracts, optimize queries, use filters.

    • Optimize data source by removing unnecessary columns and rows

    • Reduce number of rows and columns to only necessary data

    • Use extracts instead of live connections

    • Optimize queries by using custom SQL or aggregating data

    • Use filters to limit the amount of data being extracted

  • Answered by AI
  • Q11. How do you handle large data extracts in Tableau?
  • Ans. 

    Large data extracts in Tableau are handled by optimizing data sources, using filters, and aggregating data.

    • Optimize data sources by removing unnecessary columns and filtering data before extracting.

    • Use filters to limit the amount of data extracted.

    • Aggregate data to reduce the number of rows and columns.

    • Consider using Tableau's data engine to improve performance.

    • Use incremental extracts to only extract new or updated da...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Please go through the Barclays Values. Many behavioral questions rare based on the 5 values of Barclays.

Skills evaluated in this interview

Interview questions from similar companies

I appeared for an interview before Dec 2020.

Round 1 - Face to Face 

(5 Questions)

Round duration - 60 Minutes
Round difficulty - Medium

This round focused more on the Operating Systems part followed by some questions from Microservices Architecture.

  • Q1. What is a bootstrap program in an operating system?
  • Ans. 

    Bootstrap program is the initial code that runs when a computer is powered on, loading the operating system into memory.

    • Bootstrap program is stored in ROM or firmware.

    • It initializes the system hardware and loads the operating system kernel into memory.

    • Examples include BIOS in PCs and UEFI in modern systems.

  • Answered by AI
  • Q2. What is memory protection in operating systems?
  • Ans. 

    Memory protection in operating systems is a feature that prevents a process from accessing memory that has not been allocated to it.

    • Memory protection helps prevent one process from interfering with the memory of another process.

    • It ensures that each process can only access memory that has been allocated to it.

    • Examples of memory protection mechanisms include segmentation and paging.

    • Segmentation divides memory into segmen...

  • Answered by AI
  • Q3. What are the four necessary and sufficient conditions that lead to a deadlock?
  • Ans. 

    Four necessary and sufficient conditions for deadlock

    • Mutual exclusion: Resources cannot be shared between processes. Example: Process A holding Resource 1 and waiting for Resource 2, while Process B holding Resource 2 and waiting for Resource 1.

    • Hold and wait: Processes hold resources while waiting for others. Example: Process A holding Resource 1 and waiting for Resource 2, while Process B holding Resource 2 and waitin...

  • Answered by AI
  • Q4. What are the fundamental characteristics of a Microservices design?
  • Ans. 

    Microservices design is characterized by modularity, independence, scalability, and resilience.

    • Modularity: Microservices are designed as independent modules that can be developed, deployed, and scaled separately.

    • Independence: Each microservice operates independently and communicates with other services through APIs.

    • Scalability: Microservices allow for scaling specific components of an application based on demand.

    • Resili...

  • Answered by AI
  • Q5. What are the different strategies for deploying microservices?
  • Ans. 

    Different strategies for deploying microservices include blue-green deployment, canary deployment, rolling deployment, and feature flagging.

    • Blue-green deployment involves running two identical production environments, with one serving as the active environment while the other is on standby. Traffic is switched from one environment to the other once the new version is deemed stable.

    • Canary deployment gradually rolls out ...

  • Answered by AI
Round 2 - Face to Face 

(6 Questions)

Round duration - 60 Minutes
Round difficulty - Medium

This round was preety much mixed and contained questions from DBMS, Java and more importantly Spring Boot.

  • Q1. Why is normalization needed in a database?
  • Ans. 

    Normalization is needed in a database to reduce data redundancy, improve data integrity, and optimize database performance.

    • Eliminates data redundancy by breaking down data into smaller tables

    • Reduces update anomalies and inconsistencies in data

    • Improves data integrity by enforcing relationships between tables

    • Optimizes database performance by reducing storage space and improving query efficiency

  • Answered by AI
  • Q2. What are views in SQL?
  • Ans. 

    Views in SQL are virtual tables that are generated based on the result set of a SELECT query.

    • Views are not stored physically in the database, but are dynamically generated when queried.

    • They can be used to simplify complex queries by encapsulating logic and joining multiple tables.

    • Views can also be used to restrict access to certain columns or rows of a table.

    • Example: CREATE VIEW vw_employee AS SELECT emp_id, emp_name F

  • Answered by AI
  • Q3. What is dependency injection?
  • Ans. 

    Dependency injection is a design pattern where components are given their dependencies rather than creating them internally.

    • Allows for easier testing by providing mock dependencies

    • Promotes loose coupling between components

    • Improves code reusability and maintainability

    • Examples: Constructor injection, Setter injection, Interface injection

  • Answered by AI
  • Q4. What is the use of profiles in Spring Boot?
  • Ans. 

    Profiles in Spring Boot allow for different configurations to be applied based on the environment or specific needs.

    • Profiles can be used to define different sets of configurations for different environments such as development, testing, and production.

    • By using profiles, you can easily switch between configurations without changing the code.

    • Profiles are typically defined in application.properties or application.yml file...

  • Answered by AI
  • Q5. What are the various access specifiers in Java?
  • Ans. 

    Access specifiers in Java control the visibility of classes, methods, and variables.

    • There are four access specifiers in Java: public, protected, default (no specifier), and private.

    • Public: accessible from any other class.

    • Protected: accessible within the same package or subclasses.

    • Default: accessible only within the same package.

    • Private: accessible only within the same class.

  • Answered by AI
  • Q6. What is a JIT compiler?
  • Ans. 

    JIT compiler stands for Just-In-Time compiler, which compiles code during runtime instead of ahead of time.

    • JIT compiler translates bytecode into machine code on the fly

    • Improves performance by optimizing frequently executed code

    • Examples include Java HotSpot, .NET CLR's JIT compiler

  • Answered by AI
Round 3 - HR 

(2 Questions)

Round duration - 30 Minutes
Round difficulty - Easy

This is a cultural fitment testing round .HR was very frank and asked standard questions. Then we discussed about my role.

  • Q1. Why should we hire you?
  • Q2. Why are you looking for a job change?

Interview Preparation Tips

Eligibility criteriaAbove 2 years of experienceMphasis interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 4 MonthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Y are you looking for job change?
  • Q2. Will provide Work from home?

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview was about overall aspects like current company .salary,expected salary and skills .

Interview Questionnaire 

1 Question

  • Q1. Introduce Yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - The company usually takes 2 rounds followed by a client round. Interview was not difficult for my profile. I was interviewed for a BA profile and questions were mostly from my area of expertise.

I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Java 8, J2EE, Spring, SQL

Interview Preparation Tips

Interview preparation tips for other job seekers - There were four rounds. Technical written, two technical f2f rounds, coding test.

All the best

Interview Questionnaire 

1 Question

  • Q1. Asked about question regarding my technical skills

Interview Preparation Tips

Round: Resume Shortlist
Experience: Resume shortlisting

Round: Test
Experience: Aptitude, Reasoning and Technical test

I applied via Recruitment Consulltant and was interviewed before Mar 2021. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. About core java basics, hibernate, spring etc
Round 2 - HR 

(1 Question)

  • Q1. Expected CTC, about previous company experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well about core java basics. Read about immutable classes. Method to create an immutable class. Singleton class etc.

I applied via Walk-in and was interviewed before Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. The questions are on the basics of C#, OOPS. It depends on the project.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong on the basics.

I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Technical questions related to skills

Interview Preparation Tips

Interview preparation tips for other job seekers - technical skills related questions

I applied via Campus Placement and was interviewed in Jul 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Self introduction ,what is python, cyber security

Interview Preparation Tips

Interview preparation tips for other job seekers - Say all the answers with confidence

Barclays Global Service Centre Interview FAQs

What are the top questions asked in Barclays Global Service Centre Senior Business Intelligence Analyst interview?

Some of the top questions asked at the Barclays Global Service Centre Senior Business Intelligence Analyst interview -

  1. What is Live Vs Extract in Tableau? What is the file generated during extract a...read more
  2. How to show Top 10 and Bottom 10 Rankings in single Worksh...read more
  3. What are Dashboard Actions and what are the steps to apply Dashboard actio...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Mphasis Interview Questions
3.4
 • 807 Interviews
DXC Technology Interview Questions
3.7
 • 802 Interviews
Nagarro Interview Questions
4.0
 • 763 Interviews
NTT Data Interview Questions
3.8
 • 627 Interviews
Publicis Sapient Interview Questions
3.5
 • 621 Interviews
GlobalLogic Interview Questions
3.6
 • 592 Interviews
View all
Assistant Vice President
726 salaries
unlock blur

₹14.5 L/yr - ₹42.2 L/yr

Process Advisor
404 salaries
unlock blur

₹1 L/yr - ₹7.5 L/yr

Senior Analyst
362 salaries
unlock blur

₹3.5 L/yr - ₹11.8 L/yr

Assistant Manager
264 salaries
unlock blur

₹6.5 L/yr - ₹24 L/yr

Vice President
186 salaries
unlock blur

₹27 L/yr - ₹74.7 L/yr

Explore more salaries
Compare Barclays Global Service Centre with

DXC Technology

3.7
Compare

Mphasis

3.4
Compare

Sutherland Global Services

3.5
Compare

Optum Global Solutions

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview