Upload Button Icon Add office photos

Filter interviews by

Clear (1)

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 applied via Naukri.com and was interviewed before Sep 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all Resume tips
Round 2 - Aptitude Test 

Entry level aptitude test

Round 3 - One-on-one 

(1 Question)

  • Q1. Introduction and about college project.

Interview Preparation Tips

Interview preparation tips for other job seekers - It was a really good experience working in TCS

I applied via Walk-in and was interviewed before Sep 2021. There were 4 interview rounds.

Round 1 - Aptitude Test 

Reasoning and English

Round 2 - Group Discussion 

Just a minute round about favourite movie

Round 3 - Technical 

(1 Question)

  • Q1. SD , about education questions
Round 4 - HR 

(1 Question)

  • Q1. Regarding shifts, timings and relocation

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best guys. It's very is to crack the interview in TCS

I was interviewed in Nov 2016.

Interview Questionnaire 

6 Questions

  • Q1. Explain Btech Project
  • Ans. 

    Developed a Btech project on automated attendance system using facial recognition.

    • Developed a software application to automate the attendance process in educational institutions.

    • Implemented facial recognition technology to identify and mark attendance of students.

    • Used machine learning algorithms to train the system for accurate recognition.

    • Integrated the application with a database to store attendance records.

    • Provided ...

  • Answered by AI
  • Q2. Code Pascal's Traingle
  • Ans. 

    Code Pascal's Triangle

    • Pascal's Triangle is a triangular array of binomial coefficients

    • Each number is the sum of the two numbers above it

    • The first and last numbers in each row are 1

    • Can be implemented using nested loops or recursion

  • Answered by AI
  • Q3. What is abstract function
  • Ans. 

    An abstract function is a function that has no implementation and must be implemented by its subclasses.

    • An abstract function is declared with the 'abstract' keyword.

    • It is used to define a template for its subclasses to follow.

    • It cannot be instantiated and must be implemented by its subclasses.

    • It can have abstract and non-abstract methods.

    • Example: abstract class Animal { abstract void makeSound(); }

    • Example: class Dog ex...

  • Answered by AI
  • Q4. Difference between abstract and normal function
  • Ans. 

    Abstract functions cannot be instantiated and must be implemented by child classes, while normal functions can be directly called.

    • Abstract functions have no implementation in the parent class, while normal functions do.

    • Abstract functions are declared with the 'abstract' keyword, while normal functions are not.

    • Normal functions can be called directly, while abstract functions must be implemented by child classes.

    • An examp...

  • Answered by AI
  • Q5. Your 2 weakness
  • Ans. 

    Perfectionism and public speaking anxiety

    • I tend to be a perfectionist, which can sometimes lead to spending too much time on a task

    • I struggle with public speaking anxiety, but I have been working on improving my communication skills through practice and training

  • Answered by AI
  • Q6. Why Capgemini
  • Ans. 

    Capgemini is a global leader in consulting, technology services, and digital transformation.

    • Capgemini has a strong reputation in the industry for delivering high-quality software solutions.

    • The company offers a wide range of opportunities for career growth and development.

    • Capgemini has a collaborative and inclusive work culture that fosters innovation and teamwork.

    • The company has a global presence, providing exposure to...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: General Aptitude and English

Round: Technical Interview
Experience: 10 minutes approx. Questions were repetitive for candidates. i.e. for 13 candidates interviewed most of those were similar.

Round: HR Interview
Experience: Other normal stuff about family.
Tips: HR might try to get under your skin so prepare for general hr questions.

College Name: IIT Patna

Skills evaluated in this interview

Interview Questionnaire 

