CJ Darcl Logistics Limited Business Analyst Interview Questions and Answers

Q1. Show me the PowerBi Data Relations
Ans. 
PowerBI Data Relations show how tables are related to each other in a data model.
• Data relations are created by linking columns between tables.

• One table can have multiple relationships with other tables.

• Data relations can be one-to-one, one-to-many, or many-to-many.

• PowerBI automatically detects and creates relationships based on column names.

• Data relations can be edited and managed in the Relationship view.
Answered by AI
Add your answer
Q2. Python code issue resolve
Add your answer

Q1. Tell Me about yourself
Ans. 
Experienced Business Analyst with a background in data analysis and process improvement.
• Over 5 years of experience in analyzing business processes and identifying areas for improvement

• Skilled in data analysis tools such as Excel, SQL, and Tableau

• Strong communication and presentation skills, able to effectively communicate findings to stakeholders

• Certified in Business Analysis (CBAP) and Lean Six Sigma

• Previous projects ...read more
Answered by AI
Add your answer
Q2. How much you use power BI in your day to day work
Ans. 
I use Power BI extensively in my day to day work to analyze data and create visualizations.
• I use Power BI to create interactive reports and dashboards for stakeholders

• I utilize Power BI's data modeling capabilities to analyze large datasets

• I regularly use Power BI's DAX language to create calculated columns and measures

• I schedule data refreshes and automate report generation using Power BI
Answered by AI
Add your answer

Basic logical reasoning questions

Q1. BRD,FRD,User stories
Add your answer
Q2. Case Studies related questions to judge problem solving attitude
Add your answer
Q3. Basic SQL questions
Add your answer

Q1. Why should we hire you
Ans. 
I have a strong analytical background, excellent communication skills, and a proven track record of delivering valuable insights to drive business decisions.
• I have a Bachelor's degree in Business Analytics and 3 years of experience in data analysis

• I am proficient in various data analysis tools such as SQL, Excel, and Tableau

• I have successfully led cross-functional teams to implement data-driven solutions, resulting in ...read more
Answered by AI
Add your answer
Q2. What is your expected CTC
Ans. 
My expected CTC is based on my experience, skills, and the market rate for Business Analyst roles.
• I have researched the market rates for Business Analyst positions in this industry.

• I have considered my years of experience and relevant skills in determining my expected CTC.

• I am open to negotiation based on the overall compensation package offered by the company.
Answered by AI
Add your answer

Talk to the head hunter. General phone screening

Q1. Talk to the hiring manager and another manager from BI. Asked about work experience and gave me a SQL test
Add your answer

Shared a dataset and wanted me to provide some insights and also build some slides to present

Python, SQL, Aptitude

Q1. SQL - A table EmployeeSkills was given having two columns EmpID & Skills. There can be multiple for an employee id with skills he possess. You need to find the EmpID having skills in Python and SQL
Add your answer
Q2. PowerBI - Create Bookmarks in Power BI
Ans. 
Bookmarks in Power BI allow users to save the state of a report, including filters, slicers, and visuals.
• Bookmarks can be created by selecting 'View' and then 'Bookmarks' in the Power BI toolbar.

• Users can add bookmarks by selecting 'Add' and then naming the bookmark.

• Bookmarks can be applied by selecting the desired bookmark from the 'Bookmarks' pane.

• Bookmarks can be used to save different views of a report for easy acc
Answered by AI
Add your answer
Q3. SQL - Find cumulative Profit sum in a given table.
Ans. 
Use SQL query with window function to find cumulative profit sum in a given table.
• Use window function like SUM() with ORDER BY clause to calculate cumulative profit sum.

• Example: SELECT date, profit, SUM(profit) OVER (ORDER BY date) AS cumulative_profit FROM table_name;

• Ensure the table has a column for date and profit to order and calculate cumulative sum.
Answered by AI
Add your answer

SQL, Python and Power BI