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

Pdi Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Pdi? The Pdi 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 Pdi Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Pdi.</li>
<li>Practice real Pdi 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 Pdi Business Intelligence interview.</p>


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

- Know what skills are necessary for Pdi Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Pdi.
- Practice real Pdi 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 Pdi Business Intelligence interview.
        

Overview

Pdi 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.

Pdi 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>Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.</p>

<p>You wish to begin with the age group that is currently generating the most connections (fastest growing).</p>

<p>Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.</p>

<p><em>Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.</em></p>

<p><em>We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

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

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>requests_accepted</code></strong></p>

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

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong><code>age_groups</code></strong></p>

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

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

<tr>
<td>age_group</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>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>


Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

Pdi Business Intelligence Interview Questions

<strong>DESCRIPTION</strong> <br><br>Driven by a commitment to research, quality, and service, PDI provides innovative products, educational resources, training, and support to prevent infection transmission and promote health and wellness. Encompassing three areas, our Healthcare, Sani Professional and Contract manufacturing divisions, we develop, manufacture, and distribute leading edge products for North America and the world. We have several locations across the US and are looking for new Associates to join our team! <br><br><strong>POSITION PURPOSE</strong> <br><br>The R&D Manager, Packaging and Sustainability will focus on advancing PDI's strategic objectives to deliver innovative and sustainable product to our customers. This will include leading a high performing team of engineers and developing packaging and sustainability roadmaps. <br><br><strong>ESSENTIAL FUNCTIONS AND BASIC DUTIES</strong><br><br><strong>ESSENTIAL FUNCTIONS AND BASIC DUTIES</strong> <br><br>Responsibilities include leading the design, development and execution of packaging R&D programs and the execution of our R&D sustainability goals. It includes providing leadership to direct reports and cross functional team members to ensure product development programs are executed timely, compliant and meet the high standards aligned with PDI's mission.The position will also assist in the implementation of an organizational structure that supports successful delivery of innovation. <br><br> <ul><li>Acts as subject matter expert for packaging and ensure technical and business requirements are managed and met. </li><li>Provides input to program strategies, budgets, timelines, and project/product development plans. </li><li>Build cross-functional relationships to integrate R&D environmental sustainability initiatives into business practices; manage R&D related data and support reporting requirements. </li></ul>Leadership and Management <ul> <li>Reinforces PDI's culture and values, and drives change where needed to increase alignment with those goals. </li><li>Identifies departmental needs and assist with recruits/hires/promotes personnel as appropriate. </li><li>Develops staff through coaching, training, and other relevant experiences. Builds high performance teams. </li><li>Guides the reallocation of roles and responsibilities across team members to facilitate both goal achievement and personal development. </li></ul>Project Management <ul><li>Operates effectively in a multi-tasking, cross-functional environment, including managing network external collaborators and experts. </li><li>Analyzes and provides clear direction in areas of ambiguity or uncertainty, maintaining momentum and achieving alignment with cross-functional partners in these areas. </li><li>Demonstrates intellectual agility to work effectively and efficiently in the ever-evolving sustainability space, exhibiting the ability to identify and assess opportunities for prudent risk taking. </li><li>Develops appropriately proactive resource plans and utilizes staff and other resources effectively to meet area/partners' needs. Uses appropriate tools to regularly review, measure, modify, and adjust plans and to monitor the efficiency, effectiveness and balance of resources according to evolving business needs and environment. </li></ul><strong>PERFORMANCE MEASUREMENTS</strong><br><br><ol> <li>Meet key PDI business targets for packaging and sustainability. </li><li>Support, recruit, develop and retain an effective team, act as a model for the R&D organization </li></ol><br><br><strong>QUALIFICATIONS</strong><br><br><strong>EDUCATION/CERTIFICATION</strong><ul><li>Minimum of a bachelor's degree in Packaging Design or Engineering with a focus in Packaging materials and sustainability or equivalent experience </li></ul><strong>REQUIRED KNOWLEDGE</strong><ul><li>Knowledge of MS Office, TOPS or Cape, SolidWorks or Creo, AutoCAD, Adobe, and Minitab is preferred. </li><li>Technical knowledge of regulated products and packaging; FDA or EPA Regulated Environment </li><li>Familiar with laws and regulations on sustainability </li></ul><strong>EXPERIENCE REQUIRED</strong><ul><li>7+ years of relevant experience in packaging development and R&D support, with a demonstrated track record of successful product launches and scientific responsibilities </li><li>Previous experience in wipes packaging advantageous </li></ul><strong>SKILLS/ABILITIES</strong><ul><li>Excellent written and verbal communication skills. Capable of influencing opinion and sharing technical information and best practices through effective presentations to internal and external audiences </li><li>Excellent Project Management skills </li><li>Expert knowledge and strong experience in packaging as well as product development and life-cycle management </li><li>Experience in leading a team of engineers of various experiences </li></ul><strong>WORKING CONDITIONS</strong><ul><li>About 20% Lab and 80% office environment </li></ul><strong>SALARY RANGE</strong><ul><li>$120,000 - $140,000 </li></ul><strong>BENEFITS</strong><br><br><strong>PDI is pleased to offer comprehensive and affordable benefits for our associates, which includes:</strong><ul><li>Medical, behavioral & prescription drug coverage </li><li>Health Savings Account (HSA) </li><li>Dental </li><li>Vision </li><li>401(k) savings plan with company match and profit sharing </li><li>Basic and supplemental Life and AD&D insurance </li><li>Flexible Spending Accounts (FSAs) </li><li>Short & long-term disability </li><li>Employee Assistance Program (EAP) </li><li>Health Advocacy Program </li></ul><br><br><strong>PDI also offers many voluntary benefits such as: </strong>Legal services, critical illness, hospital indemnity, accident coverage, ID theft and fraud protection, pet insurance and employee discounts. <br><br><strong>At PDI, we are also committed to helping our associates maintain a healthy and sustainable work/life balance and are proud to provide associates with paid time off programs including:</strong>sick & safe leave, vacation, company & floating holidays, paid parental leave, and depending on the position we also offer summer hours and flex place/flex time options. <br><br>Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities <br><br>The contractor 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. 41 CFR 60-1.35(c)

Pdi Business Intelligence Interview Guide

Overview

Pdi Business Intelligence Salary

Pdi Business Intelligence Interview Process

Pdi Business Intelligence Interview Questions

Pdi Business Intelligence Jobs