"-- Write your query here
with cte as (
select departmentid,tochar(orderdate,'MM-YYYY') as d,SUM(orderamount) as revenue
from orders
where tochar(orderdate,'MM-YYYY') in ('11-2022','12-2022')
GROUP BY department_id,d
),
b as
(Select *,LEAD(revenue) OVER(PARTITION BY departmentid ORDER BY d ) as decrevenue
from cte
)
Select distinct o.departmentid,c.departmentname,
(o.decrevenue-o.revenue) as momincrease
from b o
JOIN departments c on
o.departmentid=c.departmentid
where o.dec_revenue"
Mayank G. - "-- Write your query here
with cte as (
select departmentid,tochar(orderdate,'MM-YYYY') as d,SUM(orderamount) as revenue
from orders
where tochar(orderdate,'MM-YYYY') in ('11-2022','12-2022')
GROUP BY department_id,d
),
b as
(Select *,LEAD(revenue) OVER(PARTITION BY departmentid ORDER BY d ) as decrevenue
from cte
)
Select distinct o.departmentid,c.departmentname,
(o.decrevenue-o.revenue) as momincrease
from b o
JOIN departments c on
o.departmentid=c.departmentid
where o.dec_revenue"See full answer
"a) What metric should be focused on for improving customer value creation, and why?
I may the metric is user engagement. We can dive into groups of users, and the newbies' actions will not be the same as the old hands.
The engaging frequency and time must be defined and tracked because it shows whether users (as a workspace) are accustomed to Clickup or not.
b) Share the potential feature points that can improve the above metric, explain your rationale for each and the expected"
Freddie - "a) What metric should be focused on for improving customer value creation, and why?
I may the metric is user engagement. We can dive into groups of users, and the newbies' actions will not be the same as the old hands.
The engaging frequency and time must be defined and tracked because it shows whether users (as a workspace) are accustomed to Clickup or not.
b) Share the potential feature points that can improve the above metric, explain your rationale for each and the expected"See full answer
Product Manager
Analytical
+1 more
🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.
"Ask Follow up Questions
Is this for specific type of user or open?
Do we have any past research that has been done?
Do we have an idea of company and user goals?
Do we have metrics of success?
Are there any existing constraints?
Why | 5 min
Why is this product or feature important?
How does this product benefit customers?
What business opportunities does it create?
What is our hypothesis?
What are our company goals?
Who | 3 min
Who are the different types"
Ben G. - "Ask Follow up Questions
Is this for specific type of user or open?
Do we have any past research that has been done?
Do we have an idea of company and user goals?
Do we have metrics of success?
Are there any existing constraints?
Why | 5 min
Why is this product or feature important?
How does this product benefit customers?
What business opportunities does it create?
What is our hypothesis?
What are our company goals?
Who | 3 min
Who are the different types"See full answer
"1) Start by clarifying your constraints - which side of the marketplace am I focusing on and what are they solving for? (e.g., minimize cost for hoster, maximize comfort for renter indoor etc.). Assuming this is a "dealer's choice" type response then proceed to step 2
2) Where to focus: which customer segment, which job-to-be-done, and why
I'd start by laying out segments on 2 dimensions: urban (think big cities, downtowns) and suburban (think suburbs, beach towns, mountains) areas focused on e"
Anonymous Spider - "1) Start by clarifying your constraints - which side of the marketplace am I focusing on and what are they solving for? (e.g., minimize cost for hoster, maximize comfort for renter indoor etc.). Assuming this is a "dealer's choice" type response then proceed to step 2
2) Where to focus: which customer segment, which job-to-be-done, and why
I'd start by laying out segments on 2 dimensions: urban (think big cities, downtowns) and suburban (think suburbs, beach towns, mountains) areas focused on e"See full answer
"I will start by asking some of the clarifying questions here -
Does the interviewer want me to focus on any specific region or it's a global product -
What's the timeline we are looking over here -
Any specific problem statement that I should be focusing on -
Any specific objective that they want me to drive
Some of these questions will help to get my head straight and align myself with the interviewer.
(2 mins to jot down my thoughts )
Answer -
Problem statement : Will focus on the cha"
Dhirendra S. - "I will start by asking some of the clarifying questions here -
Does the interviewer want me to focus on any specific region or it's a global product -
What's the timeline we are looking over here -
Any specific problem statement that I should be focusing on -
Any specific objective that they want me to drive
Some of these questions will help to get my head straight and align myself with the interviewer.
(2 mins to jot down my thoughts )
Answer -
Problem statement : Will focus on the cha"See full answer
"· Support team members to grow, people oriented, have ability to deal with underperformers, influential and motivational skills
· Can deal with multiple releases and able to manage resource crunch"
BePostive - "· Support team members to grow, people oriented, have ability to deal with underperformers, influential and motivational skills
· Can deal with multiple releases and able to manage resource crunch"See full answer
"To speed up A/B tests results with limited sample sizes, we can apply advanced techniques like CUPED to reduce variance for faster statistical significance, interleaving to gather more comparative data per user (e.g., ranking), MAB to dynamically allocate traffic to winning variations for quicker optimization (e.g., campaigns), and Bayesian A/B testing which offers probabilistic conclusions that can be reached earlier. Each method, when appropriately applied, allows you to gain m"
Lucas G. - "To speed up A/B tests results with limited sample sizes, we can apply advanced techniques like CUPED to reduce variance for faster statistical significance, interleaving to gather more comparative data per user (e.g., ranking), MAB to dynamically allocate traffic to winning variations for quicker optimization (e.g., campaigns), and Bayesian A/B testing which offers probabilistic conclusions that can be reached earlier. Each method, when appropriately applied, allows you to gain m"See full answer
"Clarify:
Across all platforms? - Yes
Specific geographies? - No
Any specific users? Like >60 years - No
Benefits of profile picture:
User can find their friends by identifying them through profile picture.
Helps in understanding if the profile is genuine. Also establishes trust in the platform.
Users checking profiles is also a way for users to engage on the platform.
Possible decisions:
Remove profile upload feature
Make it optional
No change
Approach to make decis"
Nishant V. - "Clarify:
Across all platforms? - Yes
Specific geographies? - No
Any specific users? Like >60 years - No
Benefits of profile picture:
User can find their friends by identifying them through profile picture.
Helps in understanding if the profile is genuine. Also establishes trust in the platform.
Users checking profiles is also a way for users to engage on the platform.
Possible decisions:
Remove profile upload feature
Make it optional
No change
Approach to make decis"See full answer
"Clarifying Qs:
Question: Would this be a standalone platform, or be integrated into the existing LinkedIn web application and mobile applications?
Answer: Integrated into the existing LinkedIn web application and mobile applications.
Question: What are the goals of a video conferencing platform for LinkedIn?
Answer: You decide.
Let's think about LinkedIn's mission statement, which is to connect the world's professionals to make them more productive and successful. LinkedIn's co"
Jessica A. - "Clarifying Qs:
Question: Would this be a standalone platform, or be integrated into the existing LinkedIn web application and mobile applications?
Answer: Integrated into the existing LinkedIn web application and mobile applications.
Question: What are the goals of a video conferencing platform for LinkedIn?
Answer: You decide.
Let's think about LinkedIn's mission statement, which is to connect the world's professionals to make them more productive and successful. LinkedIn's co"See full answer
"After clarifying the question, answered in following way:
Defined what is Google Map. Discussed its history and dominant #1 current market position
Aligned with the Google's mission
Listed few users segments and few features for roadmap and discussed technology advancements & need to continue to innovate and differentiate aggressively"
Anonymous Tapir - "After clarifying the question, answered in following way:
Defined what is Google Map. Discussed its history and dominant #1 current market position
Aligned with the Google's mission
Listed few users segments and few features for roadmap and discussed technology advancements & need to continue to innovate and differentiate aggressively"See full answer
"Some clarifying questions:
Is this going to be a part of exciting Meta product or completely new one? you choose
Is there a particular sport or range of sports that the product should cater to? all sports, should be agnostic.
What is "athletes"? pros? amateurs? fitness enthusiasts? you can decide
Is there a specific problems or challenges faced by athletes does he want the product to address? feel free to make assumptions
Is there a specific goal that we want to achieve"
R K. - "Some clarifying questions:
Is this going to be a part of exciting Meta product or completely new one? you choose
Is there a particular sport or range of sports that the product should cater to? all sports, should be agnostic.
What is "athletes"? pros? amateurs? fitness enthusiasts? you can decide
Is there a specific problems or challenges faced by athletes does he want the product to address? feel free to make assumptions
Is there a specific goal that we want to achieve"See full answer
"I'll approach this by asking questions and creating scenarios based on answers. If the answer to any questions points to a specific issue, I'll double down on that to understand the issue. This is more of a RCA question.
First I'll quickly check
Were there any recent updates released before we observed the drops?
Assuming Yes, I'll check the updates released and check the test cases and testing results
If the issue is identified, I will engage with the product leadership, update them and conne"
Aekagra S. - "I'll approach this by asking questions and creating scenarios based on answers. If the answer to any questions points to a specific issue, I'll double down on that to understand the issue. This is more of a RCA question.
First I'll quickly check
Were there any recent updates released before we observed the drops?
Assuming Yes, I'll check the updates released and check the test cases and testing results
If the issue is identified, I will engage with the product leadership, update them and conne"See full answer
"Define Groups: Platform where users ( organizers and members) with shared interests can come together and express their thoughts and opinions.
Meta's mission: To bring ppl closer together by giving them access to tools and technology.
Groups Mission alignment: Gives Organizers and members to come closer together over shared interests and build community.
Users :
Organizers ( create a group-> invite people on the platform --> can accept or deny a member to the group --> Intera"
Anjali M. - "Define Groups: Platform where users ( organizers and members) with shared interests can come together and express their thoughts and opinions.
Meta's mission: To bring ppl closer together by giving them access to tools and technology.
Groups Mission alignment: Gives Organizers and members to come closer together over shared interests and build community.
Users :
Organizers ( create a group-> invite people on the platform --> can accept or deny a member to the group --> Intera"See full answer