The State of utah Business Intelligence interview guide, interview questions, salary data, and interview experiences.

State of utah Business Intelligence Interview Guide

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


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

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

Overview

State of utah 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.

State of utah 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>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

State of utah Business Intelligence Interview Questions

<p>The Functional Senior Business Analyst acts as the liaison between division staff and the vendor; facilitate/chair workgroups to maintain system design documents; ensures deadlines are met; review system design documentation for compliance with procedures,policies,regulations and standards have been applied/maintained; make recommendations to management for improving and/or maintaining effective information analysis support for the organization; assist with user acceptance testing. Additional duties to include: Review system documentation and standard operating procedures to ensure compliance with procedures,regulations and standards. Coordinate and participate in operational releases. Facilitate/Chair work groups,teams,and/or meetings. Creates a positive environment,evaluates group processes,recommends solutions or alternatives,etc. Conduct detailed research of intended subject matter according to Division needs. Review and/or inspect work for quality,accuracy,and completeness. Research and recommend system enhancements to better meet customer needs. Perform activities which may include: the utilization of SharePoint and other computer software programs to store data,retrieve stored data,analyze retrieved data,and arrange results in aformat that effectively supports Medicaid s production activities; and helps identify better ways to utilize the system's capabilities. Monitor and evaluate operations,programs,processes and/or practices for quality and effectiveness. Utilize MS Word,Excel and Visio to create documents and reports. Review and perform user acceptance testing. Note: as of April 8,2024,DHHS employees will be working a hybrid schedule,which includes 2 office days per week and 3 telework days. Why work for the Utah Department of Health and Human Services? In addition to the rich benefits {target"_blank"} the State of Utah offers,the department offers: On-site fitness center,for a minimal membership fee UTA Eco Pass,at a discounted monthly rate Teleworking opportunities with a minimum 2 office days per week beginning 04/2024. On-site day care center at the Cannon Health Building with First Steps Day Care - contact for rates and availability,801-538-6996 For more information on the Utah Department of Health and Human Services,please click here {target" blank"}. If offered this position,your employment will be contingent upon passing a background check and review. There will be no cost to you for this check. This check will include fingerprinting,which will be available at various DHHS locations for your convenience. Fingerprinting will be completed prior to your first day of employment. You may review the policy by clicking here. {target" blank"}</p>

State of utah Business Intelligence Interview Guide

Overview

State of utah Business Intelligence Salary

State of utah Business Intelligence Interview Process

State of utah Business Intelligence Interview Questions

State of utah Business Intelligence Jobs