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

Suncoast Drivers Business Intelligence Interview Guide

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


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

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

Overview

Suncoast Drivers 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.

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

Suncoast Drivers Business Intelligence Interview Questions

<strong>Job Description</strong> <br>Req #: 27811773 <br><br>Bachelor's Degree in a technology or related field required. <br><br>Minimum 3 years experience for Data Analyst & 5 years experience for Sr Data Analyst . <br><br>Advanced SQL skills. <br><br>Experience in Tableau preferred. <br><br>Proven track record of solving complex problems. <br><br>Passion for the use of data & business intelligence principles & their ability to apply those skills to solve customer reporting & data problems. <br><br>Demonstrated ability to handle large data sets & relational databases. <br><br>Excellent organizational, interpersonal, communication (written, verbal, visual) & analytical skills. <br><br>Travel includes less than 5% locally for training purposes. <br><br>Work in either a Kanban or scrum agile development framework. <br><br>Develop new reports & data extracts & perform enhancements and fix defects for existing reports & data extracts. <br><br>Deliver timely reports & data extracts to customers on an ongoing basis. <br><br>Write complex SQL queries & conduct SQL performance tuning. <br><br>Dive deep into data to uncover trends, data quality, & data completeness. <br><br>Adhere to all confidentiality and HIPAA requirements as outlined within Inovalon's Operating Policies & Procedures in all ways and all times. <br><br>Create & maintain views into data sets to provide visualization of data analysis. <br><br>Develop data marts, data structures, functions, data warehouse fact & dimension tables, views, and indexes.

Suncoast Drivers Business Intelligence Interview Guide

Overview

Suncoast Drivers Business Intelligence Salary

Suncoast Drivers Business Intelligence Interview Process

Suncoast Drivers Business Intelligence Interview Questions

Suncoast Drivers Business Intelligence Jobs