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

Brandeis University Business Intelligence Interview Guide

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


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

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

Overview

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

Brandeis University 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>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

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

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

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

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


Find the total salary of slacking employees.

Slacking Employees Salaries

<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

Brandeis University Business Intelligence Interview Questions

The IT Department at Brandeis is looking for a Temp Business Analyst, IT Change Management Office.<br><br>Please note that this is a temporary position for a duration of 3 months.<br><br>Job Description/Job Duties:<br><br><ul><li>They will develop job aids, instructional videos, and other instructional materials as well schedule training sessions and work with subject matter experts to deliver training to users.</li><li>Coordinate with IT Organizational Change team and Project Managers to work on deliverables such as training plans, training needs analysis, meeting facilitation, and website management as directed.</li><li>Manage change management and product training activities via detailed planning, tracking, and reporting on progress.</li></ul><br><br>Requirements:<br><ul><li>Bachelor's degree</li><li>3-5 years of relevant experience</li></ul><br><br><strong><b>Equal Opportunity Statement</b></strong><br><br>Brandeis University is an equal opportunity employer which does not discriminate against any applicant or employee on the basis of race, color, ancestry, religious creed, gender identity and expression, national or ethnic origin, sex, sexual orientation, pregnancy, age, genetic information, disability, caste, military or veteran status or any other category protected by law (also known as membership in a "protected class")

Brandeis University is delighted to announce a career opportunity as a Business Analyst, IT Change Management. The Business Analyst, CMO position, operating within the Change Management Office (CMO), is responsible for business analysis, training, testing, and communication related to projects in support of ITS supported products, in accordance with the needs of departments across campus. This position will coordinate and conduct user training, testing, document communications, and provide user support as applicable with ITS staff members requesting assistance with their projects, and act as liaison between the requesting party and others in ITS to ensure successful completion of projects. The individual will also contribute to system enhancements and product upgrades, performing analysis and eliciting requirements from stakeholders. Expertise in Salesforce, Marketing Cloud Account Engagement (MCAE), and Linvio is highly important for this type of work. The individual also supports applications built in the Slate CRM, as well as the Workday ERP system in support of various stakeholder groups across campus.This is a hybrid role and will require working at our Waltham, MA campus.For full consideration, please upload your cover letter and resume.Job Description:Training & Readiness (45%)Develop various types of training for the CRM and ERP suite of products.Develop written job aids to assist and train users how to use CRM and ERP associated applications.Develop training videos to demonstrate commonly used functionality for CRM and ERP and its associated applications.Deliver live training to user groups.Alert users to product enhancements, changes in functionality, and system issues.Coordinate system down time and maintenance windows with technical resources and functional teams.Act as a liaison between the technical team in ITS and functional users.Review vendor delivered system enhancement and upgrade documentation and determine what training material needs to be modified or created.CRM Support and Business Analysis (45%)Know the products of the Workday, Salesforce, and Slate suites and manage processes to update training assets based on product release cycles.Configure and support Marketing Cloud Account Engagement and Linvio, working in conjunction with the Salesforce SystemAdmin to apply and test application updates, and troubleshoots questions and issues from usersMaintain and support projects within the shared ITS instance of the Slate CRM, working with various campus partners.Analyze existing and future state business processes, systems and flows of data.Develop and maintain documentation related to developing and modifying business processes and systems.Partner with business, internal and external technology teams to define associated system requirements and solutions.Elicit business requirements from functional area staff and from stakeholders across campus in need of reports anddashboards. Develop, test, and refine reports and dashboards to meet user needs.Manage day-to-day operational aspects of a project's scope.Manage client expectation and scope changes effectively.Ensure issues are identified, tracked, reported on and resolved in a timely manner.Participate in additional ITS initiatives as assigned.Communications (10%)Develop and produce content for a variety of communication channels including print, presentations, digital displays, web,and video, based on the needs of the project or initiative.Design consistent and effective messages, marketing materials, policy, and social media campaigns, print brochures,newsletters, digital signage, publications, and brand standards to represent and promote ITSContribute to the design/development of the ITS website. Write new content, establish new features, and develop new interactive elements.Job Requirements:BA/BS required in preferably in the field of Communications, Management Information Systems, or Related.Work Experience: 3-5 yrs. related work experience.Strong customer service and communication skills required.Previous experience developing and delivering training required.Experience in Higher Education with functional knowledge of Institutional Advancement core business processes is preferred.Experience in Salesforce is strongly preferredExperience with UX design concepts is highly desirable.Equal Opportunity StatementBrandeis University is an equal opportunity employer which does not discriminate against any applicant or employee on the basis of race, color, ancestry, religious creed, gender identity and expression, national or ethnic origin, sex, sexual orientation, pregnancy, age, genetic information, disability, caste, military or veteran status or any other category protected by law (also known as membership in a "protected class")

Brandeis University Business Intelligence Interview Guide

Overview

Brandeis University Business Intelligence Interview Process

Brandeis University Business Intelligence Interview Questions

Brandeis University Business Intelligence Jobs