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

Shaw Industries Business Intelligence Interview Guide

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


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

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

Overview

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

Shaw 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

Shaw Industries Business Intelligence Interview Questions

<p>Job Title Commercial Business Intelligence Analyst Position Overview This position will be a part of the Commercial Business Intelligence team, which resides within the Commercial Strategy and Insights group. The BI Analyst will be a leader in supporting the Commercial Sales and Marketing organization by building, maintaining, and improving key platforms for insight development and decision making. They will be a steward of Commercial Business data, delivering high quality insights for both operational use and strategic development. Responsibilities: Collaborate, consult, and lead discussions with business leaders, analysts, and engineers to collect business requirements and design effective solutions Organize and transform data to be used in analysis and visualization, utilizing SQL (within the Databricks platform) for data source development/ETL Develop clear and concise visual insights that lead to optimal decision making and business improvements, utilizing Tableau for visualization Ensure insights are accessible, repeatable, explainable, and actionable Deliver compelling communications about business insights with mid-level and senior leadership Drive projects with minimal supervision, effectively managing project scope, prioritization, and timelines Be a valuable partner to our business stakeholders, providing a positive user experience Organize and document data assets and visualizations, continuously knowledge sharing with team members Continuously learn about data visualization, cloud data engineering, and advanced analytics concepts Communicate with others at appropriate times in order to seek solutions to problems and/or clarify task requirements Partner with Shaws Enterprise IT organization to receive support and ensure data governance standards are met Be able to travel locally among Shaw facilities to train on the systems and information by presenting in front of groups of sales or marketing; or to travel to conferences Be able to work with confidential data and safeguard as appropriate Qualifications: 2 or 4 Year Degree in Business or Computer Science or equivalent program Experience developing insights with Data Visualization tools such as Tableau or PowerBI Experience coding in SQL both for querying and creating database objects Ability to creatively analyze data and find trends utilizing Excel, Tableau, and SQL Ability to contribute and lead cross functional teams to develop collaborative solutions Ability to effectively communicate to a variety of audiences with various technical backgrounds Strong problem-solving, critical thinking skills with willingness to challenge the status quo Strong learning agility and adaptive skills to new software and methodologies Strong business acumen with financial and sales literacy Flexible work environment with remote days Preferred Qualifications: Knowledge of Shaw Commercial Division business processes Experience with Databricks cloud-based platform Familiarity with Salesforce.com for sales quoting/opportunities/customer management, etc. Familiarity with Shaws order management system Experience with Data Science tools such as R or Python Experience with Data Lakes such as Azure, AWS, or Hadoop Required Competencies: Innovate: Create novel solutions with measurable value for existing and potential customers (internal and external); experiment with new ways to solve work problems and seize opportunities that result in unique and differentiated solutions. Adapt and Change: Maintain effectiveness during change, adjusting to new responsibilities or environment by exploring the benefits, trying new approaches, and collaborating with others to make the change successful. Influence Others: Create and execute strategies that commitment to of ideas and commitment to actions that support specific work outcomes. Build Trusting Relationships: Establish effective relationships with key stakeholders, customers and partners; interacting with others in a way that promotes openness and trust and gives them confidence in ones intentions. Demonstrate Customer Orientation: Craft and implement service practices that meet customer and organization needs, placing a high priority on the internal or external customers perspective when making decisions and taking action. Shaw benefits include: Medical, dental, and vision insurance Life insurance and disability coverage Tuition reimbursement Employee assistance program Health savings account Paid Time Off Parental Leave 401K and Retirement Plans Product discounts for employees Adoption assistance Shaw Family Health Center (Dalton, GA, and Cartersville, GA, locations) Work Shift 8 Hr non-rotating shift, Hrs fall to in punch day, Observed Calendar, shift starts AM Shaw Industries is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, gender identity, religion, sexual orientation, national origin, disability, genetic information, pregnancy, protected veteran status, or any other protected characteristic as outlined by federal, state, or local laws.</p>

Shaw Industries Business Intelligence Interview Guide

Overview

Shaw Industries Business Intelligence Salary

Shaw Industries Business Intelligence Interview Process

Shaw Industries Business Intelligence Interview Questions

Shaw Industries Business Intelligence Jobs