02 — Dimensions
AI-classified · 5 distinct dimensions found
4
Sources
89
Total Fields
3
Classified
1
Pending
Connected Sources 4 total
📊
Sales_Q4_2024.csv
Finance · 84,302 rows · 12 fields
Mapped
🗄
product_events
Product · PostgreSQL · live
Mapped
📋
Customer_Master.xlsx
CRM · 22,109 rows · 31 fields
Mapped
📦
inventory_log
Ops · BigQuery · 3 pending
Review
Add new source
Sales_Q4_2024.csv — Fields 12 fields
Field Name AI Type Sample Values
5
Dimensions
3
Hierarchies
89
Fields Mapped
97%
Confidence
Time
Standard · ISO 8601
7 fields
94% conf.
Atomic granularity detected across sources
Quarter (most atomic)
Century Year Quarter ▲ Month Day Hour Sec
Century Year Quarter Month
Mapped fields
order_quarter Sales_Q4 event_date product_events signup_date Customer
🌍
Geography
Standard · ISO 3166
12 fields
99% conf.
Continent Country State City Lat/Lng
Mapped fields
country_code Sales_Q4 shipping_city Sales_Q4 customer_region Customer
📦
Product
Custom · Company taxonomy
8 fields
88% conf.
Division Category Subcategory SKU
Mapped fields
product_category Sales_Q4 item_sku inventory_log
👤
Customer Segment
Custom · Proposed by AI
5 fields
81% conf.
⚠ AI proposed this taxonomy — review & confirm
Tier Segment Account
Mapped fields
customer_tier Customer account_type Sales_Q4
Measures
Numeric · 4 sources
22 fields
99% conf.
Available measures
revenue Sales_Q4 units_sold Sales_Q4 event_count product_events stock_qty inventory_log avg_order_val Sales_Q4
+
Add dimension
Linked Unlinked 12 / 27 fields connected
Source Fields All sources · 27 fields
order_quarter
Sales_Q4linked
country_code
Sales_Q4linked
product_category
Sales_Q4linked
revenue
Sales_Q4linked
rep_name
Sales_Q4linked
event_date
product_eventslinked
event_type
product_eventslinked
session_id
product_eventslinked
customer_tier
Customerlinked
customer_region
Customerlinked
contact_email
Customerlinked
item_sku
inventory_loglinked
stock_qty
inventory_loglinked
mapping
Taxonomy Dimensions 5 dimensions
⏱ Time
Year › Quarter
⏱ Time
event_date
◈ Geography
Country level
◈ Geography
Region level
◈ Product
Category
◈ Product
SKU
◈ Customer
Tier
◈ Customer
Segment
∑ Revenue
numeric
∑ Stock Qty
numeric
∑ Event Count
numeric
📄
CSV File
Flat file export with all mapped fields and taxonomy labels applied
📊
Excel Workbook
Multi-sheet export — one sheet per dimension with hierarchy levels
🗄
Database
Push directly to PostgreSQL, BigQuery, Snowflake, or MySQL
🔗
REST API
Expose taxonomy as a live JSON endpoint for BI tools
📐
Tableau / Power BI
Export as a data source with pre-built dimension hierarchies
🧩
JSON Schema
Export the taxonomy definition itself for use in other systems
Export Configuration
File name
Include measures
Hierarchy depth
Null handling