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

Atos Business Intelligence Interview Guide

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


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

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

Overview

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

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

Atos Business Intelligence Interview Questions

<p>Eviden, part of the Atos Group, with an annual revenue of circa € 5 billion is a global leader in data-driven, trusted and sustainable digital transformation. As a next generation digital business with worldwide leading positions in digital, cloud, data, advanced computing and security, it brings deep expertise for all industries in more than 47 countries. By uniting unique high-end technologies across the full digital continuum with 47,000 world-class talents, Eviden expands the possibilities of data and technology, now and for generations to come.Position: Business AnalystLocation: Nashville, TN / OnsiteType: FulltimeSalary range: $90K - $115K (Depends upon experience)Requirements:A bachelor's degree in business or related field or an MBA. A minimum of 5 years of experience in business analysis or a related field.Exceptional analytical and conceptual thinking skills.The ability to influence stakeholders and work closely with them to determine acceptable solutions.Advanced technical skills.Excellent documentation skills.Fundamental analytical and conceptual thinking skills.Experience creating detailed reports and giving presentations.Competency in Microsoft applications including Word, Excel, and Outlook. A track record of following through on commitments.Excellent planning, organizational, and time management skills.Experience leading and developing top-performing teams. A history of leading and supporting successful projects.Responsibilities:Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions.Leading ongoing reviews of business processes and developing optimization strategies.Staying up-to-date on the latest process and IT advancements to automate and modernize systems.Conducting meetings and presentations to share ideas and findings. Performing requirements analysis.Documenting and communicating the results of your efforts.Effectively communicating your insights and plans to cross-functional team members and management.Gathering critical information from meetings with various stakeholders and producing useful reports.Working closely with clients, technicians, and managerial staff. Providing leadership, training, coaching, and guidance to junior staff.Allocating resources and maintaining cost efficiency. Ensuring solutions meet business needs and requirements.Performing user acceptance testing. Managing projects, developing project plans, and monitoring performance.Updating, implementing, and maintaining procedures. Prioritizing initiatives based on business needs and requirements.Serving as a liaison between stakeholders and users.Managing competing resources and priorities.Monitoring deliverables and ensuring timely completion of projects.Let's grow together.</p>

Eviden, part of the Atos Group, with an annual revenue of circa € 5 billion is a global leader in data-driven, trusted and sustainable digital transformation. As a next generation digital business with worldwide leading positions in digital, cloud, data, advanced computing and security, it brings deep expertise for all industries in more than 47 countries. By uniting unique high-end technologies across the full digital continuum with 47,000 world-class talents, Eviden expands the possibilities of data and technology, now and for generations to come. <br><br>Position: Business Analyst <br><br>Location: Nashville, TN / Onsite <br><br>Type: Fulltime <br><br>Salary range: $90K - $115K (Depends upon experience) <br><br>Requirements: <br><br>A bachelor's degree in business or related field or an MBA. A minimum of 5 years of experience in business analysis or a related field. <br><br>Exceptional analytical and conceptual thinking skills. <br><br>The ability to influence stakeholders and work closely with them to determine acceptable solutions. <br><br>Advanced technical skills. <br><br>Excellent documentation skills. <br><br>Fundamental analytical and conceptual thinking skills. <br><br>Experience creating detailed reports and giving presentations. <br><br>Competency in Microsoft applications including Word, Excel, and Outlook. A track record of following through on commitments. <br><br>Excellent planning, organizational, and time management skills. <br><br>Experience leading and developing top-performing teams. A history of leading and supporting successful projects. <br><br><b>Responsibilities</b>: <br><br>Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions. <br><br>Leading ongoing reviews of business processes and developing optimization strategies. <br><br>Staying up-to-date on the latest process and IT advancements to automate and modernize systems. <br><br>Conducting meetings and presentations to share ideas and findings. Performing requirements analysis. <br><br>Documenting and communicating the results of your efforts. <br><br>Effectively communicating your insights and plans to cross-functional team members and management. <br><br>Gathering critical information from meetings with various stakeholders and producing useful reports. <br><br>Working closely with clients, technicians, and managerial staff. Providing leadership, training, coaching, and guidance to junior staff. <br><br>Allocating resources and maintaining cost efficiency. Ensuring solutions meet business needs and requirements. <br><br>Performing user acceptance testing. Managing projects, developing project plans, and monitoring performance. <br><br>Updating, implementing, and maintaining procedures. Prioritizing initiatives based on business needs and requirements. <br><br>Serving as a liaison between stakeholders and users. <br><br>Managing competing resources and priorities. <br><br>Monitoring deliverables and ensuring timely completion of projects. <br><br><b>Let's grow together.</b>

Atos Business Intelligence Interview Guide

Overview

Atos Business Intelligence Salary

Atos Business Intelligence Interview Process

Atos Business Intelligence Interview Questions

Atos Business Intelligence Jobs