Manager - Business Intelligence

Manager - Business Intelligence Interview Questions and Answers

Updated 7 Apr 2023

Popular Companies

Q1. How to make pivot table range auto and how to adjust pivot to not show nil value.

Ans.

To make pivot table range auto, select the data range and press Ctrl + T. To adjust pivot to not show nil value, go to PivotTable Options > Layout & Format > uncheck 'Show items with no data'.

To make pivot table range auto, select the data range and press Ctrl + T.
To adjust pivot to not show nil value, go to PivotTable Options > Layout & Format > uncheck 'Show items with no data'.

Q2. What is differ types of data error in Pharma data science What type of machine learning model. You know well

Ans.

Data errors in Pharma data science include missing data, incorrect data, duplicate data, and outliers.

Missing data: When important data points are not recorded or are incomplete.
Incorrect data: When data is entered or recorded incorrectly, leading to inaccurate analysis.
Duplicate data: When the same data is recorded multiple times, skewing the analysis.
Outliers: Data points that deviate significantly from the rest of the data, potentially affecting analysis results.

Q3. What to do if wrong report was sent by you?

Ans.

Acknowledge the mistake, inform the concerned parties, and provide the correct report as soon as possible.

Admit the mistake and take responsibility
Notify the recipients of the incorrect report
Provide the correct report as soon as possible
Take steps to prevent similar mistakes in the future

Q4. What you will do if more work load ?

Ans.

I will prioritize tasks, delegate responsibilities, and communicate with my team to ensure timely completion of all work.

Assess the workload and prioritize tasks based on urgency and importance
Delegate responsibilities to team members based on their strengths and workload
Communicate with team members to ensure everyone is aware of their responsibilities and deadlines
Monitor progress and provide support as needed
Consider hiring additional staff or outsourcing work if necessary

Are these interview questions helpful?

Q5. Diffrence between line chart and Bar chart.

Ans.

Line chart shows trends over time while bar chart compares values between categories.

Line chart displays data as a series of points connected by a line, useful for showing trends over time.
Bar chart displays data as rectangular bars, useful for comparing values between categories.
Line chart is best suited for continuous data while bar chart is best suited for discrete data.
Line chart can show multiple series of data on the same chart while bar chart is typically used for one ...read more

Q6. What is Row Level Security?

Ans.

Row Level Security is a feature that restricts access to specific rows in a database based on user roles and permissions.

It allows for fine-grained control over data access.
It is commonly used in multi-tenant applications where different users should only have access to their own data.
It can be implemented using database views, stored procedures, or application-level logic.
For example, a sales manager may only be able to see sales data for their own team, while a regional man...read more

Share interview questions and help millions of jobseekers 🌟

Q7. Approach to reduce manual process.

Ans.

Automate manual processes using technology and streamline workflows.

Identify repetitive tasks that can be automated
Evaluate available technology solutions
Implement automation tools and integrate with existing systems
Train employees on new processes and monitor for efficiency
Continuously review and improve automated processes

Q8. What is digital twin

Ans.

A digital twin is a virtual replica of a physical object or system.

Digital twins are used in various industries such as manufacturing, healthcare, and transportation.
They can be used to simulate and optimize processes, predict maintenance needs, and improve efficiency.
For example, a digital twin of a wind turbine can be used to monitor its performance and predict when maintenance is needed.
Another example is a digital twin of a patient, which can be used to simulate different...read more