Add office photos
HSBC Group
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
HSBC Group Manager - Business Intelligence Interview Questions, Process, and Tips
HSBC Group Manager - Business Intelligence Interview Experiences
1 interview found
Anonymous
Selected
I applied via Approached by Company and was interviewed before Apr 2022. There were 3 interview rounds.
(4 Questions)
- Q1. What is Row Level Security?
- Ans.
Row Level Security is a feature that restricts access to specific rows in a database based on user roles and permissions.
It allows for fine-grained control over data access.
It is commonly used in multi-tenant applications where different users should only have access to their own data.
It can be implemented using database views, stored procedures, or application-level logic.
For example, a sales manager may only be able ...
- Q2. How to make pivot table range auto and how to adjust pivot to not show nil value.
- Ans.
To make pivot table range auto, select the data range and press Ctrl + T. To adjust pivot to not show nil value, go to PivotTable Options > Layout & Format > uncheck 'Show items with no data'.
To make pivot table range auto, select the data range and press Ctrl + T.
To adjust pivot to not show nil value, go to PivotTable Options > Layout & Format > uncheck 'Show items with no data'.
- Q3. Diffrence between line chart and Bar chart.
- Ans.
Line chart shows trends over time while bar chart compares values between categories.
Line chart displays data as a series of points connected by a line, useful for showing trends over time.
Bar chart displays data as rectangular bars, useful for comparing values between categories.
Line chart is best suited for continuous data while bar chart is best suited for discrete data.
Line chart can show multiple series of data on...
- Q4. Approach to reduce manual process.
- Ans.
Automate manual processes using technology and streamline workflows.
Identify repetitive tasks that can be automated
Evaluate available technology solutions
Implement automation tools and integrate with existing systems
Train employees on new processes and monitor for efficiency
Continuously review and improve automated processes
(3 Questions)
- Q1. What to do if wrong report was sent by you?
- Ans.
Acknowledge the mistake, inform the concerned parties, and provide the correct report as soon as possible.
Admit the mistake and take responsibility
Notify the recipients of the incorrect report
Provide the correct report as soon as possible
Take steps to prevent similar mistakes in the future
- Q2. Why you want to get into HSBC?
- Q3. What you will do if more work load ?
- Ans.
I will prioritize tasks, delegate responsibilities, and communicate with my team to ensure timely completion of all work.
Assess the workload and prioritize tasks based on urgency and importance
Delegate responsibilities to team members based on their strengths and workload
Communicate with team members to ensure everyone is aware of their responsibilities and deadlines
Monitor progress and provide support as needed
Conside...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via LinkedIn and was interviewed in Jul 2024. There were 3 interview rounds.
Assignment on credit risk
(1 Question)
- Q1. Hyperparameter tuning
(1 Question)
- Q1. Case study for problem solving
Rohan Soni
(2 Questions)
- Q1. How do you define model Gini?
- Ans.
Model Gini is a measure of statistical dispersion used to evaluate the performance of classification models.
Model Gini is calculated as twice the area between the ROC curve and the diagonal line (random model).
It ranges from 0 (worst model) to 1 (best model), with higher values indicating better model performance.
A Gini coefficient of 0.5 indicates a model that is no better than random guessing.
Commonly used in credit
- Q2. How to you train XG boost model
- Ans.
XGBoost model is trained by specifying parameters, splitting data into training and validation sets, fitting the model, and tuning hyperparameters.
Specify parameters for XGBoost model such as learning rate, max depth, and number of trees
Split data into training and validation sets using train_test_split function
Fit the XGBoost model on training data using fit method
Tune hyperparameters using techniques like grid search
Skills evaluated in this interview
Question on Probability and basic aptitude questions
(2 Questions)
- Q1. Question were related to Past projects
- Q2. SQL and Excel medium level questions
I was asked Python, sql, coding questions
Case study on how would you identify the total number of footfall on a airport
Python coding question and ML question
(1 Question)
- Q1. ML questions from resume + general
(1 Question)
- Q1. Techno managerial round
(1 Question)
- Q1. Sorting Question
I was interviewed before Apr 2023.
(1 Question)
- Q1. Basic statistics
(1 Question)
- Q1. Project related
Interview Preparation Tips
I applied via campus placement at Birla Institute of Technology and Science (BITS), Pilani
(1 Question)
- Q1. Work done in previous companty
- Ans.
Developed machine learning models to predict customer churn and optimize marketing campaigns.
Built predictive models using Python and scikit-learn
Utilized SQL to extract and manipulate data for analysis
Collaborated with cross-functional teams to implement data-driven solutions
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
(4 Questions)
- Q1. What are joins,
- Ans.
Joins are used in databases to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column between them
Common 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 th...
- Q2. Difference between having and where
- Ans.
The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions, while 'where' is used with individual rows.
HAVING is used to filter groups of rows based on aggregate functions, such as COUNT, SUM, AVG, etc.
WHERE is used to filter individual rows based on specific conditions.
HAVING is applied after the GROUP BY clause, while WHERE is applied before.
Example: SELECT department, A...
- Q3. What are analytical functions explain all
- Ans.
Analytical functions are used in SQL to perform calculations across a set of rows related to the current row.
Analytical functions operate on a group of rows and return a single result for each row.
They can be used to calculate moving averages, running totals, rank, and percentiles.
Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD(), LAG(), SUM(), AVG().
- Q4. What are triggers and how to create them and what is the use of triggers and explain when and how did you use triggers in your previous org
- Ans.
Triggers are database objects that automatically perform an action when a specified event occurs on a particular table or view.
Triggers are used to enforce business rules, validate data, and maintain data integrity.
They can be created using SQL commands like CREATE TRIGGER.
Triggers can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.
An example of using triggers is to automatically upda...
Skills evaluated in this interview
HSBC Group Interview FAQs
Tell us how to improve this page.
HSBC Group Interviews By Designations
- HSBC Group Assistant Manager Interview Questions
- HSBC Group Software Engineer Interview Questions
- HSBC Group Analyst Interview Questions
- HSBC Group Business Analyst Interview Questions
- HSBC Group Senior Software Engineer Interview Questions
- HSBC Group Software Engineer Trainee Interview Questions
- HSBC Group Software Developer Interview Questions
- HSBC Group Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Intelligence Analyst Interview Questions
- Business Intelligence Developer Interview Questions
- Business Intelligence Consultant Interview Questions
- Senior Business Intelligence Analyst Interview Questions
- Artificial Intelligence Intern Interview Questions
- Artificial Intelligence Developer Interview Questions
- Data Scientist Interview Questions
- Lead - Business Intelligence Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
HSBC Group Manager - Business Intelligence Reviews and Ratings
based on 1 review
Rating in categories
|
Assistant Manager
2.6k
salaries
|  ₹4.3 L/yr - ₹14.4 L/yr |
|
Manager
2k
salaries
| ₹8 L/yr - ₹28 L/yr |
|
Senior Software Engineer
1.7k
salaries
| ₹7.4 L/yr - ₹28 L/yr |
|
Assistant Vice President
1.4k
salaries
| ₹13 L/yr - ₹45 L/yr |
|
Software Engineer
1.3k
salaries
| ₹4.8 L/yr - ₹14.5 L/yr |
Standard Chartered
Citibank
ICICI Bank
Axis Bank
Calculate your in-hand salary
- Home >
- Interviews >
- HSBC Group Interview Questions >
- HSBC Group Manager - Business Intelligence Interview Questions
