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

Project44 Business Intelligence Interview Guide

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


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

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

Overview

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

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

Project44 Business Intelligence Interview Questions

<p>Why project44?</p><p>At project44, we revolutionize supply chains with our High-Velocity Supply Chain Platform. As the connective tissue of the supply chain, project44 optimizes global product movement, delivering unparalleled resiliency, sustainability, and value for our customers. We operate the world's most trusted end-to-end visibility platform, tracking over 1 billion shipments annually for 1,300 leading brands across various industries, including manufacturing, automotive, retail, life sciences, food & beverage, and oil, chemical & gas. Our High-Velocity platform eliminates supply chain friction, enabling sophisticated inventory control, exceptional customer experience, and predictive analytics through machine learning and automation.</p><p>If you're eager to be part of a winning team that works together to solve some of the most challenging supply chain challenges every day, let's talk.</p><p>Description:</p><p>You're looking for next opportunity as a Staff Product Manager to bring the passion, work ethic and expertise needed to lead key product initiatives at a fast-growing tech startup. You are very enthusiastic about managing the complete product lifecycle to ensure success in terms of both revenue and the timely release of new products and capabilities. You thrive working closely with your counterparts on the Development team to ensure successful product delivery as well as collaborate with extended team members in Marketing, Sales, Support, and other departments.</p><p>What you're most excited for:</p><p>* Articulate a product strategy leading to solutions that continuously and incrementally?improve product culture</p><p>* Manage challenges for your engineering team, and always ensure they have a strong understanding of customer problems, why those are important, and a robust backlog of well-defined use cases to solve</p><p>* Work with marketing, sales enablement, and customer success teams to launch new capabilities in a way that empowers those teams to make customers successful</p><p>* Define and drive success via OKRs and KPIs for end users along a funnel of adoption after launch, troubleshooting areas of friction, and delivering solutions to reduce adoption obstacles</p><p>* Assess market competition by comparing project44's products to competitors' products.</p><p>* Analyze data and collaborate with customers, partners, and x-functional stakeholders to understand the broader business needs and build consensus</p><p>* Represent project44 as a domain and product expert during customer interaction</p><p>Requirements & Skills:</p><p>* Bachelor's degree in any discipline that has propelled you to build tech chops in your career, from computer science to business.</p><p>* 8+ years overall industry experience with 5+ years of Product Management leadership, experience building enterprise SaaS</p><p>* Experience building and driving a roadmap, based in customer needs, with a clear path to incremental delivery</p><p>* Experience presenting to executive leadership, participating in the sales cycle, and handling sensitive customer escalations</p><p>* Strong interpersonal skills, and the ability to rapidly develop and cultivate relationships with peers, partners, and key influencers across a software business</p><p>* Passion and empathy for the product and for our users and strong belief in the mission of creating customer and user value.</p><p>* Ability to self-manage and act with autonomy.</p><p>* Detail oriented, but also strategic. You should be able to context switch from guiding on implementation details to giving a company presentation with ease and aplomb.</p><p>* This position may require travel to global project44, customers, and partner locations.</p><p>* Supply chain and/or logistics experience is required.</p><p>In-office Commitment: This position requires a commitment to contribute to our collaborative culture by working in-office three days weekly, if you are based out of Chiago, IL.</p><p>Diversity & Inclusion</p><p>At project44, we're designing the future of how the world moves and is connected through trade and global supply chains. As we work to deliver a truly world-class product and experience, we are also intentionally building teams that reflect the unique communities we serve. We're focused on creating a company where all team members can bring their authentic selves to work every day.</p><p>We're building a company that every one of us at project44 is proud to work for, and our journey of becoming a more diverse, equitable and inclusive organization, where all have a sense of belonging, is shaped through the actions of our leadership, global teams and individual team members. We are resolute in our belief that each team member has an equal responsibility to mold and uphold our culture.</p><p>project44 is an equal opportunity employer seeking to enrich our work environment by creating opportunities for individuals of all backgrounds and experiences to thrive. If you share our values and our passion for helping the way the world moves, we'd love to review your application!</p><p>For any needed accommodations during the hiring process, please email?recruiting@project44.com. Even if you don't meet 100% of the above job description you should still seriously consider applying. Studies show that you can still be considered for a role if you meet just 50% of the role's requirements.</p><p>More about project44</p><p>Since 2014, project44 has been transforming the way one of the largest, most important global industries does business. As transportation and logistics continue to evolve and customer expectations around delivery become more demanding, industry technology must rise to the occasion. In just a few short years, we have created a digital infrastructure that eliminates the inefficiencies caused by dated technology and manual processes. Our Advanced Visibility Platform is used by the world's leading brands to track shipments, collaborate with supply chain partners, drive operational efficiencies, and create outstanding customer experiences.</p>

