Philips Innovation Campus Senior Data Analyst Interview Questions and Answers

Q1. What time intelligence functions can be used for ytd and qtd analysis
Ans. 
Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.
• YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.

• QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.

• Thes...read more
Answered by AI
Add your answer
Q2. Difference between import and direct query
Ans. 
Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.
• Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.

• Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.

• Import is suitable for smaller datasets, while direct query is better for large da
Answered by AI
Add your answer

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

Q1. What is a data table
Ans. 
A data table is a collection of rows and columns used to organize and display data in a structured format.
• Data tables are commonly used in databases and spreadsheets to store and manipulate data.

• Each row in a data table represents a record or entry, while each column represents a specific attribute or field.

• Data tables can be sorted, filtered, and analyzed to extract meaningful insights from the data.

• Examples of data t...read more
Answered by AI
Add your answer

Q1. All power bi questions
Add your answer
Q2. Sql questions and excel questions
Add your answer

Q1. Question related to experience and skills
Add your answer

Q1. Healthcare experience related to the medical coding?
Add your answer

Power bi test which ask you to make a dashboard

Basic communication round