Visions Business Analyst Interview Questions and Answers

Q1. General question on powerbi and sql
Add your answer
Q2. Had solve sone queries on sql
Ans. 
I have resolved various SQL queries to extract, manipulate, and analyze data effectively.
• Used SELECT statements to retrieve specific columns from a table, e.g., SELECT name, age FROM patients;

• Implemented JOIN operations to combine data from multiple tables, e.g., SELECT orders.id, customers.name FROM orders JOIN customers ON orders.customer_id = customers.id;

• Utilized WHERE clause to filter records based on conditions, ...read more
Answered by AI
Add your answer

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.
Add your answer
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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
Q4. No of records returned after applying left and inner join on 2 tables.
Ans. 
Understanding record counts from left and inner joins helps in data analysis and decision-making.
• A left join returns all records from the left table and matched records from the right table.

• An inner join returns only the records that have matching values in both tables.

• Example: If Table A has 5 records and Table B has 3 matching records, a left join will return 5 records, while an inner join will return 3.

• If there are ...read more
Answered by AI
Add your answer
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;
Answered by AI
Add your answer

Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data

Q1. About sql, python, visualaization
Add your answer

Q1. About sql and business kpi's
Add your answer

Q1. Sql and business kpi's
Add your answer

Q1. Salary negotiation
Add your answer

Q1. Write sql query on leet code
Ans. 
SQL query on LeetCode platform for business analysis.
• Use SELECT statement to retrieve data from database tables.

• Use JOIN clause to combine data from multiple tables.

• Use WHERE clause to filter data based on specific conditions.
Answered by AI
Add your answer
Q2. Power BI interview questions
Add your answer

60 question 90 minutes

Faviorate sports persion of india

Some power BI problems and excel problems

Q1. SQL query questions along with power bi
Add your answer

Q1. Excel and Power Bi and Analytics
Add your answer

Basic Aptitude question

Allocated one topic and given half an hour of time to prepare on it

Q1. Tenchnical coding related questions
Add your answer
Q2. Libraries used for interview, basic joins etc
Add your answer

Q1. Business related questions
Add your answer

Q1. Why do you want to join this company
Ans. 
I admire your company's innovative approach and commitment to data-driven decision-making, aligning perfectly with my career goals.
• Your company's reputation for innovation in the industry excites me, as I thrive in environments that challenge the status quo.

• I am impressed by your commitment to data-driven decision-making, which aligns with my analytical skills and passion for insights.

• The collaborative culture at your ...read more
Answered by AI
Add your answer

Intermediate Aptitude Questions

Q1. SQL Question on JOINS
Add your answer
Q2. OOPS Definitions
Add your answer