The Nc State University Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Nc State University Business Intelligence Interview Guide

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


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

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

Overview

Nc State University 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.

Nc State University 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

You’ve been asked to analyze the player’s behaviors at a gaming company.

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.

Example:

Input:

<code>players</code> table

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

<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

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

What makes them useful for use in logistic regression?

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

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

Softmax vs Logistic II

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

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

Nc State University Business Intelligence Interview Questions

Posting Information Posting Number PG193805EP Internal Recruitment No Working Title Energy Data Analyst Anticipated Hiring Range $80,000 - $85,062 Work Schedule M-F 7:00am -4:00pm; with some flexible/remote work capability Job Location Raleigh, NC Department Energy Management About the Department The North Carolina State University Facilities Division ensures that the campus's physical environment supportsthe university's mission 24 hours a day, 365 days a year. Our diverse team of approximately 900 dedicated professionals plans for current and future needs, buildshigh-impact facilities, and maintains the campus. Join one of the largest and best employers in the state and help shape the future of our campus community! As a Pack member, you can enjoy exclusive perks designed to enhance your personal and professional well-being. What we offer: <ul><li>Medical, Dental, and Vision </li><li>Flexible Spending Account </li><li>Retirement Programs </li><li>Disability Plans </li><li>Life Insurance </li><li>Accident Plan </li><li>Paid Time Off and Other Leave Programs </li><li>12 Holidays Each Year </li><li>Tuition and Academic Assistance </li><li>And so much more! </li> </ul>Essential Job Duties We are seeking a passionate and knowledgeable Energy Data Analyst to join our ever growing team. This position will play a critical role in supporting campus energy management initiatives. The ideal candidate will be skilled and enthusiastic about analyzing energy and water data to drive cost-saving measures and sustainable practices. By performing detailed statistical analysis, preparing reports, and collaborating with campus personnel, you will help identify actionable opportunities for energy and water conservation. This position offers an opportunity to contribute to sustainability efforts while utilizing your analytical skills to make a difference at NC State. If you're ready to make an impact with data-driven insights, we encourage you to apply. Key responsibilities and duties include but are not limited to: <ul><li>Analyze energy and water data to identify trends, outliers, and cost-saving opportunities </li><li>Prepare clear and concise reports on energy and water consumption to support cost avoidance initiatives </li><li>Perform energy cost accounting and statistical analysis to uncover inefficiencies </li><li>Collaborate with campus personnel and utility companies to resolve utility discrepancies and consumption inconsistencies </li><li>Support external benchmarking and the measurement and verification of conservation measures </li><li>Conduct life cycle cost analysis and cash flow projections for pilot conservation projects </li><li>Develop and publish regular reports on energy and water consumption trends and costs </li><li>Interface with campus utility customers to address billing questions and provide insights </li><li>Report performance outcomes of energy and water conservation projects to management and regulatory agencies </li><li>Develop and publish periodic campus energy and water consumption and cost trend reports </li><li>Periodically interface with campus utility customers on billing questions and investigations </li><li>Report to campus management and regulatory agencies on periodic energy and water conservation project performance, including measurement and verification reporting </li><li>Design an application to perform measurement and verification for an Energy Savings Performance Contract by creating time-series data queries from our data historian and generating formatted outputs for QA/QC in final reporting </li><li>Perform frequent ad-hoc data queries to identify and interpret anomalies, determining if they stem from metering errors, communication issues, or building performance, using data from sources such as the data historian, utility billing software, and utility provider portals to enhance reporting, visualization, and insights into campus energy performance and utilization </li></ul>Other Responsibilities <ul><li>Participate in NC State's Campus Environmental Sustainability Team working groups </li><li>Participate in UNC system sponsored energy & water conservation initiatives </li><li>Represent NC State at professional meetings and conferences as resources allow </li><li>Other duties as assigned </li></ul>Qualifications Minimum Education and Experience Master's degree and at least one year of relevant experience; or Bachelor's degree with at least two years' of relevant experience; or an equivalent combination of education, training and relevant experience. - For management-level roles, also include with the above requirements 1-2 years of supervisory experience. All degrees must be received from appropriately accredited institutions. Other Required Qualifications <ul><li>Strong interest in energy economics and finance </li><li>Proficient in quantitative, analytical, and statistical methods </li><li>Able to work both independently and as part of a team, with an emphasis on achieving common goals in a small office environment </li><li>Deep understanding of organizational structure and relationships for effective problem-solving </li><li>Skilled in verbal and written communication, translating complex information for various audiences and choosing appropriate formats for presenting findings and recommendations </li> </ul>Preferred Qualifications <ul><li>Experience in analyzing and presenting utility and energy data, auditing industrial and commercial energy and water bills, knowledge of electric and natural gas tariffs, emerging energy efficiency trends, participation in energy audits, and proficiency in energy conversion calculations </li></ul>Required License(s) or Certification(s) <ul><li>North Carolina driver's license within 60 days of hire </li></ul> Valid NC Driver's License required Yes Commercial Driver's License required No Recruitment Dates and Special Instructions Job Open Date 11/18/2024 Anticipated Close Date Open Until Filled Special Instructions to Applicants Please include a resume, cover letter and contact information for three professional references. Position Details Position Number 00061472 Position Type EHRA Non-Faculty Full Time Equivalent (FTE) (1.0 = 40 hours/week) 1.00 Appointment 12 Month Recurring Mandatory Designation - Adverse Weather Non Mandatory - Adverse Weather Mandatory Designation - Emergency Events Non Mandatory - Emergency Event Department ID 445020 - Energy Management AA/EEO NC State University is an equal opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, gender identity, age, sexual orientation, genetic information, status as an individual with a disability, or status as a protected veteran. Individuals with disabilities requiring disability-related accommodations in the application and interview process are welcome to contact 919-515-3148 to speak with a representative at the Office of Equal Opportunity If you have general questions about the application process, you may contact Human Resources at (919) 515-2135 or workatncstate@ncsu.edu. Final candidates are subject to criminal & sex offender background checks. Some vacancies also require credit or motor vehicle checks. Degree(s) must be obtained prior to start date in order to meet qualifications and receive credit. NC State University participates in E-Verify. Federal law requires all employers to verify the identity and employment eligibility of all persons hired to work in the United States.

Nc State University Business Intelligence Interview Guide

Overview

Nc State University Business Intelligence Salary

Nc State University Business Intelligence Interview Process

Nc State University Business Intelligence Interview Questions

Nc State University Business Intelligence Jobs