The Southern Wine & Spirits Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Southern Wine & Spirits Business Intelligence Interview Guide

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


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

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

Overview

Southern Wine & Spirits 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.

Southern Wine & Spirits 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 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

Southern Wine & Spirits Business Intelligence Interview Questions

<p>What You Need To Know Open your future to incredible career potential. Work for an industry-leader who invests in their people. Southern Glazer’s Wine & Spirits is North America’s preeminent wine and spirits distributor, as well as a family-owned, privately held company with a 50+ year legacy of success. We were named by Newsweek as a Most Loved Workplace and are included on the Forbes lists for Largest Private Companies and Best Employers for Diversity.
As a full-time employee, you can choose from a full menu of our Top Shelf Benefits, including comprehensive medical and prescription drug coverage, dental and vision plans, tax-saving Flexible Spending Accounts, disability coverage, life insurance plans, and a 401(k) plan. We also offer tuition reimbursement, a wellness program, parental leave, vacation accrual, paid sick leave, and more.
At Southern Glazer’s, you’ll enjoy an environment where continuous learning and growth are supported and experience a culture where you are respected, and your voice is heard. If you’re looking to fill your glass with opportunity, come join our FAMILY.
Overview Provide reporting, analytic review and support to members of the BI, Commercial Strategy, Commercial Sales and Commercial Operations teams to assist in evaluating the effectiveness of route-to-market strategies, business intelligence tools and applications.
Primary Responsibilities Support department-wide Insights projects that can drive standardization and efficiencies while driving innovation of new reporting capabilities and insights.
Input corporate and supplier programs into designated business intelligence applications (i.e., NSM, Goal Builder, SODs, Business Objects, etc.).
Track, review, verify, analyze and report accurate results to Commercial leadership, field team, and/or suppliers in a timely manner.
Identify system deficiencies and propose possible solutions.
Evaluate past program success/failure trends; use trend analysis to advise stakeholders on proposed programs.
Provide accurate insights into live program performance and evaluate ROI on key initiatives.
Follow established reporting and documentation standards to ensure uniformity throughout the organization.
Provide analysis on Route-to-Market design, sales planning/execution, sales force size/coverage, Org. Structures, etc.
Additional Primary Responsibilities Develop performance management initiatives including compensation/incentive design, development of KPIs, etc.
Provide Sales and Marketing stakeholders with a data-driven roadmap for sales execution.
Complete quarterly field sales ride-along throughout the sales organization as needed.
Support operational efficiencies and cost savings initiatives (e.g., supplier/SKU optimization, variable service, and delivery levels/fees, etc.).
Streamline established Business Intelligence reporting to align with standards and processes.
Provide support to Leadership with ad hoc reporting and query needs and provide accurate and timely results consistent with state/region/national standards.
Perform other job-related duties as assigned.
Minimum Qualifications Bachelor’s degree and up to three years of experience in a corporate business analyst role.
Experience in the Wine and Spirits/Beverage Industry with cross-functional experience.
Knowledge of applicable state regulations and adult beverage market dynamics.
Experience in RTM.
Proficient in SharePoint and all aspects of Microsoft Office Suite with an emphasis on Excel.
Demonstrated analytical ability and able to build presentation and business cases.
Strong interpersonal skills and ability to communicate both verbally and in writing.
Able to organize priorities and work under deadlines while producing a high-quality result in a team environment.
Physical Demands Physical demands include a considerable amount of time sitting and typing/keyboarding, using a computer (e.g., keyboard, mouse, and monitor) or adding machine.
Physical demands with activity or condition may occasionally include walking, bending, reaching, standing, and stooping.
May require occasional lifting/lowering, pushing, carrying, or pulling up to 20lbs.
EEO Statement Southern Glazer's Wine and Spirits, an Affirmative Action/EEO employer, prohibits discrimination and harassment of any type and provides equal employment opportunities to all employees and applicants for employment 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 laws.

#J-18808-Ljbffr</p>

Southern Wine & Spirits Business Intelligence Interview Guide

Overview

Southern Wine & Spirits Business Intelligence Salary

Southern Wine & Spirits Business Intelligence Interview Process

Southern Wine & Spirits Business Intelligence Interview Questions

Southern Wine & Spirits Business Intelligence Jobs