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

Mohawk Industries Business Intelligence Interview Guide

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


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

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

Overview

Mohawk Industries 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.

Mohawk Industries 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>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

Mohawk Industries Business Intelligence Interview Questions

Are you looking for more?<br><br>At Mohawk Industries, we're committed to more - more customer solutions, more process improvements, more sustainable manufacturing and more opportunities for our team. <br><br>As a Fortune 500, global flooring leader with some of the best-known brands in the industry, Mohawk is a great place to start or develop your career with an emphasis on more of what's important to you. Whether you want to lead more, innovate more, learn more or create more, you can find your more with Mohawk.<br><br><b>What we're looking for: </b><br><br>Mohawk is looking for a Business Analyst that is an established performer that works to facilitate and support CRM applications and projects by utilizing strong knowledge of industry practices and standards. This role will collaborate with various departments to understand business needs, document requirements, and analyze data to inform business decisions.<br><br><b>What you'll do:</b> <br><ul> <li>Work on projects and assignments as part of a large work team to support business owners.</li> <li>Perform accurate analyses, conduct research, and draw meaningful conclusions about potential job/work-area impacts.</li> <li>Provide functional and technical support on CRM projects.</li> <li>Draw from prior experience, interpret facts, and identify incomplete data/anomalies to solve problems.</li> <li>Assist when needed with the development, configuration and testing of CRM applications, under the guidance of a senior team member.</li> <li>Analyze data to identify trends, patterns, and insights that can inform business decision-making.</li> <li>Utilize tools and techniques to extract valuable information from diverse datasets.</li> <li>Serve as a Second-tier support provider for sales support, troubleshooting, and research and resolution of issues.</li> <li>Assist in testing new system modules or system improvements in cooperation with the QA Teams.</li> <li>Fully understand the complete CRM processes from a functional viewpoint so problems can be easily identified in the correct context and efficient problem resolution can be guaranteed.</li> <li>Generate and maintain comprehensive documentation, including business requirements, process flows, and technical specifications.</li> <li>Create reports and dashboards to communicate key performance indicators (KPIs) and insights.</li> <li>Perform other duties as needed.</li></ul><br><br><b>What you have:</b><br><br><ul> <li>Bachelor's degree in a related field preferred.</li> <li>2-4 years' relevant experience OR equivalent combination of education and experience.</li> <li>Preferred Salesforce Administration Certifications.</li> <li>Experience with other CRM applications desirable; SAP preferred.</li></ul><br><br><b>What else?</b><br><ul> <li>We're located in a pretty great spot - check out this video to see what we mean</li> <li>Hybrid Work environment</li></ul><br><br>Mohawk Industries is a leading global flooring manufacturer that creates products to enhance residential and commercial spaces around the world. Mohawk's vertically integrated manufacturing and distribution processes provide competitive advantages in the production of carpet, rugs, ceramic tile, laminate, wood, stone and vinyl flooring. Our industry-leading innovation has yielded products and technologies that differentiate our brands in the marketplace and satisfy all remodeling and new construction requirements. Our brands are among the most recognized in the industry and include American Olean, Daltile, Durkan, IVC, Karastan, Marazzi, Mohawk, Mohawk Home, Pergo, and Quick-Step. During the past decade, Mohawk has transformed its business from an American carpet manufacturer into the world's largest flooring company with operations in Australia, Brazil, Canada, Europe, India, Malaysia, Mexico, New Zealand, Russia and the United States.<br><br>Mohawk Industries, Inc. is an Equal Opportunity Employer including disability/veteran committed to an inclusive workplace and a proud Drugs Don't Work participant.

Mohawk Industries Business Intelligence Interview Guide

Overview

Mohawk Industries Business Intelligence Salary

Mohawk Industries Business Intelligence Interview Process

Mohawk Industries Business Intelligence Interview Questions

Mohawk Industries Business Intelligence Jobs