This document describes the top level data model employed by v0.01 of the public data analysis system. The data model links the API Gateway's ingested, normalized public data resources with downstream data systems. The primary goal of this system is generating certain novel data points through analysis of public data. These data points are listed under the section Targets below. These data points form the basis of any downstream data analysis, including analytic and predicative statistical applications with or without the inclusion of other systems.
This is where our narrative becomes specific to this version
-
TAM (Total Addressable Market)
-
SAM (Serviceable Available Market)
- TAM filtered by demographics/geographies from ACS.
- NAICS roll-ups focus on relevant industries.
- See Full Article
-
SOM (Serviceable Obtainable Market)
- SAM further filtered by adoption proxies (e.g., broadband access, education).
- Competitive constraints estimated from CBP/NES firm counts.
- See Full Article
-
Elasticity
- Income from ACS
- Receipts, establishments, and employment numbers from ECN
- Geography and category mapped via NAICS, annually via year
- price index (CPI/PPI from BLS) mapped via NAICS/NAPCS
- Demographics via ???
- See Full Article
-
Supply Curve
-
Demand Curve
- From ACS: income, household counts, demographic structure.
- Constructed as expenditure proxies (income, housing burden, vehicle ownership, broadband, education).
- See Full Article
-
Price Optimization
- Occurs at the point of suppy & demand interection, as determined by market equillibrium points.
Geography
Product
Supply & Industry
Demographics
Channel & Servicability
Crosswalk
A market is a saved, reviewable, versioned analytical object with:
- a product definition;
- a supplier/industry definition;
- a geography definition;
- a buyer or demographic definition;
- channel and serviceability rules;
- a time basis;
- a monetary basis;
- source releases and classification vintages;
- explicit assumptions.
No metric may be published without a market_definition_version_id.
- NAPCS to define the product or service being analyzed.
- NAICS to define the industries producing, carrying, selling, or delivering it.
- UCC to define Consumer Expenditure Survey spending categories.
- CPI ELI to define consumer-price series.
- PPI commodity or industry codes to define producer-price series.
- PCE categories to define broad personal-consumption categories.
- SOC/OEWS occupations to define labor requirements and wage exposure.
Market Definition
Metrics
TAM
SAM
SOM
PC
DC
PE