Add office photos
Filter interviews by
Pharmaace Analytics Senior Consultant Interview Questions and Answers
Pharmaace Analytics Senior Consultant Interview Experiences
1 interview found
Rahul Udhwani
(2 Questions)
- Q1. Cumulative Sum in SQL
- Ans.
Cumulative sum in SQL is a running total of a column's values.
Use the SUM() function with the OVER() clause to calculate the cumulative sum.
The OVER() clause specifies the partitioning and ordering of rows for the calculation.
Example: SELECT column_name, SUM(column_name) OVER (ORDER BY column_name) AS cumulative_sum FROM table_name;
- Q2. Case When in SQL
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Anonymous
Selected
(1 Question)
- Q1. How to get the last row of any SAS dataset
- Ans.
Use the OBS option in a SET statement to read the last observation of a SAS dataset.
Use the OBS option in a SET statement followed by the keyword 'END' to read the last observation of a SAS dataset.
For example, to read the last observation of a dataset named 'mydata', use the following code: data lastobs; set mydata(obs=last end=last); run;
Skills evaluated in this interview
Selected
(1 Question)
- Q1. Technical round about business analyst
Business case study about hyper local delivery model. Cash management with delivery boys was at crux
(1 Question)
- Q1. Normal HR round
Selected
I applied via Approached by Company and was interviewed in Feb 2023. There were 2 interview rounds.
(2 Questions)
- Q1. What you did in primary nd secondary research in your previous job
- Q2. How yor fits into this position
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Aug 2023. There was 1 interview round.
(2 Questions)
- Q1. KPI's for CLI and CLD
- Ans.
Key Performance Indicators (KPIs) for Customer Lifetime Income (CLI) and Customer Lifetime Duration (CLD)
CLI KPIs could include average revenue per customer, customer retention rate, customer lifetime value
CLD KPIs could include average customer lifespan, customer churn rate, customer engagement metrics
Tracking CLI and CLD KPIs can help measure the financial impact and longevity of customer relationships
- Q2. Credit score variables and impact on strategy
- Ans.
Credit score variables impact strategy by influencing lending decisions and interest rates.
Credit score variables include payment history, credit utilization, length of credit history, types of credit used, and new credit accounts.
Higher credit scores typically result in lower interest rates and more favorable lending terms.
Lenders use credit scores to assess risk and determine the likelihood of repayment.
Strategies ma...
Selected
I applied via campus placement at Indian Institute of Technology (IIT), Kanpur and was interviewed before Nov 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Questions related to my work experience
- Q2. A case study on how to improve sales using website analytics management and email marketing
(2 Questions)
- Q1. Questions about past projects
- Q2. Case on use of analytics in a retail sector. How would you as a consultant, structure the whole process (as the job was for an assistant project manager)
Interview Preparation Tips
2. Clear thought process and ability to demonstrate learning nature is a good tool to have
Selected
I applied via Naukri.com and was interviewed before Nov 2023. There were 3 interview rounds.
Basic SQL join and Python data wrangling questions.
(1 Question)
- Q1. Metrics that can be useful in a defined dataset.
- Ans.
Metrics such as mean, median, mode, standard deviation, and range can be useful in analyzing a defined dataset.
Mean: average value of the dataset
Median: middle value of the dataset when arranged in ascending order
Mode: most frequently occurring value in the dataset
Standard deviation: measure of the amount of variation or dispersion of a set of values
Range: the difference between the maximum and minimum values in the da
(1 Question)
- Q1. Salary discussion
Selected
I applied via Company Website and was interviewed before Sep 2023. There was 1 interview round.
(2 Questions)
- Q1. What are your biggest strengths and weaknesses?
- Ans.
My biggest strengths include strong analytical skills and effective communication. My weaknesses are sometimes being too detail-oriented and struggling with delegation.
Strengths: strong analytical skills
Strengths: effective communication
Weaknesses: being too detail-oriented
Weaknesses: struggling with delegation
- Q2. Have you led a team before?
- Ans.
Yes, I have led multiple teams in previous roles.
Led a team of 5 consultants in a project for a major client
Managed a team of analysts in developing a new data analytics tool
Coordinated a team of developers in implementing a software upgrade
(1 Question)
- Q1. All questions according to cv.
(1 Question)
- Q1. Managerial and technical
(1 Question)
- Q1. Behavioural question
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
(2 Questions)
- Q1. Rank vs dense rank
- Ans.
Rank assigns unique ranks to each distinct row, while dense rank assigns consecutive ranks to rows with the same values.
Rank function is used to assign a unique rank to each distinct row based on the specified column(s).
Dense rank function is used to assign consecutive ranks to rows with the same values, without any gaps.
For example, if we have scores of 90, 85, 85, 80, then rank would assign ranks as 1, 2, 2, 4 while
- Q2. Row level security
Skills evaluated in this interview
Pharmaace Analytics Interview FAQs
Tell us how to improve this page.
Pharmaace Analytics Interviews By Designations
Interview Questions for Popular Designations
- Associate Consultant Interview Questions
- Senior Associate Consultant Interview Questions
- Lead Consultant Interview Questions
- Technical Consultant Interview Questions
- Consultant Interview Questions
- Associate Technical Consultant Interview Questions
- Principal Consultant Interview Questions
- Technology Consultant Interview Questions
- Show more
Pharmaace Analytics Senior Consultant Interview Process
based on 1 interview
Interview experience
Senior Consultant Interview Questions from Similar Companies
Pharmaace Analytics Senior Consultant Reviews and Ratings
based on 3 reviews
Rating in categories
|
Associate Consultant
80
salaries
|  ₹6.3 L/yr - ₹15 L/yr |
|
Consultant
79
salaries
| ₹7 L/yr - ₹21.5 L/yr |
|
Analyst
53
salaries
| ₹5 L/yr - ₹10 L/yr |
|
Senior Consultant
22
salaries
| ₹9.2 L/yr - ₹33 L/yr |
|
Project Manager
16
salaries
| ₹14 L/yr - ₹34 L/yr |
IQVIA
Cognizant
Accenture
TCS
- Home >
- Interviews >
- Pharmaace Analytics Interview Questions >
- Pharmaace Analytics Senior Consultant Interview Questions
