Add office photos
Filter interviews by
Visions Business Analyst Interview Questions and Answers
Be the first one to contribute and help others!
Interview questions from similar companies
Anonymous
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
(5 Questions)
- Q1. Prepare All theoretical questions related to SQL and excel. Learn everything about your resume so that you will be able to explain each and everything about the resume.
- Q2. Difference between Vlookup and Xlookup ?
- Ans.
Vlookup searches for a value in the first column of a range and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible function that can search in any direction and return multiple results.
Vlookup searches vertically in a table and returns a value from a specified column.
Xlookup can search in any direction (horizontal, vertical, or both) and return multiple results.
Vlookup requ...
- Q3. Difference between Subquery and CTE. Which is better?
- Ans.
Subquery is a query nested within another query, while CTE is a temporary result set defined within a query. Both have their own use cases.
Subquery is enclosed in parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.
CTE is defined using the WITH keyword and can be referenced multiple times in a query.
CTEs are more readable and easier to maintain compared to subqueries.
Subqueries are useful when t...
- Q4. No of records returned after applying left and inner join on 2 tables.
- Q5. Pivot the table in SQL using case when statements.
- Ans.
Pivoting a table in SQL using case when statements
Use the CASE WHEN statement to create new columns based on specific conditions
Use the SUM or COUNT function to aggregate data in the pivoted table
Group by the remaining columns to ensure correct aggregation
Example: SELECT id, SUM(CASE WHEN category = 'A' THEN value END) AS A_total FROM table_name GROUP BY id;
Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data
Interview Preparation Tips
- SQL
- EXCEL
Skills evaluated in this interview
(2 Questions)
- Q1. General question on powerbi and sql
- Q2. Had solve sone queries on sql
(2 Questions)
- Q1. What is Gross profit
- Ans.
Gross profit is the total revenue minus the cost of goods sold.
Gross profit = Total revenue - Cost of goods sold
It represents the profit a company makes from its core business activities before deducting operating expenses.
It does not include expenses such as taxes, interest, and other non-operating costs.
Gross profit margin is calculated as (Gross profit / Total revenue) * 100%
Example: If a company has total revenue o...
- Q2. GP = Sales - COGS
(2 Questions)
- Q1. Hahsk kdks ksksk sks
- Q2. Jeks ksks dkkd dd fr ss
Selected
I applied via Naukri.com and was interviewed before Dec 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Tell me about yourself
- Ans.
I am a dedicated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.
I have a Bachelor's degree in Business Administration
I have 5 years of experience in analyzing business processes and identifying areas for improvement
I am proficient in using data analysis tools such as Excel, SQL, and Tableau
I have a proven track record of successfully implementing process improvements ...
- Q2. Few BA related questions
(2 Questions)
- Q1. Salary discussions
- Q2. How did you know about the opening
Selected
I applied via LinkedIn and was interviewed before May 2023. There were 3 interview rounds.
(1 Question)
- Q1. SQL and Visualizationbased questions
Case study for business problems
(1 Question)
- Q1. Behaviour fit round
Selected
I applied via Company Website and was interviewed before Aug 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Subjective based
- Q2. Situational awareness
Interview Preparation Tips
Basic Aptitude question
Allocated one topic and given half an hour of time to prepare on it
(2 Questions)
- Q1. Tenchnical coding related questions
- Q2. Libraries used for interview, basic joins etc
(1 Question)
- Q1. Business related questions
(1 Question)
- Q1. Why do you want to join this company
(1 Question)
- Q1. Tell us about yourself
(1 Question)
- Q1. About sql, python, visualaization
(1 Question)
- Q1. About sql and business kpi's
(1 Question)
- Q1. Sql and business kpi's
(1 Question)
- Q1. Salary negotiation
Divya Devkumar
(1 Question)
- Q1. Vlookup sumif all excel formulas
Visions Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Manager Interview Questions
- Business Executive Interview Questions
- Show more
Business Analyst Interview Questions from Similar Companies
|
Software Developer
8
salaries
|  ₹3.8 L/yr - ₹6 L/yr |
|
Quality Analyst
8
salaries
| ₹3 L/yr - ₹8.4 L/yr |
|
Graphic Designer
4
salaries
| ₹2.5 L/yr - ₹4.6 L/yr |
|
System Administrator
4
salaries
| ₹3 L/yr - ₹6.2 L/yr |
|
Web Designer
4
salaries
| ₹2.6 L/yr - ₹5 L/yr |
Infosys
TCS
Wipro
HCLTech
Calculate your in-hand salary
- Home >
- Interviews >
- Visions Interview Questions >
- Visions Business Analyst Interview Questions
