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

Cybercoders Business Intelligence Interview Guide

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


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

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

Overview

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

Cybercoders 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

Cybercoders Business Intelligence Interview Questions

<strong>Job Title: </strong>Controls Engineering Manager<br><br><strong>Location: </strong>St. Louis, MO - North of Arnold City Park and Meramec River<br><br><strong>Salary: </strong>$120K - $140K<br><br><strong>Requirements: </strong>PLC Programming, Control Panel Design, Machine Vision (Cognex/Keyence), Management<br><br>This role will be based out of 40,000 square foot plant. This is an on-site position. We have created a strong culture and found this is a great way for us to continue to push ideas and help one another learn and develop. We are currently seeking a Controls Engineering Manager who is looking to help guide our established team and work alongside our Director of Engineering. We are seeking someone to come in and lead by example to the other engineers around them. Our team consists of multiple levels of engineers.<br><br>This position will interact with our customers to help provide them new and unique situations, or solve problems that have arisen. We work across multiple industries, but all mass production manufacturers are able to leverage our product and insure end users are provided the highest quality, while providing our clients the opportunity to locate system defaults.<br><br><strong>Responsibilities<br><br></strong><ul><li>Manage teams that design and implement control systems and software for new and existing projects.</li><li>We would like someone who can be hands on with programming PLCs and HMIs.</li><li>Teach and Create Panel Designs.</li><li>Test and commission new automation systems.</li><li>Understanding on how to work with Machine Vision systems, leveraging Cognex and Keyence.<br><br></li></ul><strong>Qualifications<br><br></strong><ul><li>Bachelor's degree in engineering or related field preferred</li><li>5+ years of experience in programming PLC's. </li><li>5 + Experience with designing control panels.</li><li>Experience with Machine Vision Software - Cognex or Keyence.</li><li>Some management, or project management experience<br><br></li></ul><strong>Benefits<br><br></strong><strong>Vacation/PTO<br><br></strong><strong>Medical<br><br></strong><strong>Dental<br><br></strong><strong>Vision<br><br></strong><strong>401k<br><br></strong><strong>Bonus<br><br></strong><strong>Email Your Resume In Word To<br><br></strong>Looking forward to receiving your resume through our website and going over the position with you. Clicking apply is the best way to apply, but you may also:<br><br>steve.nash@cybercoders.com<br><br><ul><li>Please do NOT change the email subject line in any way. You must keep the JobID: linkedin : SN1-1818505 -- in the email subject line for your application to be considered.***<br><br></li></ul>Steve Nash - Recruiting Manager<br><br>Applicants must be authorized to work in the U.S.<br><br>This job was first posted by CyberCoders on 09/05/2024 and applications will be accepted on an ongoing basis until the position is filled or closed.<br><br><strong>CyberCoders is proud to be an Equal Opportunity Employer<br><br></strong>All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity or expression, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, status as a crime victim, disability, protected veteran status, or any other characteristic protected by law. CyberCoders will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable state and local law, including but not limited to the Los Angeles County Fair Chance Ordinance, the San Francisco Fair Chance Ordinance, and the California Fair Chance Act. CyberCoders is committed to working with and providing reasonable accommodation to individuals with physical and mental disabilities. If you need special assistance or an accommodation while seeking employment, please contact a member of our Human Resources team to make arrangements.<br><br>Copyright 1999 - 2024. CyberCoders, Inc. All rights reserved.<br><br>

Cybercoders Business Intelligence Interview Guide

Overview

Cybercoders Business Intelligence Salary

Cybercoders Business Intelligence Interview Process

Cybercoders Business Intelligence Interview Questions

Cybercoders Business Intelligence Jobs