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
I applied via Referral and was interviewed in Aug 2021. There were 3 interview rounds.
Interview Questionnaire
6 Questions
- Q1. All types of Join from SQL ?
- Ans.
SQL has four types of joins: Inner Join, Left Join, Right Join, and Full Outer Join.
Inner Join returns only the matching rows from both tables.
Left Join returns all the rows from the left table and matching rows from the right table.
Right Join returns all the rows from the right table and matching rows from the left table.
Full Outer Join returns all the rows from both tables, with NULL values in the columns where there...
- Q2. What is Index in SQL ?
- Ans.
Index in SQL is a database object that improves the speed of data retrieval operations.
Index is created on one or more columns of a table.
It stores a copy of the data in the indexed columns in a separate structure.
This allows for faster search and retrieval of data.
Examples of index types include clustered, non-clustered, and unique indexes.
- Q3. Difference b/w char and varchar ?
- Ans.
Char is fixed length while varchar is variable length.
Char takes up the same amount of space for each value, while varchar only takes up as much space as needed.
Char is faster for fixed length data, while varchar is more flexible for variable length data.
Example: char(10) will always take up 10 characters, while varchar(10) will only take up as much space as needed for the value.
Example: char is commonly used for stori...
- Q4. What is substring ?
- Ans.
Substring is a part of a string that is smaller in length and extracted from the original string.
Substring is a sequence of characters within a string.
It can be extracted using string slicing or substring functions.
For example, 'hello world'[0:5] will return 'hello'.
- Q5. What is normalization ?
- Ans.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a database into smaller, more manageable tables
Each table should have a primary key that uniquely identifies each record
Data is then organized into related tables to minimize redundancy
Normalization helps to prevent data inconsistencies and anomalies
There are different level...
- Q6. Some questions from accounting
Interview Preparation Tips
Skills evaluated in this interview
(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
What people are saying about PwC
Selected
I was interviewed in Sep 2024.
Good questions on power bi
Duration 45 min with current affairs topics
PwC interview questions for designations
(1 Question)
- Q1. Self intro was asked
Get interview-ready with Top PwC Interview Questions
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
Data Analyst Jobs at PwC
Logical , Reasoning questions
2 program questions of Dsa
(1 Question)
- Q1. Array , linked list
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
