Prepare for and practice interview questions from Nigel Frank International.

Nigel Frank International Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Nigel Frank International Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

The schema below is for a retail online shopping company consisting of two tables, <code>attribution</code> and <code>user_sessions</code>.

<ul>
<li>The attribution table logs a session visit for each row.</li>

<li>If <code>conversion</code> is <code>true</code>, then the user converted to buying on that session.</li>

<li>The <code>channel</code> column represents which advertising platform the user was attributed to for that specific session.</li>

<li>Lastly the <code>user_sessions</code> table maps many to one session visits back to one user.</li>
</ul>

First touch attribution is defined as the channel with which the converted user was associated when they first discovered the website.

Calculate the first touch attribution for each <code>user_id</code> that converted. 

Example:

Input:

<code>attribution</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>session_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>channel</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>conversion</code></td>
<td>BOOLEAN</td>
</tr>
</tbody>
</table>
<code>user_sessions</code> table

<table>
<thead>
<tr>
<th>column</th>
<th>type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>session_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Example output:

<table>
<thead>
<tr>
<th><code>user_id</code></th>
<th><code>channel</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>123</td>
<td>facebook</td>
</tr>

<tr>
<td>145</td>
<td>google</td>
</tr>

<tr>
<td>153</td>
<td>facebook</td>
</tr>

<tr>
<td>172</td>
<td>organic</td>
</tr>

<tr>
<td>173</td>
<td>email</td>
</tr>
</tbody>
</table>

First Touch Attribution

D365 CE Business Analyst | MS Partner | Hybrid | Up to £65,000 + BonusLocation: Remote, with time on client sitesSalary: Up to £65,000 + Bonus + BenefitsEmployment Type: PermanentSector: Microsoft Partner (NFP) Are you a skilled Dynamics 365 CE Business Analyst looking to make a real impact within a forward-thinking end user environment? We’re working exclusively with a well-established organisation that’s investing heavily in Microsoft technologies and looking to expand their internal D365 capability. This is a fantastic opportunity to join a collaborative team where your insights will directly shape CRM strategy and customer engagement across the business. The RoleAs a D365 CE Business Analyst, you’ll act as the key liaison between business stakeholders and the technical delivery team. You’ll gather and translate requirements, support solution design, and help drive user adoption across the Sales, Customer Service, and Marketing modules. Key Responsibilities<ul><li>Lead workshops and stakeholder interviews to gather and document business requirements.</li><li>Translate business needs into functional specifications and user stories.</li><li>Collaborate with internal teams and external partners to deliver enhancements and new features.</li><li>Support testing, training, and change management activities.</li><li>Champion best practices and continuous improvement within the D365 CE platform.</li></ul> Ideal Candidate<ul><li>Proven experience as a Business Analyst within a Dynamics 365 CE / CRM environment.</li><li>Strong understanding of core modules: Sales, Customer Service, and/or Marketing.</li><li>Excellent communication and stakeholder engagement skills.</li><li>Experience with Power Platform (Power Automate, Power Apps) is highly desirable.</li><li>Agile delivery experience is a plus.</li></ul> What’s in It for You?<ul><li>Competitive salary up to £65,000 + performance bonus.</li><li>Flexible hybrid working model.</li><li>Opportunity to work directly with business leaders and influence CRM strategy.</li><li>Supportive culture with a focus on professional development and training.</li></ul>

Senior Business Analyst - UK-Wide (Remote) Lead the delivery of complex Microsoft Dynamics projects across CRM, ERP, and data domains, while mentoring project teams and driving continuous improvement. Role<ul><li>Support PMO leadership and deputise for the Head of PMO when required</li><li>Champion cross-functional collaboration across CRM and ERP delivery teams</li><li>Own and enhance PMO processes, governance, and reporting standards</li><li>Act as a subject matter expert and role model in project delivery excellence</li></ul> Responsibilities<ul><li>Deliver high-value Dynamics projects across CRM, ERP, Data, and Workplace domains</li><li>Manage project budgets, risks, issues, and change control with full accountability</li><li>Lead pre-sales activities including bids, demos, and tender support</li><li>Ensure projects meet time, cost, and quality expectations through structured methodologies</li></ul> Skills & Experience<ul><li>5+ years delivering Dynamics projects with experience in programme and portfolio management</li><li>Strong leadership, stakeholder engagement, and commercial acumen</li><li>Skilled in Agile, Waterfall, and Hybrid delivery methodologies</li><li>Certified in project management frameworks (Prince2, APM, MSP, Scrum Master)</li></ul> Benefits <ul><li>Starting Salary - up to £65k dependent on experience</li><li>Flexible, remote working model</li><li>Enhanced life assurance and more!</li></ul>

Question	Topic	Difficulty	Ask Chance
Boarding Times Bias	Statistics	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	Very High
First Touch Attribution	SQL	Hard	Very High

Nigel Frank International Interview Questions

Nigel Frank International Interview Guides

Nigel Frank International Interview Questions

Nigel Frank International Opening Jobs