Owl Park
— Data Architecture
|
Real-time Analytics Pipeline · Zoological Facility
① Ingest
n8n Agent 1
Events & Visits
n8n Agent 2
Products & Sellouts
n8n Agent 3
Transactions & Weather
Owl Park Webstore
E-commerce & Tickets
Stream
② Store
Supabase
Raw Data Repository
Analyst_Transactions
Weather_Impact
events
issues
products
sales_summary
sellout_counter
transactions
visit_dates
wh_transactions
Real-time
Pull
③ Transform · Model · Store
Microsoft Fabric
Gen2 Dataflow
· Real-time Schedule
Dimensions (19)
dim_time
dim_date
dim_products_events
dim_products_products
dim_time_products
dim_date_products
dim_product_sellout
dim_time_sellout
dim_date_sellout
dim_transactions_date_time
dim_transactions_contacts
dim_weather_dates
dim_customer_warehouse
dim_date_warehouse
dim_time_warehouse
dim_contact
dim_date_VCalendar
dim_date_VCalendar_created_at
dim_time_VCalendar_visit_date
Facts & Bridge (7)
facts_events
facts_products
facts_sellout_counter
facts_transactions
facts_Weather_Impact
facts_wh_transactions
facts_visit_dates
Query Groups — 26 Queries
Events (4) · Products (4) · Sellouts (4)
Transactions (3) · VisitingCalendar (5)
Warehouse (4) · Weather (2)
REAL-TIME
Data Warehouse
Real-time OLAP · Structured Queries
EVERY 24H
Data Lake
Daily Backup · Historical Archive
④ Analyze
LIVE
Power BI Reports
BI Team Dashboards · Executive Analytics
AI · MCP
Claude + PBI MCP Server
AI-Assisted Analysis · Natural Language