BankBazaar Data Scientist Trainee Interview Questions and Answers

Q1. Tell me brief about your self
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Experienced in analyzing large datasets using SQL, Python, and R

• Skilled in creating insightful reports and dashboards using Tableau and Power BI

• Strong communication skills to present findings to stakeholders

• Certified in data analysis and machine learning techniques
Answered by AI
Add your answer
Q2. What are youre strenth and weekness
Ans. 
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
• Strength: Strong analytical skills

• Strength: Attention to detail

• Weakness: Getting caught up in details (provide example)
Answered by AI
Add your answer

Q1. Detailed discussion on past experience and projects.
Add your answer

Q1. 2 Hackerrank SQL Questions
Add your answer
Q2. 1 Hackerrank Python Question
Add your answer

Q1. What is the order of execution in sql
Ans. 
The order of execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
• 1. FROM: Specifies the tables involved in the query.

• 2. WHERE: Filters the rows based on specified conditions.

• 3. GROUP BY: Groups the rows that have the same values into summary rows.

• 4. HAVING: Filters groups based on specified conditions.

• 5. SELECT: Selects the columns to be included in the result set.

• 6. ORDER BY: Sorts the result set base
Answered by AI
Add your answer

Q1. How to do conditional formatting in excel
Ans. 
Conditional formatting in Excel allows users to format cells based on specified conditions.
• Select the range of cells you want to apply conditional formatting to

• Go to the 'Home' tab and click on 'Conditional Formatting'

• Choose the desired formatting option, such as color scales, data bars, or icon sets

• Set the conditions for when the formatting should be applied, such as greater than, less than, or equal to a certain valu...read more
Answered by AI
Add your answer

It was hackerrank test

Q1. General questions and sql questions
Add your answer

Q1. Different types of Joins in SQL and what are the outputs when you join two tables with nulls.
Ans. 
Different types of Joins in SQL and the outputs when joining two tables with nulls.
• Types of joins in SQL include inner join, left join, right join, and full outer join.

• When joining two tables with nulls, the output depends on the type of join used.

• In an inner join, null values are excluded from the result.

• In a left join, all rows from the left table and matching rows from the right table are included, with nulls for no...read more
Answered by AI
View 1 more answer
Q2. Can you union tables with different datatypes.
Ans. 
Yes, but it requires careful handling of data types and potential conversion.
• Union can be performed on tables with different datatypes, but the resulting table will have a common datatype for each column.

• Data types should be compatible, otherwise conversion may be necessary.

• For example, a table with a column of integers can be unioned with a table with a column of floats, but the resulting column will be of type float.

• ...read more
Answered by AI
Add your answer

Q1. Given a data set, should write sql queries to answer a few questions
Add your answer
Q2. A few puzzles would be asked to evaluate the problem solving skills.
Add your answer

Q1. Business Case studies - try parctising profitablility and other cases
Add your answer

Q1. An Excel round will also be there if you apply for business analyst role.
Add your answer

Easy questions based on Logical Reasoning, Mathematics, English

Be sure to put your thoughts on the topic you get, and try to put a point that meets the goals or aspirations of the company.

Q1. Tell me about yourself Tell me something from your resume Desribe your project
Add your answer

Sql and aptitude questions

Q1. Question from resume amd project
Add your answer
Q2. Some questions on sql
Add your answer