Bristol-Myers Squibb Interview Questions and Answers

I have a strong background in data analysis and reporting, with experience in BI tools and SQL.

• Experience in creating reports and dashboards using BI tools such as Tableau and Power BI

• Proficient in SQL for data extraction and manipulation

• Strong analytical skills with the ability to interpret data and provide insights

• Familiarity with data visualization best practices

• Previous experience working with cross-functional team...read more

The region with the highest sales is North America.

• Check sales data for each region or country

• Look for the region or country with the highest total sales

• Create a bar chart or pie chart to visualize the data

Sales comparison between last year and current year with relevant filters

• Calculate total sales for last year and current year

• Apply any relevant filters such as product category or region

• Compare sales figures to identify trends or changes

• Visualize the comparison using charts or graphs for better understanding

Compare last year sales for budget with the forecast and visualize the sales comparison between budget and forecast.

• Calculate the difference between last year sales, budget, and forecast.

• Create a bar chart showing the comparison of last year sales, budget, and forecast.

• Highlight any significant deviations between budget and forecast.

• Provide a narrative explaining the reasons for any discrepancies.

A line chart showing continuous sales data from January 2021 to December 2024.

• Use a line chart to display the trend of sales over time

• Include a time axis with months from January 2021 to December 2024

• Label the axes clearly and provide a legend if necessary

Calculate a three-month running total using DAX and Excel

• In DAX, use the CALCULATE function with a FILTER for the three-month period

• In Excel, use a combination of SUM and OFFSET functions to calculate the running total

• For example, in DAX: CALCULATE(SUM([Value]), FILTER(ALL('Date'[Month]), 'Date'[Month] >= 'November' && 'Date'[Month] <= 'January'))

• For Excel: =SUM(OFFSET($A$2, MAX(ROW($A$2:$A$10)-2, 1), 0, ...read more

To find the third highest salary of an employee and calculate cumulative sales using SQL.

• To find the third highest salary of an employee, you can use the following SQL query: SELECT DISTINCT Salary FROM Employees ORDER BY Salary DESC LIMIT 2, 1

• To calculate cumulative sales, you can use the following SQL query: SELECT SUM(Sales) FROM SalesData

Different types of joins in database management, null values in primary and unique key columns, and right join in SQL.

• Types of joins: inner join, outer join (left, right, full), cross join, self join

• Primary key column cannot contain null values

• Unique key column can contain null values, but only one null value is allowed

• Right join in SQL: returns all rows from the right table and the matched rows from the left table

I am looking for new challenges and opportunities for growth. I have experience with both Tableau and Power BI.

• Seeking new challenges and opportunities for growth

• Experience with both Tableau and Power BI

• Excited to learn and work with Tableau

Day-to-day tasks include data collection, analysis, reporting, and providing insights to stakeholders. The organization typically works for various departments within the company.

• Collecting and organizing data from different sources

• Analyzing data to identify trends and patterns

• Creating reports and dashboards to visualize data

• Communicating insights and recommendations to stakeholders

• Working closely with different depart...read more

Soliciting multiple quotes involves reaching out to various suppliers and evaluating them based on criteria like price, quality, lead time, and reliability.

• Reach out to a variety of suppliers to request quotes for the same product or service.

• Consider criteria such as price, quality, lead time, reliability, and supplier reputation.

• Evaluate the quotes based on the criteria and choose the supplier that best fits the needs...read more

I would highlight the benefits and advantages of the specified supplier's proposal compared to others.

• Emphasize the unique value proposition of the specified supplier's proposal

• Highlight any cost savings or efficiencies that can be gained by choosing this supplier

• Provide evidence of the supplier's track record of delivering high-quality products or services

• Address any concerns or objections raised by the manager and of...read more

I would conduct a thorough analysis of the supplier's offer and present a detailed comparison with the L1 and L2 suppliers to persuade my manager.

• Conduct a detailed cost analysis of the H1 supplier's offer, including all relevant factors such as quality, delivery time, and terms of payment.

• Prepare a comprehensive comparison chart showcasing the strengths and weaknesses of the H1 supplier in relation to the L1 and L2 su...read more

Developed a predictive model for customer churn using machine learning algorithms

• Used R programming language to clean and preprocess customer data

• Implemented various machine learning algorithms such as Random Forest and Logistic Regression

• Evaluated model performance using metrics like accuracy, precision, and recall

I use metrics such as accuracy, precision, recall, F1 score, ROC-AUC, and confusion matrix to test the models deployed.

• Accuracy: measures the overall correctness of the model

• Precision: measures the proportion of true positive predictions among all positive predictions

• Recall: measures the proportion of true positive predictions among all actual positives

• F1 score: balances precision and recall

• ROC-AUC: measures the area u...read more

I have a basic understanding of JavaScript and can work with it to some extent.

• Familiar with basic JavaScript syntax and concepts

• Able to manipulate DOM elements using JavaScript

• Have experience working with JavaScript libraries like jQuery

Yes, R can be integrated with JavaScript using the 'shiny' package to create interactive web applications.

• Use the 'shiny' package in R to create interactive web applications

• Use the 'htmlwidgets' package to embed interactive R visualizations in web pages

• Utilize the 'r2d3' package to create D3 visualizations in R and embed them in web applications

The 'V8' package in R is used to import and execute JavaScript code.

• Use the 'V8' package in R to import and execute JavaScript code.

• Install the 'V8' package using install.packages('V8').

• Load the 'V8' package using library(V8).

• Use the v8() function to create a new V8 context and execute JavaScript code.