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 and Answers
9 Interview questions
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...
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
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
Query to generate state-wise sales summary report with ranking using multiple table joins.
Use SQL JOINs to combine sales, states, and products tables.
Aggregate sales data using SUM() function grouped by state.
Use RANK() or DENSE_RANK() to rank states based on total sales.
Example SQL: SELECT state, SUM(sales) AS total_sales, RANK() OVER (ORDER BY SUM(sales) DESC) AS sales_rank FROM sales_data JOIN states ON sales_d...
What people are saying about PwC
Query to retrieve all customer names starting with A.
Use the SELECT statement to retrieve customer names.
Use the LIKE operator with the pattern 'A%' to match names starting with A.
Specify the table and column name where the customer names are stored.
Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';
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 ...
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'.
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 ...
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 ...
PwC Data Analyst Interview Experiences
15 interviews found
Anonymous
(2 Questions)
- Q1. Explain all types of joins
- Q2. Difference between having and where
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 appeared for an interview in Sep 2024.
Good questions on power bi
Duration 45 min with current affairs topics
(1 Question)
- Q1. Self intro was asked
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
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
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 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
Some of the top questions asked at the PwC Data Analyst interview -
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
Overall Interview Experience Rating
based on 10 interview experiences
Difficulty level
Duration
Data Analyst Interview Questions from Similar Companies
PwC Data Analyst Reviews and Ratings
based on 54 reviews
Rating in categories
|
Senior Associate
19.2k
salaries
|  ₹12.5 L/yr - ₹25.3 L/yr |
|
Associate
15.3k
salaries
| ₹8 L/yr - ₹14 L/yr |
|
Manager
7.7k
salaries
| ₹23 L/yr - ₹41 L/yr |
|
Senior Consultant
4.9k
salaries
| ₹16 L/yr - ₹26.5 L/yr |
|
Associate2
4.7k
salaries
| ₹7.5 L/yr - ₹14 L/yr |
Deloitte
Ernst & Young
Accenture
TCS
- Home >
- Interviews >
- PwC Interview Questions
