AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
PwC Data Analyst Interview Questions, Process, and Tips
Top PwC Data Analyst Interview Questions and Answers
- Q1. Write a query where all the customer name start with A
- Q2. Compare 2 scorce files record count and print if their are equally or not
- Q3. What is Index in SQL ?
PwC Data Analyst Interview Experiences
15 interviews found
Anonymous
(2 Questions)
- Q1. Explain all types of joins
- Ans.
Different types of joins in SQL are inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a match in both 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
Full outer join: Returns rows when there is a match in either table
- Q2. Difference between having and where
- Ans.
The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions to filter groups, while 'where' is used to filter rows.
HAVING is used with GROUP BY to filter groups based on aggregate functions results
WHERE is used to filter rows based on conditions
HAVING is applied after GROUP BY, while WHERE is applied before GROUP BY
Example: SELECT department, AVG(salary) FROM employees GROU...
Skills evaluated in this interview
Shakthi
Behavioural Tests,Quants, basic Excel functions
(1 Question)
- Q1. About the firm and interests
What do you think about electric cars
(1 Question)
- Q1. It was completely about competency questions
Selected
I was interviewed in Sep 2024.
Good questions on power bi
Duration 45 min with current affairs topics
What people are saying about PwC
(1 Question)
- Q1. Self intro was asked
PwC interview questions for designations
Selected
I applied via Approached by Company and was interviewed in Mar 2024. There was 1 interview round.
(1 Question)
- Q1. What is SQL and How to use in Data Analyst ? What Difference Between NO SQL and SQL ? Difference Between RDBMS and DBMS ?
- Ans.
SQL is a programming language used for managing and manipulating relational databases. NoSQL is a non-relational database management system. RDBMS is a type of DBMS that stores data in a structured format.
SQL (Structured Query Language) is used to manage and manipulate data in relational databases.
Examples of SQL commands include SELECT, INSERT, UPDATE, and DELETE.
NoSQL databases are non-relational and do not use SQL. ...
Interview Preparation Tips
Skills evaluated in this interview
Get interview-ready with Top PwC Interview Questions
Logical , Reasoning questions
2 program questions of Dsa
(1 Question)
- Q1. Array , linked list
Data Analyst Jobs at PwC
Selected
I applied via Recruitment Consulltant and was interviewed in Jan 2023. There were 4 interview rounds.
Good communication skills Strongly time management
(2 Questions)
- Q1. Tell me about your self
- Q2. Salary expectation. And time management
(1 Question)
- Q1. All about experience
Interview Preparation Tips
I applied via Approached by Company and was interviewed in Oct 2022. There was 1 interview round.
(2 Questions)
- Q1. Informatica: All scenario based questions. When aggregator will fail, need top and bottom 1 salary.
- Q2. Compare 2 scorce files record count and print if their are equally or not
- Ans.
Compare record count of 2 score files and print if they are equal or not.
Read both score files
Count the number of records in each file
Compare the record counts
Print if they are equal or not
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before Dec 2022. There were 4 interview rounds.
(2 Questions)
- Q1. Tell me about yourself.
- Ans.
I am a data analyst with a strong background in statistics and programming.
I have a Bachelor's degree in Statistics and have completed several courses in data analysis and programming.
I have experience working with large datasets and using statistical software such as R and Python.
I have successfully analyzed data to identify trends, patterns, and insights that have helped inform business decisions.
I am skilled in data...
- Q2. Why do you want to join PwC
- Ans.
I want to join PwC because of their reputation for excellence in data analysis and their commitment to professional development.
PwC is known for its expertise in data analysis and has a strong reputation in the industry.
I am impressed by PwC's commitment to professional development and continuous learning opportunities.
PwC's diverse client base will provide me with exposure to a wide range of data analysis projects.
I b...
We were given a case study to solve. End-to-end. Tableau/Power BI. 3hrs
(1 Question)
- Q1. Telephonic Operation Round. Where do you see yourself in 5 years? Salary Expectations
Interview Preparation Tips
- Tableau
- Power Bi
- Alteryx
- SQL
- Python
- Advanced Excel
Selected
I applied via campus placement at Birla Institute of Technology (BIT), Ranchi and was interviewed before Apr 2023. There were 2 interview rounds.
Pretty easy , questions were mostly around SQL coding
(2 Questions)
- Q1. General behavioural questions
- Q2. Tell me about yourself Why PwC Why are you switching now
PwC Interview FAQs
Tell us how to improve this page.
PwC Interviews By Designations
- PwC Associate Interview Questions
- PwC Senior Associate Interview Questions
- PwC Consultant Interview Questions
- PwC Associate2 Interview Questions
- PwC Associate Consultant Interview Questions
- PwC Manager Interview Questions
- PwC Senior Consultant Interview Questions
- PwC Technology Consultant 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
PwC Data Analyst Interview Process
based on 10 interviews
2 Interview rounds
- Resume Shortlist Round
- HR Round
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
PwC Data Analyst Reviews and Ratings
based on 48 reviews
Rating in categories
|
Senior Associate
15.2k
salaries
|  ₹8 L/yr - ₹30 L/yr |
|
Associate
13.1k
salaries
| ₹4.8 L/yr - ₹17 L/yr |
|
Manager
6.8k
salaries
| ₹14 L/yr - ₹45 L/yr |
|
Senior Consultant
4.4k
salaries
| ₹9 L/yr - ₹32.8 L/yr |
|
Associate2
4.2k
salaries
| ₹4.6 L/yr - ₹16.5 L/yr |
Deloitte
Ernst & Young
Accenture
TCS
- Home >
- Interviews >
- PwC Interview Questions >
- PwC Data Analyst Interview Questions
