AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Johnson & Johnson Data Analyst Interview Questions and Answers
Johnson & Johnson Data Analyst Interview Experiences
1 interview found
Anonymous
(2 Questions)
- Q1. What time intelligence functions can be used for ytd and qtd analysis
- Ans.
Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.
YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.
QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.
Thes...
- Q2. Difference between import and direct query
- Ans.
Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.
Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.
Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.
Import is suitable for smaller datasets, while direct query is better for large da
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Its on python mostly to do with string manipulation, acces data from list, dataframe
(2 Questions)
- Q1. Wht is your last ctc
- Q2. How soon can you join
Sudheer Saladhi
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
(2 Questions)
- Q1. How to clean the raw data
- Ans.
Raw data can be cleaned by removing duplicates, handling missing values, standardizing formats, and correcting errors.
Remove duplicates by identifying unique identifiers and filtering out redundant entries.
Handle missing values by imputing with mean, median, or mode values or removing rows with missing data.
Standardize formats by converting data into a consistent format (e.g. date formats, units of measurement).
Correct...
- Q2. How to give relationship for two tables.
- Ans.
To establish a relationship between two tables, use a common key or field that links the records in both tables.
Use primary and foreign keys to establish relationships between tables.
Primary key in one table should match the foreign key in another table.
Types of relationships include one-to-one, one-to-many, and many-to-many.
Examples: CustomerID in a Customers table can be linked to CustomerID in Orders table.
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Sep 2024. There were 2 interview rounds.
Excel,sql,advance excel
Sql,excel,advanced excel
Interview Preparation Tips
(2 Questions)
- Q1. What is an inactive relationship in PBI
- Ans.
An inactive relationship in Power BI is a relationship that is not being used in any visualizations or calculations.
Inactive relationships can occur when a relationship is created but not utilized in any measures or visuals.
These relationships do not impact the data model or query performance, but can clutter the model view.
To remove an inactive relationship, you can delete it from the relationship view in Power BI.
Ina...
- Q2. Import vs Direct Query vs Live connection
- Ans.
Import vs Direct Query vs Live connection
Import: Data is imported into the tool for analysis, suitable for small datasets or when real-time data is not required
Direct Query: Data is queried directly from the source in real-time, suitable for large datasets or when up-to-date data is needed
Live connection: Data is connected live to the source, allowing for real-time updates and analysis without storing data locally
Skills evaluated in this interview
I applied via Referral and was interviewed in Dec 2023. There was 1 interview round.
(3 Questions)
- Q1. Explain Order of execution in SQL
- Ans.
Order of execution in SQL determines the sequence in which different clauses are processed in a query.
SQL query is processed in the following order: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
FROM clause is processed first to retrieve data from tables.
WHERE clause filters the data based on specified conditions.
GROUP BY clause groups the data based on specified columns.
HAVING clause filters the grouped data.
SELECT ...
- Q2. Sumifs function
- Q3. Boxplots?Histograms?
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before May 2023. There were 2 interview rounds.
(2 Questions)
- Q1. What you do in your empty time
- Q2. What is your hobby
(1 Question)
- Q1. What is your strength
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed before Dec 2022. There were 3 interview rounds.
(1 Question)
- Q1. Tell me about yourself
(1 Question)
- Q1. About yourself n work profile
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed before May 2021. There were 4 interview rounds.
(3 Questions)
- Q1. Questions related to Data analytics and SharePoint for my role.
- Q2. Previous projects and their solutions.
- Q3. Tool used in previous company. (SharePoint, Power BI, Nintex, InfoPath, Power Apps, Workflows)
(1 Question)
- Q1. Related to professional life and assurance to work.
(1 Question)
- Q1. Salary details and candidature check.
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Oct 2023. There was 1 interview round.
(1 Question)
- Q1. Machine learning,sql
Interview Preparation Tips
Johnson & Johnson Interview FAQs
Tell us how to improve this page.
Johnson & Johnson Interviews By Designations
- Johnson & Johnson Business Associate Interview Questions
- Johnson & Johnson Medical Representative Interview Questions
- Johnson & Johnson Research & Development,application,marketing Interview Questions
- Johnson & Johnson Medical Sales Representative Interview Questions
- Johnson & Johnson RSR Interview Questions
- Johnson & Johnson Associate District Manager Interview Questions
- Johnson & Johnson Field Manager Interview Questions
- Johnson & Johnson Marketing Intern Interview Questions
- Show more
Johnson & Johnson Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Johnson & Johnson Data Analyst Reviews and Ratings
based on 11 reviews
Rating in categories
|
District Manager
120
salaries
|  ₹5.9 L/yr - ₹13 L/yr |
|
Associate District Manager
108
salaries
| ₹4 L/yr - ₹11 L/yr |
|
Field Manager
102
salaries
| ₹10 L/yr - ₹22.3 L/yr |
|
Medical Representative
100
salaries
| ₹1.8 L/yr - ₹5.5 L/yr |
|
Area Sales Manager
85
salaries
| ₹6.2 L/yr - ₹21 L/yr |
Procter & Gamble
GlaxoSmithKline Pharmaceuticals
Pfizer
Merck
- Home >
- Interviews >
- Johnson & Johnson Interview Questions >
- Johnson & Johnson Data Analyst Interview Questions
