Test - Answerability Report

Dataset overview

The dataset evaluates the answerability of business questions and provides detailed customer and order information.

It helps identify data gaps and supports customer and product analysis.

Facilitates identification of data gaps for business questions, aiding in strategic decision-making.
Enables detailed analysis of customer orders and product performance.
Supports customer segmentation and regional analysis for targeted marketing.

The 'Questions' sheet assesses the answerability of business questions, highlighting missing evidence and data sources.
The 'Orders' sheet details customer orders, including product, quantity, and revenue, but lacks cost data.
The 'Customers' sheet provides customer information, including region and status, with some missing regional data.
Questions like 'Which customers are most profitable?' are not answerable due to missing cost data.
Order data can be used to analyze product performance and customer purchasing behavior.
Customer data supports segmentation and analysis of customer distribution across regions.

Supported example questions

These are sample questions we can answer from this dataset.

What is the total revenue generated by each product?
How many orders have been placed by each customer?
Which product generates the highest revenue?
What is the average revenue per order?
How many products are included in each order on average?
Which customer has placed the most orders?
What is the distribution of customers across different regions?
How many active customers are there currently?
What is the average quantity of each product sold per order?
Which region has the most active customers?
What is the trend in customer signups over time?
How many customers are currently at risk?
What is the total revenue generated by each customer?
Which products are most frequently ordered together?
What is the average revenue generated per customer?

Question	Verdict	Explanation
What is the total revenue generated by each product?	Answerable	The 'Orders' table contains 'Product ID' and 'Revenue' columns, allowing calculation of total revenue per product.
How many orders have been placed by each customer?	Answerable	The 'Orders' table includes 'Order ID' and 'Customer ID', enabling counting of orders per customer.
Which product generates the highest revenue?	Answerable	The 'Orders' table provides 'Product ID' and 'Revenue', allowing identification of the product with the highest total revenue.
What is the average revenue per order?	Answerable	The 'Orders' table contains 'Order ID' and 'Revenue', enabling calculation of average revenue per order.
How many products are included in each order on average?	Answerable	The 'Orders' table includes 'Order ID' and 'Product ID', allowing calculation of average products per order.
Which customer has placed the most orders?	Answerable	The 'Orders' table has 'Customer ID' and 'Order ID', enabling determination of the customer with the most orders.
What is the distribution of customers across different regions?	Answerable	The 'Customers' table contains 'Region' and 'Customer ID', allowing analysis of customer distribution by region.
How many active customers are there currently?	Answerable	The 'Customers' table includes 'Status', enabling counting of active customers.
What is the average quantity of each product sold per order?	Answerable	The 'Orders' table provides 'Product ID', 'Order ID', and 'Quantity', allowing calculation of average quantity per product per order.
Which region has the most active customers?	Answerable	The 'Customers' table contains 'Region' and 'Status', enabling identification of the region with the most active customers.
What is the trend in customer signups over time?	Answerable	The 'Customers' table includes 'Signup Date', allowing analysis of signup trends over time.
How many customers are currently at risk?	Answerable	The 'Customers' table has 'Status', enabling counting of customers marked as 'At risk'.
What is the total revenue generated by each customer?	Answerable	The 'Orders' table includes 'Customer ID' and 'Revenue', allowing calculation of total revenue per customer.
Which products are most frequently ordered together?	Partial	The 'Orders' table can show products per order, but lacks explicit grouping for frequently ordered combinations.
What is the average revenue generated per customer?	Answerable	The 'Orders' table provides 'Customer ID' and 'Revenue', enabling calculation of average revenue per customer.