The PCS Global Tech Business Intelligence interview guide, interview questions, salary data, and interview experiences.

PCS Global Tech Business Intelligence Interview Guide

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


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

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

Overview

PCS Global Tech 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.

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

PCS Global Tech 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>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

PCS Global Tech Business Intelligence Interview Questions

<p>Entry Level Data Analyst and SQL Developer at PCS Global Tech<strong> (Internship)</strong> </p> <p>We are pleased to announce an opportunity for a motivated Entry-Level Data Analyst to join our dynamic team. This position is ideal for individuals who are passionate about data analysis and eager to derive valuable insights that inform strategic decision-making within our organization. As an Entry-Level Data Analyst, you will learn from seasoned professionals while contributing to our data analysis initiatives. </p><p>Key Responsibilities: </p><p>Data Analysis: </p><p>Collaborate with various departments to gather data requirements and conduct analyses to identify trends, patterns, and anomalies. </p><p>Assist in data cleansing and transformation to ensure accuracy and reliability for reporting purposes. </p><p>Data Visualization: </p><p>Partner with the team to create compelling visualizations that clearly communicate insights into key performance indicators (KPIs) and business metrics. </p><p>Aid in the development of interactive dashboards and reports to simplify complex data. </p><p>Data Reporting: </p><p>Contribute to the creation and maintenance of data reports, ensuring alignment with business objectives. </p><p>Assist in optimizing data reporting processes to improve efficiency and effectiveness. </p><p>Collaboration: </p><p>Work closely with cross-functional teams to understand data needs and support the creation of tailored solutions. </p><p>Participate in discussions to gather feedback and refine data analysis and reporting efforts based on user insights. </p><p>Quality Assurance: </p><p>Assist in validating the accuracy of data utilized in analysis and reporting. </p><p>Conduct thorough testing to ensure the functionality and reliability of data solutions. </p><p>Learning and Growth: </p><p>Stay informed about the latest data analysis tools, best practices, and industry trends. </p><p>Proactively seek opportunities to enhance technical skills and contribute to the overall success of the team. </p><p>Qualifications: </p><p>Bachelors degree in a relevant field such as Business Analytics, Computer Science, or Information Systems. </p><p>Basic understanding of data analysis concepts and principles. </p><p>Familiarity with data analysis tools is an advantage but not required. </p><p>Strong analytical skills with a passion for transforming data into actionable insights. </p><p>Excellent communication skills, both written and verbal. </p><p>Enthusiasm for learning and a proactive approach to professional development. </p><p>Ability to collaborate effectively within a team and adapt to changing priorities. </p><p>Graduated. </p><p>Join us as an Entry-Level Data Analyst and gain hands-on experience in leveraging data to propel our business forward. Contribute to a dynamic environment focused on data-driven decision-making and make a meaningful impact in your career. </p> <p>Send me your #resume at karias@pcsglobaltech.com</p>

<p>Entry Level Data Analyst and SQL Developer at PCS Global Tech<strong> (Internship)</strong></p><p><br></p><p>We are pleased to announce an opportunity for a motivated Entry-Level Data Analyst to join our dynamic team. This position is ideal for individuals who are passionate about data analysis and eager to derive valuable insights that inform strategic decision-making within our organization. As an Entry-Level Data Analyst, you will learn from seasoned professionals while contributing to our data analysis initiatives.</p><p>Key Responsibilities:</p><p>Data Analysis:</p><p>Collaborate with various departments to gather data requirements and conduct analyses to identify trends, patterns, and anomalies.</p><p>Assist in data cleansing and transformation to ensure accuracy and reliability for reporting purposes.</p><p>Data Visualization:</p><p>Partner with the team to create compelling visualizations that clearly communicate insights into key performance indicators (KPIs) and business metrics.</p><p>Aid in the development of interactive dashboards and reports to simplify complex data.</p><p>Data Reporting:</p><p>Contribute to the creation and maintenance of data reports, ensuring alignment with business objectives.</p><p>Assist in optimizing data reporting processes to improve efficiency and effectiveness.</p><p>Collaboration:</p><p>Work closely with cross-functional teams to understand data needs and support the creation of tailored solutions.</p><p>Participate in discussions to gather feedback and refine data analysis and reporting efforts based on user insights.</p><p>Quality Assurance:</p><p>Assist in validating the accuracy of data utilized in analysis and reporting.</p><p>Conduct thorough testing to ensure the functionality and reliability of data solutions.</p><p>Learning and Growth:</p><p>Stay informed about the latest data analysis tools, best practices, and industry trends.</p><p>Proactively seek opportunities to enhance technical skills and contribute to the overall success of the team.</p><p>Qualifications:</p><p>Bachelor’s degree in a relevant field such as Business Analytics, Computer Science, or Information Systems.</p><p>Basic understanding of data analysis concepts and principles.</p><p>Familiarity with data analysis tools is an advantage but not required.</p><p>Strong analytical skills with a passion for transforming data into actionable insights.</p><p>Excellent communication skills, both written and verbal.</p><p>Enthusiasm for learning and a proactive approach to professional development.</p><p>Ability to collaborate effectively within a team and adapt to changing priorities.</p><p>Graduated.</p><p>Join us as an Entry-Level Data Analyst and gain hands-on experience in leveraging data to propel our business forward. Contribute to a dynamic environment focused on data-driven decision-making and make a meaningful impact in your career.</p><p><br></p><p>Send me your #resume at karias@pcsglobaltech.com</p>

PCS Global Tech Business Intelligence Interview Guide

Overview

PCS Global Tech Business Intelligence Salary

PCS Global Tech Business Intelligence Interview Process

PCS Global Tech Business Intelligence Interview Questions

PCS Global Tech Business Intelligence Jobs