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

Connectedx Inc. Business Intelligence Interview Guide

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


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

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

Overview

Connectedx Inc. 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.

Connectedx Inc. 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 show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).</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>products</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>price</code></td>
<td>FLOAT</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>

<tr>
<td><code>sex</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>month</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_customers</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>num_orders</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>order_amt</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Monthly Customer Report

<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

Connectedx Inc. Business Intelligence Interview Questions

<p><strong>Data Analyst</strong></p><p><strong>Location: Ann Arbor Michigan (Onsite)</strong></p><p><strong>Long term</strong></p><p><strong>Preferred : Local </strong></p><p><strong>Bachelor’s degree or higher, or equivalent professional work experience.</strong></p><p><strong>Significant hands-on technical/analytical work experience relevant to this position, such as data modeling, data analysis, data warehouse engineering, and creating data pipelines.</strong></p><p><strong>Advanced skills in SQL.</strong></p><p><strong>Experience with reporting and analytics tools.</strong></p><p><strong>Strong knowledge and experience in database technologies such as Netezza, Snowflake, Oracle, SQL server, etc.</strong></p><p><strong>Project management experience.</strong></p><p><strong>Experience with Agile Methodologies.</strong></p><p><strong>Added bonus if you have </strong></p><p><strong>Advanced degree specifically in Computer Science, Finance, or Information Systems.</strong></p><p><strong>Banking or financial services industry experience.</strong></p><p><strong>Familiarity with Web Authentication products (i.e., Centrify, Okta).</strong></p><p><strong>Working knowledge of deployment/configuration of connector server clients to enable SSO and MFA to multiple AD domains.</strong></p>

<p><strong>Who we are </strong></p><p><strong>ConnectedX is focused on Digital Transformation and Product Engineering Services, enabling clients achieve their business, operating and technology needs for the digital age. Our unique industry-based, consultative approach helps clients implement digital transformation initiatives. Headquartered in Dallas, Texas, U.S. ConnectedX is a preferred partner for leading Fortune 1000 enterprises and is consistently admired by the clients and employees across the globe. </strong></p><p><strong>Data Analyst</strong></p><p><strong>Location: Ann Arbor Michigan (Onsite)</strong></p><p><strong>Long term</strong></p><p><strong>Preferred : Local </strong></p><p><strong>Bachelor’s degree or higher, or equivalent professional work experience.</strong></p><p><strong>Significant hands-on technical/analytical work experience relevant to this position, such as data modeling, data analysis, data warehouse engineering, and creating data pipelines.</strong></p><p><strong>Advanced skills in SQL.</strong></p><p><strong>Experience with reporting and analytics tools.</strong></p><p><strong>Strong knowledge and experience in database technologies such as Netezza, Snowflake, Oracle, SQL server, etc.</strong></p><p><strong>Project management experience.</strong></p><p><strong>Experience with Agile Methodologies.</strong></p><p><strong>Added bonus if you have </strong></p><p><strong>Advanced degree specifically in Computer Science, Finance, or Information Systems.</strong></p><p><strong>Banking or financial services industry experience.</strong></p><p><strong>Familiarity with Web Authentication products (i.e., Centrify, Okta).</strong></p><p><strong>Working knowledge of deployment/configuration of connector server clients to enable SSO and MFA to multiple AD domains.</strong></p>

Connectedx Inc. Business Intelligence Interview Guide

Overview

Connectedx Inc. Business Intelligence Salary

Connectedx Inc. Business Intelligence Interview Process

Connectedx Inc. Business Intelligence Interview Questions

Connectedx Inc. Business Intelligence Jobs