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

Nleague Business Intelligence Interview Guide

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


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

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

Overview

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

Nleague 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

Nleague Business Intelligence Interview Questions

<h3>Job Description</h3><div>Job Description<div><p><b>Job Overview</b><b>:</b></p><p></p><p>The <b>Virginia Department of Transportation (VDOT)</b> <b>Business Integrated Solutions Division (BISD)</b> is seeking a Master Data Analyst with demonstrated experience in data analytics to work as a key member of the <b>Business Analysis</b> and <b>Testing Support team</b>. This analyst will support teams working in <b>Agile (Sprint)</b> as well as traditional <b>Waterfall methodologies</b> for <b>Software Development Lifecycle (SDLC).</b><br><br> Responsibilities include analyzing problems; documenting business processes and data lifecycle; developing data requirements, user stories and acceptance criteria; and testing. VDOT is a fast-paced organization with very high standards for work quality and efficiency. This position is expected to handle multiple projects, and remain flexible and productive, despite changing priorities and processes. Ongoing improvement and efficiency are a part of our culture, and each team member is expected to proactively contribute to process improvements.<br><br><b>Responsibilities:</b></p><ul><li>Work with the Project team members and business stakeholders to understand business processes and pain points. </li><li>Develop expertise in the customers' <b>datasets</b> and <b>data lifecycle</b></li><li><b>Profile source data</b>; review source data and compare content and structure to dataset requirements; identify conflicts and determine recommendations for resolution</li><li>Conduct entity resolution to identify <b>matching</b> and <b>merging</b> and <b>semantic conflicts</b></li><li><b>Elicit, record, and manage metadata</b></li><li>Diagram current processes and proposed modifications using <b>process flows</b>, <b>context diagrams</b> and <b>data flow diagrams</b></li><li>Discover and document requirements and userstories with a focus on improving both business and technical processing</li><li>Decompose requirements into Epics and Features and create clear and concise user stories that are easy to understand and implement by technical staff</li><li>Utilize <b>progressive elaboration</b>; map stories to <b>data models</b> and <b>architectures</b> to be used by internal staff to facilitate master data management</li><li>Identify and group related user stories into themes, document dependencies and associated business processes</li><li><b>Assist Product Owner</b> in maintaining the product backlog</li><li>Create conceptual prototypes and mock-ups</li><li>Collaborate with staff, vendors, consultants, and contractors as they are engaged on tasks to formulate, detail and test potential and implemented solutions</li><li>Perform Quality Analyst functions such as defining test objectives, test plans and test cases, and executing test cases</li><li>Coordinate and Facilitate <b>User Acceptance Testing</b> with Business and ensure <b>Project Managers/Scrum Masters</b> are informed of the progress<br><br><b>Qualifications</b> <b>Required:</b></li></ul><ul><li>The candidate must have a minimum of 10 years of experience delivering <b>business data analysis artifacts</b>. </li><li>5+ years of experience as an <b>Agile Business Analyst</b>; strong understanding of <b>Scrum concepts</b> and methodology</li><li>Experience organizing and <b>maintaining Product</b> and <b>Sprint backlogs</b></li><li>Experience translating client and product strategy requirements into dataset requirements and user stories</li><li>Proficient with defining acceptance criteria and managing acceptance process</li><li>Experience with <b>enterprise data management</b></li><li>Expertise with <b>Microsoft Office products</b> (<b>Word, Excel, Access, Outlook, Visio, PowerPoint, Project Server</b>)</li><li>Experience with reporting systems <b>operational data stores</b>, <b>data warehouses</b>, <b>data lakes</b>, <b>data marts</b></li><li>The candidate must have exceptional written and oral communications skills and have the proven ability to work well with a diverse set of peers and customers</li></ul><p><b>Preferred:</b></p><ul><li><b>Certified Business Analysis Professional (CBAP</b>) and/or <b>Certified Scrum Product Owner (CSPO)</b> Certification</li><li><b>Certified Data Management Professional (CDMP)</b></li><li>Experience using <b>Team Foundation Server</b> and work item tracking</li><li>Experience with automated testing tools such as <b>Test Complete</b></li></ul></div></div>

Nleague Business Intelligence Interview Guide

Overview

Nleague Business Intelligence Salary

Nleague Business Intelligence Interview Process

Nleague Business Intelligence Interview Questions

Nleague Business Intelligence Jobs