Fan Intelligence: Data Warehouse & Analytics

Overview

• Power Automate: Connecting to Two Circles PSS SQL and Redshift Data Warehouse
• DWA overview
• Integrations table
• Integration policies
• Connecting to the data warehouse

Setup and configuration

• View integration status and error reports
• One-off data import (from supported integrations)
• Download service
• Seat coordinates (X, Y) and heatmaps
• Configure individual Redshift users

Schemas and data modeling

• KORE CRM products ('korepss' schema)
• Schemas overview
• KORE Data Model ('kore' schema)
• Ticketing data model ('dwa' schema)
• Archtics ticket coding ('korebi' schema)
• Upload data into DWA ('custom' schema)

See all 8 articles

Integrations catalog

• Emplifi