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

Revolve Business Intelligence Interview Guide

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


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

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

Overview

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

Revolve 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>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

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

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

<p><strong><code>players</code></strong> table</p>

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

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

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

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

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

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

Revolve Business Intelligence Interview Questions

<p><strong><u>Meet REVOLVE:</u></strong></p><p><em>REVOLVE is the next-generation fashion retailer for Millennial and Generation Z consumers. As a trusted, premium lifestyle brand, and a go-to online source for discovery and inspiration, we deliver an engaging customer experience from a vast yet curated offering totaling over 45,000 apparel, footwear, accessories and beauty styles. Our dynamic platform connects a deeply engaged community of millions of consumers, thousands of global fashion influencers, and more than 500 emerging, established and owned brands. Through 20 years of continued investment in technology, data analytics, and innovative marketing and merchandising strategies, we have built a powerful platform and brand that we believe is connecting with the next generation of consumers and is redefining fashion retail for the 21st century. For more information please visit <a>www.revolve.com</a>.</em></p><p><br></p><p>At REVOLVE the most successful team members have the thirst and creativity to redefine fashion retail for the 21st century, making REVOLVE the leading online retail destination targeted towards Millennial and Generation Z consumers seeking premium fashion. With a team of 1,000 strong, we are a dynamic bunch that are motivated by getting the company to the next level. It’s our goal to hire high-energy, diverse, bright, creative, and flexible individuals who thrive in a fast-paced work environment. </p><p><br></p><p>Some of the sweetest perks we offer aren’t in a typical benefit package like hefty discount on items we carry – as in 50% or more off retail prices, free weekly lunches, and pretty rad company parties. </p><p>To take a behind the scenes look at the REVOLVE “corporate” lifestyle check out our Instagram @REVOLVEcareers or #lifeatrevolve.</p><p><strong>Are you ready to set the standard for Premium apparel?</strong></p><p><br></p><p><strong>Main purpose of the position:</strong></p><p>Synthesize current business intelligence or trend data to assess area of improvement, support recommendations for action, define and implement routine reports.</p><p><br></p><p><strong><u>Position responsibilities and daily tasks:</u></strong></p><ul><li>Consult with BI’s internal client to develop analyses that lead to actionable insights that accelerate profitable growth using SQL, Google analytics, Google query, Tableau and Excel</li><li>Work closely with the assigned team, as well as with the business intelligence team to solve problems with a holistic approach, owning the analytical portion</li><li>Define and implement routine reports (weekly / monthly) of key performance metrics and action items and alerts</li><li>Generate analysis and develop key insights from various data sources to come up with actionable recommendations</li><li>Work closely with the business intelligence and tech team to define, automate and validate the extraction of new metrics from various data sources for use in future analysis and reports</li><li>Designing and building reports, dashboards, and analyses in Excel, SQL, and Tableau.</li></ul><p><br></p><p><strong><u>What does a candidate need to demonstrate to perform this job successfully:</u></strong></p><ul><li>Outstanding analytical skills, with strong academic background in statistics, math, science or technology.</li><li>Strong SQL background, ability to dive into the dataset and arrive at a conclusion</li><li>Advanced programming skills in at least one languages (java, vba, python, c++…)</li><li>Proven business acumen and results oriented.</li><li>Ability to demonstrate logical thinking and problem solving skills</li><li>Strong attention to detail</li></ul><p><br></p><p><strong><u>Minimum candidate qualifications (years of experience, education level, technical skills, software, etc):</u></strong></p><ul><li>A BA/BS Degree is required</li><li>1+ years of experience in a strong analytical environment.</li><li>SQL and Database</li><li>Excel Pivot Table, functions</li></ul><p><br></p><p><strong><u>Preferred qualifications (years of experience, education level, technical skills, software, etc):</u></strong></p><ul><li>MS/MEng in a quantitative field or MBA preferred</li><li>Strong business acumen</li><li>Strong passion for fashion</li><li>Strong Statistical background</li><li>3+ years of analytical experience preferred</li><li>Advanced SQL experience, query optimization preferred</li><li>Experience with Tableau, Google Analytics, Python preferred</li><li>Experience with A/B testing preferred</li></ul><p><br></p><p>A successful candidate works well in a dynamic environment with minimal supervision. At REVOLVE we all roll up our sleeves to pitch-in and do whatever it takes to get the job done. Each day is a little different, it’s what keeps us on our toes and excited to come to work every day. </p><p><br></p><p>For individuals assigned and/or hired to work in California, Revolve includes a reasonable estimate of the salary or hourly rate range for this role. This takes into account the wide range of factors that are considered in making compensation decisions; including but not limited to business or organizational needs, skill sets, experience and training, licensure, and certifications.</p><p><br></p><p>A reasonable estimate of the current base salary range is $70,000 per year to $80,000 per year.</p><p></p>

Revolve Business Intelligence Interview Guide

Overview

Revolve Business Intelligence Salary

Revolve Business Intelligence Interview Process

Revolve Business Intelligence Interview Questions

Revolve Business Intelligence Jobs