BA Club Brain Teaser

Which visualization tool is best for understanding relationships between two numerical variables?

• Pie chart

• Bar chart

• Scatter plot

• Line chart

Which programming language is widely used for statistical analysis and graphics in business analytics?

• C++

• R

• JavaScript

• SQL

In a startup, business analytics can be crucial for:

• Optimizing office space

• Developing an amazing UX

• Identifying key market segments

• Planning company events

A data warehouse is:

• Software for creating data backups

• A physical store for company data files

• A system that stores and manages large datasets

• A new type of online data center

Business simulation and optimization is used for:

• Testing business strategies

• Video game development

• Predicting sales

• Fund raising

CRM systems help businesses manage:

• Data about employee interactions

• Data about inventory trends

• Data about supply chain

• Data about customer interactions

What is the main difference between a mean and a weighted average?

• Mean is only used in finance, while weighted average is used in marketing.

• Mean is calculated with multiplication, while weighted average uses addition.

• Mean equally considers all values, while weighted average assigns different weights to values based on importance.

• Mean is used when there is more uncertainty in data, while weighted average is used in more certain situations.

What is a key advantage of using cloud storage in business analytics?

• It increases the reliability of on-site IT infrastructure.

• It ensures that only local networks can access data for security.

• It offers unlimited physical storage space for office documents.

• It provides scalable and accessible data storage, allowing for efficient data analysis and collaboration.

In SQL, which statement is used to remove duplicates from the results of a SELECT query?

• DELETE

• UNIQUE

• REMOVE

• DISTINCT

An analyst wants to find the total number of orders placed by each customer in a table named 'Orders' where 'CustomerID' identifies each customer. Which SQL query will correctly provide this information?

• SELECT COUNT(DISTINCT CustomerID) FROM Orders;

• SELECT CustomerID, COUNT(*) FROM Orders GROUP BY CustomerID;

• SELECT CustomerID, COUNT(*) FROM Orders;

• SELECT COUNT(*) FROM Orders GROUP BY CustomerID;