Redcliffe Labs Data Analyst Interview Questions and Answers

Q1. Advance excel, pivot, Power pivot
Add your answer

Data analysis in excel

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

Q1. Brief your self and tell the details about your past experience.
Add your answer

Q1. What is Ms Excel and how much knowledge about it .
Ans. 
Ms Excel is a spreadsheet program developed by Microsoft for data entry, analysis, and visualization.
• Ms Excel is used for organizing data into rows and columns.

• It allows users to perform calculations, create charts, and analyze data.

• Functions like SUM, AVERAGE, and VLOOKUP are commonly used in Excel.

• Excel can be used for budgeting, financial analysis, and project management.

• Knowledge of formulas, functions, and formatt...read more
Answered by AI
Add your answer

Q1. Normal tell about his company and fulfill my doubts .
Add your answer

Q1. What are your salary expectations?
View 3 more answers
Q2. What is your family background?
View 1 more answer
Q3. Share details of your previous job.
View 2 more answers
Q4. Tell me about yourself.
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. Advance excel, pivot, Power pivot
Add your answer

Data analysis in excel

Q1. Why do you want to work here?
Add your answer
Q2. Explain a tough situation, which you faced in your last experience?
Add your answer

Q1. How failed jobs will be reprocessed?
Ans. 
Failed jobs can be reprocessed by identifying the root cause of failure, fixing the issue, and resubmitting the job.
• Identify the reason for job failure by checking logs and error messages.

• Fix the issue causing the failure, such as correcting code errors or resolving resource constraints.

• Resubmit the job after making necessary changes to ensure successful processing.

• Implement monitoring and alerting systems to proactive...read more
Answered by AI
Add your answer
Q2. On-premise to cloud data migration.
Ans. 
Data migration from on-premise to cloud involves transferring data from local servers to cloud-based storage systems.
• Assess the current data infrastructure and identify the data to be migrated

• Choose a suitable cloud storage solution based on requirements and budget

• Plan the migration process including data extraction, transformation, and loading (ETL)

• Test the migration process to ensure data integrity and security

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