The Holland America Line Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Holland America Line Business Intelligence Interview Guide

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


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

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

Overview

Holland America Line 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.

Holland America Line 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>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><strong><code>players</code></strong> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

<p>What are the logistic and softmax functions? What is the difference between the two?</p>

<p>What makes them useful for use in logistic regression?</p>


<p>In logistic regression, how is the predicted class determined based on the logistic function?</p>


In logistic regression, how is the predicted class determined based on the logistic function?

Softmax vs Logistic II

<p>What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?</p>


What is the key characteristic of the logistic function that makes it useful for mapping continuous values to a probability?

Softmax vs Logistic I

What are the logistic and softmax functions? What is the difference between the two?

Softmax vs Logistic

Holland America Line Business Intelligence Interview Questions

<p>As the Manager – Global Air Sourcing Analytics, you’ll play a pivotal role within the Global Air Sourcing group. You will lead the Air Analytics function by designing and developing meaningful dashboards and data visualizations, analyzing the results, and making business recommendations. You will be the subject matter expert for PowerBI on the team by ensuring data integrity and functionality of new and existing dashboards and be the main point of contact with questions related to PowerBI functionality and error resolution. You will work closely with the Strategic Sourcing Team in developing the strategy and implementing those strategies with airlines and GDS partners. You will lead all Global Air Sourcing efforts and projects related to IT, data and systems, and automation, by collaborating closely with IT and other relevant stakeholders.</p><p><strong><u>Essential Functions:</u></strong></p><ul><li>Design and develop meaningful dashboards and data visualizations by importing data from multiple data sources to support the strategic sourcing efforts of the Global Air Sourcing team. Write ad-hoc queries in SQL to obtain the required data from underlying tables.</li><li>Ensure data integrity and functionality of new and existing PowerBI dashboards and serve as the Subject Matter Expert for the Global Air Sourcing team and brands with questions related to PowerBI functionality and error resolution.</li><li>Lead all Global Air Sourcing efforts and projects related to IT, data and systems, and automation, by collaborating closely with IT and other relevant stakeholders.</li><li>Support the Global Air Sourcing Team with ad-hoc data analytics and other projects as needed.</li><li>Dive into dashboards, reports, data, and trends to uncover opportunities and identify trends that can shape negotiation strategies, developing actionable recommendations for the Manager – Global Air Sourcing and the Director – Global Air Sourcing by providing analytics and insights.</li><li>Partner with IT to identify and implement improved analytic tools and data structures, as well as manage efforts related to the development, maintenance (including researching and resolving issues), accuracy, and hygiene of air data.</li></ul><p><strong><u>Qualifications:</u></strong></p><ul><li>Education: Master’s degree preferred, with an undergraduate degree in Finance, Business Administration, Supply Chain, Mathematics, Statistics, Economics, or related fields.</li><li>Years & Area of Professional Experience: 5-8 years of experience working with advanced analytics. Strong commercial acumen and PowerBI knowledge required. Excellent verbal and written communication skills and attention to detail. Highly driven and self-motivated, with an entrepreneurial spirit. Air industry experience is strongly preferred; strategic sourcing and cruise line experience is a plus. Critical Professional Related Technical/Computer Skills: Proficiency in all Microsoft Office applications, with strong expertise in Excel and Power BI, is required. Expertise in Oracle SQL and Oracle SQL Developer (including SSRS and TSQL) is required, providing this person the ability to browse database objects, run SQL statements, edit and debug PL/SQL statements and run reports. Expertise in ETL Tools, Power Query, MDX, and DAX is required. GDS (Sabre / Amadeus) knowledge and experience is a plus.</li></ul><p><u>Physical Demands:</u> Must be able to remain in a stationary position at a desk and/or computer for extended periods of time.</p><p><u>Travel:</u> Less than 25% non-shipboard travel likely.</p><p><u>Work Conditions:</u> Work primarily in a climate-controlled environment with minimal safety/health hazard potential.</p><p>This position is classified as 'in-office.' As an in-office role, it requires employees to work from a designated Carnival office in South Florida from Tuesday through Thursday. Employees may work from home on Mondays and Fridays. Some positions may require additional in-office time each week and the final schedule is determined by your leader. Candidates must be located in (or willing to relocate to) the Miami/Ft. Lauderdale area.</p><p>Offers to select candidates will be made on a fair and equitable basis, taking into account specific job-related skills and experience.</p><p>At Carnival, your total rewards package is much more than your base salary. All non-sales roles participate in an annual cash bonus program, while sales roles have an incentive plan. Director and above roles may also be eligible to participate in Carnival’s discretionary equity incentive plan. Plus, Carnival provides comprehensive and innovative benefits to meet your needs, including:</p><ul><li>Health Benefits:<ul><li>Cost-effective medical, dental and vision plans.</li><li>Employee Assistance Program and other mental health resources.</li><li>Additional programs include company-paid term life insurance and disability coverage.</li></ul></li><li>Financial Benefits:<ul><li>401(k) plan that includes a company match.</li><li>Employee Stock Purchase plan.</li></ul></li><li>Paid Time Off<ul><li>Holidays – All full-time and part-time with benefits employees receive days off for 7 company-wide holidays, plus an additional floating holiday to be taken at the employee’s discretion.</li><li>Vacation Time – All full-time employees at the manager and below level start with 14 days/year; director and above level start with 19 days/year. Part-time with benefits employees receive time off based on the number of hours they work, with a minimum of 84 hours/year. All employees gain additional vacation time with further tenure.</li><li>Sick Time – All full-time employees receive 80 hours of sick time each year. Part-time with benefits employees receive time off based on the number of hours they work, with a minimum of 60 hours each year.</li></ul></li><li>Other Benefits<ul><li>Complementary stand-by cruises, employee discounts on confirmed cruises, plus special rates for family and friends.</li><li>Personal and professional learning and development resources including tuition reimbursement.</li><li>On-site preschool program and wellness center at our Miami campus.</li></ul></li></ul><p>#LI-Hybrid</p><p>#LI-LS1</p>
#J-18808-Ljbffr

Holland America Line Business Intelligence Interview Guide

Overview

Holland America Line Business Intelligence Salary

Holland America Line Business Intelligence Interview Process

Holland America Line Business Intelligence Interview Questions

Holland America Line Business Intelligence Jobs