Radico Khaitan MIS Executive Interview Questions and Answers

Q1. Conditional sum or distinct count in pivot
Ans. 
Conditional sum is used to calculate the sum based on certain conditions, while distinct count is used to count unique values in a pivot table.
• Conditional sum can be achieved using functions like SUMIF or SUMIFS in Excel.

• Distinct count can be achieved using the COUNTIF function with a unique identifier column.

• In a pivot table, you can use the Value Field Settings to choose between sum or count, based on your requiremen
Answered by AI
Add your answer
Q2. Advance Excel formula like lookup formula
Add your answer

Q1. Salaray Negosiation process
Add your answer
Q2. Responsibilties in prevoius organization
Ans. 
Managed database systems, generated reports, provided technical support, and implemented new technologies.
• Managed database systems to ensure data integrity and security

• Generated reports for management to analyze business performance

• Provided technical support to end users for software and hardware issues

• Implemented new technologies to improve efficiency and productivity

• Collaborated with cross-functional teams to integra
Answered by AI
Add your answer

Q1. Current Salary last company
Ans. 
My current salary at my last company was competitive, reflecting my skills and contributions to the team.
• Salary was aligned with industry standards for my role and experience.

• I received a performance-based raise after my first year.

• Participated in projects that increased company revenue, justifying my salary level.

• Salary included benefits such as health insurance and bonuses.
Answered by AI
View 1 more answer
Q2. Expted increase Salary
Add your answer

Basic Aptitude Test for 30 min

2 Coding question from easy to mid difficulty. Time Given - 30 min. Topics can be array, String , stack, queue, and bit manipulation.

Group discussion on 'Electric Vehicles on Indian Roads'

Q1. What do you know about Power Platform?
Ans. 
Power Platform is a collection of Microsoft tools that enable users to build business solutions without extensive coding.
• Power Platform consists of Power Apps, Power Automate, Power BI, and Power Virtual Agents.

• Power Apps allows users to create custom apps using a visual interface.

• Power Automate enables users to automate workflows and integrate different systems and services.

• Power BI is a business analytics tool that p...read more
Answered by AI
Add your answer
Q2. What is the difference between DAX and Power Query?
Ans. 
DAX is a formula language used in Power BI and Power Pivot for data analysis and calculations. Power Query is a data transformation and shaping tool.
• DAX is used for creating custom calculations and measures in Power BI and Power Pivot.

• Power Query is used for importing, transforming, and cleaning data from various sources.

• DAX is a formula language similar to Excel formulas, but with additional functions and capabilities...read more
Answered by AI
Add your answer
Q3. How to obtain a sync between Dataverse and SQL database to show real time updates?
Ans. 
To obtain a sync between Dataverse and SQL database for real-time updates, you can use change tracking, triggers, or a data integration platform.
• Enable change tracking in the SQL database to track modifications

• Create triggers in the SQL database to capture changes and update Dataverse

• Utilize a data integration platform like Azure Data Factory or SSIS to synchronize data in real-time

• Implement a custom solution using API...read more
Answered by AI
Add your answer

Q1. Automation framework
Add your answer
Q2. Design pattern explain project
Ans. 
Design patterns are reusable solutions to common problems in software design.
• Design patterns help in creating flexible, maintainable, and scalable code.

• Examples of design patterns include Singleton, Factory, Observer, and Strategy.

• Each design pattern has a specific purpose and can be applied to different scenarios in software development.
Answered by AI
Add your answer