3 Questions

  • Q1. What is autocorrelation?
  • Ans. 

    Autocorrelation is the correlation of a signal with a delayed copy of itself.

    • Autocorrelation is used to identify patterns in time series data.

    • It is a measure of how similar a signal is to a delayed version of itself.

    • Autocorrelation can be positive, negative, or zero.

    • It is commonly used in signal processing, finance, and econometrics.

    • Autocorrelation can be visualized using a correlogram.

  • Answered by AI
  • Q2. What is heteroscedasticity?
  • Ans. 

    Heteroscedasticity is a statistical term that refers to the unequal variance of a variable across different levels of another variable.

    • It is a violation of the assumption of homoscedasticity in regression analysis.

    • It can lead to biased and inefficient estimates of regression coefficients.

    • It can be detected through residual plots or statistical tests such as the Breusch-Pagan test.

    • Examples include income and expenditure...

  • Answered by AI
  • Q3. How do they affect your data analysis?
  • Ans. 

    Data analysis is affected by various factors that can influence the accuracy and reliability of the results.

    • Data quality: The accuracy, completeness, and consistency of the data can impact the analysis.

    • Data sources: The reliability and relevance of the data sources used for analysis can affect the outcomes.

    • Data preprocessing: The way data is cleaned, transformed, and prepared for analysis can impact the results.

    • Data in...

  • Answered by AI

Interview Preparation Tips

Round: Technical + HR Interview
Experience: Most of the questions was based on statistical modelling as the position they were hiring for was business analyst which requires statistical modelling and its business applications.
Tips: Always try to apply your statistical knowledge to the businesses around you. How you can improve that or apply it for better usage.

College Name: Institute of Management Technology

I was interviewed before Aug 2016.

Interview Preparation Tips

Round: Test
Experience: It was good
Total Questions: 20

Round: Technical Interview
Experience: It was good

Interview Questionnaire 

2 Questions

  • Q1. Simple programming and questions related to the subject in B Tech
  • Q2. Testing communication

Interview Preparation Tips

Round: Test
Experience: Aptitude , Reasoning

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

Interview Questionnaire 

1 Question

  • Q1. Where you see yourself after 5 years

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident whatever u say. This one thing is enough to get judge by interviewer

I applied via Approached by Company and was interviewed in Nov 2018. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Questions were asked on what was written on resume
  • Q2. Questions were also asked on testing
  • Q3. Complete questions from payments flow and swift msg

Interview Preparation Tips

General Tips: Be aware of what you write on your resume and be confident while answering for the questions.
Skills: Communication, Body Language, Analytical Skills
Duration: <1 week

Interview Questionnaire 

5 Questions

  • Q1. Basic telephone round probably around 3 times
  • Q2. About ourself and past experience
  • Q3. And they really see if we are interested or not, nothing technical
  • Q4. Telephone technical interview
  • Q5. My role is pega developer so questions are on pega

Interview Preparation Tips

Round: Face to face technical
Experience: Asked each and every aspect in pega

Contribute & help others!
anonymous
You can choose to be anonymous

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

Recently Viewed

JOBS

Browse jobs

Discover jobs you love

COMPANY BENEFITS

KNR Constructions

20 benefits

COMPANY BENEFITS

IRB Infrastructure

60 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

INTERVIEWS

Barclays Global Service Centre

No Interviews

CAMPUS PLACEMENT

Vellore Institute of Technology (VIT)

INTERVIEWS

Wunderman Thompson Commerce

No Interviews

INTERVIEWS

Barclays Global Service Centre

No Interviews

INTERVIEWS

China State Construction Engineering Corporation

No Interviews

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.1k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.7k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
IBM Interview Questions
4.0
 • 2.3k Interviews
Infosys BPM Interview Questions
3.6
 • 939 Interviews
DXC Technology Interview Questions
3.7
 • 795 Interviews
Mphasis Interview Questions
3.4
 • 788 Interviews
Nagarro Interview Questions
4.0
 • 759 Interviews
View all
Assistant Vice President
716 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Process Advisor
437 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
278 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
254 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
238 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Barclays Global Service Centre with

HSBC Group

3.9
Compare

OneMain Financial

4.5
Compare

Wipro

3.7
Compare

TCS

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent