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

Indiana University Business Intelligence Interview Guide

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


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

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

Overview

Indiana University 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.

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

Indiana University Business Intelligence Interview Questions

<p>Departmental Solutions (DSOL) is 1 of 5 areas in the Enterprise Systems division of University Information Technology Services (UITS) at Indiana University. As a part of Enterprise Systems, we collaborate closely with Enterprise Experience, Enterprise Solutions, Student and HR Systems, and the CRM team. We work with select departments across IU to design, build, and support custom application and website solutions. In addition to work for individual departmental clients, we work with partners across Enterprise Systems, UITS, and University Communications and Marketing (UCM) to support the strategic goals of the university regarding websites, systems, and the adoption of enterprise tools in support of IU's educational, research, and service goals. <br><br>The DSOL Web Team supports approximately 100 departments and over 200 websites and applications. Our clients include schools, academic divisions, research centers, and presidential initiatives. The Web Team maintains and supports existing solutions, consults with web developers and website owners around the university on their ongoing projects, and designs and builds new solutions for clients in collaboration with other teams in DSOL, UITS, and UCM. <br><br><b> Job Summary </b> </p><ul><li>Provides advanced design, development, testing, and configuration of software systems and computer programs; performs advanced analysis, programming, troubleshooting, bug-fixing, and tuning of new and existing software. </li><li>Consults with stakeholders/clients to review existing software solutions; develops new functionality and/or writes new code as needed; advises clients on critical decisions regarding information technology software solutions that will improve business process efficiency. </li><li>Serves as a first point of escalation for diagnosis and resolution of complex technical problems arising from the deployment of software and computer programs. </li><li>Acts as a lead and takes responsibility for designing advanced programmatic solutions and work with other developers on the team to resolve more complex technical issues. </li><li>Ensures that all protocols used in the development and maintenance of software is up to date and compliant with university policies and standards; may participate in committees and communities of practice to share and improve software development practices across the university. </li><li>Provides advanced research/analysis and stays up-to-date on new industry software development standards, emerging technology, UX/UI design/philosophy, and accessibility standards. </li><li>Makes recommendations to improve, as well as implements, testing, quality assurance, and documentation protocols and procedures for websites and web applications; fixes complex bugs and resolves issues accordingly. </li><li>Lead contributor in project planning, formulating objectives, estimating tasks; performs studies to include feasibility, conceptual design, cost/benefit analysis, development and implementation planning. </li><li>May serve as project lead; often provides guidance to junior peers. </li></ul><b> Qualifications </b> <br><br>Combinations of related education and experience may be considered. Education beyond the minimum required may be substituted for work experience. Work experience beyond the minimum required may be substituted for education. <br> <br>EDUCATION <br> <br><strong>Required</strong> <ul><li>Bachelor's degree (preferably in computer science, business systems, or related field) </li></ul> WORK EXPERIENCE <br> <br><strong>Required</strong> <ul><li>5 years software development or related experience </li></ul><strong>Preferred</strong> <ul><li>5 years Full stack development </li><li>5 years web applications and web services development </li><li>5 years in ASP.NET, JavaScript Frameworks (e.g., Oracle SQL, Angular, PostgreSQL, MSSQL, MariaDB, MongoDB, other NoSQL) development </li></ul> SKILLS <br> <br><strong>Required</strong> <ul><li>Proficient communication skills </li><li>Maintains a high degree of professionalism </li><li>Demonstrates time management and priority setting skills </li><li>Demonstrates a high commitment to quality </li><li>Possesses flexibility to work in a fast paced, dynamic environment </li><li>Seeks to acquire knowledge in area of specialty </li><li>Highly thorough and dependable </li><li>Demonstrates a high level of accuracy, even under pressure </li><li>Possesses a high degree of initiative </li><li>Ability to influence internal and/or external constituents </li></ul><strong>Preferred</strong> <ul><li>Fluency in at least one .NET programming language, such as C# or VB.NET </li><li>Familiarity with a variety of database management systems (e.g., Oracle SQL, PostgreSQL, MSSQL, MariaDB, MongoDB, other NoSQL) </li><li>Knowledge of RPC and REST APIs </li><li>Experience with test-driven development and automated testing </li><li>Experience working in an Agile environment </li><li>Experience with Git </li> </ul><b> Working Conditions / Demands </b> <br><br>This role requires the ability to effectively communicate and to operate a computer and other standard office productivity equipment. The position involves sedentary work as well as periods of time moving around an office environment and the campus. The person in this role must be able to perform the essential functions with or without an accommodation. <br><br><b> Work Location </b> <br><br>Bloomington, Indiana or Indianapolis, Indiana <br><br><b> Benefits Overview </b> <br><br>For full-time staff employees, Indiana University offers a wide array of benefits including: <ul> <li> Multiple plan options for medical insurance </li> <li> Dental insurance </li> <li> Health Savings Account with generous IU contribution </li> <li> Life insurance, LTD, and AD&D options </li> <li> Base retirement plan contribution from IU, subject to vesting </li> <li> Additional supplemental retirement plan options </li> <li> Tuition benefit for IU classes </li> <li> 10 paid holidays per year </li> <li> Generous Paid Time Off </li> <li> Paid Parental Leave </li> <li> Employee Assistance Program (EAP) </li></ul> Learn more about our benefits by reviewing our online Benefits Brochure . <br> <br><b> Job Classification </b> <br><br>Career Level: Advanced <br><br> FLSA: Exempt <br><br> Job Function: Information Technology <br><br> Job Family: Software/App Design, Dev & Eng <br><br> Click here to learn more about Indiana University's Job Framework. <br> <br><b> Posting Disclaimer </b> <br><br>This posting is scheduled to close at 11:59 pm EST on the advertised Close Date. This posting may be closed at any time at the discretion of the University, but will remain open for a minimum of 5 business days. To guarantee full consideration, please submit your application within 5 business days of the Posted Date. <br><br> If you wish to include a cover letter, you may include it with your resume when uploading attachments. <br> <br><b> Equal Employment Opportunity </b> <br><br>Indiana University is an equal employment and affirmative action employer and a provider of ADA services. All qualified applicants will receive consideration for employment based on individual qualifications. Indiana University prohibits discrimination based on age, ethnicity, color, race, religion, sex, sexual orientation, gender identity or expression, genetic information, marital status, national origin, disability status or protected veteran status. Indiana University does not discriminate on the basis of sex in its educational programs and activities, including employment and admission, as required by Title IX. Questions or complaints regarding Title IX may be referred to the U.S. Department of Education Office for Civil Rights or the university Title IX Coordinator. See Indiana University's Notice of Non-Discrimination here which includes contact information . <br> <br><b> Campus Safety and Security </b> <br><br>The Annual Security and Fire Safety Report, containing policy statements, crime and fire statistics for all Indiana University campuses, is available online . You may also request a physical copy by emailing IU Public Safety at iups@iu.edu or by visiting IUPD. <br> <br><b> Contact Us </b> <br><br>Request Support <br>Telephone: 812-856-1234 <br> <br>Apply for Job <ul><li> Staff Positions </li><li> Sign In </li><li> New User </li><li> Enable Screen Reader Mode </li> </ul>

Indiana University Business Intelligence Interview Guide

Overview

Indiana University Business Intelligence Salary

Indiana University Business Intelligence Interview Process

Indiana University Business Intelligence Interview Questions

Indiana University Business Intelligence Jobs