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

Kootenai health Business Intelligence Interview Guide

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


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

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

Overview

Kootenai health 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.

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

Kootenai health Business Intelligence Interview Questions

<p>Calling all Power BI experts! Kootenai Health has an immediate need for a Healthcare Data Analyst who is well versed in developing automated dashboards and data storytelling using Power BI, and publishing those reports to the Power BI web service.This position is US-Remote Eligible. Currently, Kootenai Health employees cannot be located in: California, Hawaii, Massachusetts, Minnesota, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Dakota, Rhode Island, Vermont, Washington D.C., West Virginia, or Wyoming. This list is continuously evolving and may be updated. Position Summary:Works collaboratively with data and reporting and the database administrator to help produce effective production management and utilization management reports in support of performance management related to quality, safety, utilization, cost, and risk from a variety of data sources.•Monitors data integrity and quality of reports on a regular basis•Develops, implements, and enhances evaluation and measurement models for quality and operational department programs, projects, and initiatives for maximum effectiveness•Recommends improvements to processes, programs, and initiatives by using analytical skills and a variety of reporting tools•Determines the most appropriate approach for internal and external report design, production, and distribution specific to the relevant audience•Performs a variety of tasks•A certain degree of creativity and latitude is required•Performs other related duties as assigned•Familiar with standard concepts, practices, and procedures within the field •Relies on experience and judgment to plan and accomplish goals•Regular and predictable attendance is an essential job function•Competent to meet age specific needs of the unit assignedFull Time - Day Shift Requirements and Minimum Qualifications•Bachelor's degree required; 4 years' related experience may be accepted in lieu of a Bachelor's degree•Master's degree preferred•3 years of experience in data analysis required in addition to education requirement•Relational database experience required, such as SQL (SSMS). Experience with data visualization/ reporting tools such as SSRS, Tableau, Qlik, etc., preferred•Experience in data analysis techniques required (queries, drills, sorting, formulas)•Experience with statistical analysis concepts required•Strong organizational and communication skills required•Power BI expertise strongly preferred Your location:This position is US-Remote Eligible. Currently, Kootenai Health employees cannot be located in: California, Hawaii, Massachusetts, Minnesota, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Dakota, Rhode Island, Vermont, Washington D.C., West Virginia, or Wyoming. This list is continuously evolving and may be updated. Working Conditions•Must be able to maintain a sitting position •Typical equipment used in an office job•Repetitive movements•Remote eligible (please see eligible state information before applying)About Kootenai HealthKootenai Health is a highly esteemed health care organization, serving patients throughout northern Idaho and the Inland Northwest. We pride ourselves on our outstanding reputation as both an employer and a health care provider. We have been recognized with many accolades and distinctions including being recognized as a Gallup Great Workplace, No. 1 Best Place to Work in Large Healthcare Organizations, and Magnet™ Status for Nursing Excellence. As your next employer, we are excited to offer you:100% employer-paid health insurance premiums for full-time employees. Part-time employees pay only a small portion a month for medical, dental, and vision coverage. Benefits start 1st of the month following 30 days of employmentA tuition assistance program available after 90 days. If you want to further your education, we'll help you pay for itKootenai Health will match your contributions in a retirement plan based on years of service ranging from 3-6 percent. Kootenai Health will contribute an amount equal to two percent of your gross earningsCompetitive salaries with night, weekend and PRN shift differentialsAn award-winning and incentive-driven wellness program. Including a MyHealth corporate team, onsite financial seminars and coachingEmployees receive discounts at The Wellness Bar, PEAK Fitness, various cell phone carriers, and moreRobust and interactive employee referal bonus programAnd much moreIf you strive to be an integral part of a high-quality healthcare system like Kootenai Health, we want to meet you! Apply today! Please reach out to Talent Acquisition Consultant Alex Cronnelly at acronnelly@kh.org with questions or call 208-625-4620. Kootenai Health complies with applicable federal civil rights laws and does not discriminate on the basis of race, color, national origin, age, disability, veteran status, or sex. Kootenai Health does not exclude people or treat them differently because of race, color, national origin, age, disability, veteran status, or sex.</p>

Kootenai health Business Intelligence Interview Guide

Overview

Kootenai health Business Intelligence Salary

Kootenai health Business Intelligence Interview Process

Kootenai health Business Intelligence Interview Questions

Kootenai health Business Intelligence Jobs