Philips Innovation Campus Senior Data Analyst Interview Questions and Answers

Q1. Type of Filters in Tableau.
Ans. 
Tableau offers various types of filters including quick filters, context filters, and data source filters.
• Quick filters allow users to easily filter data by selecting values from a list.

• Context filters are applied before other filters, affecting the data visible to subsequent filters.

• Data source filters limit the data available to Tableau by filtering data at the data source level.

• Other types of filters include extract...read more
Answered by AI
Add your answer
Q2. Types of refresh in Tableau
Ans. 
There are two types of refresh in Tableau: Extract Refresh and Data Source Refresh.
• Extract Refresh: Refreshes the data in Tableau extract, which is a snapshot of data from the original data source.

• Data Source Refresh: Refreshes the data directly from the original data source.

• Examples: Extract Refresh is useful when working with large datasets to improve performance, while Data Source Refresh ensures real-time data upda
Answered by AI
Add your answer
Q3. Difference in Extract and live connection.
Ans. 
Extract connection imports data into Tableau workbook while live connection directly connects to data source.
• Extract connection creates a static snapshot of data in Tableau workbook.

• Live connection directly queries data from the source in real-time.

• Extract connection is useful for large datasets or when offline access is needed.

• Live connection is beneficial for real-time data analysis and dynamic updates.

• Example: Extra...read more
Answered by AI
Add your answer

2 leetcode easy questions were asked

Data science case study

Q1. Why would you join us
Add your answer

Q1. Related to core concepts like OS, DBMS and OOPs
Add your answer

Q1. How do you do pruning
Ans. 
Pruning is a technique used in machine learning to reduce the size of decision trees by removing unnecessary branches.
• Pruning helps prevent overfitting by simplifying the model

• There are two main types of pruning: pre-pruning and post-pruning

• Pre-pruning involves setting a limit on the depth of the tree or the number of leaf nodes

• Post-pruning involves removing branches that do not improve the overall accuracy of the tree

• ...read more
Answered by AI
Add your answer

Basic Aptitude questions

Q1. SQL Python Basic Commands and coding
Add your answer

It was basic aptitude but it was online

Q1. Write python code for bizzbuss for prime or not prime\
Ans. 
Python code for determining if a number is prime or not and applying bizzbuzz logic.
• Write a function to check if a number is prime or not

• Iterate through a range of numbers and apply bizzbuzz logic

• Return 'prime' if the number is prime, 'bizz' if divisible by 3, 'buzz' if divisible by 5, and 'bizzbuzz' if divisible by both 3 and 5
Answered by AI
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