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

Connectedx Inc. Business Intelligence Interview Guide

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


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

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

Overview

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

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

Connectedx Inc. Business Intelligence Interview Questions

<p><strong>Role: Data Scientist Location: Plano, TX (Hybrid) Duration: 12+ Months Contract</strong> <strong>What you bring:</strong> Strong experience manipulating data set and building statistical models, has master’s or Ph.D. in statistics, mathematics with focus on ML, NLP, machine learning or another quantitative field. Strong Knowledge and experience in statistical and data mining techniques – GLM/regression, Random Forest, Boosting, text and data mining. Experience querying database and using statistical computer languages : R , Python, SQL etc. Experience creating and using advanced machine learning algorithms and statistics: regression, simulation, scenario analysis, modeling, clustering, decision trees, neural networks, etc. Experience with distributed data/computing tools: Map/Reduce, Hadoop, Hive, Spark, , MySQL, etc. Experience visualizing/presenting data for stakeholders using: Tableau, Business Objects, D3, Exp with Prescriptive analysis, predictive analysis. Exp leveraging big data and search technologies (e.g., Spark, Elastic Search, Natural Language Processing, Web Crawling) . Knowledge of machine learning techniques and algorithms and be able to apply them in data driven natural language processing techniques. Ability to quickly prototype ideas / solutions and perform critical analysis and using creative approaches for solving complex problems. Exp with Automotive analytics a PLUS Excellent written and verbal communication skills <strong>What you will do:</strong> This role is a hands-on Data scientist to work very closely with business stakeholders helping to analyze the data and suggested patters and models to help them improve their business outcomes. Serve as lead data strategist to identify and integrate new datasets that can be leveraged through our product capabilities, and work closely with the engineering team in the development of data products. Execute analytical experiments to help solve problems across Automobile Domain Identify relevant data sources and sets to mine for client business needs and collect large structured and unstructured datasets and variables. Devise and utilize algorithms and models to mine big-data stores; perform data and error analysis to improve models; clean and validate data for uniformity and accuracy. Analyze data for trends and patterns and interpret data with clear objectives in mind. Implement analytical models in production by collaborating with software developers and machine-learning engineers. Work closely with business stakeholders, Software engineering team and data team to deliver the required outcomes.</p>

<p><strong>Who we are:</strong></p><p>ConnectedX is focused on Digital Transformation and Product Engineering Services, enabling clients achieve their business, operating and technology needs for the digital age. Our unique industry-based, consultative approach helps clients implement digital transformation initiatives. Headquartered in Dallas, Texas, U.S. ConnectedX is a preferred partner for leading Fortune 1000 enterprises and is consistently admired by the clients and employees across the globe.</p><p> </p><p><strong>Who we’re looking for:</strong></p><p>We are looking for a passionate and highly motivated<strong> Data Analysis for a Fortune 100 client. This is a long-term role in Plano, TX</strong></p><p> </p><p><strong>What you will do:</strong></p><p>Data Analysis - Perform analysis for large complex systems applying structured and repeatable data analysis techniques. Answer complex data questions over multiple large marketing data sets to deliver data-driven insights and recommendations to non-technical audiences, through clear visualizations and presentations. Identify, analyze, and interpret trends or patterns in complex data sets.</p><p>Data Analysis Design and Documentation – Develop repeatable and organized processes for answering complex questions that can be utilized by others. This will include supporting data flow diagram and data documentation as well as visualization and presentation standards. Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required. Data Discovery and Support– Profiling and connecting new data sources to existing data sources to highlight opportunities to meet business and technology objectives. Troubleshoot and provide resolutions on issues related to data quality, reports, and databases. Stakeholder Engagement - Communicate and build relationships with the business and vendor partners. Work with external and internal teams to influence direction and achieve buy-in to solutions. Experience with Data Modelling, Data structures, data engineering, understanding on difference schema, experience validating data, transforming data .</p>

Connectedx Inc. Business Intelligence Interview Guide

Overview

Connectedx Inc. Business Intelligence Salary

Connectedx Inc. Business Intelligence Interview Process

Connectedx Inc. Business Intelligence Interview Questions

Connectedx Inc. Business Intelligence Jobs