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

Priceline.Com Business Intelligence Interview Guide

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


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

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

Overview

Priceline.Com 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.

Priceline.Com 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>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

<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

Priceline.Com Business Intelligence Interview Questions

<div><div><strong>This role is eligible for our hybrid work model: Two days in-office<br/><br/></strong><strong>Data Analyst, Financial Planning & Analysis<br/><br/></strong>From accounting and financial planning to risk/fraud analysis and payments, our Finance team ensures not only our company’s financial security, but also that our customers can buy from us with confidence.<br/><br/><strong>Why This Job’s a Big Deal<br/><br/></strong>Priceline – a part of Booking Holdings Inc. (NASDAQ: BKNG) is looking for an Analyst of FP&A to join its Finance team. Our FP&A team sits at the center of the organization and is actively involved with all major strategic decisions. The individual will be an integral member of a team responsible for budgeting, forecasting, and handling Priceline’s variable expenses and serving as analytical and strategic business partner throughout the organization.<br/><br/><strong>In This Role You Will Get To<br/><br/></strong><ul><li>Prepare and ingest data into financial forecasting models and be responsible for timeliness and accuracy of such data processes.</li><li>Build data pipelines, reporting infrastructures and help develop new FP&A processes and analyses that contribute for all customers.</li><li>Implement SQL composition skills that collects and queries data for investigation and analysis in real time from our applications.</li><li>Ensure data integrity across our various databases and tools</li><li>Maintain and craft early warning and analytics systems using brand-new cloud data technologies.</li><li>Collaborate on building software that collects and queries data, while also composing queries for investigation purposes.</li><li>Improve upon the data ingestion models, ETL jobs, and alarming to maintain data integrity and data availability.</li><li>You will work cross-functionally with various teams, creating solutions that deal with large volumes of data.</li><li>Gain hands-on experience with new data platforms and programming languages<br/><br/></li></ul><strong>Who You Are<br/><br/></strong><ul><li>3+ years' experience with data aggregation, standardization, linking, quality check mechanisms, and reporting.</li><li>Hands-on, extensive knowledge and experience of working with large databases, data mining and business intelligence tools</li><li>SQL mastery required; BigQuery/GCP, Tableau a plus</li><li>Experience/exposure in Python or Object-oriented programming a plus</li><li>Prior experience working in a finance department is a plus, but not a requirement</li><li>Takes ownership for results, “owning” assignments and projects</li><li>Ability to work under pressure and multi-task in a fast-paced/constantly evolving environment</li><li>Intellectual curiosity with demonstrated ability to learn and master new subject areas quickly</li><li>Project management and work structure skills – excellent attention to detail and ability to work independently</li><li>Ambitious spirit, owner attitude, take initiative</li><li>Demonstrated history of living the values important to Priceline: Customer, Innovation, team, Accountability and Trust, Unquestionable integrity and Ethics</li><li>Illustrated history of living the values vital to Priceline: Customer, Innovation, Team, Accountability and Trust. The Right Results, the Right Way is not just a motto at Priceline; it’s a way of life. Unquestionable integrity and ethics is essential<br/><br/></li></ul><strong>There are a variety of factors that go into determining a salary range, including but not limited to external market benchmark data, geographic location, and years of experience sought/required. In addition to a competitive base salary, certain roles may be eligible for an annual bonus and/or equity grant<br/><br/></strong>The salary range for this position is $95000-$120000<br/><br/><strong>Who We Are<br/><br/></strong>WE ARE PRICELINE.<br/><br/>Our success as one of the biggest players in online travel is all thanks to our incredible, dedicated team of talented employees. Priceliners are focused on being the best travel deal makers in the world, motivated by our passion to help everyone experience the moments that matter most in their lives. Whether it’s a dream vacation, your cousin’s graduation, or your best friend’s wedding - we make travel affordable and accessible to our customers.<br/><br/>Our culture is unique and inspiring (that’s what our employees tell us). We’re a grown-up, startup. We deliver the excitement of a new venture, without the struggles and chaos that can come with a business that hasn’t stabilized.<br/><br/>We’re on the cutting edge of innovative technologies. We keep the customer at the center of all that we do. Our ability to meet their needs relies on the strength of a workforce as diverse as the customers we serve. We bring together employees from all walks of life and we are proud to provide the kind of inclusive environment that stimulates innovation, creativity and collaboration.<br/><br/>Priceline is part of the Booking Holdings, Inc. (Nasdaq: BKNG) family of companies, a highly profitable global online travel company with a market capitalization of over $80 billion. Our sister companies include Booking.com, BookingGo, Agoda, Kayak and OpenTable.<br/><br/>If you want to be part of something truly special, check us out!<br/><br/><strong>Flexible work at Priceline<br/><br/></strong>Priceline is following a hybrid working model, which includes two days onsite as determined by you and your manager (ideally selecting among Tuesday, Wednesday, or Thursday). On the remaining days, you can choose to be remote or in the office.<br/><br/><strong>Diversity and Inclusion are a Big Deal!<br/><br/></strong>To be the best travel dealmakers in the world, it’s important we have a workforce that reflects the diverse customers and communities we serve. We are committed to cultivating a culture where all employees have the freedom to bring their individual perspectives, life experiences, and passion to work.<br/><br/>Priceline is a proud equal opportunity employer. We embrace and celebrate the unique lenses through which our employees see the world. We’d love you to join us and add to our rich mix!<br/><br/><strong>Applying for this position<br/><br/></strong>We're excited that you are interested in a career with us. For all<strong>current employees</strong>, please use the internal portal to find jobs and apply.<br/><br/>External candidates are required to have an account before applying. When you click Apply, returning candidates can log in, or new candidates can quickly create an account to save/view applications.<br/><br/></div></div>
#J-18808-Ljbffr

Priceline.Com Business Intelligence Interview Guide

Overview

Priceline.Com Business Intelligence Salary

Priceline.Com Business Intelligence Interview Process

Priceline.Com Business Intelligence Interview Questions

Priceline.Com Business Intelligence Jobs