Oracle Cerner Business Intelligence Analyst Interview Questions and Answers

Q1. About projects and then questions related to ML and DL. Mostly focused on DL part
Add your answer
Q2. What is the difference between Adam optimizer and Gradient Descent Optimizer?
Ans. 
Adam optimizer is an extension to the Gradient Descent optimizer with adaptive learning rates and momentum.
• Adam optimizer combines the benefits of both AdaGrad and RMSProp optimizers.

• Adam optimizer uses adaptive learning rates for each parameter.

• Gradient Descent optimizer has a fixed learning rate for all parameters.

• Adam optimizer includes momentum to speed up convergence.

• Gradient Descent optimizer updates parameters b...read more
Answered by AI
Add your answer
Q3. When to use Relu and when not?
Ans. 
Use ReLU for hidden layers in deep neural networks, avoid for output layers.
• ReLU is commonly used in hidden layers to introduce non-linearity and speed up convergence.

• Avoid using ReLU in output layers for regression tasks as it can lead to vanishing gradients.

• Consider using Leaky ReLU or Sigmoid for output layers depending on the task.

• ReLU is computationally efficient and helps in preventing the vanishing gradient prob...read more
Answered by AI
Add your answer

Q1. Do you know power BI
Add your answer
Q2. Yes. I know PowerBI
Add your answer

Q1. Asked about some machine learning concepts like NLP, TensorFlow etc
Add your answer

Q1. How can Logistic regression be applied for multiclasstext classification
Ans. 
Logistic regression can be applied for multiclasstext classification by using one-vs-rest or softmax approach.
• One-vs-rest approach: Train a binary logistic regression model for each class, treating it as the positive class and the rest as the negative class.

• Softmax approach: Use the softmax function to transform the output of the logistic regression into probabilities for each class.

• Evaluate the model using appropriate...read more
Answered by AI
Add your answer

Q1. Why Citrix? Take 5 minutes and talk to me about your profile and experience. How will you interact with others? How do you deal with conflict and what are problem-solving challenges in the past? Where do y...read more
Add your answer

Q1. Writing common MS-SQL queries, report building on Power Bi / Tableau, managing end-to-end BI projects, data pre-processing and transformations on Power Query, managing documentation and version control, co...read more
Add your answer

Q1. Tell me about yourself? How will you make a positive impact in Citrix?
Ans. Take 5 mins to talk about yourself with crisp and sharp summary. Find a way to relate your experiences with prior company goals. To answer positive impact on Citrix make sure you get a high level understanding on Citrix goals and mission statement. Talk about empowering stakeholders and decision makers, how will you position BI effort to reach decision intelligence and build winning consensus with stakeholders.
Answered Anonymously
Add your answer
Q2. Talk about the most challenging project you managed with both good and not so good outcomes?
Add your answer
Q3. Be prepared with the best, most satisfying project of your life. Describe project charter, mandates and goals. What efforts did you lead and what were your strengths? How did you overcome challenges as an ...read more
Add your answer

Q1. What are your salary expectations? If you are asking for a hike, why should we pay you this much? Are you prepared to relocate on notice? Talk to me about your hobbies and what you do on your personal time...read more
Ans. Never come through as arrogant and deceitful. Make sure you have well rounded answers on a pay hike and your long term financial goals. If you need a 30% hike from your prior role, be sure to provide a compelling argument and not make absurd comparison with peers and industry standards. For e.g. arguing that your peers all got a 30% hike in salary OR that the industry needs me at any price is not going to sit well with...read more
Answered Anonymously
Add your answer

Can you share some examples or visuals of prior work so I can get a 1st hand impression of what your work looks like?

I showcased 2 POC's using freely available data (Adv Works and NY Taxi datasets) that I built on MS-SQL and Power BI. In fact I used an old abandoned laptop as a Power BI reporting (on-prem) and loaded my reports and view from a business perspective. With Adv works I built Operations, Sales, Marketing and Finance Power BI views whereas with NY Taxi data I built forecasting model on taxi fares and surge pricing using Power BI & Python. Discussed technical challenges, used Exploratory data analysis to talk about businesses I knew nothing about. Use your own ingenuity and creative thinking for building POC's that standout from the usual YouTube instructional videos.

Q1. You are selected, welcome to the team. You will need to go through standard on-boarding and training sessions. How does that make you feel?
Add your answer
Q2. Be sure to thank them from the bottom of your heart for all the time they invested in listening to you. Ask questions about the on-boarding process, how long it takes to clear background checks and when ca...read more
Add your answer

Standard question from sql and python in hackerrank

Q1. Reverse a linked list
Ans. 
Reverse a linked list by changing the direction of pointers
• Start with three pointers: current, previous, and next

• Iterate through the linked list, updating pointers to reverse the direction

• Return the new head of the reversed linked list
Answered by AI
Add your answer
Q2. Question based on joins and subquery
Add your answer

Q1. More question about project
Add your answer
Q2. What do you know about genAI
Add your answer

Q1. What are the various projects that have you implemented in your current org ?
Ans. 
I have implemented several projects in my current organization.
• Developed a predictive model to forecast customer churn

• Built a recommendation system to personalize product recommendations

• Created a fraud detection model to identify fraudulent transactions

• Implemented a natural language processing model for sentiment analysis

• Designed an anomaly detection system to detect network intrusions
Answered by AI
Add your answer
Q2. How is y9ur project related to business problem and how you have solved it
Ans. 
Developed a predictive model to identify potential customer churn for a telecom company
• Identified key factors contributing to customer churn through exploratory data analysis

• Built a logistic regression model to predict customer churn with 85% accuracy

• Provided actionable insights to the business team to reduce customer churn and improve customer retention

• Implemented the model in production environment using Python and S
Answered by AI
Add your answer
Q3. Why you are looking out for a change
Ans. 
Seeking new challenges and growth opportunities in the field of data science.
• Looking for a more challenging role to further develop my skills and knowledge in data science.

• Interested in exploring new industries and applying data science techniques to solve different problems.

• Seeking a company with a strong data-driven culture and a focus on innovation.

• Want to work with a diverse team of data scientists and learn from t...read more
Answered by AI
Add your answer

Q1. Define your work
Ans. 
As a Data Scientist, I analyze and interpret complex data to help businesses make informed decisions.
• I collect and clean data from various sources.

• I use statistical techniques and machine learning algorithms to analyze data.

• I develop predictive models and algorithms to solve business problems.

• I communicate findings and insights to stakeholders through visualizations and reports.
Answered by AI
Add your answer
Q2. What motivates you to join our company
Ans. 
I am motivated to join your company because of the challenging and innovative work environment.
• I am excited about the opportunity to work with cutting-edge technologies and tools in data science.

• Your company's reputation for being at the forefront of data-driven decision making is inspiring.

• I am impressed by the collaborative and diverse team culture that fosters continuous learning and growth.

• The company's commitment ...read more
Answered by AI
Add your answer
Q3. Why looking out for a change
Ans. 
Seeking new challenges and growth opportunities in the field of data science.
• Looking for a more challenging role to apply and expand my skills

• Interested in working with cutting-edge technologies and techniques

• Seeking a company with a strong data-driven culture

• Want to work on diverse projects and industries to broaden my experience

• Desire to make a bigger impact and contribute to solving complex problems
Answered by AI
Add your answer

Q1. Tell me about your self
Add your answer