Prepare for and practice interview questions from Indotronix Avani Group.

Indotronix Avani Group Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Indotronix Avani Group Interview Guides

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Boarding Times Bias

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Title: Data AnalystLocation: Chula Vista, CAFull Time roleSalary: $80K annually What You will Do:<ul><li>Data Analyst to update/edit/develop A320 Neo EBU Coverage Tracker. </li><li>Develop teams automated tracker for part allocation prior to MSN delivery. </li><li>Using Spreadsheets, PowerBI and creating new tools to track shortages from our supplier as well further data analytics for our operating.</li><li>Improve and develop visuals in PowerBI.</li><li>Create/Maintain A320 Neo EBU Coverage Report for both internal and external focals. </li><li>Additionally, duties include data cleanup for error free data sources. Constant monitoring of reporting tools is required to ensure data is accurate. All sourced data must be reviewed prior to determined refresh cycle in PowerBI.</li><li>Job function include continuous improvement tools, developing work instructions / standard work, and following all regulatory company procedures. </li><li>Attend daily / weekly schedule / status meetings, or more frequently as deemed appropriate. </li><li>Treat all documentation as customer proprietary & comply with applicable customer procedures. </li><li>Revisions to the work scope may be made. </li><li>Additional engineering support task may be added to the work scope according to business needs at the discretion and approval of the PO owner.</li><li>Ability to work with others, train up-and-coming engineers, and review their work.</li><li>Realize opportunities for continuous improvement and find ways to implement solutions.</li><li>Other administrative and supportive duties as needed.</li></ul>What You Will Bring:<ul><li>This position requires an B.S. degree in the appropriate discipline and 3 years of relevant experience. In the absence of a degree, 5 years of relevant experience is required.</li><li>Hands-on experience building and publishing customized and interactive dashboards within PowerBI.</li><li>Microsoft Office 365 is a required skill. Majority of programs utilized include, Excel, Microsoft Teams, and PowerBI. </li><li>Intermediate level of MS Excel skills, including advanced formulas and data tables.</li><li>Power Query and SQL logic are required for PowerBI reports. </li><li>Understanding of basic visuals in PowerBI are needed, as well as ability to create intermediate calculated columns/new measures. </li><li>Basic understanding of Microsoft Teams is needed for communication efforts with team and to edit source data for all reporting tools.</li><li>In depth understanding of data collection, data flow management, data manipulation, data archiving and data standards</li><li>Passionate about solving problems with data and high level of intellectual curiosity.</li><li>Highly motivated to work on multiple projects in parallel and team player with a startup spirit.</li><li>Very strong written and oral communication skills, with proven ability to translate complex analysis into actionable insights to a non-technical audience.</li></ul>

Question	Topic	Difficulty	Ask Chance
Boarding Times Bias	Statistics	Medium	Very High
Hundreds of Hypotheses	Statistics	Medium	Very High
Decreasing Comments	Product Metrics	Easy	Very High

Indotronix Avani Group Interview Questions

Indotronix Avani Group Interview Guides

Indotronix Avani Group Interview Questions

Indotronix Avani Group Opening Jobs