The Press ganey Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Press ganey Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Press ganey? The Press ganey Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Press ganey Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Press ganey.</li>
<li>Practice real Press ganey Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Press ganey Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Press ganey? The Press ganey Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Press ganey Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Press ganey.
- Practice real Press ganey Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Press ganey Business Intelligence interview.
        

Overview

Press ganey Business Intelligence Salary

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Press ganey Business Intelligence Interview Process

<p>We’re given a table of bank transactions with three columns, <code>user_id</code>, a deposit or withdrawal value (determined if the value is positive or negative), and <code>created_at</code> time for each transaction.</p>

<p>Write a query to get the total three-day rolling average for deposits by day.</p>

<p><em>Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout</em></p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>bank_transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>transaction_value</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>dt</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>rolling_three_day</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Rolling Bank Transactions

<p>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>transactions</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p> 
<strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

<p>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</code> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Manager Team Sizes

Press ganey Business Intelligence Interview Questions

<div>
<b>Company Description</b>
<p>PG Forsta is the leading experience measurement, data analytics, and insights provider for complex industries—a status we earned over decades of deep partnership with clients to help them understand and meet the needs of their key stakeholders. Our earliest roots are in U.S. healthcare –perhaps the most complex of all industries. Today we serve clients around the globe in every industry to help them improve the Human Experiences at the heart of their business. We serve our clients through an unparalleled offering that combines technology, data, and expertise to enable them to pinpoint and prioritize opportunities, accelerate improvement efforts and build lifetime loyalty among their customers and employees.</p>
<p>Like all great companies, our success is a function of our people and our culture. Our employees have world-class talent, a collaborative work ethic, and a passion for the work that have earned us trusted advisor status among the world’s most recognized brands. As a member of the team, you will help us create value for our clients, you will make us better through your contribution to the work and your voice in the process. Ours is a path of learning and continuous improvement; team efforts chart the course for corporate success.</p>
<p><b> Our Mission: </b> We empower organizations to deliver the best experiences. With industry expertise and technology, we turn data into insights that drive innovation and action.</p>
<p><b> Our Values: </b> To put Human Experience at the heart of organizations so every person can be seen and understood.</p>
<ul>
<li><b> Energize the customer relationship:</b> Our clients are our partners. We make their goals our own, working side by side to turn challenges into solutions.</li>
<li><b> Success starts with me:</b> Personal ownership fuels collective success. We each play our part and empower our teammates to do the same.</li>
<li><b> Commit to learning:</b> Every win is a springboard. Every hurdle is a lesson. We use each experience as an opportunity to grow.</li>
<li><b> Dare to innovate:</b> We challenge the status quo with creativity and innovation as our true north.</li>
<li><b> Better together:</b> We check our egos at the door. We work together, so we win together.</li>
</ul>
<b> Job Description</b>
<p>Press Ganey is seeking a Senior Technical Product Manager with specialized experience in managing FedRAMP authorized products. This role is critical in overseeing our survey and nursing quality platforms, especially those utilized by government clients. Reporting to the Chief Product Officer, this Senior Technical Product Manager will collaborate closely with engineering, risk and compliance, and government clients and federal agencies. This position ensures that government product offerings and enhancements meet our client needs while achieving and/or maintaining FedRAMP authorization, upholding the highest standards of security and compliance.</p>
<p><b>Key Responsibilities:</b></p>
<ul>
<li>Manage the technical product development lifecycle of FedRAMP-authorized products.</li>
<li>Lead efforts to achieve and maintain FedRAMP authorization, collaborating with internal teams and external agencies.</li>
<li>Work closely with the product organization, engineering, risk, security, and compliance teams to provide FedRAMP compliant product offerings, enhancements, updates, and ongoing maintenance of monitoring and compliance.</li>
<li>Serve as the primary product liaison for government clients, ensuring their specific needs are met and that our products enhance their operational efficiency.</li>
<li>Cross-functionally collaborate to continuously lead and improve technical product roadmaps, delivery plans, cutover and implementation plans, process improvements, and governance structures as related to FedRAMP authorized offerings.</li>
</ul>
<b> Qualifications</b>
<ul>
<li>7-10 years of experience as a technical product manager, preferably within in a regulated healthcare environment.</li>
<li>Proven expertise in managing FedRAMP-authorized products and a deep understanding of FedRAMP requirements, processes, and agencies.</li>
<li>Technical background with a strong grasp of product management practices in healthcare or related fields.</li>
<li>Experience with VA or other US government organizations is ideal but not required, demonstrating an understanding of the unique challenges and requirements of this client base.</li>
<li>Excellent communication and collaboration skills, capable of working effectively across multiple departments and with various stakeholders including executives.</li>
</ul>
<b> Additional Information</b>
<p>Press Ganey Associates LLC is an Equal Employment Opportunity/Affirmative Action employer and well committed to a diverse workforce. We do not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, veteran status, and basis of disability or any other federal, state or local protected class.</p>
<p>Pay Transparency Non-Discrimination Notice – Press Ganey will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.</p>
<p>The expected base salary for this position ranges from $150,000-$250,000. It is not typical for offers to be made at or near the top of the range. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, licensure or certifications obtained. Market and organizational factors are also considered. In addition to base salary and a competitive benefits package, successful candidates are eligible to receive a discretionary bonus or commission tied to achieved results.</p>
<p>All your information will be kept confidential according to EEO guidelines.</p>
</div>
#J-18808-Ljbffr

Press ganey Business Intelligence Interview Guide

Overview

Press ganey Business Intelligence Salary

Press ganey Business Intelligence Interview Process

Press ganey Business Intelligence Interview Questions

Press ganey Business Intelligence Jobs