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

Sabre Business Intelligence Interview Guide

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


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

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

Overview

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

Sabre 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>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

<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

Sabre Business Intelligence Interview Questions

<p><p>Sabre Corporation is a leading technology provider to the global travel and tourism industry. Headquartered in Southlake, Texas, USA, Sabre operates offices in approximately 60 countries around the world. At Sabre, we make travel happen. Positioned at the center of the business of travel, our platform connects people with experiences that matter in their lives. Today, Sabre is creating a new marketplace for personalized travel. It is our people who develop and deliver powerful solutions that meet the current and future needs or our airline, hotel and travel agency customers. Join our journey!</p><p>Team Description</p><p>Be part of an internship program, driving people, process, and business progress through technology. Our interns are presented with real business challenges and provide solutions that make a difference across all areas of the company, all while learning the skills needed to successfully navigate the modern workplace.</p><p>Sabre is looking for an intern on the People Team with the opportunity to grow both as a Business Analyst and in Data Analytics. Our intern will partner with our people operations subject matter experts to support continuous improvement initiatives. Working side by side with our HRIS and People Operations owners, the intern will be part of a team that delivers process and business technology improvements that make a real difference in the lives of our team members and leaders.</p><p>What will you achieve?</p><p>Use your research, analytical, written and verbal skills to complete a project for a key business or process opportunity within the People Team</p><p>Partner with subject matter experts in our HR information systems, reporting, systems configuration management, and global people business partner functions to research and determine potential solutions or alternatives to enhance current operations or processes which support overall People and Business goals</p><p>Learn about the People function and associated HRIS technology platform, Workday</p><p>Develop process documentation and map from/to scenarios</p><p>Work within complex environment to analyze data and summarize findings through presentations, spreadsheets, data visualization and other reports</p><p>Coordinate project updates and present findings, solutions, and final project outcomes to key stakeholders and leaders within the organization</p><p>What's in it for you?</p><p>Innovate - to deliver solutions to real business problems</p><p>Transform - your skills and knowledge through challenging work projects</p><p>Connect - to our company and culture creating valuable connections with your intern peers, work team and leaders across the organization</p><p>Impact - through community and social interactions - collaborate with your fellow interns, Sabre inclusion groups, and Sabre leaders to give back and make an impact in the communities Sabre serves</p><p>Ideal Candidates will be:</p><p>Detail-oriented - Display attention to detail and think critically to solve complex problems</p><p>Data lover with action bias - Have a desire to interpret and understand data, turn data insights into actionable solutions, and communicate results</p><p>Storyteller - Demonstrate the art of connecting the dots and drawing out the story, bridging technical and non-technical</p><p>Eager to learn - Be naturally curious and willing to learn when faced with an unfamiliar subject or in a fast-paced global environment</p><p>Team Player - Work collaboratively within a team environment - expect to rely on and partner with other people to complete the project, so working well with others is critical</p><p>Preferred Qualifications:</p><p>Pursuit of a BS in Data and Analytics or Business Analysis with a Data and Analytics focus</p><p>Proficiency in process mapping and driving continuous improvement, including delivery of process documentation</p><p>Proficiency in Microsoft Office suite - Excel and SharePoint (in particular), including some macro development</p><p>Interest in Enterprise HR Systems would be a plus</p><p>Strong presentation skills, including both oral and written communication</p><p>Process, problem-solving, and critical thinking</p><p>Attention to detail</p><p>Disclaimer: The duties and responsibilities described above are not a comprehensive list, and additional tasks may be assigned to the employee occasionally. The scope of the job may change as necessitated by business requirements.</p><p>Reasonable Accommodation Sabre is committed to working with and providing reasonable accommodation to applicants with disabilities. Applicants applying for a Sabre position with a disability who require a reasonable accommodation for any part of the application or hiring process may contact Sabre's Compliance Office at compliance.office@sabre.com</p><p>Affirmative Action Sabre is an equal employment opportunity/affirmative action employer and is committed to providing equal employment opportunities to minorities, females, veterans, and disabled individuals. EEO IS THE LAW Stay connected with Sabre Careers</p></p>

Sabre Business Intelligence Interview Guide

Overview

Sabre Business Intelligence Salary

Sabre Business Intelligence Interview Process

Sabre Business Intelligence Interview Questions

Sabre Business Intelligence Jobs