The North Highland Business Intelligence interview guide, interview questions, salary data, and interview experiences.

North Highland Business Intelligence Interview Guide

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


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

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

Overview

North Highland 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.

North Highland 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

North Highland Business Intelligence Interview Questions

<p><strong>REACH YOUR POTENTIAL | COLLABORATE WITH AMAZING PEOPLE | MAKE CHANGE HAPPEN</strong> <br><br>Do you have the skills, passion, and commitment to transform our clients for the better? Are you ready to be a changemaker? If so, join us. <br><br>North Highland is the world's leading change and transformation consultancy. Simply put, we make change happen like no one else. And we're on the hunt for a newContract<strong>Business Analyst</strong>. 12-month Contract assignment, hybrid onsite 3 days a week in Vancouver, WA. <br><br><strong>HOW WILL YOU MAKE CHANGE HAPPEN?</strong> <br><br>Leading Business Analysis efforts for a variety of Projects in an IT setting. <br><br><strong>YOU WILL:</strong> </p> <ul><li> <p>Lead business analysis efforts on small to medium projects. </p> </li><li> <p>configure/setup new servers (specifically Active Directory) </p> </li><li> <p>Identify and document project requirements through various methods, including interviews, workshops, surveys, document analysis, etc. </p> </li><li> <p>Manage, validate and prioritize business requirements. </p> </li><li> <p>Identify and document existing processes and use cases. </p> </li><li> <p>Design future-state processes and obtain necessary approvals. </p> </li><li> <p>Document functional and technical specifications and obtain necessary approvals. </p> </li><li> <p>Conduct analyses to define alternative approaches to satisfy requirements. </p> </li><li> <p>May participate in other duties such as documenting test plans, scripts, and conducting system testing and assist in user acceptance test planning and testing. </p> </li><li> <p>May work on multiple projects. </p> </li><br> </ul> <p><br> <br><strong>IDEALLY, WE'D LIKE:</strong> </p> <ul><li> <p>5+ years of experience in business analysis, 10+ total years of experience </p> </li><li> <p>Understanding of requirements development and management, business process documentation and design </p> </li><li> <p>Demonstrated ability to build trust with management, project teams, and stakeholders. </p> </li><li> <p>Demonstrated ability to work effectively in a team environment. </p> </li><li> <p>Bachelor's degree in business, technology, or related field preferred or an equivalent of education and experience </p> </li><br> </ul> <p><br> <br><strong>TRANSFORMING CLIENTS. TRANSFORMING CAREERS.</strong> <br><br>Success-for both our clients and our colleagues-is all about putting people first and doing great things together. We believe that when we work as one team, we can take action today to build lasting capability for tomorrow. <br><br>We strive to have the most enviable culture on the planet, inspiring people to reach their full potential. Here's how we make it happen: <br><br><strong>Intentional, flexible growth.</strong>We never want you to settle. Leading your own growth and transformation is your prerogative-one which we'll help you nurture and develop every step of the way. We'll inspire you to learn, teach, and ultimately carve your own path. That means you grow, we grow, and so do our clients. <br><br><strong>People-first, and then some.</strong>It goes without saying that people come first, but what comes next? Our people are always at the heart; your wellbeing and success is built on a collective understanding that every one of us can be a coach, a friend, and a fantastic listener-regardless of job title. We think of it as a celebration of individuality, difference, and diversity. <br><br><strong>Make your own change happen.</strong>With us, your curiosity and creativity know no bounds. The reins are off. All we ask is that you have the courage to transform yourself and those around you-colleagues and clients alike. If you've got the drive to become a changemaker, we'll do the rest. <br><br><strong>Enviable Total Rewards.</strong>We inspire our employees to do their best work. North Highland's Total Rewards Program encompasses PTO, Medical, Dental, Vision, STD/LTD, Life Insurance, FSA/HSA, 401(k), and a variety of other perks like a dedicated Health Advocate, commuter benefits, and legal assistance. <br><br><strong>READY TO MAKE CHANGE HAPPEN?</strong> <br><br>North Highland makes change happen, helping businesses transform by placing people at the heart of every decision. It's how lasting progress is made. With our blend of workforce, customer, and operational expertise, we're recognized as the world's leading transformation consultancy. We break new ground today, so tomorrow is easier to navigate. <br><br>Founded in 1992, North Highland is regularly named one of the best places to work. We are a proud member of Cordence Worldwide, a global network of truly connected consultancy firms with the ability to think and deliver together. <br><br>This means North Highland has more than 3,500 experts in 50+ offices around the globe on hand to partner with you. <br><br>Please note that applicants must be authorized to work in the United States without the need for visa sponsorship by North Highland. Work visa sponsorship will not be provided, either now or in the future, for this position. <br><br>North Highland is an Equal Employment Opportunity (EEO)/Affirmative Action employer. All qualified applicants will receive fair and impartial consideration without regard to race, color, sex, gender identity, religion, national origin, age, sexual orientation, disability, veteran status, or any other characteristic protected by law.</p>

North Highland Business Intelligence Interview Guide

Overview

North Highland Business Intelligence Salary

North Highland Business Intelligence Interview Process

North Highland Business Intelligence Interview Questions

North Highland Business Intelligence Jobs