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

Instacart Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Instacart? The Instacart Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Instacart Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Instacart.</li>
<li>Practice real Instacart Business Intelligence interview questions.</li>
</ul>
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 Instacart Business Intelligence interview.


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

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

Overview

Instacart Business Intelligence Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Instacart Business Intelligence Interview Process

Given a list of (name, item) pairs, <code>pair_list</code>, write a function <code>common_items</code> to create a list of (<code>name1</code>, <code>name2</code>, <code>item_frequency</code>) triples where <code>item_frequency</code> is the number of common items shared between the two names.

Make sure all possible name pairs are included, there are no duplicate name pairs, there are no pairs of the same name, and the order of the names is alphabetical.

Example:

Input:

<pre tabindex="0" class="chroma"><code>pair_list = [(&#39;Susan&#39;, &#39;spoon&#39;), 
 (&#39;Susan&#39;, &#39;fork&#39;), 
 (&#39;Mark&#39;, &#39;fork&#39;), 
 (&#39;Mark&#39;, &#39;spoon&#39;), 
 (&#39;Mark&#39;, &#39;plate&#39;), 
 (&#39;Lily&#39;, &#39;plate&#39;)]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def common_items(pair_list) -&gt; [
 (&#39;Lily&#39;,&#39; Mark&#39;, 1),
 (&#39;Lily&#39;, &#39;Susan&#39;, 0),
 (&#39;Mark&#39;, &#39;Susan&#39;, 2),
]
</code></pre>

Write a function to calculate the number of common items.

Common Item Frequency

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.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

<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>
Output:

<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

Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.

Example:

Input:

<code>transactions</code> table

<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>
<code>users</code> table

<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>
 
Output:

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

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Which of the following queries will return a list of customers and the total amount they have spent on orders?

Instacart Business Intelligence Interview Guide

Overview

Instacart Business Intelligence Salary

Instacart Business Intelligence Interview Process

Instacart Business Intelligence Interview Questions

Instacart Business Intelligence Jobs