The C-vision inc. Business Intelligence interview guide, interview questions, salary data, and interview experiences.

C-vision inc. Business Intelligence Interview Guide

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


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

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

Overview

C-vision inc. 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.

C-vision inc. 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>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

C-vision inc. Business Intelligence Interview Questions

<h3>Job Description</h3><div>Job Description<div><div><b>Technical Data Analyst 4/Scientist</b></div><div><b>Preference local to Warren, MI, open to Texas (Austin). </b></div><div><b>Hybrid working onsite 3 days a week (Tuesday, Wednesday, Thursday) for collaboration.</b></div><div><b>Contract on W2</b></div><div></div><div></div><div>-Must have 8+ years of actual experience<br /> -Preferable Michigan/Texas (Austin) Hybrid working onsite 3 days a week (Tuesday, Wednesday, Thursday) for collaboration<br><br> *Research/Data Science/Analytics Background</div><div>*Sharp <span class="long-word">Technical/Statistical/Math</span> skills<br /> *Strong data storytelling, communication and presentation skills</div><div>*Displays curiosity and creativity</div><div>*Ability to liaise with business leads and create tangible next steps from data to create better business outcomes<br /> *Auto industry preferred, not mandatory<br /> *R or Python experience is mandatory<br><br><b>Department: Cadillac Global Strategy & Operations</b></div><div></div><div><i>Position: Data & Research Scientist</i></div><div><br /> KEY <span class="long-word">RESPONSIBILITIES/ACCOUNTABILITIES</span></div><div></div><div>Work as an integral member within the Global Strategy & Operations Team, with a focus on innovation and analytics providing a key data science component to support the development and execution of global strategy, research, innovation, and operations projects. Provide strong connection and support to strategy and operations managers by developing analytical solutions to address and improve KPI's and business results. Pursues problem identification and impact across large vehicle populations, leveraging data mining, predictive modeling, simulation, and visualization techniques to further enhance insight and internal performance optimization.</div><div></div><div><b>Conduct Advanced Data Analysis and Automation</b>:</div><ol><li><ul><li>Perform in-depth analysis and design search patterns.</li></ul></li></ol><ol><li><ul><li>Develop automation tools for data mining and reduction.</li></ul></li></ol><ol><li><b>Mentorship and Skill Development</b>: <ul><li>Mentor junior researchers and data scientists to enhance their analytical skills.</li><li>Foster a collaborative learning environment within the research and strategy team.</li></ul></li><li><b>Stay Informed on Technological Advancements</b>: <ul><li>Continuously update knowledge on the latest software and hardware innovations and ideate on how to apply.</li><li>Identify and implement cutting-edge solutions to meet research and strategy objectives.</li></ul></li><li><b>Collaborative Research and Statistical Application</b>: <ul><li>Establish strong working relationships with interdisciplinary teams including Enterprise Data and Analytics and IT.</li><li>Review research and strategy project requirements and apply appropriate statistical techniques to data.</li></ul></li><li><b>Data Collection and Refinement</b>: <ul><li>Drive the acquisition of new data and refine existing datasets.</li><li>Ensure data quality and relevance for ongoing research and strategy projects.</li></ul></li><li><b>Develop and Communicate Best Practices</b>: <ul><li>Create best practices for research instrumentation and experimentation.</li><li>Share these practices with peer teams to enhance research methodologies.</li></ul></li><li><b>Support Complex and Real-Time Data Processing</b>: <ul><li>Develop analytics to support complex event processing and real-time data analysis in big data contexts.</li></ul></li><li><b>Subject Matter Expertise in Research, Statistics, and Data Analytics</b>: <ul><li>Serve as an expert in predictive and prescriptive analytics.</li><li>Ensure research aligns with industry best practices and contributes to the field's body of knowledge.</li></ul></li><li><b>Data storytelling</b><ul><li>Use a structured approach for communicating data insights, with key elements: data, visuals, and narrative to explain, enlighten or engage the audience. The data story is used to drive and influence change.</li></ul></li></ol><div>Additional Requirements</div><ul><li>8+ years of experience using data to solve problems, hypothesis testing, and create visualizations and storytelling to address business problems</li><li>8+ years of experience in data architecture and data base management</li><li>8+ years of professional development experience</li><li>Solid experience with Big Data technologies in Data Bricks platform using Python/R</li><li>Master's degree in STEM fields required.</li><li>Ph. D in STEM fields preferred.<br><br> Share your resumes at romil.a@c-visionit.com</li></ul></div></div>

<h3>Job Description</h3><div>Job Description<div>A Data Analyst with Cognos reporting and ETL experience possesses a comprehensive skill set for working with data. They excel in extracting data from various sources, transforming it into usable formats, and loading it into databases for analysis. Additionally, their proficiency in reporting involves creating meaningful visualizations and reports that communicate insights effectively to support informed decision-making. This combination of skills allows them to handle the end-to-end data lifecycle, from collection and preparation to analysis and reporting, making them valuable assets for data-driven organizations.</div></div>

C-vision inc. Business Intelligence Interview Guide

Overview

C-vision inc. Business Intelligence Salary

C-vision inc. Business Intelligence Interview Process

C-vision inc. Business Intelligence Interview Questions

C-vision inc. Business Intelligence Jobs