Add office photos
i
DXC Technology
Compare
Filter interviews by
DXC Technology Data Analyst Interview Questions and Answers
DXC Technology Data Analyst Interview Experiences
1 interview found
Anonymous
I applied via Referral and was interviewed in May 2022. There were 2 interview rounds.
It's very good
Interview Preparation Tips
Interview questions from similar companies
RISHABH Pal
Selected
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
The Aptitude Test session accesses mathematical and logical reasoning abilities
(6 Questions)
- Q1. What is Vlookup
- Ans.
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Vlookup stands for 'Vertical Lookup'
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...
- Q2. Some IF else Question in Excel
- Q3. What does your day in your previous organization look like?
- Ans.
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
Reviewing and cleaning large datasets to ensure accuracy
Creating visualizations and reports to communicate insights
Collaborating with team members to identify trends and patterns
Presenting findings to stakeholders in meetings or presentations
- Q4. Could you share the technical skills you possess?
- Ans.
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
Proficient in programming languages such as Python, R, SQL
Skilled in statistical analysis and data modeling techniques
Experience with data visualization tools like Tableau, Power BI
Knowledge of machine learning algorithms and techniques
- Q5. Can you explain what a Pivot Table is?
- Ans.
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.
Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.
Pivot tables are commonly used in Excel and other spreadsheet program...
- Q6. Find the Highest-paid employee in each department along with their salary and department name.
- Ans.
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
Group employees by department
Find the employee with the highest salary in each group
Retrieve the employee's name, salary, and department name
Interview Preparation Tips
- SQL
- Excel
- Problem Solving
- PowerBI
- SQL Queries
Be prepared to discuss past challenges and how did you overcome.
Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Can you provide an overview of your background, including your past experiences and daily activities, as well as the tools you use in your routine?
- Q2. What are the concepts of advanced Excel and Power BI projects, and how are they utilized within a company or for clients?
(2 Questions)
- Q1. Can you explain your project experience related to Advanced Excel and Power BI?
- Q2. What are the concepts of credit and operations, particularly in relation to Know Your Customer (KYC) procedures and the privacy of client data?
Interview Preparation Tips
I applied via Job Fair and was interviewed in Nov 2024. There were 2 interview rounds.
(2 Questions)
- Q1. DAX Related Syntax and Codes
- Q2. Data Modelling, SQL, Python
(1 Question)
- Q1. No Response from HR after calling of selection after Round 1
(2 Questions)
- Q1. What is the importance of data analysis?
- Q2. What steps should be taken to become a data analyst?
ananthakrishnan
Selected
I applied via Campus Placement and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. What is star topology
- Q2. Hybrid topology
Interview Preparation Tips
Nishu Goud
I applied via Walk-in and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. What is powerbi
- Ans.
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
Power BI is a data visualization tool used to create interactive reports and dashboards.
It allows users to connect to various data sources, clean and transform data, and create visually appealing reports.
Users can share and collaborate on reports with others, and access them on multiple dev...
- Q2. What is enumeration
- Ans.
Enumeration is the process of listing items in a specific order or sequence.
Enumeration is commonly used in programming to iterate through a list of items.
It helps in organizing and categorizing data for analysis.
Examples include counting the number of occurrences of specific values in a dataset.
General aptitude test numerical reasoning, verbaal
(2 Questions)
- Q1. Python question based on list.
- Q2. Python question based on data manipulation
Coding 2 questions java
(1 Question)
- Q1. Lot of questions based on resume Oops questions 2 basic coding
(1 Question)
- Q1. Basic questions
Pranita Wagh
Selected
I was interviewed in Dec 2024.
(2 Questions)
- Q1. Can you tell me about yourself? Why do you want to work as a data analyst? What do you know about our company?
- 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?
DXC Technology Interview FAQs
Tell us how to improve this page.
DXC Technology Interviews By Designations
- DXC Technology Associate Software Engineer Interview Questions
- DXC Technology Associate Professional Interview Questions
- DXC Technology Software Engineer Interview Questions
- DXC Technology Associate Professional Software Engineer Interview Questions
- DXC Technology Software Developer Interview Questions
- DXC Technology Associate Engineer Interview Questions
- DXC Technology Business Analyst Interview Questions
- DXC Technology Senior Assistant Service Delivery Coordinator 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
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
DXC Technology Data Analyst Reviews and Ratings
based on 26 reviews
Rating in categories
|
Associate Professional Software Engineer
2.2k
salaries
|  ₹2.6 L/yr - ₹7 L/yr |
|
Software Engineer
2k
salaries
| ₹2.4 L/yr - ₹11.7 L/yr |
|
Associate Professional
1.6k
salaries
| ₹0.8 L/yr - ₹7 L/yr |
|
Associate Software Engineer
1.2k
salaries
| ₹3 L/yr - ₹7 L/yr |
|
Professional 1
1.2k
salaries
| ₹3.4 L/yr - ₹14 L/yr |
Cognizant
Capgemini
TCS
Wipro
- Home >
- Interviews >
- DXC Technology Interview Questions >
- DXC Technology Data Analyst Interview Questions
