The Metaphase Consulting Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Metaphase Consulting Business Intelligence Interview Guide

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


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

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

Overview

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

Metaphase Consulting 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>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.</p>

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

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

<p><em>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.</em></p>

<p><em>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.</em></p>

<p><em>The result should be rounded to two decimal places.</em></p>

<h3>Example:</h3>

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

<p><strong><code>friend_requests</code></strong></p>

<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>
<p><strong><code>requests_accepted</code></strong></p>

<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>
<p><strong><code>age_groups</code></strong></p>

<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>
<p><strong>Output:</strong></p>

<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

<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

Metaphase Consulting Business Intelligence Interview Questions

<strong>Description</strong><br><br><strong>Description</strong> <br><br>At MetaPhase, we believe Quirky is Cool and being authentic is the only way to be! We take the work we do very seriously and do a lot of important mission-focused work for our clients. We are individuals with different passions and strengths who take as much joy in the work we do as from those we work with. Today, we have a team that is invested in creating new solutions that lean forward, challenge the status quo, but also reflect our intimate knowledge of our customers' business. Over the years we have fostered a culture in which we are united by shared values-passion, solidarity, generosity, curiosity, and boldness-and these come alive in the work we do and how we do it. <br> <br>Together, we know our people are our difference-for our clients and our colleagues. <br> <br><b>Are you ready to:</b> <br><ul> <li>Work alongside a dedicated and diverse set of people to offer honest advice and practical guidance to our clients? </li> <li>Learn and grow by taking advantage of every opportunity available to you? </li> <li>Join a company which prides itself on its shared values and inclusive culture? </li> <li>Be the difference and make it happen? </li></ul><strong>Role Summary</strong> <br><br>MetaPhase Consulting (MPC) is currently supporting our client at the US Department of the Treasury with their Enterprise IT Acquisition Management program. In support of this project, MPC is seeking aBusiness Analystwith three (3+) years of experience managing complex client relationships, strong engagement skills, and commitment to high quality standards for deliverables. This role will help identify common IT acquisition needs, establish and promote enterprise acquisition processes, and foster shared and scalable solutions across the Treasury department. <br> <br>What You Will Be Doing <br> <ul><li>Reviewing acquisition requests to ensure compliance with applicable policies and procedures. </li><li>Tracking the status of acquisition packages and communicating with customers throughout the acquisition process. </li><li>Preparing and maintaining reports and records to include capturing, analyzing, detailing, and updating project information (status, metrics, outputs, etc.) </li><li>Facilitating meetings to include scheduling and capturing, distilling, and distributing meeting minutes. </li></ul><strong>What We Need From You (Required) </strong> <br><ul> <li>A minimum of three or more (3+) years of direct experiencemanaging or providing support for the management of a financial portfolio, preferably 1-3 years of experience in federal government consulting. </li> <li>Excellent verbal and written communication skills with demonstrated ability to articulate information in an effective manner. </li> <li>Well organized and detail-oriented with the ability to self-direct multiple work requirements simultaneously. </li><li>Proficient with the Microsoft Office Suite of tools (Word, Excel, PowerPoint). </li></ul><strong>Bonus Points (Desired)</strong> <br><ul> <li>Knowledge of Federal acquisition terminology, processes, and regulations. </li><li>Knowledge of government contracting documents (PWS, SOO, etc.) </li><li>Familiarity with FITARA, OMB Circulars, Technology Business Management (TBM), etc. </li></ul><strong>Work Location</strong> <br><br>Remote <br><strong>Travel</strong> <br><br>None <br><strong>Education Level</strong> <br><br>Minimum Bachelor's degree <br><strong>Clearance Level</strong> <br><br>Public Trust; U.S. Citizenship required (NO EXCEPTIONS) <br> <br><strong>Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $80-$88k</strong> <br><strong>About MetaPhase Consulting</strong> <br><br>MetaPhase Consulting is different with a purpose - demonstrating a new approach to the industry that puts employees and culture first! We continue to be recognized by industry as one of the fastest growing and most impactful consultancies in the nation, and are aggressively hiring to grow our team: <br><br>Fastest Growing <br> <ul><li>Inc 5000 Fastest Growing Company - 2020, 2021, 2022, 2023 </li> <li>Washington Technology Fast 50 Award - 2020, 2021 </li> <li>Financial Times America's Fastest Growing Companies - 2021, 2022, 2023 </li></ul>Best Places to Work <ul><li>Washington Post Top Workplaces - 2022, 2023 </li> <li>Washington's Business Journal's Best Places to Work - 2021, 2022 </li><li>Virginia Businesses Best Place to Work - 2021, 2022, 2023 </li><li>Northern Virginia Technology Council Top 100 Technology Firms - 2020 </li></ul>Company & Individual Awards <ul> <li>2021 Washington Business Journal Small Business - CEO of the Year </li> <li>2021 FedScoop 50 - Industry Leadership Award Nominee </li> <li>2021, 2023 Moxie Award Finalist </li><li>2022 SECAF Government Contractor Awards ($27.5 to $50 Million in Revenue) </li> <li>2022 FedScoop Best Bosses Finalist - Brett McLaren </li> <li>2022 Washington Business Journal 40 under 40 - Brett McLaren </li> <li>2022 FedHealth IT and G2XChange Women in in Leadership Awards - Beth Angerman </li> <li>2022 George Mason University Prominent Patriots in Business - Fred Costa </li> <li>2022 TiE DC Capital ELITE Award </li><li>2023 Elev8 Engage GovCon Finalist </li> <li>2023 Maryland Tech Council ICON Awards Finalist for Government Contracting Company of the Year: Over $50 Million </li><li>2023 Greater Washington Government Contractor of the Year ($25 to $75 million) Awards Finalist </li></ul> <br><br>MetaPhase Consulting is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, or any other factors protected by federal, state, or local law. <br><br>#LI-Remote

Metaphase Consulting Business Intelligence Interview Guide

Overview

Metaphase Consulting Business Intelligence Salary

Metaphase Consulting Business Intelligence Interview Process

Metaphase Consulting Business Intelligence Interview Questions

Metaphase Consulting Business Intelligence Jobs