Expeditors International 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

Aptitude section Quants,LR,CR,DI. There are around 40 questions each of 1 marks with negative marking of 1/4.

Q1. It's first round in which question asked about python ,sql and two basic case study questions.
Add your answer

Q1. Question asked from list, dictionary and basic sql,from electrical engineering like a out max efficiency of machine .
Add your answer

They asked general aptitude questions that u can practice by solving online mcqs

Coding question was quite easy

Q1. There were few technical questions and some personal questions
Add your answer
Q2. Sir asked few questions regarding hobbies and interest
Add your answer

Logical reasoning, quant and english

Q1. Puzzles from geeksforgeeks
Add your answer

Q1. SQL joins , sub queries
Add your answer

Sql and python questions are asked,statistic and machine learning

Sql and case study is asked.

Q1. Attitude related
Add your answer
Q2. Conflicts and how do you over come
Add your answer