Bristol-Myers Squibb Analyst II Interview Questions and Answers

Power BI is a business analytics tool by Microsoft for visualizing and analyzing data.

• Power BI is a business analytics tool by Microsoft

• It allows users to visualize and analyze data from various sources

• Users can create interactive reports and dashboards

• Power BI offers a wide range of data connectors for seamless integration

• It provides features like data modeling, data preparation, and data visualization

• Power BI can be ...read more

Window functions are used to perform calculations across a set of table rows related to the current row.

• Window functions are used in SQL to perform calculations within a specific window or subset of rows.

• They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().

Stability studies are conducted to evaluate the stability of a product over time under various conditions.

• Stability studies help determine the shelf life of a product.

• They assess how the quality of a product changes over time.

• Factors such as temperature, humidity, light exposure, and packaging are considered in stability studies.

• Results of stability studies are used to establish storage conditions and expiration dates ...read more

UV, IR, KF, and polarimeter are analytical instruments used for different types of analysis based on principles of light absorption, emission, and rotation.

• UV (Ultraviolet) spectrophotometer measures the absorption of ultraviolet light by a sample to determine its concentration or purity.

• IR (Infrared) spectrophotometer measures the absorption of infrared light by a sample to identify functional groups in organic compou...read more

Calibration of analytical balance is essential for accurate measurements in analytical chemistry.

• Calibration involves comparing the readings of the balance to known weights.

• Regular calibration ensures accuracy and reliability of measurements.

• Adjustments may be needed if the balance readings deviate from the known weights.

• Calibration should be done using a proper calibration weight and following manufacturer's instructi...read more

PH range is 0-14. Calibration ensures accuracy by adjusting the PH meter to known standards.

• PH range is from 0 to 14, with 7 being neutral

• Acidic solutions have a PH below 7, while alkaline solutions have a PH above 7

• Calibration involves adjusting the PH meter using buffer solutions of known PH values

• Regular calibration ensures accurate PH measurements

SLA stands for Service Level Agreement, a contract between a service provider and a customer that defines the level of service expected.

• SLA is a formal agreement between a service provider and a customer outlining the services to be provided, the responsibilities of each party, and the expected level of service.

• It typically includes details such as uptime guarantees, response times, and penalties for not meeting the ag...read more

EC2 in AWS stands for Elastic Compute Cloud, a web service that provides resizable compute capacity in the cloud.

• EC2 allows users to rent virtual servers on which they can run their own applications.

• Users can choose the instance type, operating system, and storage options for their EC2 instances.

• EC2 instances can be easily scaled up or down based on demand, providing flexibility and cost efficiency.

• Examples of EC2 inst