<p><strong>Why project44?</strong></p><p>At project44, we’re on a mission—to make supply chains work.</p><p><br></p><p>We revolutionize supply chains with our High-Velocity Supply Chain Platform. As the connective tissue of the supply chain, project44 optimizes global product movement, delivering unparalleled resiliency, sustainability, and value for our customers. We operate the world's most trusted end-to-end visibility platform, tracking over 1 billion shipments annually for 1,300 leading brands across industries including manufacturing, automotive, retail, life sciences, food & beverage, and oil, chemical & gas. Our High-Velocity platform eliminates supply chain friction, enabling sophisticated inventory control, exceptional customer experience, and predictive analytics through machine learning and automation. </p><p><br></p><p>If you’re eager to be part of a winning team that works together to solve some of the most challenging supply chain challenges every day, let’s talk.</p><p><br></p><p><strong>About the team</strong> </p><p>Are you interested in driving business outcomes through analytics? What about using data to answer difficult questions and come up with interesting insights and collaborate with others? If so, then this is the job for you. As a Senior Data Analyst in the Internal Analytics team, you get to use your quantitative skill set, obsession around customer value, drive for operational efficiency, and collaborative spirit to work cross-functionally, to provide data-driven insights and productize workflows to enable our operational teams to reach the next level. </p><p> </p><p><strong>Responsibilities </strong> </p><ul><li>Build dashboards and reports to operationalize workflows and provide data-driven insights. </li><li>Analyse raw data, assess quality, profiling, cleansing, and structuring for downstream processing </li><li>Identify opportunities that present the most potential for customer value, and operational efficiency. </li><li>Define and analyse operational performance metrics </li><li>Partner with operational teams to understand requirements and areas of opportunity. </li><li>Partner with product teams to investigate product-level analytics. </li><li>Collaboration in the creation of single-source-of-truth normalized data and standardized denormalized data sets to power companywide analytics. </li></ul><p><strong>Qualifications </strong> </p><ul><li>Bachelor or master’s degree in business Analytics, Economics, Marketing, Statistics or a related field and 3 years of work experience in the job offered or in an analytics-related occupation </li><li>Experience must include 3 years of experience in the following: </li><li>3+ years of experience in quantitative analysis and data mining </li><li>3+ years of experience in SQL or another programming language for data querying </li><li>3-5 years of relevant experience </li><li>Define and analyze metrics that inform the success of products </li><li>Dashboarding experience with Tableau and Looker</li></ul><p><br></p><p><strong>In-office Commitment</strong>: This position requires a commitment to contribute to our collaborative culture by working in-office <strong>three </strong>days weekly.</p><p><br></p><p><strong>Diversity & Inclusion</strong> </p><p>At project44, we're designing the future of how the world moves and is connected through trade and global supply chains. As we work to deliver a truly world-class product and experience, we are also intentionally building teams that reflect the unique communities we serve. We’re focused on creating a company where all team members can bring their authentic selves to work every day. </p><p>We’re building a company that every one of us at project44 is proud to work for, and our journey of becoming a more diverse, equitable and inclusive organization, where all have a sense of belonging, is shaped through the actions of our leadership, global teams and individual team members. We are resolute in our belief that each team member has an equal responsibility to mold and uphold our culture. </p><p>project44 is an equal opportunity employer seeking to enrich our work environment by creating opportunities for individuals of all backgrounds and experiences to thrive. If you share our values and our passion for helping the way the world moves, we’d love to review your application! </p><p>For any needed accommodations during the hiring process, please email recruiting@project44.com. Even if you don’t meet 100% of the above job description you should still seriously consider applying. Studies show that you can still be considered for a role if you meet just 50% of the role’s requirements. </p><p><br></p><p>#LI-Hybrid</p><p></p>

Project44 Business Intelligence Interview Guide

Overview

Project44 Business Intelligence Salary

Project44 Business Intelligence Interview Process

Project44 Business Intelligence Interview Questions

Project44 Business Intelligence Jobs