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

Lehigh University Business Intelligence Interview Guide

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


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

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

Overview

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

Lehigh 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 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

Lehigh University Business Intelligence Interview Questions

<strong>Institutional Research Analyst</strong><br><br><b>Job no:</b> 503076<br> <b>Work type:</b> Exempt Staff Full-time<br> <b>Location:</b> Partial Remote, Bethlehem<br> <b>Categories:</b> Information Technology<br><br>Are you a data enthusiast with a passion for higher education? Join Lehigh University, a leading research institution renowned for its academic excellence and vibrant campus community, as an Institutional Research Analyst (Position Number S88910).<br><br>In this pivotal role, you will be at the forefront of data-driven decision-making, playing a crucial part in shaping the university's strategic direction. As an Institutional Research Analyst, you will collect, analyze, and interpret a vast array of institutional data, providing invaluable insights into areas such as student enrollment, retention, graduation rates, faculty productivity, and key performance indicators.<br><br>Key Responsibilities:<br>•Gather, analyze, and interpret complex data from various university systems and external sources<br>•Develop and maintain comprehensive databases and data warehouses<br>•Conduct quantitative analyses and produce reports, dashboards, and data visualizations<br>•Collaborate with stakeholders to identify data needs and provide actionable insights<br>•Ensure data integrity, accuracy, and compliance with relevant policies and regulations<br>•Participate in strategic planning and decision-making processes<br><br>Qualifications:<br>•Bachelor's Degree or the equivalent combination of education and experience; Master's Degree preferred<br>•One to three years of related work experience<br>•Proficiency in data analysis tools (e.g., SQL, Python, R, Tableau, Power BI)<br>•Strong analytical and problem-solving skills<br>•Excellent written and verbal communication abilities<br>•Attention to detail and commitment to data quality<br>•Ability to work independently and as part of a team<br><br>At Lehigh University, you'll be part of a dynamic and inclusive community that values diversity, fosters innovation, and promotes personal and professional growth. We offer a competitive compensation package, comprehensive benefits, and a wealth of opportunities for career advancement and lifelong learning.<br><br>This position is a Grade: 9 - 40, offering an approximate salary of $54,390-$66,190. The duties of this position may allow the employee to work partially remote as deemed appropriate by their supervisor.<br><br>Persons with disabilities who anticipate needing an accommodation for any part of the interview or hiring process may contact Lehigh's Accommodations Specialist <br><br>Lehigh University is an equal opportunity employer and is committed to building a diverse and inclusive environment for all. We actively encourage applications from individuals of diverse backgrounds and experiences. The Lehigh community takes seriously our commitment to antiracism and The Principles of our Equitable Community.<br><br>Successful completion of standard background checks including but not limited to: social security verification, education verification, national criminal background checks, motor vehicle checks, PATCH, FBI fingerprinting, Child Abuse Clearance and credit history based upon the requirements of the position<br><br><strong>Only complete applications will be considered therefore please complete the application in its entirety. Once the posting is removed from the website applications may no longer be allowed to be completed.</strong><br><br><b>Advertised:</b> September 09, 2024 Eastern Daylight Time<br> <b>Applications close:</b>

Lehigh University Business Intelligence Interview Guide

Overview

Lehigh University Business Intelligence Salary

Lehigh University Business Intelligence Interview Process

Lehigh University Business Intelligence Interview Questions

Lehigh University Business Intelligence Jobs