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

Buildzoom Business Intelligence Interview Guide

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


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

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

Overview

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

Buildzoom 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 the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

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

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

<p><code>employees</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</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>

<tr>
<td><code>team</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>manager</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>team_size</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Manager Team Sizes

<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

Buildzoom Business Intelligence Interview Questions

<p>Full Time Product Manager at BuildZoom (United States) | BEAMSTART Jobs
Product Manager BuildZoom United States
Date Posted: 31 Oct, 2022
Work Location: San Francisco, United States
Salary Offered: $90,000 — $150,000 yearly
Job Type: Full Time
Experience Required: 3+ years
Remote Work: Yes
Stock Options: No
Vacancies: 1 available
BuildZoom is modernizing the $1.2 trillion remodeling and construction industry. We guide clients through medium-to-large residential and light commercial projects to help them turn vision into physical reality.
A typical week might look like this:
Collaborate with a UI/UX designer and an engineer to design an elegant cost-effective solution.
Engage with our Finance, Operations, and Sales leaders to understand their challenges and turn opportunities into product specs.
Define KPIs, build analytics dashboards, identify opportunities, and measure the impact of your solutions.
Brainstorm with the Founders and CTO on actionable items in pursuit of BuildZoom’s vision.
We operate in a fast-paced, dynamic, and (mostly) remote environment. You’ll need to come equipped with the motivation, talent, and experience to make an outsized impact:
3+ years of experience in a product role.
Excellent written and verbal communication.
Experience creating high-fidelity specs and documentation.
Experience achieving business outcomes through user-centered design.
Emotional intelligence and the ability to build consensus.
Quantitative acuity, the skills to interpret complex data and translate insight into action.
Contagious energy to inspire those around you in pursuit of success.
Prior exposure to marketplaces or construction.
Why join BuildZoom?
Your work will have the potential to impact almost two million monthly users – that user base is only growing.
Design software to help property owners and construction companies build spaces for life, work, and play.
Lead a pivotal part of our business while working directly with the company’s leadership and in doing so, further hone your entrepreneurial skills.
Help to build a company with the potential to influence an enormous market and positively impact millions of people and businesses.
Collaborate with dynamic and passionate peers across the company, who will challenge and stimulate you every day.
About BuildZoom
We’re a data company at heart, ingesting vast volumes of construction and real estate data to gain deep insight into the construction marketplace.

#J-18808-Ljbffr</p>

Buildzoom Business Intelligence Interview Guide

Overview

Buildzoom Business Intelligence Salary

Buildzoom Business Intelligence Interview Process

Buildzoom Business Intelligence Interview Questions

Buildzoom Business Intelligence Jobs