The Border States Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Border States Business Intelligence Interview Guide

Getting ready for an Business Intelligence interview at Border States? The Border States Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Border States Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Border States.</li>
<li>Practice real Border States Business Intelligence interview questions.</li>
</ul>
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 Border States Business Intelligence interview.


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

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

Overview

Border States Business Intelligence Salary

We've gathered this data from parsing thousands of interview experiences sourced from members.

We've gathered this data from parsing thousands of interview experiences sourced from members.

Border States Business Intelligence Interview Process

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.

Write a query to get the total three-day rolling average for deposits by day.

Note: Please use the format <code>&#39;%Y-%m-%d&#39;</code> for the date in the outout

Example:

Input:

<code>bank_transactions</code> table

<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>
Output:

<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

Write a query to identify the manager with the biggest team size.

You may assume there is only one manager with the largest team size.

Example:

Input:

<code>employees</code> table

<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>
<code>managers</code> table

<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>
Output:

<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

Let’s say you’re working for a social media company trying to grow your user base. You know that people tend to use the same social network as their peers, so you want to target all your growth and marketing efforts on specific age groups so as to take advantage of network effects.

You wish to begin with the age group that is currently generating the most connections (fastest growing).

Write a SQL query to find the average number of accepted friend requests for each age group and order the results in descending order.

Note: The average number of accepted friend requests is calculated as the total number of friend requests sent by an age group that was accepted divided by the number of members in said age group.

We can assume the tables hold valid data in that there are no duplicate friend requests, friend requests are only accepted once, and user A can only accept a friend request from User B after B sends A a friend request.

The result should be rounded to two decimal places.

<h3>Example:</h3>

Input:

<code>friend_requests</code>

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

<tbody>
<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>receiver_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>sent_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<code>requests_accepted</code>

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

<tbody>
<tr>
<td>accepter_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>requester_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>accepted_at</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<code>age_groups</code>

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

<tbody>
<tr>
<td>user_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td>age_group</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>average_acceptance</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Find the average number of accepted friend requests for each age group that sent the requests.

Avg Friend Requests By Age Group

Border States Business Intelligence Interview Questions

