The Churchill downs Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Churchill downs Business Intelligence Interview Guide

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


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

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

Overview

Churchill downs 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.

Churchill downs 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 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

<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

Churchill downs Business Intelligence Interview Questions

<h3>Job Description</h3><div>Job Description<div><p><strong>SUMMARY</strong></p><p>The Business Analyst – Audio Video (AV) Specialist will focus primarily on the operations, standardization of support processes and documentation related to Audio, Video (e.g. Outdoor LED Video Boards, Naked Eye 3D video Boards), Presentation & Conference room systems and IPTV systems. Their primary responsibility will be to work with local IT and corporate IT to ensure the enterprise AV systems across all of Churchill Downs Incorporated’s gaming sites in the USA are correctly implemented, maintained and have support processes defined and communicated. The ideal candidate has experience managing vendor relationships and maintaining an understanding of vendor support contracts and is comfortable setting-up metrics that allow CDI to measure and maintain a high levels of up-time for those systems. In an outage, the AV Specialist will work with the onsite and third-party support teams to restore service as quickly as possible. Utilizing their working knowledge of various applications within the AV space the AV Specialist will guide property operations and IT teams who may be new to the AV system’s space. This individual will write functional specification documents, test plans, training plans, deployment plans, and policies and procedures supporting AV operations and projects.</p><p></p><p></p><p><strong>ESSENTIAL DUTIES and RESPONSIBILITIES include the following:</strong></p><ul><li>Responsible for documenting existing processes for AV support and building and maintaining a new process for defining a support structure for existing AV systems.</li><li>Continuously look for opportunities to standardize AV support processes and systems across all existing properties and future properties.</li><li>Facilitate meetings to discuss end-user requirements, status, issues, planning, training, and/or operational needs related to a facility AV system.</li><li>Maintain an equipment list with warranty/support agreement dates included for each property.</li><li>Work with vendors and the local IT teams to keep AV systems up to date and remediate any security vulnerabilities discovered.</li><li>Stay current on industry standards and practices within the AV industry to offer potential alternatives and upgrade options, mainly when replacement or installation of new systems is being considered.</li><li>Work with Local IT and vendors for issue monitoring and quick resolution.</li><li>Work with construction & vendor timelines to schedule vendors at the appropriate times to deliver systems when needed with minimal impact to the business.</li><li>Work with businesses to identify and improve business processes within the application's abilities.</li><li>Ensure the business is aware of system capabilities to better utilize available systems.</li><li>Responsible for timely and complete communications between the corporate IT team, vendors, and all property staff as needed.</li><li>Analyze the application needs and contribute to the design, structure, and maintenance of the systems and architecture.</li><li>Analyzes business and user needs, documentation of requirements, and translation into proper system requirement specifications.</li><li>Ability to plan, estimate, and schedule multiple tasks and develop detailed resource and project plans.</li><li>Possesses technical and AV industry knowledge of most phases of systems analysis and considers the business implications of applying technology to the current and future business environment.</li><li>Analyzes business requirements and defines information systems solutions to address complex business needs (requiring innovative and creative solutions and frequently involving multiple platforms, software, hardware, technologies, and tools).</li><li>Provides support to users in system and software administration and usage.</li><li>Communicate and coordinate maintenance schedules, backups, and downtime to users.</li><li>Additional duties as assigned.</li></ul><p></p><p><strong>REGULATORY </strong></p><p>Ability to obtain racing and/or gaming licenses as required in any jurisdiction where CDI operates. The gaming industry is highly regulated and, as such, requires an extensive background check to obtain a license. Must be 21 years of age.</p><p></p><p><strong>EDUCATION and EXPERIENCE:</strong></p><ul><li>Bachelor’s degree in Information Technology or equivalent experience.</li><li>Minimum 3 years of experience in Information Technology supporting AV systems.</li><li>Project Management background a plus.</li><li>Experience in gaming applications support preferred.</li><li>Experience understanding of major business processes within Gaming industry preferred.</li><li>Experience with planning, budgeting, and standard business processes preferred.</li></ul><p></p><p><strong>REQUIRED SKILLS:</strong></p><ul><li>Ability to <span class="long-word">articulate/demonstrate</span> 2+ major IT/casino AV project implementations.</li><li>Minimum 3+ years of proven vendor relationship management experience.</li><li>Understanding of core ITIL processes (i.e. Incident, Request, Change Management).</li><li>Excellent interpersonal and communication skills (oral and written).</li><li>Support a 24/7 365 information systems environment.</li><li>Ability to manage multiple complex projects simultaneously according to agreed-upon schedules and budgets.</li><li>Strong attention to detail and prompt follow-up.</li></ul><p></p><p></p><p><strong>PHYSICAL DEMANDS/ WORKING CONDITIONS:</strong></p><ul><li>Extended periods of sitting at a desk and working on a computer.</li><li>Regular use of a keyboard and mouse for typing and navigating software.</li><li>Viewing a computer screen for prolonged periods.</li><li>Ability to manipulate paperwork, including filing, sorting, and organizing.</li><li>Moving within the office environment to attend meetings, use office equipment, or interact with colleagues.</li><li>Occasional lifting of office supplies or paperwork (up to 20 pounds).</li><li>Speaking and listening to colleagues and clients in person, over the phone, or via video conferencing.</li><li>Working in a climate-controlled office environment with moderate noise levels.</li><li>Performing repetitive tasks such as data entry or document preparation.</li><li>Working under artificial lighting conditions typical of an office environment, including fluorescent or LED lighting.</li></ul></div></div>

Churchill downs Business Intelligence Interview Guide

Overview

Churchill downs Business Intelligence Salary

Churchill downs Business Intelligence Interview Process

Churchill downs Business Intelligence Interview Questions

Churchill downs Business Intelligence Jobs