AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Apollo Hospitals Data Analyst Interview Questions, Process, and Tips
Apollo Hospitals Data Analyst Interview Experiences
1 interview found
J Yaswanth
Selected
I applied via Naukri.com and was interviewed in Dec 2023. There were 2 interview rounds.
Power bi assignment was given to solve
(6 Questions)
- 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
- 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);
- 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
- 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
- Q5. Logical questions in aptitude
- 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, ...
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Data Scientist Interview Questions & Answers
Philips Innovation Campus
Anonymous
posted on 18 Nov 2024
(1 Question)
- Q1. In depth project based qiestions
Selected
I applied via AmbitionBox and was interviewed in Aug 2023. There were 2 interview rounds.
Related to data entry operator with support
(2 Questions)
- Q1. Which do you do type our work with sincerity
- Q2. I do my happyness playfulness
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed before Jul 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Tell me about your self
- Ans.
I am a detail-oriented individual with strong data entry skills and a passion for accuracy.
Experienced in data entry tasks such as inputting information into databases
Proficient in using Microsoft Excel and other data entry software
Strong attention to detail and ability to maintain accuracy in high-volume data entry tasks
- Q2. Why we should hair you
(2 Questions)
- Q1. Tell me about your self
- Ans.
I am a detail-oriented individual with strong data entry skills and a passion for accuracy.
Experienced in data entry tasks such as inputting information into databases
Proficient in using Microsoft Excel and other data entry software
Strong attention to detail and accuracy in data entry work
Ability to work efficiently under pressure and meet deadlines
- Q2. Why we should hire you
- Ans.
I am detail-oriented, efficient, and have a strong background in data entry.
I have a proven track record of accurately entering data in a timely manner.
I am proficient in using data entry software and have a fast typing speed.
I have excellent attention to detail and can spot errors quickly to ensure data accuracy.
Interview Preparation Tips
Data Engineer Interview Questions & Answers
Philips Innovation Campus
Anonymous
posted on 16 Oct 2022
I applied via Recruitment Consulltant and was interviewed before Oct 2021. There were 4 interview rounds.
There were 2 SQL queries based on rank function and count aggregation. 1 python program based on array.
(3 Questions)
- Q1. 2 sql questions. Was asked which technology I worked on- aws redshift.
- Q2. Architecture of redshift. keys in redshift.
- Ans.
Redshift is a cloud-based data warehousing solution by AWS. It uses columnar storage and massively parallel processing.
Redshift is based on PostgreSQL and uses SQL for querying data.
It uses columnar storage which is optimized for analytical queries.
Redshift is a massively parallel processing (MPP) system, which means it can distribute queries across multiple nodes for faster processing.
It uses key-based sharding to dis...
- Q3. 1 python program on sliding window technique .
- Ans.
Sliding window technique is used to solve problems where we need to find a substring of a certain length in a larger string.
Define the window size and slide it over the string
Use two pointers to keep track of the start and end of the window
Examples: Maximum sum subarray of size K, Longest substring with K distinct characters
(1 Question)
- Q1. 3 sql queries. architecture for a data pipeline to display hour per activity in last 24 hra on a smartwatch .
- Ans.
Design a data pipeline to display hourly activity on a smartwatch for the last 24 hours using SQL queries.
Create a table to store activity data with columns for timestamp and activity type.
Use a SQL query to aggregate activity data by hour for the last 24 hours.
Display the results on the smartwatch using a suitable visualization.
Interview Preparation Tips
Skills evaluated in this interview
Data Scientist Interview Questions & Answers
Philips Innovation Campus
Anonymous
posted on 2 Feb 2024
Selected
I applied via Campus Placement and was interviewed before Feb 2023. There were 3 interview rounds.
Aptitude test involving coding
(1 Question)
- Q1. Questions on Data science related
(1 Question)
- Q1. Basic details round
Senior Data Analyst Interview Questions & Answers
Philips Innovation Campus
Anonymous
posted on 12 Jul 2023
Selected
I applied via campus placement at Vellore Institute of Technology (VIT) and was interviewed before Jul 2022. There were 4 interview rounds.
For campus placement it will be a mix of logical reasoning, english proficiency , mathematical abilty etc
(1 Question)
- Q1. Checks our subject matter expertise
(1 Question)
- Q1. Manager round(for freshers)
Interview Preparation Tips
Generally, interviews are not so difficult.
Get a good grasp on the tech stack you shared in resume.
Good luck
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. 1) Model building process of one of my previous projects 2) Random forest hyperparameters 3) ROC curve, using the ROC curve to set probability cutoffs in classication models 4) Gradient boosting techniques...
- Ans.
Data Scientist interview questions on model building, random forest, ROC curve, gradient boosting, and real estate valuation
For model building, I followed the CRISP-DM process and used various algorithms like logistic regression, decision trees, and random forest
Random forest hyperparameters include number of trees, maximum depth, minimum samples split, and minimum samples leaf
ROC curve is a graphical representation of...
Interview Preparation Tips
Skills evaluated in this interview
Apollo Hospitals Interview FAQs
Tell us how to improve this page.
Apollo Hospitals Interviews By Designations
- Apollo Hospitals Pharmacist Interview Questions
- Apollo Hospitals Staff Nurse Interview Questions
- Apollo Hospitals Nursing Staff Interview Questions
- Apollo Hospitals Hospital Pharmacist Interview Questions
- Apollo Hospitals Medical Laboratory Technician Interview Questions
- Apollo Hospitals Medical Officer Interview Questions
- Apollo Hospitals Clinical Pharmacist Interview Questions
- Apollo Hospitals Lab Technician Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Apollo Hospitals Data Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Apollo Hospitals Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Staff Nurse
983
salaries
|  ₹0.8 L/yr - ₹5.5 L/yr |
|
Pharmacist
691
salaries
| ₹1 L/yr - ₹4.2 L/yr |
|
Assistant Manager
247
salaries
| ₹3.2 L/yr - ₹13.5 L/yr |
|
Senior Executive
219
salaries
| ₹2.2 L/yr - ₹11.1 L/yr |
|
Clinical Pharmacist
218
salaries
| ₹1.3 L/yr - ₹5 L/yr |
Fortis Healthcare
Max Healthcare
Narayana Health
Manipal Hospitals
- Home >
- Interviews >
- Apollo Hospitals Interview Questions >
- Apollo Hospitals Data Analyst Interview Questions
