Pinch to zoom · Ctrl + scroll to zoom faster
0 / 0
lineage Cycle Superstore Data Warehouse Lineage Node Types Square box = table Rounded box = view Edge color = originating object Data Sources Main ERP [Central operational system: POS, inventory, financials, and service management] CSS2 [E-commerce website and online order data] Google Ads [Campaigns, conversions and Merchant Center product data] Bizimply [Staff timecards and payroll] Xero [Accounting, invoices and bank transactions] Email [Microsoft 365 customer correspondence] How to read this lineage This map shows how data sources feed the warehouse, are shaped through Silver and Intermediate, consolidated in Gold, and exposed through the Semantic layer. Each node is a warehouse table or view. Arrows point from an object to its upstream dependencies, so read the diagram right to left. Example layer path: read right to left Semantic ← Gold ← Intermediate ← Silver ← Bronze raw_layer BRONZE LAYER stg_layer SILVER LAYER int_layer INTERMEDIATE marts_layer GOLD LAYER semantic_layer SEMANTIC LAYER raw_365_365_mail raw_365.365_mail raw_ccdata_adminusers raw_ccdata.adminusers raw_ccdata_category_map raw_ccdata.category_map raw_ccdata_customer raw_ccdata.customer raw_ccdata_customerphoneno raw_ccdata.customerphoneno raw_ccdata_events raw_ccdata.events raw_ccdata_inventory raw_ccdata.inventory raw_ccdata_invoicedetails raw_ccdata.invoicedetails raw_ccdata_invoiceheader raw_ccdata.invoiceheader raw_ccdata_makes raw_ccdata.makes raw_ccdata_products raw_ccdata.products raw_ccdata_purchaseorderdetails raw_ccdata.purchaseorderdetails raw_ccdata_purchaseorderheader raw_ccdata.purchaseorderheader raw_ccdata_repairs raw_ccdata.repairs raw_ccdata_repairsdetails raw_ccdata.repairsdetails raw_ccdata_saleorderdetails raw_ccdata.saleorderdetails raw_ccdata_saleorderheader raw_ccdata.saleorderheader raw_ccdata_stock raw_ccdata.stock raw_ccdata_sundrydetails raw_ccdata.sundrydetails raw_ccdata_sundryheader raw_ccdata.sundryheader raw_ccdata_usedbikes raw_ccdata.usedbikes raw_css2_categories_products raw_css2.categories_products raw_css2_customers raw_css2.customers raw_css2_itemgroupings_t raw_css2.itemgroupings_t raw_css2_productoptions_t raw_css2.productoptions_t raw_css2_products raw_css2.products raw_google_ads_campaignconversionstats_5605924582 raw_google.ads_campaignconversionstats_5605924582 raw_google_ads_campaignlabel_5605924582 raw_google.ads_campaignlabel_5605924582 raw_google_ads_campaignstats_5605924582 raw_google.ads_campaignstats_5605924582 raw_google_vw_daily_product_performance raw_google.vw_daily_product_performance raw_google_vw_pricecompetitiveness raw_google.vw_pricecompetitiveness raw_google_vw_priceinsights raw_google.vw_priceinsights raw_payroll_bizimply_timecards raw_payroll.bizimply_timecards raw_payroll_seed_dwh_employee raw_payroll.seed-dwh-employee raw_xero_banktransactions raw_xero.banktransactions stg_bike_product stg.bike_product stg_bike_product->raw_ccdata_products stg_categories_products stg.categories_products stg_categories_products->raw_css2_categories_products stg_category_map_temp stg.category_map_temp stg_category_map_temp->raw_ccdata_category_map stg_customer_numbers stg.customer_numbers stg_customer_numbers->raw_ccdata_customerphoneno stg_customers stg.customers stg_customers->raw_ccdata_customer stg_employees stg.employees stg_employees->raw_ccdata_adminusers stg_events stg.events stg_events->raw_ccdata_events stg_exchange_emails stg.exchange_emails stg_exchange_emails->raw_365_365_mail stg_google_ads_campaign_conversion_stats stg.google_ads_campaign_conversion_stats stg_google_ads_campaign_conversion_stats->raw_google_ads_campaignconversionstats_5605924582 stg_google_ads_campaign_label stg.google_ads_campaign_label stg_google_ads_campaign_label->raw_google_ads_campaignlabel_5605924582 stg_google_ads_campaign_stats stg.google_ads_campaign_stats stg_google_ads_campaign_stats->raw_google_ads_campaignstats_5605924582 stg_google_daily_product_performance stg.google_daily_product_performance stg_google_daily_product_performance->raw_google_vw_daily_product_performance stg_google_price_competitiveness stg.google_price_competitiveness stg_google_price_competitiveness->raw_google_vw_pricecompetitiveness stg_google_price_insights stg.google_price_insights stg_google_price_insights->raw_google_vw_priceinsights stg_inventory stg.inventory stg_inventory->raw_ccdata_inventory stg_invoice_details stg.invoice_details stg_invoice_details->raw_ccdata_invoicedetails stg_invoice_header stg.invoice_header stg_invoice_header->raw_ccdata_invoiceheader stg_makes stg.makes stg_makes->raw_ccdata_makes stg_payroll_employees stg.payroll_employees stg_payroll_employees->raw_payroll_seed_dwh_employee stg_product stg.product stg_product->raw_ccdata_stock stg_purchase_order_details stg.purchase_order_details stg_purchase_order_details->raw_ccdata_purchaseorderdetails stg_purchase_order_header stg.purchase_order_header stg_purchase_order_header->raw_ccdata_purchaseorderheader stg_repairs_details stg.repairs_details stg_repairs_details->raw_ccdata_repairsdetails stg_repairs_header stg.repairs_header stg_repairs_header->raw_ccdata_repairs stg_sales_order_details stg.sales_order_details stg_sales_order_details->raw_ccdata_saleorderdetails stg_sales_order_header stg.sales_order_header stg_sales_order_header->raw_ccdata_saleorderheader stg_sundry_details stg.sundry_details stg_sundry_details->raw_ccdata_sundrydetails stg_sundry_header stg.sundry_header stg_sundry_header->raw_ccdata_sundryheader stg_used_bike_memo stg.used_bike_memo stg_used_bike_memo->raw_ccdata_usedbikes stg_vw_stg_bizimply_timecards stg.vw_stg_bizimply_timecards stg_vw_stg_bizimply_timecards->raw_payroll_bizimply_timecards stg_web_customers stg.web_customers stg_web_customers->raw_css2_customers stg_web_item_groupings stg.web_item_groupings stg_web_item_groupings->raw_css2_itemgroupings_t stg_web_product stg.web_product stg_web_product->raw_css2_products stg_web_product_options stg.web_product_options stg_web_product_options->raw_css2_productoptions_t stg_xero_bank_transaction_details stg.xero_bank_transaction_details stg_xero_bank_transaction_details->raw_xero_banktransactions stg_xero_bank_transaction_header stg.xero_bank_transaction_header stg_xero_bank_transaction_header->raw_xero_banktransactions int_base_repair_details int.base_repair_details int_base_repair_details->stg_repairs_details int_base_repair_headers int.base_repair_headers int_base_repair_headers->stg_repairs_header int_service_product int.service_product int_base_repair_headers->int_service_product int_bike_product int.bike_product int_bike_product->stg_bike_product int_bike_product->stg_category_map_temp int_bike_product->stg_makes int_consolidated_customers int.consolidated_customers int_consolidated_customers->stg_web_customers int_customers int.customers int_consolidated_customers->int_customers int_consolidated_product int.consolidated_product int_product_consolidated_enriched int.product_consolidated_enriched int_consolidated_product->int_product_consolidated_enriched int_customers->stg_customer_numbers int_customers->stg_customers int_employees int.employees int_employees->stg_employees int_employees->stg_payroll_employees int_exchange_emails_with_customer int.exchange_emails_with_customer int_exchange_emails_with_customer->stg_exchange_emails int_exchange_emails_with_customer->int_consolidated_customers int_fact_repair_lines int.fact_repair_lines int_fact_repair_lines->int_base_repair_details int_fact_repair_lines->int_base_repair_headers int_fact_repair_lines->int_employees int_product_code_to_product_key_mapping int.product_code_to_product_key_mapping int_fact_repair_lines->int_product_code_to_product_key_mapping int_google_ads_campaign_conversions int.google_ads_campaign_conversions int_google_ads_campaign_conversions->stg_google_ads_campaign_conversion_stats int_google_ads_campaign_conversions->stg_google_ads_campaign_label int_int_dim_transaction int.int_dim_transaction int_int_dim_transaction->stg_sales_order_header int_int_dim_transaction->int_base_repair_headers int_order_credit_header int.order_credit_header int_int_dim_transaction->int_order_credit_header int_order_invoice_header int.order_invoice_header int_int_dim_transaction->int_order_invoice_header int_pos_credit_notes_header int.pos_credit_notes_header int_int_dim_transaction->int_pos_credit_notes_header int_pos_invoice_notes_header int.pos_invoice_notes_header int_int_dim_transaction->int_pos_invoice_notes_header int_int_order_credits int.int_order_credits int_int_order_credits->int_base_repair_headers int_int_order_credits->int_employees int_order_credit_details int.order_credit_details int_int_order_credits->int_order_credit_details int_int_order_credits->int_order_credit_header int_int_order_credits->int_order_invoice_header int_int_order_credits->int_product_code_to_product_key_mapping int_int_order_invoices int.int_order_invoices int_int_order_invoices->int_employees int_order_invoice_details int.order_invoice_details int_int_order_invoices->int_order_invoice_details int_int_order_invoices->int_order_invoice_header int_int_order_invoices->int_product_code_to_product_key_mapping int_int_pos_credits int.int_pos_credits int_int_pos_credits->int_employees int_pos_credit_notes_details int.pos_credit_notes_details int_int_pos_credits->int_pos_credit_notes_details int_int_pos_credits->int_pos_credit_notes_header int_pos_invoice_notes_details int.pos_invoice_notes_details int_int_pos_credits->int_pos_invoice_notes_details int_int_pos_credits->int_pos_invoice_notes_header int_int_pos_credits->int_product_code_to_product_key_mapping int_int_pos_invoices int.int_pos_invoices int_int_pos_invoices->int_employees int_int_pos_invoices->int_pos_credit_notes_details int_int_pos_invoices->int_pos_credit_notes_header int_int_pos_invoices->int_pos_invoice_notes_details int_int_pos_invoices->int_pos_invoice_notes_header int_int_pos_invoices->int_product_code_to_product_key_mapping int_int_sales_orders int.int_sales_orders int_int_sales_orders->stg_sales_order_details int_int_sales_orders->stg_sales_order_header int_int_sales_orders->int_employees int_int_sales_orders->int_product_code_to_product_key_mapping int_sales_order_collections int.sales_order_collections int_int_sales_orders->int_sales_order_collections int_int_service_credits int.int_service_credits int_int_service_credits->int_base_repair_headers int_int_service_credits->int_employees int_int_service_credits->int_order_credit_details int_int_service_credits->int_order_credit_header int_int_service_credits->int_order_invoice_header int_int_service_credits->int_product_code_to_product_key_mapping int_int_service_invoices int.int_service_invoices int_int_service_invoices->int_fact_repair_lines int_int_service_orders int.int_service_orders int_int_service_orders->int_fact_repair_lines int_non_bike_product int.non_bike_product int_non_bike_product->stg_category_map_temp int_non_bike_product->stg_makes int_non_bike_product->stg_product int_order_credit_details->stg_invoice_details int_order_credit_header->stg_invoice_header int_order_invoice_collections int.order_invoice_collections int_order_credit_header->int_order_invoice_collections int_order_invoice_collections->stg_events int_order_invoice_details->stg_invoice_details int_order_invoice_header->stg_invoice_header int_order_invoice_header->int_order_invoice_collections int_pos_credit_notes_details->stg_sundry_details int_pos_credit_notes_header->stg_sundry_header int_pos_invoice_notes_details->stg_sundry_details int_pos_invoice_notes_header->stg_sundry_header int_vw_int_product_code_to_product_key_mapping int.vw_int_product_code_to_product_key_mapping int_product_code_to_product_key_mapping->int_vw_int_product_code_to_product_key_mapping int_product_consolidated_base int.product_consolidated_base int_product_source_bike int.product_source_bike int_product_consolidated_base->int_product_source_bike int_product_source_non_bike int.product_source_non_bike int_product_consolidated_base->int_product_source_non_bike int_product_source_special_keys int.product_source_special_keys int_product_consolidated_base->int_product_source_special_keys int_product_consolidated_enriched->stg_makes int_product_consolidated_enriched->int_product_consolidated_base int_product_google_signals int.product_google_signals int_product_consolidated_enriched->int_product_google_signals int_product_google_signals->stg_google_price_competitiveness int_product_google_signals->stg_google_price_insights int_product_source_bike->int_bike_product int_web_product_integrated int.web_product_integrated int_product_source_bike->int_web_product_integrated int_product_source_non_bike->int_non_bike_product int_product_source_non_bike->int_web_product_integrated int_product_source_special_keys->stg_bike_product int_product_source_special_keys->int_product_code_to_product_key_mapping int_purchase_orders int.purchase_orders int_purchase_orders->stg_purchase_order_details int_purchase_orders->stg_purchase_order_header int_purchase_orders->int_employees int_purchase_orders->int_product_code_to_product_key_mapping int_sales_order_collections->stg_events int_service_engineer_performance int.service_engineer_performance int_service_engineer_performance->stg_events int_service_engineer_performance->int_base_repair_headers int_service_engineer_performance->int_employees int_vw_int_service_product int.vw_int_service_product int_service_product->int_vw_int_service_product int_used_bikes_memo int.used_bikes_memo int_used_bikes_memo->stg_used_bike_memo int_used_bikes_memo->int_product_code_to_product_key_mapping int_vw_int_bizimply_timecards_daily int.vw_int_bizimply_timecards_daily int_vw_int_bizimply_timecards_daily->stg_employees int_vw_int_bizimply_timecards_daily->stg_vw_stg_bizimply_timecards int_vw_int_dim_google_ads_campaign int.vw_int_dim_google_ads_campaign int_vw_int_dim_google_ads_campaign->stg_google_ads_campaign_label int_vw_int_google_ads_campaign_daily_stats int.vw_int_google_ads_campaign_daily_stats int_vw_int_google_ads_campaign_daily_stats->stg_google_ads_campaign_label int_vw_int_google_ads_campaign_daily_stats->stg_google_ads_campaign_stats int_vw_int_google_daily_product_performance int.vw_int_google_daily_product_performance int_vw_int_google_daily_product_performance->stg_google_daily_product_performance int_vw_int_google_daily_product_performance->stg_web_product int_vw_int_google_daily_product_performance->int_consolidated_product int_vw_int_product_code_to_product_key_mapping->stg_bike_product int_vw_int_product_code_to_product_key_mapping->stg_product int_vw_int_service_product->stg_product int_vw_web_product_integrated int.vw_web_product_integrated int_vw_web_product_integrated->stg_categories_products int_vw_web_product_integrated->stg_web_item_groupings int_vw_web_product_integrated->stg_web_product int_vw_web_product_integrated->stg_web_product_options int_web_product_integrated->int_vw_web_product_integrated int_xero_bank_transactions int.xero_bank_transactions int_xero_bank_transactions->stg_xero_bank_transaction_details int_xero_bank_transactions->stg_xero_bank_transaction_header marts_dim_customer marts.dim_customer marts_vw_dim_customer marts.vw_dim_customer marts_dim_customer->marts_vw_dim_customer marts_dim_employee marts.dim_employee marts_vw_dim_employee marts.vw_dim_employee marts_dim_employee->marts_vw_dim_employee marts_dim_product marts.dim_product marts_vw_dim_product marts.vw_dim_product marts_dim_product->marts_vw_dim_product marts_dim_transaction marts.dim_transaction marts_vw_dim_transaction marts.vw_dim_transaction marts_dim_transaction->marts_vw_dim_transaction marts_fct_exchange_emails_with_customer marts.fct_exchange_emails_with_customer marts_vw_fct_exchange_emails_with_customer marts.vw_fct_exchange_emails_with_customer marts_fct_exchange_emails_with_customer->marts_vw_fct_exchange_emails_with_customer marts_fct_google_ads_campaign_conversions marts.fct_google_ads_campaign_conversions marts_vw_fct_google_ads_campaign_conversions marts.vw_fct_google_ads_campaign_conversions marts_fct_google_ads_campaign_conversions->marts_vw_fct_google_ads_campaign_conversions marts_fct_google_ads_campaign_daily_stats marts.fct_google_ads_campaign_daily_stats marts_vw_fct_google_ads_campaign_daily_stats marts.vw_fct_google_ads_campaign_daily_stats marts_fct_google_ads_campaign_daily_stats->marts_vw_fct_google_ads_campaign_daily_stats marts_fct_google_daily_product_performance marts.fct_google_daily_product_performance marts_vw_fct_google_daily_product_performance marts.vw_fct_google_daily_product_performance marts_fct_google_daily_product_performance->marts_vw_fct_google_daily_product_performance marts_fct_order_credits marts.fct_order_credits marts_vw_fct_order_credits marts.vw_fct_order_credits marts_fct_order_credits->marts_vw_fct_order_credits marts_fct_order_invoices marts.fct_order_invoices marts_vw_fct_order_invoices marts.vw_fct_order_invoices marts_fct_order_invoices->marts_vw_fct_order_invoices marts_fct_purchase_orders marts.fct_purchase_orders marts_vw_fct_purchase_orders marts.vw_fct_purchase_orders marts_fct_purchase_orders->marts_vw_fct_purchase_orders marts_fct_sales_orders marts.fct_sales_orders marts_vw_fct_sales_orders marts.vw_fct_sales_orders marts_fct_sales_orders->marts_vw_fct_sales_orders marts_fct_service_credits marts.fct_service_credits marts_vw_fct_service_credits marts.vw_fct_service_credits marts_fct_service_credits->marts_vw_fct_service_credits marts_fct_service_engineer_performance marts.fct_service_engineer_performance marts_vw_fct_service_engineer_performance marts.vw_fct_service_engineer_performance marts_fct_service_engineer_performance->marts_vw_fct_service_engineer_performance marts_fct_service_invoices marts.fct_service_invoices marts_vw_fct_service_invoices marts.vw_fct_service_invoices marts_fct_service_invoices->marts_vw_fct_service_invoices marts_fct_service_orders marts.fct_service_orders marts_vw_fct_service_orders marts.vw_fct_service_orders marts_fct_service_orders->marts_vw_fct_service_orders marts_fct_till_credits marts.fct_till_credits marts_vw_fct_till_credits marts.vw_fct_till_credits marts_fct_till_credits->marts_vw_fct_till_credits marts_fct_till_invoices marts.fct_till_invoices marts_vw_fct_till_invoices marts.vw_fct_till_invoices marts_fct_till_invoices->marts_vw_fct_till_invoices marts_fct_used_bikes_memo marts.fct_used_bikes_memo marts_vw_fct_used_bikes_memo marts.vw_fct_used_bikes_memo marts_fct_used_bikes_memo->marts_vw_fct_used_bikes_memo marts_fct_xero_bank_transaction_credits marts.fct_xero_bank_transaction_credits marts_vw_fct_xero_bank_transaction_credits marts.vw_fct_xero_bank_transaction_credits marts_fct_xero_bank_transaction_credits->marts_vw_fct_xero_bank_transaction_credits marts_fct_xero_bank_transaction_debits marts.fct_xero_bank_transaction_debits marts_vw_fct_xero_bank_transaction_debits marts.vw_fct_xero_bank_transaction_debits marts_fct_xero_bank_transaction_debits->marts_vw_fct_xero_bank_transaction_debits marts_vw_dim_customer->int_consolidated_customers marts_vw_dim_employee->int_employees marts_vw_dim_google_ads_campaign marts.vw_dim_google_ads_campaign marts_vw_dim_google_ads_campaign->int_vw_int_dim_google_ads_campaign marts_vw_dim_order_channel marts.vw_dim_order_channel marts_vw_dim_product->int_consolidated_product marts_vw_dim_transaction->int_int_dim_transaction marts_vw_employee_timecards_hours marts.vw_employee_timecards_hours marts_vw_employee_timecards_hours->int_vw_int_bizimply_timecards_daily marts_vw_fct_exchange_emails_with_customer->int_exchange_emails_with_customer marts_vw_fct_google_ads_campaign_conversions->int_google_ads_campaign_conversions marts_vw_fct_google_ads_campaign_daily_stats->int_vw_int_google_ads_campaign_daily_stats marts_vw_fct_google_daily_product_performance->int_vw_int_google_daily_product_performance marts_vw_fct_order_credits->int_int_order_credits marts_vw_fct_order_invoices->int_int_order_invoices marts_vw_fct_purchase_orders->int_purchase_orders marts_vw_fct_sales_orders->int_int_sales_orders marts_vw_fct_service_credits->int_int_service_credits marts_vw_fct_service_engineer_performance->int_service_engineer_performance marts_vw_fct_service_invoices->int_int_service_invoices marts_vw_fct_service_orders->int_int_service_orders marts_vw_fct_till_credits->int_int_pos_credits marts_vw_fct_till_invoices->int_int_pos_invoices marts_vw_fct_used_bikes_memo->int_used_bikes_memo marts_vw_fct_xero_bank_transaction_credits->int_xero_bank_transactions marts_vw_fct_xero_bank_transaction_debits->int_xero_bank_transactions meta_deployment_log meta.deployment_log meta_refresh_metadata meta.refresh_metadata dbo_01___order_invoices 01 - Order Invoices dbo_01___order_invoices->marts_fct_order_invoices dbo_02___till_invoices 02 - Till Invoices dbo_02___till_invoices->marts_fct_till_invoices dbo_03___service_invoices 03 - Service Invoices dbo_03___service_invoices->marts_fct_service_invoices dbo_04___used_bikes 04 - Used Bikes dbo_04___used_bikes->marts_fct_used_bikes_memo dbo_05___order_credits 05 - Order Credits dbo_05___order_credits->marts_fct_order_credits dbo_06___till_credits 06 - Till Credits dbo_06___till_credits->marts_fct_till_credits dbo_07___service_credits 07 - Service Credits dbo_07___service_credits->marts_fct_service_credits dbo_08___sales_order 08 - Sales Order dbo_08___sales_order->marts_fct_sales_orders dbo_09___service_orders 09 - Service Orders dbo_09___service_orders->marts_fct_service_orders dbo_10___inventory 10 - Inventory dbo_10___inventory->stg_inventory dbo_11___emails 11 - Emails dbo_11___emails->marts_fct_exchange_emails_with_customer dbo_12___purchase_orders 12 - Purchase Orders dbo_12___purchase_orders->marts_fct_purchase_orders dbo_13___google_ads_campaign_conversions 13 - Google Ads Campaign Conversions dbo_13___google_ads_campaign_conversions->marts_fct_google_ads_campaign_conversions dbo_14___google_product_performance 14 - Google Product Performance dbo_14___google_product_performance->marts_fct_google_daily_product_performance dbo_15___google_ads_campaign_stats 15 - Google Ads Campaign Stats dbo_15___google_ads_campaign_stats->marts_fct_google_ads_campaign_daily_stats dbo_16___service_engineer_performance 16 - Service Engineer Performance dbo_16___service_engineer_performance->marts_fct_service_engineer_performance dbo_17___xero_bank_transaction_debits 17 - Xero Bank Transaction Debits dbo_17___xero_bank_transaction_debits->marts_fct_xero_bank_transaction_debits dbo_18___xero_bank_transaction_credits 18 - Xero Bank Transaction Credits dbo_18___xero_bank_transaction_credits->marts_fct_xero_bank_transaction_credits dbo_19___employee_payroll_hours 19 - Employee Payroll Hours dbo_19___employee_payroll_hours->marts_vw_employee_timecards_hours dbo_41___document_date 41 - Document Date dbo_42___product 42 - Product dbo_42___product->marts_dim_product dbo_43___customer 43 - Customer dbo_43___customer->marts_dim_customer dbo_44___employee 44 - Employee dbo_44___employee->marts_vw_dim_employee dbo_45___order_channel 45 - Order Channel dbo_45___order_channel->marts_vw_dim_order_channel dbo_46___order_time 46 - Order Time dbo_47___transaction 47 - Transaction dbo_47___transaction->marts_dim_transaction dbo_48___engineer 48 - Engineer dbo_48___engineer->marts_vw_dim_employee dbo_49___order_date 49 - Order Date dbo_50___service_type 50 - Service Type dbo_51___google_ads_campaign 51 - Google Ads Campaign dbo_51___google_ads_campaign->marts_vw_dim_google_ads_campaign dbo_98___refreshes 98 - Refreshes dbo_98___refreshes->meta_refresh_metadata