i
Baxter International
Filter interviews by
Top trending discussions
I applied via Recruitment Consultant and was interviewed in Apr 2021. There were 4 interview rounds.
I applied via Referral and was interviewed before May 2020. There were 4 interview rounds.
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...
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
I applied via Naukri.com and was interviewed in Dec 2023. There were 2 interview rounds.
Power bi assignment was given to solve
Optimization techniques in SQL involve using indexes, query optimization, and proper database design.
Use indexes on columns frequently used in WHERE clauses to speed up query performance
Avoid using SELECT * and instead specify only the columns needed in the query
Optimize queries by using appropriate join types and conditions
Normalize database tables to reduce redundancy and improve query efficiency
Sub queries in SQL are queries nested within another query to retrieve data based on the result of the outer query.
Sub queries can be used in SELECT, INSERT, UPDATE, and DELETE statements.
They can be used to filter results, retrieve data from multiple tables, or perform calculations.
Example: SELECT * FROM table1 WHERE column1 = (SELECT column2 FROM table2 WHERE condition);
Types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a match in both tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left table
Full outer join: Returns all rows when there is a match in either table
Time intelligence functions in Power BI are used to analyze and compare data based on time periods.
Time intelligence functions help in calculating year-to-date, month-to-date, and other time-based calculations.
Functions like TOTALYTD, SAMEPERIODLASTYEAR, and PARALLELPERIOD are commonly used for time intelligence in Power BI.
These functions allow for easy comparison of data across different time periods and help in tren
Row level security in Power BI allows users to restrict access to specific rows of data based on their role or criteria.
Row level security can be implemented by creating roles in Power BI and defining rules to filter data based on user roles.
Users can be assigned to specific roles which determine the data they have access to.
Row level security helps in ensuring data privacy and compliance with regulations.
For example, ...
posted on 16 Dec 2024
I applied via Referral and was interviewed before Dec 2023. There were 2 interview rounds.
Power bi test which ask you to make a dashboard
Basic communication round
I was interviewed before Feb 2024.
I applied via Campus Placement and was interviewed in Jul 2023. There were 2 interview rounds.
It was basic aptitude but it was online
Python code for determining if a number is prime or not and applying bizzbuzz logic.
Write a function to check if a number is prime or not
Iterate through a range of numbers and apply bizzbuzz logic
Return 'prime' if the number is prime, 'bizz' if divisible by 3, 'buzz' if divisible by 5, and 'bizzbuzz' if divisible by both 3 and 5
I applied via Company Website and was interviewed in Jan 2023. There were 2 interview rounds.
I applied via Naukri.com and was interviewed in May 2022. There were 2 interview rounds.
based on 1 interview
Interview experience
based on 3 reviews
Rating in categories
Associate
82
salaries
| ₹4 L/yr - ₹10.9 L/yr |
Senior Engineer
79
salaries
| ₹12 L/yr - ₹40 L/yr |
Senior Executive
75
salaries
| ₹3.4 L/yr - ₹10 L/yr |
Principal Engineer
57
salaries
| ₹18.2 L/yr - ₹42 L/yr |
Senior Associate
46
salaries
| ₹6 L/yr - ₹17.5 L/yr |
Johnson & Johnson
Medtronic
Abbott
Boston Scientific