Multiple Tables Demo

Here are the questions we can answer with your current data

15 answerable

Dataset overview

The dataset provides a comprehensive view of sales, operations, and financial activities within a company, covering sales orders, inventory, financial transactions, and operational tasks.

It is structured to facilitate analysis of sales performance, inventory management, financial health, and operational efficiency.

  • Enables identification of sales order issues and responsible parties for resolution.
  • Supports inventory management by tracking stock levels and reorder needs.
  • Facilitates financial oversight through detailed transaction and departmental budget analysis.
  • 'Sales Review' sheet tracks sales orders, customer issues, and responsible owners, aiding in issue resolution and customer satisfaction.
  • 'Operations Tracker' sheet monitors inventory levels, reorder points, and suppliers, crucial for maintaining optimal stock levels.
  • 'Finance Notes' sheet provides departmental budget vs. actual spending data, highlighting financial performance and variances.
  • 'Sales Review' sheet also reviews sales reps' weekly targets and pipeline activities, supporting sales performance tracking.
  • 'Finance Notes' sheet records financial transactions by cardholders, offering insights into spending patterns and receipt management.
  • 'Operations Tracker' sheet logs operational tasks and shipment issues, helping track task progress and resolve shipment problems.

Supported example questions

These are sample questions we can answer from this dataset.

  • Which owner is responsible for the most sales order issues?
  • What is the total revenue generated by orders from Acme Co?
  • How many sales orders have issues related to 'Waiting on signed PO'?
  • Which supplier provides the most SKUs that are below their reorder threshold?
  • What is the variance between budget and actual spending for the Marketing department?
  • How many tasks assigned to Maya are currently blocked?
  • Which sales representative has the highest weekly sales target in the North region?
  • What is the total amount of invoices due from Bright Supply?
  • How many shipments handled by UPS have unresolved issues?
  • Which product generated the highest revenue in June 2026?
  • What is the average amount spent per transaction by cardholder Nina?
  • How many sales orders were placed by Brightline in June 2026?
  • Which department has the largest negative variance in financial performance?
  • What is the most common issue reported in sales orders?
  • How many shipments have been resolved successfully?

Answerability

Your questions

0 total
QuestionVerdictExplanation
No user-provided questions were assessed for this report.

Suggested questions

15 total
QuestionVerdictExplanation
Which owner is responsible for the most sales order issues?AnswerableThe 'Sales Review' sheet contains information on sales orders, issues, and their responsible owners, allowing us to count issues per owner.
What is the total revenue generated by orders from Acme Co?AnswerableThe 'Sales Review' sheet includes order details such as customer, product, and revenue, enabling calculation of total revenue for Acme Co.
How many sales orders have issues related to 'Waiting on signed PO'?AnswerableThe 'Sales Review' sheet lists sales orders and their associated issues, allowing us to filter and count orders with the specified issue.
Which supplier provides the most SKUs that are below their reorder threshold?AnswerableThe 'Operations Tracker' sheet contains SKU details, including current stock and reorder thresholds, allowing us to identify suppliers with SKUs below threshold.
What is the variance between budget and actual spending for the Marketing department?AnswerableThe 'Finance Notes' sheet provides budget, actual spending, and variance for departments, including Marketing.
How many tasks assigned to Maya are currently blocked?AnswerableThe 'Operations Tracker' sheet lists tasks, their owners, and status, allowing us to filter tasks assigned to Maya that are blocked.
Which sales representative has the highest weekly sales target in the North region?AnswerableThe 'Sales Review' sheet includes sales representatives, their regions, and weekly targets, enabling identification of the highest target in the North region.
What is the total amount of invoices due from Bright Supply?AnswerableThe 'Finance Notes' sheet contains invoice details, including vendor and amount, allowing us to sum amounts due from Bright Supply.
How many shipments handled by UPS have unresolved issues?AnswerableThe 'Operations Tracker' sheet tracks shipment issues, including carrier and resolution status, allowing us to count unresolved UPS shipments.
Which product generated the highest revenue in June 2026?AnswerableThe 'Sales Review' sheet provides order details, including product and revenue, enabling identification of the highest revenue-generating product in June 2026.
What is the average amount spent per transaction by cardholder Nina?AnswerableThe 'Finance Notes' sheet records transactions, including cardholder and amount, allowing calculation of average spending per transaction for Nina.
How many sales orders were placed by Brightline in June 2026?AnswerableThe 'Sales Review' sheet includes order details such as customer and order date, enabling filtering for Brightline orders in June 2026.
Which department has the largest negative variance in financial performance?AnswerableThe 'Finance Notes' sheet provides variance data for departments, allowing identification of the largest negative variance.
What is the most common issue reported in sales orders?AnswerableThe 'Sales Review' sheet lists issues associated with sales orders, enabling determination of the most common issue.
How many shipments have been resolved successfully?AnswerableThe 'Operations Tracker' sheet tracks shipment issues and their resolution status, allowing us to count successfully resolved shipments.