The Neiman Marcus Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Neiman Marcus Business Intelligence Interview Guide

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


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

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

Overview

Neiman Marcus 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.

Neiman Marcus 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

Neiman Marcus Business Intelligence Interview Questions

<b>Job Description</b><br><br>Neiman Marcus Group is a relationship business that leads with love in everything we do-for our customers, associates, brand partners, and communities. Our legacy of innovating and our culture of Belonging guide our roadmap for Revolutionizing Luxury Experiences. <b>Your Role</b> The Tableau Analyst is a full time, entry-level position supporting our Company initiative to leverage data to better serve our customers. The position provides first-hand insights to our merchant partners to improve decision making. Leveraging visuals to easily identify strengths and weaknesses that can supplement future or current strategies. This position will be a liaison for not only delivering visuals but also helping the merchant population with how best to leverage Tableau and our other systems. In addition to Tableau, this position will assist in preparation of ad hoc analysis to support Senior leaders. <br><br><b><strong>What You'll Do </strong></b> <ul> <li>Assist in bringing data to life through visualization from Tableau</li> <li>Partner with cross functional teams to understand needs and develop, test, and deploy new visualizations that assist in better merchandising decision making</li> <li>Responsible for updating, refining, and maintaining existing Tableau views along with ad hoc data analysis Communicates with buying offices on discrepancies</li> <li>Listening skills are a must as you will be taking needs from users across the organization to establish requirements for new visualizations or enhancements to existing templates</li> </ul> <b>What You Bring</b> <ul> <li>Bachelor's degree from a four-year college or university</li> <li>Previous experience in retail, service, or other fast paced environments</li> <li>Must be analytical, articulate, and organized</li> <li>Excellent communication skills, both written and verbal</li> <li>Must work confidently in teams</li> <li>Able to multi-task and work independently in a fast-paced environment and prioritize effectively</li> <li>Must be proficient in Microsoft Word, Excel, and other Microsoft Office properties</li> <li>Must have a firm understanding of SQL, Excel, Tableau, and DB visualizer</li> <li>Quick study on new computer systems and quickly understands and incorporates new system functionality</li> <li>Strong follow up and follow through to make sure all tasks are taken to full completion</li> </ul><br><br><b>Qualifications:</b><br><br><b>Inclusive Benefits</b> We offer an inclusive and comprehensive range of benefits to our valued associates, including: <ul> <li>Medical, Dental, Vision Benefits</li> <li>Disability Benefits</li> <li>Paid Parental Leave, Paid Family Leave, and Adoption Support</li> <li>Paid Time Off</li> <li>Retirement Savings Plan (401K) and Life Insurance</li> <li>Financial Solutions</li> <li>NMG Associates Core Discount of 30%</li> <li>Personal and Professional Development Opportunities</li> </ul> For more information, please click "Our Benefits" section on our career site or reference the link here: https://www.neimanmarcusgroup.com/benefits <b>About Neiman Marcus Group</b> As one of the largest multi-brand luxury retailers in the U.S., with 3,000+ of the world's most desirable brand partners, we're delivering exceptional products and intelligent services enabled by our investments in data and technology. Through the expertise of our associates, we deliver and scale a personalized luxury experience across our three channels of in-store, eCommerce, and remote selling. Our NMG|Way culture, powered by our people, combines individual talents into a collective strength to make life extraordinary. Our brands include Neiman Marcus and Bergdorf Goodman. Our legacy of innovation and culture of Belonging guide our roadmap for Revolutionizing Luxury Experiences. As a female-founded, female-majority organization that outpaces the U.S. population in racial and ethnic diversity, our people are at the heart of our progress, and we take great care to protect and empower them. We are committed to equal employment opportunity regardless of race, color, religion, sex, pregnancy, sexual orientation, gender identity and/or expression, marital status, age, national origin, disability, genetic information, veteran status, or any other status protected by federal, state, or local law. We are committed to providing reasonable accommodations during our Talent Acquisition process. If you have a disability and need assistance or an accommodation, please email us at ApplicantSupport@NeimanMarcus.com.

Neiman Marcus Business Intelligence Interview Guide

Overview

Neiman Marcus Business Intelligence Salary

Neiman Marcus Business Intelligence Interview Process

Neiman Marcus Business Intelligence Interview Questions

Neiman Marcus Business Intelligence Jobs