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

Medallia Business Intelligence Interview Guide

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


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

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

Overview

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

Medallia 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>Write a query to identify customers who placed more than three transactions each in both 2019 and 2020.</p>

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

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

<p><code>transactions</code> table</p>

<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>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>users</code> table</p>

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

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

<tbody>
<tr>
<td><code>customer_name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>


<p>Which of the following queries will return a list of customers and the total amount they have spent on orders?</p>


Which of the following queries will return a list of customers and the total amount they have spent on orders?

Customer Orders

<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

Medallia Business Intelligence Interview Questions

<h3>Senior Product Manager, Experience Profiles and Engagement</h3><p>Medallia is the pioneer and market leader in Experience Management. Our award-winning SaaS platform, Medallia Experience Cloud, leads the market in the understanding and management of experience for candidates, customers, employees, patients, citizens, and residents.</p><p>We are more than a software company. We want to be known as a company that does the right thing, no matter the challenge or controversy. We are committed to creating a culture that values every person and every experience. Individual life experiences shape the way we interact with the world, which is why we encourage people to bring their whole selves to work each day. The strength of our global workforce is the most significant contributor to our success.</p><p>We believe: Every Experience Matters. Talent is Everywhere. All Belong Here.</p><p>At Medallia, we hire the whole person.</p><h3>The Role</h3><p>We are seeking an experienced Senior Product Manager to lead product innovation of the Medallia Experience Cloud application. The ideal candidate will be at the forefront of shaping our most impactful product areas-driving the vision, growth, and innovation behind our experience profiles and engagement capabilities. You will play a critical role in defining solutions that deeply resonate with our customers and partners, continuing to position Medallia as the leader in the market. If you're passionate about transforming customer and employee experiences and eager to lead product areas that help our users take predictive and prescriptive actions, we want you on our team.</p><p>As a Senior Product Manager, you will own and define a product roadmap for Medallia's Total Experience Profiles and engagement capabilities. These product areas enable users to understand the end-to-end experiences provided to customers, employees, and partners and suggest improvement opportunities so users can take action. You will lead efforts defining the product vision and requirements for the what, why, and where of these capabilities within the Medallia product portfolio. You'll serve as the go-to leader, accountable for driving both product excellence and measurable business results. This is an opportunity to shape the future of our products and leave a lasting impact on the organization.</p><p>Finally, you will work side by side with world-class engineers and designers, combining creativity and precision to maximize the impact of every product in support of our vision, to empower organizations to deliver on their promises. This role is best suited for someone with a strong technical and product management background who is passionate about defining and delivering technical services at scale.</p><h3>Responsibilities</h3><ul><li>Drive product strategy and delivery of Medallia's Experience Profiles and Engagement capabilities as a part of our Experience Applications Team.</li><li>Manage the product development processes, including betas, for the functionality of the feature group.</li><li>Develop detailed requirements, design, and engineering estimates to formulate plans and a delivery timeline.</li><li>Manage product backlog and scrum team.</li><li>Provide leadership and guidance to engineering teams and partner with Engineering leads/directors to manage functionality, achieve product KPIs, and guide the design and implementation of solutions.</li><li>Define and own the 12+ month feature roadmap to drive priorities while considering both value creation and the cost of creating value.</li><li>Effectively work cross-functionally and collaboratively with peers in PM, Design, and Engineering to take products/features to market and drive success.</li><li>Partner cross-functionally with other teams, such as senior leaders, sales, product marketing, and customer success, to ensure their objectives are met, inputs and feedback are considered, and plans are communicated.</li><li>Participate in building a company culture of best practices and shared knowledge among colleagues and communities.</li><li>Collect and analyze feedback from customers, stakeholders, and other teams to shape requirements, features, and end products.</li></ul><h3>Qualifications</h3><h3>Minimum Qualifications</h3><ul><li>Bachelor's Degree in science, engineering, or related quantitative field or equivalent experience.</li><li>5+ years of product management experience leading strategic vision and delivering product roadmap.</li><li>Demonstrated experience building, launching, and scaling enterprise-grade solutions.</li><li>Demonstrated business partnership experience communicating and collaborating with customers, prospects, and/or partners.</li><li>Demonstrated experience driving cross-functional company initiatives across multiple departments.</li></ul><h3>Preferred Qualifications</h3><ul><li>5+ years of direct and hands-on experience bringing enterprise products to the market.</li><li>Thought leadership, evangelizing, and public speaking experience.</li><li>Outstanding communication abilities, capable of translating complex technical concepts.</li><li>Experience with a Customer Experience Management Platform.</li><li>Experience working with Customer Data Platforms (CDPs), including designing, implementing, or managing solutions that unify, activate, and derive actionable insights from customer data.</li><li>Experience working in an agile development environment and familiarity with tools such as Productboard and Jira to write user stories and acceptance criteria in partnership with developers.</li></ul><p>Medallia is committed to equal pay and transparency. The annual base salary range for this position is $147,200 - $229,000. Please note that the salary range information provided is a general guideline and combines all of the distinct labor markets within the US. It is uncommon for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on a variety of factors. Medallia considers factors such as (but not limited to) scope and responsibilities of the position, candidate's work experience, candidate's work location, education/training, key skills, internal peer equity, external market data, as well as market and business considerations when making compensation decisions.</p><p>Medallia also offers competitive health and wellness benefits, including but not limited to medical, dental, vision, 401(k), short-term and long-term disability, life and AD&D insurance, statutory leaves, paid parental leave, and paid holidays. Benefits and eligibility may vary by location and role.</p><p>At Medallia, we celebrate diversity and recognize the value it brings to our customers and employees. Medallia is proud to be an equal-opportunity workplace and is an affirmative-action employer. All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, genetic information, disability, veteran status, or any other applicable status protected by state or local law. Individuals with a disability who need an accommodation to apply please contact us at ApplicantAccessibility@medallia.com. For information regarding how Medallia collects and uses personal information, please review our Privacy Policies. Applications will be accepted for 30 days from the date this role was posted or until the role has been filled.</p>
#J-18808-Ljbffr

Medallia Business Intelligence Interview Guide

Overview

Medallia Business Intelligence Salary

Medallia Business Intelligence Interview Process

Medallia Business Intelligence Interview Questions

Medallia Business Intelligence Jobs