Bharat Coking Coal Business Analyst Interview Questions and Answers

Aptitude round with basic questions

Q1. General Questions related to project
Add your answer
Q2. Project discussion
Add your answer

Q1. Advanced excel related questions
Add your answer
Q2. PowerBi related questions and tricks
Add your answer

Q1. About my profile and work ex
Add your answer
Q2. Department related questions and trends
Add your answer

Q1. Strengths and weaknesses myself
Add your answer
Q2. Salary negotiation and sedisgnation
Add your answer

Q1. Plant overview and process
Add your answer
Q2. Rankine cycle process and efficiency
Ans. 
Rankine cycle is a thermodynamic cycle used in power plants to generate electricity.
• Rankine cycle is a closed-loop cycle that uses steam to generate power.

• The cycle consists of four processes: heating, vaporization, expansion, and condensation.

• The efficiency of the Rankine cycle can be improved by increasing the temperature and pressure of the steam.

• The Rankine cycle is commonly used in power plants to generate electri...read more
Answered by AI
Add your answer

Q1. How to connect data sources in power bi
Ans. 
Data sources in Power BI can be connected through various methods including importing data from files, databases, online services, and streaming datasets.
• Import data from files such as Excel, CSV, XML, JSON, etc.

• Connect to databases like SQL Server, MySQL, Oracle, etc.

• Utilize online services connectors for platforms like Google Analytics, Salesforce, Facebook, etc.

• Set up streaming datasets for real-time data analysis.
Answered by AI
Add your answer
Q2. How to add file from sharepoint
Ans. 
To add a file from SharePoint, you can use the SharePoint API or sync the SharePoint library with your local machine.
• Access the SharePoint site and navigate to the library where you want to add the file.

• Click on the 'Upload' button and select the file you want to upload.

• Alternatively, you can sync the SharePoint library with your local machine using OneDrive or SharePoint Sync.

• Once synced, you can simply drag and drop ...read more
Answered by AI
Add your answer

Q1. Example of value engineering from past experience.
Ans. 
Implemented value engineering by redesigning a product to reduce costs without sacrificing quality.
• Identified unnecessary features or components that could be removed without impacting functionality.

• Suggested alternative materials or manufacturing processes to lower production costs.

• Collaborated with cross-functional teams to brainstorm cost-saving ideas and implement changes.

• Conducted cost-benefit analysis to ensure t...read more
Answered by AI
Add your answer
Q2. Example of cost saving in previous project.
Ans. 
Implemented lean manufacturing techniques to reduce material waste by 15% in previous project.
• Identified inefficiencies in production process

• Implemented just-in-time inventory system

• Negotiated better pricing with suppliers

• Utilized automation to streamline operations
Answered by AI
Add your answer

Q1. Talk about your professional experience and personal background.
Ans. 
I have over 10 years of experience in project management, leading cross-functional teams to successful outcomes.
• Managed multiple projects simultaneously, ensuring deadlines were met and budgets were adhered to

• Led a team of 15 individuals in a software development project, resulting in a 20% increase in efficiency

• Implemented Agile methodologies to streamline project processes and improve team collaboration
Answered by AI
Add your answer