Querying Sales Data

Overview


This example shows how to query a dataset of sales transactions. Each transaction represents the sale of a specified product at the given dollar amount, and credited to the listed salesperson.

Each salesperson is employee within a management hierarchy. Salespeople report up the chain through their manager to the top level sales manager.

Resources


  • Sales Data - list of sales transactions
  • Sales Person Hierarchy - a hierarchy of sales employees
  • Querying - simple examples of querying the sales data for various statistics.

Demo


PD from loan snapshot data.
source