Fujitsu Data Analyst Interview Questions and Answers

Q1. Can you tell me about yourself? Why do you want to work as a data analyst? What do you know about our company?
Add your answer
Q2. What are your short-term and long-term career goals in the field of data analysis? Why do you wish to pursue a career in data analysis? What factors motivate you to work in a data-driven environment?
Add your answer

Q1. What are the different kinds of joins
Ans. 
Different kinds of joins include inner join, outer join, left join, and right join.
• Inner join: Returns only the rows that have matching values in both tables.

• Outer join: Returns all rows when there is a match in one of the 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.
Answered by AI
Add your answer
Q2. What is the difference between columns and measures in power BI
Ans. 
Columns are the fields in a dataset, while measures are calculations based on those fields in Power BI.
• Columns are the raw data fields in a dataset, such as 'Sales Amount' or 'Product Category'.

• Measures are calculations performed on columns, like sum, average, count, etc.

• Measures are created using DAX (Data Analysis Expressions) in Power BI.

• Columns are used for grouping, filtering, and slicing data, while measures are
Answered by AI
Add your answer
Q3. How can you remove duplicates in sql
Ans. 
Use the DISTINCT keyword in a SELECT statement to remove duplicates in SQL.
• Use the DISTINCT keyword in a SELECT statement to retrieve unique values.

• Example: SELECT DISTINCT column_name FROM table_name;

• Another way is to use the GROUP BY clause to remove duplicates.

• Example: SELECT column_name FROM table_name GROUP BY column_name;
Answered by AI
Add your answer

Q1. Self introduction
Add your answer
Q2. Previous job experiences
Add your answer

Q1. Can you describe a challenging situation at work and how you handled it ?
Add your answer
Q2. How do you prioritize tasks when you have multiple deadlines to meet
Ans. 
I prioritize tasks based on deadlines, importance, and impact on overall goals.
• I start by identifying all tasks and their respective deadlines.

• I prioritize tasks based on the urgency of the deadline and the impact on overall goals.

• I break down larger tasks into smaller, manageable sub-tasks to ensure progress is made consistently.

• I communicate with stakeholders to set realistic expectations and adjust priorities if nec...read more
Answered by AI
Add your answer

Q1. Question related to SQL, Tableau and some problem statements. Challenges faced in work environment.
Add your answer

Q1. Work experience. Challenges faced in work. Type of visualization for a specific type of problem.
Ans. 
Work experience, challenges faced, and visualization types for specific problems.
• Work experience: Mention relevant job roles and responsibilities.

• Challenges faced: Discuss specific challenges encountered and how they were overcome.

• Visualization types: Provide examples of visualizations used for different types of problems.
Answered by AI
Add your answer

Q1. Work experience, expectations etc.
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

There were around 30 questions ranging from DBMS, OOPS + 2 coding questions to be solved in 90 minutes. MCQ's were easy to solve as they had been covered in my college's curriculum. It was a webcam monitored test.

Q1. 
Chocolate Distribution Problem
You are given an array/list CHOCOLATES of size 'N', where each element represents the number of chocolates in a packet. Your task is to distribute these chocolates among 'M'...read more
View 2 more answers
Q2. 
Ninja and Substrings Problem Statement
Ninja has to determine all the distinct substrings of size two that can be formed from a given string 'STR' comprising only lowercase alphabetic characters. These su...read more
View 2 more answers

Round duration - 50 minutes
Round difficulty - Medium

This was a technical round. I got the call after getting shortlisted in the Aptitude + Coding test. This round lasted for 50 minutes and started around 12 PM. The meeting was conducted on a Microsoft Teams call. 
I was asked questions based on my resume and my projects for the most part of the interview. Towards the end of the interview, I was asked 1 Problem based on Prefix arrays. Initially I presented the brute force O(N*2) solution followed by the optimal O(N) solution. This round went good for me.

Q1. 
Time to Burn Tree Problem
You are given a binary tree consisting of 'N' unique nodes and a start node where the burning will commence. The task is to calculate the time in minutes required to completely b...read more
View 1 more answer

It's very good