Wyzmindz Solutions Business Analyst Interview Questions, Process, and Tips

Q1. What is group by in MySQL.
Ans. 
GROUP BY in MySQL is used to group rows that have the same values into summary rows.
• GROUP BY is used with aggregate functions like COUNT, SUM, AVG, etc.

• It is used to summarize data by grouping rows based on one or more columns.

• GROUP BY can be used with HAVING clause to filter the grouped results.

• Example: SELECT department, COUNT(*) FROM employees GROUP BY department;
Answered by AI
Add your answer
Q2. How do you filter data in MySQL.
Ans. 
Filtering data in MySQL involves using the WHERE clause in SQL queries.
• Use the WHERE clause in SELECT statements to filter data based on specified conditions.

• You can use comparison operators such as =, <>, >, <, >=, <=, etc. in the WHERE clause.

• You can also use logical operators like AND, OR, and NOT to combine multiple conditions.

• Example: SELECT * FROM table_name WHERE column_name = 'value';
Answered by AI
Add your answer

Basic aptitude and excel test

Q1. Gave some case studies
Add your answer
Q2. If goingt9 a mall what would younotice, that'llhelp with data analytics
Ans. 
I would notice foot traffic patterns, popular stores, customer demographics, and marketing promotions.
• Foot traffic patterns - observe where people are congregating and walking

• Popular stores - note which stores have the most customers and sales

• Customer demographics - look at the age, gender, and ethnicity of shoppers

• Marketing promotions - identify any special offers or discounts being advertised
Answered by AI
Add your answer

Basic aptitude and logical reasoning

Q1. Basic excel test like avg ,sum,HLookup,vlookup
Add your answer

Q1. Excel technical questions
Add your answer

Q1. Real time example
Ans. 
Analyzing customer feedback to improve product features and user experience.
• Collecting feedback through surveys, interviews, and user testing

• Analyzing feedback data to identify trends and patterns

• Creating reports and recommendations based on findings

• Collaborating with product development team to implement changes

• Measuring impact of changes on user satisfaction and product performance
Answered by AI
Add your answer

Simple Quantitative and logical reasoning

Q1. Advanced Excel such as VLookup, FIND, PIVOT
Add your answer
Q2. MySQL question like JOINS, GROUP BY, CONSTRAINTS, DATATYPES
Add your answer

Q1. Personal question, communication required, stakeholders management
Add your answer