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

Rr Donnelley Business Intelligence Interview Guide

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


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

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

Overview

Rr Donnelley 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.

Rr Donnelley 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

Rr Donnelley Business Intelligence Interview Questions

<h3>Job Description</h3><div>Job Description<div>Company Description<br><br><p>RRD is a leading global provider of marketing, packaging, print, and supply chain solutions that elevate engagement across the complete customer journey. The company offers the industry’s most trusted portfolio of creative execution and world-wide business process consulting, with services designed to lower environmental impact. With 22,000 clients, including 93% of the Fortune 100, and 32,000 employees across 28 countries, RRD brings the expertise, execution, and scale designed to transform customer touchpoints into meaningful moments of impact.</p>Job Description<br><br><p><strong>Overview:</strong></p><p>Estimate total costs of printing and/or binding magazines, pamphlets, periodicals, books, and other variable printed matter based on job specifications that are primarily unique/moderately complex and occasionally may be routine/repeat opportunities. Prepare competitive pricing estimates for Sales to close new/existing business opportunities and retain existing customer base. Work with Customers, Sales, and Legal on the preparation of Contracts for work. Apply knowledge of print manufacturing to make determinations on the best manufacturing methods to produce customer products efficiently while maintaining high-quality standards and meeting revenue forecasts for work.</p><p><strong>Responsibilities:</strong></p><ul><li>Prepare comprehensive pricing models for a mix of moderately complex and occasionally complex bid proposals.</li><li>Examine customer specifications, sketches, and/or sample layouts, and calculates unit and production costs considering factors such as size and the number of sheets or pages, paper stock requirements, binding operations, halftones, number and units of colors, and quality of finished product, labor, and material pricing, so as to determine a cost-effective and competitive price.</li><li>Prepares timely, accurate, and detailed cost estimates for printing jobs by determining the most economical method of manufacturing while considering production capacity and equipment across platforms.</li><li>Routinely provide multiple pricing options and scenarios to Sales by comparing different methods of manufacturing, materials, materials sizes, etc to deliver pricing options to Sales.</li><li>Work with Sales and operations to develop a competitive price strategy to win prospective and ongoing deals from customers.</li><li>Confer with Sales and Operations on long-term work/ multi-year deals to build pricing models/forecasts.</li><li>Work with operations on new or unique opportunities to ensure projects can be produced in-house.</li><li>Provide recommendations from a pricing perspective to how a product can be created or manufactured.</li><li>Performs financial analyses, including forecasts, projections, and historical assessments on multi-year deals.</li><li>Facilitates the management approvals required for price levels and contract terms</li><li>Facilitates communication among management, sales, and plant staff regarding contract and price</li><li>May be responsible for compiling and preparing customer contracts working with legal and updating and appending price schedules and contract terms.</li><li>In consultation with sales, may leverage the use of incentives to close competitive deals.</li><li>Maintain knowledge of market competitive pricing and factor in the market when developing pricing strategy and recommendations.</li><li>Functions as plant and management resource on general pricing and contract issues.</li><li>Determine the need to engage outside vendors to produce work and work with external vendors to negotiate pricing and/or timelines.</li><li>Performs other related duties and participates in special projects as assigned.</li></ul>Qualifications<br><br><ul><li>Bachelor's degree in a discipline related to functional work preferred</li><li>3+ years of relevant work experience minimum</li><li>Able to demonstrate the ability to solve somewhat more complex problems by analyzing variables and applying appropriate solutions learned through experience and proficiency in understanding the job.</li><li>Must be able to recognize anomalies and critical situations and respond appropriately.</li><li>Must be able to communicate and interact with a variety of internal/external customers and/or co-workers at the level of detail required to resolve issues of moderate complexity.</li><li>Able to apply strong functional computer knowledge in utilizing Microsoft Windows, MAC, or other technical tools in completing assignments. </li><li>May require knowledge of or the ability to quickly learn specialized software to complete work assignments. </li><li>Able to demonstrate continued expertise in the primary tools or applications used in completing daily work assignments.    </li><li>Requires very good communication skills with the ability to state messages in a clear manner by using language that is easy for others to understand. </li><li>Must be able to proactively listen to others to understand issues and situations.  </li><li>Must be able to clearly articulate business needs to both internal and external customers.</li></ul><br><br>Additional Information<br><br><p>The national pay range for this role is $48,400 - $79,500 / year. The pay range may be slightly lower or higher based on the geographic location of the hired employee. The actual pay offered may vary based upon, but not limited to: education, skills, experience, proficiency, performance, shift and location. In addition to base salary, depending on the role, the total compensation package may also include participation in a bonus, commission or incentive program. RRD offers benefits including medical, dental, and vision coverage, paid time off, disability insurance, 401(k) with match, life insurance and other voluntary supplemental insurance coverages, plus tuition assistance, maternity leave, adoption assistance, and employer/partner discounts.</p><p>#LI-RRD</p><div></div><p>RRD is an Equal Opportunity Employer, including <span class="long-word">disability/veterans</span></p></div></div>

Rr Donnelley Business Intelligence Interview Guide

Overview

Rr Donnelley Business Intelligence Salary

Rr Donnelley Business Intelligence Interview Process

Rr Donnelley Business Intelligence Interview Questions

Rr Donnelley Business Intelligence Jobs