Ayu Health Hospitals Data Analyst Interview Questions and Answers

Power bi assignment was given to solve

Q1. Optimization techniques in sql
Ans. 
Optimization techniques in SQL involve using indexes, query optimization, and proper database design.
• Use indexes on columns frequently used in WHERE clauses to speed up query performance

• Avoid using SELECT * and instead specify only the columns needed in the query

• Optimize queries by using appropriate join types and conditions

• Normalize database tables to reduce redundancy and improve query efficiency
Answered by AI
Add your answer
Q2. Sub queries in sql
Ans. 
Sub queries in SQL are queries nested within another query to retrieve data based on the result of the outer query.
• Sub queries can be used in SELECT, INSERT, UPDATE, and DELETE statements.

• They can be used to filter results, retrieve data from multiple tables, or perform calculations.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);
Answered by AI
Add your answer
Q3. Types of Join in sql
Ans. 
Types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full outer join: Returns all rows when there is a match in either table
Answered by AI
Add your answer
Q4. Time intelligence functions in power bi
Ans. 
Time intelligence functions in Power BI are used to analyze and compare data based on time periods.
• Time intelligence functions help in calculating year-to-date, month-to-date, and other time-based calculations.

• Functions like TOTALYTD, SAMEPERIODLASTYEAR, and PARALLELPERIOD are commonly used for time intelligence in Power BI.

• These functions allow for easy comparison of data across different time periods and help in tren
Answered by AI
Add your answer
Q5. Logical questions in aptitude
Add your answer
Q6. Row level security in power bi
Ans. 
Row level security in Power BI allows users to restrict access to specific rows of data based on their role or criteria.
• Row level security can be implemented by creating roles in Power BI and defining rules to filter data based on user roles.

• Users can be assigned to specific roles which determine the data they have access to.

• Row level security helps in ensuring data privacy and compliance with regulations.

• For example, ...read more
Answered by AI
Add your answer

Q1. What is SQL pls definitons
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language.

• It is used to communicate with databases to retrieve, insert, update, and delete data.

• Common SQL commands include SELECT, INSERT, UPDATE, and DELETE.

• SQL is used in various database management systems like MySQL, PostgreSQL, and Oracle.

• Example: SELECT * FROM customers WHERE city = 'New York';
Answered by AI
Add your answer
Q2. What is left join how many types of join in sql
Ans. 
A left join is a type of join in SQL that returns all records from the left table and the matched records from the right table.
• Left join is used to retrieve all records from the left table and the matched records from the right table.

• If there is no match, NULL values are returned for the columns from the right table.

• Types of joins in SQL include inner join, outer join (left, right, full), cross join, and self join.
Answered by AI
Add your answer

Q1. Tell me about yourself ?
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Graduated with a degree in Statistics

• Proficient in programming languages like Python and R

• Experience in analyzing large datasets and creating data visualizations

• Strong problem-solving skills
Answered by AI
Add your answer
Q2. As a medical coder what was your responsibilities.
Add your answer
Q3. Domain round questions
Add your answer
Q4. Learning Growth
Add your answer
Q5. Fraud Analytics
Add your answer

Easy but time limit was the main issue to address

Hard coding test on hacker earth platform no cameras and plagiarism tester will be on

It is very easy . Leetcode easy prob can help out

Q1. Didn't remember the exact questions but the first set of questions were on Datastage, then SQL, and last Unix. Try to do hands-on on the tool before the interview, this will help to solve scenario-based q...read more
Add your answer

Q1. Just be yourself, it will be non technical round.
Add your answer