Forbes Marshall Data Analyst Interview Questions and Answers

Q1. Explain Order of execution in SQL
Ans. 
Order of execution in SQL determines the sequence in which different clauses are processed in a query.
• SQL query is processed in the following order: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

• FROM clause is processed first to retrieve data from tables.

• WHERE clause filters the data based on specified conditions.

• GROUP BY clause groups the data based on specified columns.

• HAVING clause filters the grouped data.

• SELECT ...read more
Answered by AI
Add your answer
Q2. Sumifs function
Add your answer
Q3. Boxplots?Histograms?
Add your answer

Q1. He ask about of your previous company and all
Add your answer

Q1. It totals depends upon for which profile you are giving interview. Mine was Data Analyst so the interviewer ask me about excel,sql,power bi and some part of statistics
Add your answer

Q1. He just asked my about my profile briefly and then questioned me about my profile ony then he told me about the work culture and the requiremnt of the profile.
Add your answer

Q1. What are joins and its types?
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

• FULL ...read more
Answered by AI
Add your answer
Q2. What are aggregate functions?
Ans. 
Aggregate functions are functions in databases that perform a calculation on a set of values and return a single value.
• Aggregate functions are used to perform operations on a group of rows and return a single result.

• Common aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• For example, SUM function calculates the total of a column, AVG calculates the average, COUNT counts the number of rows, MIN finds the minimu
Answered by AI
Add your answer

Q1. Coding questions in python eda part
Add your answer

Q1. Where do u see in next 5 years
Add your answer

30 questions and time was approx. 45 min to 60 min

There were some basic as well as some high level questions

Q1. Simple question they asked
Add your answer

Q1. Advanced Financial Reporting
Add your answer
Q2. General Costing Knowledge
Add your answer

Well, I’m currently an account executive at Smith, where I handle our top-performing client. Before that, I worked at an agency where I was on three different major national healthcare brands. And while I really enjoyed the work that I did, I’d love the chance to dig in much deeper with one specific healthcare company, which is why I’m so excited about this opportunity with Metro Health Center

Q1. Basic and in general Basic is good
Add your answer
Q2. How are you?Walk me through your resume.
Add your answer
Q3. Walk me through your redume
Add your answer

Q1. Intoduce yourself
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• Experienced in data analysis and interpretation

• Skilled in problem-solving and critical thinking

• Proficient in using analytical tools such as Excel and SQL
Answered by AI
Add your answer
Q2. Previous Work related
Add your answer
Q3. Company profile
Add your answer
Q4. Energy Sector Related
Add your answer
Q5. Finance related
Add your answer