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

Discount tire Business Intelligence Interview Guide

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


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

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

Overview

Discount tire 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.

Discount tire 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 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

<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

Discount tire Business Intelligence Interview Questions

<p>Overview: </p><p>Here at Discount Tire, we celebrate the spirit of our people with extraordinary pride and enthusiasm. Our business has been growing for more than 60 years and now is the best time in our history to join us. We are opening more locations every year and we are always looking for qualified individuals to join us in our growth. We are a company that promotes from within, both in our retail and corporate operations. Under minimal supervision the Senior UX Product Analyst evaluates existing Omni Channel Business systems and provides solutions to optimize user / customer experience. Ensures the quality of Omni Channel applications to achieve business goals. Embodies IOOGA (Integrity, Our People, Our Customers, Growth and Attitude). </p><p><strong>Essential Duties and Responsibilities:</strong> </p><ul> <li>Analyzes enhancement requests and defects, clarifies objectives and scope, summarizes findings, proposes improvements to stakeholders </li><li>Aligns functional requirements and designs to support Omni Channel projects; collaborates with stakeholders to understand and align with technical requirements </li><li>Documents user stories to assist in the creation of high-fidelity prototypes, AB Test cases, Proof of Concepts, and development efforts. </li><li>Ensures requirements related to design and user experience are documented, actionable, measurable, testable and related to identified business needs or opportunities in collaboration with stakeholders </li><li>Serves as Product Owner and Subject Matter Expert for application features who provides first level of support for questions regarding business requirements, UX designs, and general system functionality </li><li>Understands the Software development lifecycle and collaborates with Leadership, Business Stakeholders, and IT counterparts to groom backlogs and prioritize work </li><li>Communicates and coordinates schedule for feature development </li><li>Serves as UX liaison to other business segments, to coordinate joint efforts for web and store system features </li><li>Coordinates approval of functional requirements and development backlog stories </li><li>Assists in the coordination and communication of UX demonstrations to stakeholders </li><li>Proactively evaluates and resolves issues among teams; recognizes and articulates the trade-offs, risks and advantages of solutions; documents key decisions based on information provided </li><li>Stays current on the latest industry technologies, trends and strategies. </li><li>Delivers education/information to internal and external stakeholders regarding capabilities. </li><li>Serves as business liaison to technical teams. </li><li>Mentors, coaches and trains Specialists I and II. </li><li>Assists employees, vendors or other customers by answering questions related to Omni Channel business processes and procedures. </li><li>Completes work in a timely and accurate manner while providing exceptional customer service. </li><li>Other duties as assigned. </li></ul> <p><strong>Qualifications:</strong> </p><ul> <li>This position requires a minimum 5 years information technology, business analysis or related experience. </li><li>Previous experience with Retail Systems required. </li><li>SAP/Hybris experience preferred. </li><li>Progressive experience leading or facilitating projects teams is required. </li><li>Expert analytical and product management skills required, including a thorough understanding of interpreting customer business needs and translating into application and functional requirements. </li><li>Expert ability using enterprise-wide requirements definition and management systems and methodologies is needed. </li><li>Expertise with Agile delivery methods and actively managing a backlog is required. </li><li>Proficiency with Microsoft Office, including skills with Word and Excel is necessary. </li><li>Progressive experience managing professional services engagements and working with internal shared services to build project scope, metrics and manage performance to metrics is necessary. </li><li>Expert ability to communicate across all levels of the organization, present complex ideas concisely and clearly articulate technical ideas to a non-technical audience both verbally and in writing is necessary. </li><li>Ability to actively engage in multiple initiatives simultaneously is necessary. </li><li>Ability to identify complex problems, review information to develop and evaluate options then implement solutions is essential. </li><li>Proven ability to provide innovative ideas with the technical skill to implement ideas in prototype is required. </li><li>Able to work efficiently and accurately under pressure, meet deadlines, present a professional demeanor and work well independently is essential. In addition, troubleshooting and organizational skills with a can-do attitude and the ability to adjust to changing requirements are essential. </li><li>Customer service skills including the ability to manage and respond to different customer situations while maintaining a positive and friendly attitude is essential. </li><li>Maintaining confidentiality, treating others with respect and upholding Company values are key. </li></ul> <p><strong>Educational Requirements:</strong> </p><ul> <li>Bachelors degree in project management, systems analysis or a related study, or equivalent experience is required. </li></ul> <h5><strong>Work Days:</strong> </h5><ul> <li>Normal work days are Monday through Friday. Occasional Saturdays and Sundays may be necessary. </li></ul> <p><strong>Work Hours:</strong> </p><p>Normal work hours are 8:00 a.m. to 5:00 p.m. Additional hours may be necessary. </p> <p>Discount Tire provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local law. <br> </p> <p>#LI-Hybrid </p><p>#LI-MS1</p>

Discount tire Business Intelligence Interview Guide

Overview

Discount tire Business Intelligence Salary

Discount tire Business Intelligence Interview Process

Discount tire Business Intelligence Interview Questions

Discount tire Business Intelligence Jobs