Be part of a growing, successful company in an exciting and challenging field. Border States is 100% employee-owned, which means you're empowered to make decisions, find solutions and receive rewards for your hard work. This position will be located in: Nashville , TN Job Summary Supports the day-to-day operations of Branches, Account Managers, Quotations Teams, Customer Service Reps, and customers by providing product, application, and technical support and service. Regularly calls on branches along with customer accounts and makes joint sales calls with Account Managers to secure orders and perform other sales support functions for technical products and services, by providing customers field support, application support, training, and other services as required. Responsibilities Essential Functions <ul> <li>Works closely with Border States' sales and marketing staff to meet and exceed sales and gross profit objectives. </li> <li>Regularly calls-on customer accounts and makes joint sales calls with Account Managers to secure orders and perform other sales support functions for technical products and services, by providing customers field support, application support, training, and other services as required. </li> <li>Consults with customers on product and system applications. </li> <li>Supports BSE Quotations teams with timely follow-up on technical inquiries and other requests. </li> <li>Provides continuous contact and interaction with customer's engineering staff, contractors and consultants. </li> <li>Provides specific or specialized product support for branches and customers. </li> <li>Actively participates in the marketing, planning, and sale of Border States' technical products and services. </li> <li>Participates in and advises management on the implementation and success of marketing plans and strategies. </li> <li>Consistently provides responsive, quality service to meet and exceed customer expectations. </li> <li>Provides input to other sales and marketing staff on customer needs and concerns regarding pricing, products, competition, procedures, and market potential.</li> <li>Evaluates new products and makes recommendations on stock levels for new and existing products. </li> <li>Provides input to the pricing and purchasing departments on product evaluations and code descriptions, inventory management, pricing developments, and other related functions. </li> <li>Leads customer and BSE employee training on new and existing technical product lines and applications in specified product areas. </li> <li>Works with associated manufacturing agents/vendors as a liaison on all strategic issues related to planning, marketing, new products, launch and training.</li></ul> Non-essential Functions <ul> <li>Evaluates demo equipment and makes suggestions for new products in specified product areas. </li> <li>Inputs TCCM cost savings documentation that is relevant to the assigned customer base. </li> <li>Ensures existing demos are in functional condition. </li> <li>Performs product updates and new product launches for branches and customers as required. </li> <li>Attends and assists with sales meetings, trade shows and training programs as needed.</li> <li>Performs other duties as assigned by supervisor or designate.</li></ul> Qualifications <ul> <li>Minimum of a four-year technical or engineering degree preferred or the equivalent in work experience. </li> <li>Prefer the knowledge and technical competence in understanding electrical and hi-tech industrial products and applications including industrial automation software and hardware. </li> <li>Minimum of four-years of prior customer service, marketing, quotation or sales experience preferred. </li> <li>Minimum of three-years of prior electrical distribution and quotations experience preferred with a comprehensive knowledge of BSE product lines and applications, alternate product substitutes, and supplier pricing policies. </li> <li>Ability to read, write and speak in English preferred. </li> <li>Prefer strong working knowledge of PC for Windows, Microsoft Office (Excel, Word, Access and PowerPoint), Internet, Email and SAP software.</li></ul> Skills and Abilities <ul> <li>Excellent interpersonal, written and verbal communication and customer service skills are preferred with the ability to effectively plan and organize. </li> <li>Excellent customer service skills include being competent, accurate, responsive and engaged.</li></ul> Physical Requirements Frequency at which you would carry/lift in a typical day: Occasionally 0 - 33% Frequently 34 - 66% Continuously: 67 - 100% <ul><li>Lift from Waist:<ul><li><li>10 to 25 lbs. - Not at all</li><li>26 to 50 lbs. - Not at all</li><li>51 to 75 lbs. - Not at all</li><li>75 to 100 lbs. - Not at all</li><li>100+ lbs. - Not at all</li></ul></li><li>Lift from Floor:<ul><li><li>10 to 25 lbs. - Frequently</li><li>26 to 50 lbs. - Occasionally</li><li>51 to 75 lbs. - Not at all</li><li>75 to 100 lbs. - Not at all</li><li>100+ lbs. - Not at all</li></ul></li><li>Carried for Distance:<ul><li><li>10 to 25 lbs. - Not at all</li><li>26 to 50 lbs. - Not at all</li><li>51 to 75 lbs. - Not at all</li><li>75 to 100 lbs. - Not at all</li><li>100+ lbs. - Not at all</li></ul></li></ul> Physical Activity Frequency at which you would do the following in a typical day: <ul> <li>Sitting (a continuous period of being seated) - Frequently</li> <li>Standing (for sustained periods of time) - Frequently</li> <li>Walking (moving about on foot to accomplish tasks) - Frequently</li> <li>Bending/stooping (downward and forward) - Occasionally</li> <li>Crawling (moving about on hands and knees or hands and feet) - Not at all</li> <li>Climbing/Walking Stairs (ascending or descending) - Frequently</li> <li>Reaching (extending arms in any direction) - Frequently</li> <li>Crouching/squatting (bending the body downward and forward by bending leg and spine) - Occasionally</li> <li>Kneeling (bending legs at knee to come to rest on knee(s)) - Occasionally</li> <li>Balancing (maintaining body equilibrium to prevent falling) - Occasionally</li> <li>Repetitive motion (substantial movement (motions) or the wrists, hands, and/or fingers) - Continuously</li> <li>Pivoting (movement in any direction with one foot, keeping the other in contact with the floor) - Occasionally</li> <li>Pushing/Pulling (using upper extremities to press against or draw or tug) - Occasionally</li> <li>Grasping (Applying pressure to an object with the fingers and palm) - Continuously</li> <li>Fingering (picking, pinching, typing; working with primarily fingers and not whole hand) - Continuously</li> <li>Talking (expressing or exchanging ideas by means of the spoken word) - Frequently</li> <li>Driving (the control and operation of a motor vehicle) - Frequently</li> <li>Desk work (work usually performed at a desk) - Frequently</li> <li>Use of a computer - Continuously</li> <li>Use of a telephone - Frequently</li> <li>Hearing (Perceiving the nature of sounds at normal speaking levels) - Continuously</li> <li>Exposure (to adverse weather & temperature conditions) - Occasionally</li> <li>Travel (travel needed to perform job duties) - Frequently</li></ul> Additional Information This job description is a summary of the job duties and responsibilities and is not intended to cover all possible job duties and is subject to change at the employer's discretion. Employees must be able to perform the essential job duties and satisfy job requirements either with or without a reasonable accommodation. Our History Border States is a leader in the electrical supply distribution industry with over 100 locations in 24 states. Our employee-owners are second to none in delivering top-notch customer service and in demonstrating extra-ordinary people skills. We are one of the largest independent electrical distributors in the United States providing products and services to the construction, industrial and utility industries. Border States has a competitive benefit package and is a 100 percent employee-owned company. Employee-ownership is a significant part of our culture and our success stems from the dedication of our employee-owners. We practice open-book management and our employee-owners are empowered with clearly defined levels of authority to be innovative and decisive, allowing us to respond quickly to the needs of customers. Employee-owners understand their roles in the success of the company and care about customers' needs, which drives our focus on adding value to everything we do. We recognize that not all customers are the same and each has specific requirements. Our employee-owners understand these diverse needs and have the commitment, resourcefulness and flexibility to outperform all others. Values As a Border States employee-owner, you're responsible for living our mission, service philosophy and service standards. Mission Border States provides value to our customers by delivering innovative product and supply chain solutions. Service Philosophy We earn customer loyalty and confidence by caring about their needs and adding value to everything we do. Service Standards Border States employee-owners are competent, accurate, responsive, and engaged . Your career Join an experienced team at one of the largest electrical distributors in the United States. What are you waiting for? Border States has a competitive benefits package which includes but is not limited to: Health, Dental and Vision Benefits Accident, Critical Illness, Hospital Indemnity FSA & HSA Employee Stock Ownership Plan (ESOP) Disability Benefits 401(k) Retirement Plan Life Insurance Employee Assistance Program Paid Holidays Paid Volunteer Time Personal Leave time and more! Border States provides bonuses to their employee-owners upon the achievement of branch and company goals. Equal Opportunity For All It's not just the law. It's something we've believed in since our founding. We value the diversity of all of our employee-owners and will always be an equal opportunity employer. Drug Free/Smoke Free workplace

Border States Business Intelligence Interview Guide

Overview

Border States Business Intelligence Salary

Border States Business Intelligence Interview Process

Border States Business Intelligence Interview Questions

Border States Business Intelligence Jobs