The Wynn Las Vegas Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Wynn Las Vegas Business Intelligence Interview Guide

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


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

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

Overview

Wynn Las Vegas 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.

Wynn Las Vegas 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

Wynn Las Vegas Business Intelligence Interview Questions

<h3>Job Description</h3><div>Job Description<div>Job Description<br><br><p>Wynn Resorts is seeking a skilled Data Analyst to join our dynamic Marketing Department. The ideal candidate will be proficient in data analysis, segmentation, and reporting techniques to support various marketing initiatives. The Data Analyst will play a crucial role in optimizing marketing strategies, enhancing revenue generation, and leveraging data insights to drive business growth. This position will be based in Las Vegas and it will be an in-person role.</p><p><strong>Job Responsibilities:</strong></p><ul><li>Support the Marketing Department in the areas of budgeting, marketing audience list segmentation, performance analysis, reporting, data modeling, revenue enhancement & data mining.</li><li>Present information to the Marketing Team and provide strategy recommendations based upon analysis.</li><li>Collaborate with the Digital Media Team on channel performance and determine opportunities for optimization and new audience segmentation use cases.</li><li>Maintain ongoing key performance reporting as well as answering more difficult questions through advanced data mining techniques.</li><li>Collaborate with external partners on new Google Analytics 4 account setup.</li><li>Provide and initiate ad-hoc analyses to answer key business questions and explain trends/anomalies.</li><li>Setup and utilize Segment CDP. This will include setting up Sources and Destinations, Persona Management, Audience Segmentation, and more.</li></ul>Qualifications<br><br><ul><li>Bachelor's degree (preferably in marketing, finance, or other business related field).</li><li>Two to three years in an analytical marketing role preferred.</li><li>Minimum computer skills required include proficiency in Excel, Word, PowerPoint & MS Access.</li><li>Comfortable with database querying tools such as SQL Server & MySQL required.</li><li>Previous experience with Opera preferred.</li><li>Previous experience using Segment or similar CDP.</li><li>Google Analytics experience preferred.</li><li>Proficient in creating data visualizations in Tableau</li><li>Experience using Python, R, or other coding languages to perform analysis.</li><li>Experience using Snowflake, Google BigQuery or other data warehouses.</li><li>Comfortable working autonomously.</li><li>Must be 21 years of age or older.</li></ul><br><br>Additional Information<br><br><p>Wynn Resorts is an equal opportunity employer committed to hiring a diverse workforce and sustaining an inclusive culture. Wynn Resorts does not discriminate on the basis of disability, veteran status or any other basis protected under federal, state or local laws.</p></div></div>

Wynn Las Vegas Business Intelligence Interview Guide

Overview

Wynn Las Vegas Business Intelligence Salary

Wynn Las Vegas Business Intelligence Interview Process

Wynn Las Vegas Business Intelligence Interview Questions

Wynn Las Vegas Business Intelligence Jobs