Business Analytics Associate

Business Analytics Associate Interview Questions and Answers

Updated 24 Oct 2024

Q1. Estimate the number of pizzas sold in IIT Roorkee campus in a month

Ans.

Estimating the number of pizzas sold in IIT Roorkee campus in a month.

Collect data on the number of pizza outlets in the campus
Observe the average number of pizzas sold per day at each outlet
Consider the days of the week and any special events that may affect pizza consumption
Calculate the average number of pizzas sold per day across all outlets
Multiply the average by the number of days in a month to estimate the total pizzas sold

Q2. Estimate the number of streetlights in Roorkee

Ans.

Estimating the number of streetlights in Roorkee.

Collect data on the area of Roorkee and its population density.
Research the average number of streetlights per square kilometer in similar cities.
Calculate the estimated number of streetlights based on the area and population density of Roorkee.
Consider factors like main roads, residential areas, and commercial zones that may require more streetlights.
Validate the estimate by comparing it with any available official data or con...read more

Business Analytics Associate Interview Questions and Answers for Freshers

View all interview questions

Q3. Choose between 2 credit cards with different data

Ans.

I would choose the credit card with lower interest rate and higher rewards.

Compare the interest rates of both credit cards
Check the rewards program of both credit cards
Consider any additional fees or benefits of each card
Choose the card that best fits your spending habits and financial goals

Q4. What is the use of parameters in Tableau?

Ans.

Parameters in Tableau allow users to dynamically change the values of calculations, filters, and reference lines.

Parameters can be used to create dynamic filters that allow users to change the data displayed in a visualization.
Parameters can also be used in calculations to perform complex calculations based on user input.
Parameters can be used in reference lines to dynamically set thresholds or benchmarks for comparison.

Are these interview questions helpful?

Q5. Explain the differences between direct and indirect expenses?

Ans.

Direct expenses are directly related to the production of goods or services, while indirect expenses are not directly tied to production.

Direct expenses can be easily traced to a specific cost object, such as raw materials or labor costs.
Indirect expenses are overhead costs that are necessary for the business to operate but are not directly tied to a specific product or service.
Examples of direct expenses include direct labor, direct materials, and manufacturing supplies.
Exam...read more

Q6. Explain the balance sheet and P&L of banking firms/companies

Ans.

Balance sheet shows a company's assets, liabilities, and equity at a specific point in time. P&L shows a company's revenues, expenses, and profits over a period of time.

Balance sheet includes assets (cash, investments, loans), liabilities (deposits, debt), and equity (common stock, retained earnings)
P&L shows revenues (interest income, fees), expenses (operating expenses, loan loss provisions), and profits (net income)
Balance sheet provides a snapshot of a company's financial...read more

Share interview questions and help millions of jobseekers 🌟