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

Compugain Business Intelligence Interview Guide

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


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

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

Overview

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

Compugain 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>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

Compugain Business Intelligence Interview Questions

<p>Unisys is an Information Technology and Business Consulting firm providing project-based solutions, software solutions and professional staffing services. - "Those authorized to work in the United States are encouraged to apply. We are unable to sponsor at this time. Job Title: Business Data Analyst Location: Remote Duration: 8 Months Contract Client has exciting career opportunities for a Business Analyst within the Data Strategy and Enablement group. This role will provide support for business processes (including but not limited to Enterprise, Account and Person data management) with focus on process creation, management and execution of large scale data clean up initiative. What you'll do: Drive data quality initiatives on improving the accuracy of our client data that's leveraged in critical business throughout the enterprise while curating data insights that will ultimately improve the transparency and value of data across Gartner. Collaborate across business and technical teams, both on site and offshore, to create business deliverables such as Data flow diagrams, Business Requirements, Functional Requirements, User Stories and User Acceptance Tests Obtain understanding of relevant business area(s), technical options, limitations, costs and risks to communicate tradeoffs and recommend solutions or suggest alternatives to proposed solutions to shape requirements Independently drive critical data workshops with business and IT stakeholders to develop requirements and execution process while managing dependencies across teams Review data records/attributes on a periodic basis and to ensure data quality and curate data insights that will ultimately improve the transparency and value of data across Gartner Ensure quality through adherence to and supporting processes and procedures, including the maintenance of documentation on shared file systems Review delivery team output to ensure requirements are correctly interpreted; define and execute test cases Provide support to other business analysts, business process owners and project managers to help drive business initiatives What you'll need: 3 years of experience as a Business/Data Analyst; prior experience in working in Data Warehouse, Master Data Management, Analytics environment a plus Expert level communication with both technical and non-technical personnel, both oral and written Strong analytical, strategic thinking and problem-solving skills including ability to clearly and concisely gather, interpret, analyze and document Business Process, User and Data Functional requirements in a structured way Ability to breakdown complex business problems and workflows into meaningful components that are understandable by various levels Well versed with in utilizing tools such MS Excel, MS Word, Google Suite, MS Visio, Lucid Chart, JIRA, Confluence Advanced SQL Skills Required Basic understanding of data analysis tools and techniques is a plus Experience with business intelligence and data visualization systems is a plus (Tableau, Power BI) Data governance experience is a strong consideration Knowledge and experience with Scrum/Agile methodology Thanks & Best Regards Syed Adnan Jaffer Talent Acquisition Specialist Unisys Email:syed.adnanjafferunisys.com Phone: 703 964 3066</p>

<strong>Unisys is an Information Technology and Business Consulting firm providing project-based solutions, software solutions and professional staffing services. -<br><br>"Those authorized to work in the United States are encouraged to apply. We are unable to sponsor at this time.<br><br>Job Title: Business Data Analyst<br>Location: Remote<br>Duration: 8 Months Contract</strong><br><br>Client has exciting career opportunities for a Business Analyst within the Data Strategy and Enablement group. This role will provide support for business processes (including but not limited to Enterprise, Account and Person data management) with focus on process creation, management and execution of large scale data clean up initiative. <br><br>What you'll do: <ul> <li>Drive data quality initiatives on improving the accuracy of our client data that's leveraged in critical business throughout the enterprise while curating data insights that will ultimately improve the transparency and value of data across Gartner.</li> <li>Collaborate across business and technical teams, both on site and offshore, to create business deliverables such as Data flow diagrams, Business Requirements, Functional Requirements, User Stories and User Acceptance Tests</li> <li>Obtain understanding of relevant business area(s), technical options, limitations, costs and risks to communicate tradeoffs and recommend solutions or suggest alternatives to proposed solutions to shape requirements</li> <li>Independently drive critical data workshops with business and IT stakeholders to develop requirements and execution process while managing dependencies across teams</li> <li>Review data records/attributes on a periodic basis and to ensure data quality and curate data insights that will ultimately improve the transparency and value of data across Gartner</li> <li>Ensure quality through adherence to and supporting processes and procedures, including the maintenance of documentation on shared file systems</li> <li>Review delivery team output to ensure requirements are correctly interpreted; define and execute test cases</li> <li>Provide support to other business analysts, business process owners and project managers to help drive business initiatives</li> <li>What you'll need:</li> <li>3 years of experience as a Business/Data Analyst; prior experience in working in Data Warehouse, Master Data Management, Analytics environment a plus</li> <li>Expert level communication with both technical and non-technical personnel, both oral and written</li> <li>Strong analytical, strategic thinking and problem-solving skills including ability to clearly and concisely gather, interpret, analyze and document Business Process, User and Data Functional requirements in a structured way</li> <li>Ability to breakdown complex business problems and workflows into meaningful components that are understandable by various levels</li> <li>Well versed with in utilizing tools such MS Excel, MS Word, Google Suite, MS Visio, Lucid Chart, JIRA, Confluence</li> <li>Advanced SQL Skills Required</li> <li>Basic understanding of data analysis tools and techniques is a plus</li> <li>Experience with business intelligence and data visualization systems is a plus (Tableau, Power BI)</li> <li>Data governance experience is a strong consideration</li> <li>Knowledge and experience with Scrum/Agile methodology</li></ul><strong>Thanks & Best Regards<br>Syed Adnan Jaffer<br>Talent Acquisition Specialist<br>Unisys <br>Email:syed.adnanjaffer@unisys.com<br>Phone: 703 964 3066</strong>

Compugain Business Intelligence Interview Guide

Overview

Compugain Business Intelligence Salary

Compugain Business Intelligence Interview Process

Compugain Business Intelligence Interview Questions

Compugain Business Intelligence Jobs