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>Write a query to identify the manager with the biggest team size.</p>

<p>You may assume there is only one manager with the largest team size.</p>

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

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

<p><code>employees</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>

<tr>
<td><code>manager_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<p><code>managers</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>

<tr>
<td><code>team</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>manager</code></td>
<td>VARCHAR</td>
</tr>

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


Manager Team Sizes

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