10+ Junior Data Analyst Interview Questions and Answers for Freshers

Malaria is a mosquito-borne infectious disease caused by parasites. Drug allergy is an adverse reaction to medication. Hypertension is high blood pressure. Diabetes is a metabolic disorder affecting blood sugar levels. Obesity is excessive body weight. GERD is gastroesophageal reflux disease. Gout is a form of arthritis. Hyperlipidemia is high levels of lipids in the blood. Agar agar is a gelatinous substance derived from seaweed. Pigment names refer to various coloring agent...read more

There are four phases of clinical research: Phase 1, Phase 2, Phase 3, and Phase 4.

• Phase 1: Focuses on safety and dosage in a small group of healthy volunteers.

• Phase 2: Expands to a larger group to see if the treatment is effective.

• Phase 3: Compares the new treatment to standard treatments in a larger group.

• Phase 4: Post-marketing studies to monitor the treatment's long-term effects.

Pharmacovigilance is the science and activities related to the detection, assessment, understanding, and prevention of adverse effects or any other drug-related problems.

• Pharmacovigilance involves monitoring and evaluating the safety of pharmaceutical products.

• Adverse events are any undesirable experience associated with the use of a medical product.

• Examples of adverse events include side effects, allergic reactions, and medication errors.

• Pharmacovigilance aims to improve pat...read more

Candidate key is a unique key that can uniquely identify each record in a table, while a compound key is a key that consists of multiple columns to uniquely identify each record.

• Candidate key is a single column key, while compound key is a combination of multiple columns.

• Candidate key can be a primary key, while compound key cannot be a primary key if it includes non-unique columns.

• Example: In a table of students, student ID can be a candidate key, while a compound key of stu...read more

Natural Language Processing (NLP) is a field of AI that focuses on the interaction between computers and human language.

• NLP involves the ability of computers to understand, interpret, and generate human language.

• It encompasses tasks like text classification, sentiment analysis, machine translation, and speech recognition.

• NLP techniques include tokenization, part-of-speech tagging, named entity recognition, and syntactic parsing.

• Examples of NLP applications include virtual ass...read more

Pharmacovigilance involves several phases including signal detection, data collection, data assessment, risk management, and communication.

• Signal detection: Identifying potential safety issues through various sources such as clinical trials, spontaneous reports, and literature reviews.

• Data collection: Gathering information on adverse drug reactions (ADRs) from healthcare professionals, patients, and regulatory authorities.

• Data assessment: Analyzing and evaluating the collecte...read more

Machine learning is a branch of artificial intelligence that enables computers to learn and make predictions without being explicitly programmed.

• Machine learning is a subset of AI that uses algorithms to analyze and interpret data.

• It involves training a model on a dataset to make predictions or take actions.

• There are different types of machine learning, including supervised, unsupervised, and reinforcement learning.

• Examples of machine learning applications include spam filter...read more

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

• Use the RANK() function to assign a unique rank to each row within a partition of a result set.

• You can use the PARTITION BY clause to divide the result set into partitions to rank separately within each partition.

• Example: SELECT column1, column2, RANK() OVER (PARTITION BY column1 ORDER BY column2) AS rank_column FROM table_name;

One business understanding problem is identifying customer churn reasons in a subscription-based service.

• Analyze customer data to identify patterns or trends leading to churn

• Utilize predictive modeling to forecast potential churn

• Implement targeted retention strategies based on findings

• Monitor and track the effectiveness of retention efforts

Check if a given string is a palindrome in Python.

• Use string slicing to reverse the string and compare it with the original string.

• Remove any spaces and convert all characters to lowercase for accurate comparison.

• Example: 'radar' is a palindrome, 'hello' is not.

Warehousing is the process of storing and managing goods within a physical location.

• Warehousing involves receiving, storing, and organizing goods in a designated space.

• It includes inventory management, order fulfillment, and distribution.

• Examples of warehouses include Amazon fulfillment centers and distribution hubs for retail stores.

VLOOKup is a function in Excel used to search for a value in a table and return a corresponding value from another column.

• VLOOKup stands for 'Vertical Lookup'

• It is used to search for a value in the first column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 in the first column of the range B2:D10 and return...read more

Form 21 CFR is a document used by the Food and Drug Administration (FDA) to regulate medical devices.

• Form 21 CFR is a regulation set by the FDA for medical devices.

• It outlines requirements for manufacturing, labeling, and marketing medical devices.

• Compliance with Form 21 CFR is necessary for selling medical devices in the US.

Types of brakes in vehicles include disc brakes, drum brakes, and anti-lock brakes.

• Disc brakes use calipers to squeeze brake pads against a rotor to slow down the vehicle.

• Drum brakes use brake shoes to press against the inside of a drum to stop the vehicle.

• Anti-lock brakes prevent wheels from locking up during braking, allowing the driver to maintain steering control.

Oscillation is a repetitive variation, typically in a wave-like pattern.

• Oscillation refers to the repetitive movement or fluctuation around a central point.

• It can be seen in various phenomena such as pendulum swings, sound waves, and electronic signals.

• The frequency, amplitude, and phase are important characteristics of oscillation.

• Oscillation can be described mathematically using trigonometric functions like sine and cosine.