Analytics β Amazon S3
234 articles Updated weekly
Export BI data to your Amazon S3 bucket β star schema with 87 dimension tables, 55 fact tables, and 47 consolidated tables, each with full column-level reference
Ask Zeenie
ββ
Skip the list β get a direct AI answer.
No articles match. Try the Ask Zeenie row above for an AI answer.
Overview
Start with the big picture.
Getting started
New to Analytics β Amazon S3? Start here.
Settings
Display, notifications, and alert rules.
- 4 minConfigure S3 data accessHow-to
- 3 minConfigure analytics subscriptionsHow-to
- 2 minOrganization Settings β Enable Range-Based Discount CheckboxHow-to
- 1 minCenter Royalty Settings Dimension TableHow-to
- 1 minTips Payout Center Settings Dimension TableHow-to
- 1 minTips Payout Employee Settings Dimension TableHow-to
Workflows
How daily analytics β amazon s3 work flows through Zenoti.
- 1 minAccount Name Dimension TableGuide
- 3 minData pipeline architectureGuide
- 5 minS3 folder structure and file formatGuide
- 6 minTroubleshoot analytics data issuesGuide
- 7 minAdoption Fact ConsolidatedGuide
- 7 minDimension tables: Guests, centers, and appointmentsGuide
- 2 minETL processing β dimensionsGuide
- 4 minUnderstand the star schema and data modelGuide
- 5 minAdoption Summary Fact TableGuide
- 4 minData freshness and refresh cyclesGuide
- 5 minDimension tables: Employees, memberships, and businessGuide
- 6 minETL processing β factsGuide
- 2 minS3 data share configurationGuide
- 1 minAdd On User Membership Dimension TableGuide
- 3 minDimension tables: Services, products, and catalogGuide
- 2 minRedshift data warehouseGuide
- 13 minAppointment Fact ConsolidatedGuide
- 3 minFact tables: Appointments, sales, and financialGuide
- 2 minS3 export pipelineGuide
- 6 minAppointment Fact TableGuide
- 2 minFact tables: Employees, memberships, and operationsGuide
- 2 minS3 folder structure and file formatGuide
- 1 minAgent Dimension TableGuide
- 4 minConsolidated tables referenceGuide
- 2 minData freshness and schedulingGuide
- 5 minAnalytics data export column value referenceGuide
- 2 minAppointment Multiple Employee Fact TableGuide
- 3 minStar schema relationshipsGuide
- 7 minAI Lead Manager data tablesGuide
- 3 minAppointmentredo Fact ConsolidatedGuide
- 2 minData quality and error handlingGuide
- 1 minAppointment Categories Dimension TableGuide
- 2 minETL segregationGuide
- 7 minStage Table Schema Upgrades β Forms Metadata, Membership and Membership UserGuide
- 1 minAppointment Redo Fact TableGuide
- 2 minAppointmentsegment Fact ConsolidatedGuide
- 3 minHandle schema changes and upgradesGuide
- 2 minAveda Employee ConsolidatedGuide
- 4 minQuery S3 data with external BI toolsGuide
- 3 minCampaign Dimension TableGuide
- 1 minCampaign Discount Fact TableGuide
- 3 minBI Dimension User ConsolidatedGuide
- 1 minCampaign Centers Dimension TableGuide
- 1 minCampaign Summary Fact TableGuide
- 2 minCampaign Fact ConsolidatedGuide
- 1 minCash Register Dimension TableGuide
- 1 minCash Register Fact TableGuide
- 2 minCampaigndiscount Fact ConsolidatedGuide
- 2 minCash Register V2 Fact TableGuide
- 1 minCategory Products Dimension TableGuide
- 3 minCashregiser Fact ConsolidatedGuide
- 1 minCategory Services Dimension TableGuide
- 1 minChallenges Fact TableGuide
- 4 minCashregiserv2 Fact ConsolidatedGuide
- 4 minCenter Dimension TableGuide
- 5 minCollections Fact TableGuide
- 1 minCenter Holidays Dimension TableGuide
- 14 minCollections Fact ConsolidatedGuide
- 1 minDeleted Appointment Fact TableGuide
- 1 minCenter Royalty Category Dimension TableGuide
- 7 minBi_FactInvoiceItem β Resident Tax Identity ColumnsGuide
- 1 minDaily Traffic ConsolidatedGuide
- 2 minEmployee Commission Fact TableGuide
- 4 minRead the analytics data exportGuide
- 8 minHyperConnect, AI Lead Manager, Smart Targets, Employee KPI, Challenges and Custom Forms TablesGuide
- 6 minDeleted Appointments Fact ConsolidatedGuide
- 1 minEmployee Declare Tips Fact TableGuide
- 1 minCenter Timing Dimension TableGuide
- 1 minDisocount Summery ConsolidatedGuide
- 2 minEmployee Invoice Item Revenue Fact TableGuide
- 1 minCenter Working Hours Exceptions Dimension TableGuide
- 3 minDonations Fact ConsolidatedGuide
- 1 minEmployee Item Level Commissions Fact TableGuide
- 1 minChallenges Dimension TableGuide
- 6 minEmployee Commission Fact ConsolidatedGuide
- 1 minEmployee Membership Commissions Fact TableGuide
- 2 minCustom Forms Dimension TableGuide
- 2 minEmployee Declare Tips Fact ConsolidatedGuide
- 1 minEmployee Pay Fact TableGuide
- 3 minDate Dimension TableGuide
- 4 minEmployee Hourly Pay Fact ConsolidatedGuide
- 1 minEmployee Salary Fact TableGuide
- 2 minDiscount Dimension TableGuide
- 4 minEmployee Ranking ConsolidatedGuide
- 2 minEmployee Schedule Fact TableGuide
- 1 minDonations Dimension TableGuide
- 1 minEmployee Tips And SSG Details Fact TableGuide
- 4 minEmployee Tips SSG ConsolidatedGuide
- 4 minEmployee Dimension TableGuide
- 1 minEmployee Worktasks Payroll Fact TableGuide
- 4 minEmployeeinvoiceitemrevenue Fact ConsolidatedGuide
- 1 minEmp Salary Fact TableGuide
- 1 minEmployee Attendance Dimension TableGuide
- 3 minEmployeeitemlevelcommissions ConsolidatedGuide
- 1 minEmployee Break Category Dimension TableGuide
- 2 minEmployee Salary Fact ConsolidatedGuide
- 1 minFeedback V2 Fact TableGuide
- 1 minEmployee Deputation Dimension TableGuide
- 4 minForms Fact ConsolidatedGuide
- 3 minForms Fact TableGuide
- 1 minEmployee Role Dimension TableGuide
- 2 minGift Cards Fact TableGuide
- 4 minGiftcards Fact ConsolidatedGuide
- 1 minEmployee Schedule Status Dimension TableGuide
- 2 minGuest Check In Fact TableGuide
- 5 minInventory Fact ConsolidatedGuide
- 1 minEquipment Dimension TableGuide
- 1 minGuest Merge Log Fact TableGuide
- 5 minIssues Fact ConsolidatedGuide
- 1 minETL Refresh Log Dimension TableGuide
- 1 minGuest Tier Changes Fact TableGuide
- 1 minItemcomissiondeductions ConsolidatedGuide
- 1 minForms Meta Data Dimension TableGuide
- 1 minInstructor Class Fact TableGuide
- 2 minLoyaltypoints Fact ConsolidatedGuide
- 2 minGift Card Dimension TableGuide
- 2 minInventory Fact TableGuide
- 4 minMembership Dunning ConsolidatedGuide
- 3 minGuest Dimension TableGuide
- 1 minInvoice Donations Fact TableGuide
- 5 minMembership Fact Consolidated DateGuide
- 2 minGuest Coupon Dimension TableGuide
- 7 minInvoice Item Fact TableGuide
- 5 minMembership Fact ConsolidatedGuide
- 1 minGuest Loyalty Tier Dimension TableGuide
- 1 minInvoice Item Taxes Fact TableGuide
- 9 minMembership User Redemptions ConsolidatedGuide
- 1 minIssue Categories Dimension TableGuide
- 2 minIssues Fact TableGuide
- 3 minMonthly Finance Summery ConsolidatedGuide
- 1 minIssue Priority Type Dimension TableGuide
- 1 minItem Commission Deductions Fact TableGuide
- 2 minMultipleempcomissions ConsolidatedGuide
- 1 minIssue Source Dimension TableGuide
- 1 minLoyalty Points Fact TableGuide
- 7 minOpportunities Fact ConsolidatedGuide
- 1 minIssue Status Type Dimension TableGuide
- 2 minMembership Dunning Fact TableGuide
- 9 minPackage User Fact ConsolidatedGuide
- 1 minIssue Sub Categories Dimension TableGuide
- 3 minMembership Status Log Fact TableGuide
- 10 minPackage Value Fact ConsolidatedGuide
- 1 minIssue Treatment Dimension TableGuide
- 3 minMembership Status Log Deleted Fact TableGuide
- 3 minPettycash Fact ConsolidatedGuide
- 1 minIssue Type Dimension TableGuide
- 1 minMembership Transfers Fact TableGuide
- 1 minRegister Summery ConsolidatedGuide
- 1 minItems Dimension TableGuide
- 4 minMembership User Redemptions Fact TableGuide
- 6 minRegistration Fact ConsolidatedGuide
- 1 minItem Source Dimension TableGuide
- 1 minMilestones Fact TableGuide
- 25 minSales Fact ConsolidatedGuide
- 1 minItem Type Dimension TableGuide
- 1 minMultiple Employee Commission Fact TableGuide
- 11 minSales Opportunities ConsolidatedGuide
- 1 minLoyalty Point Actions Dimension TableGuide
- 1 minOpportunity Custom Field Values Fact TableGuide
- 4 minSchedule Fact ConsolidatedGuide
- 1 minLoyalty Point Programs Dimension TableGuide
- 4 minPackage User Redemptions Fact TableGuide
- 5 minScheduled Collections ConsolidatedGuide
- 3 minMembership Dimension TableGuide
- 4 minPackage Value Fact TableGuide
- 2 minTime Card ConsolidatedGuide
- 1 minMembership Fee Type Details Dimension TableGuide
- 2 minPetty Cash Details Fact TableGuide
- 5 minTurnaway Fact ConsolidatedGuide
- 1 minMembership Status Dimension TableGuide
- 1 minRecurring Payment Amount Log Fact TableGuide
- 1 minMile Stones Dimension TableGuide
- 3 minRecurring Status Log Fact TableGuide
- 1 minOpportunity Source Dimension TableGuide
- 3 minRecurring Status Log Deleted Fact TableGuide
- 2 minOrg Custom Fields Dimension TableGuide
- 2 minRegistration Fact TableGuide
- 1 minOrg Dispositions Dimension TableGuide
- 2 minScheduled Collections Fact TableGuide
- 1 minOrg LP Tier Dimension TableGuide
- 1 minTips Payout Fact TableGuide
- 1 minOrg Payment Option Dimension TableGuide
- 1 minTurn Aways Fact TableGuide
- 1 minOrg Royalty Category Dimension TableGuide
- 1 minUser Guest Pass Fact TableGuide
- 3 minPackage Dimension TableGuide
- 1 minPackage Benefits Dimension TableGuide
- 1 minPackage Center Dimension TableGuide
- 2 minPackage User Dimension TableGuide
- 2 minProduct Dimension TableGuide
- 1 minProduct Barcodes Dimension TableGuide
- 1 minProduct Center Dimension TableGuide
- 1 minProduct Vendors Dimension TableGuide
- 1 minReasons Dimension TableGuide
- 1 minRecord Type Dimension TableGuide
- 1 minRecurrence Details Dimension TableGuide
- 1 minResource Dimension TableGuide
- 1 minResource Service Association Dimension TableGuide
- 2 minService Dimension TableGuide
- 1 minService Center Dimension TableGuide
- 1 minService Segment Dimension TableGuide
- 3 minSession Dimension TableGuide
- 1 minStatus Dimension TableGuide
- 1 minTax Group Details Dimension TableGuide
- 1 minTraining Center Dimension TableGuide
- 2 minTraining Class Dimension TableGuide
- 4 minUser Dimension TableGuide
- 2 minUser Membership Dimension TableGuide
- 1 minUser Notes Dimension TableGuide
- 1 minUser Update History Dimension TableGuide
- 1 minUtc To Center Time Dimension TableGuide
- 1 minVendor Dimension TableGuide
- 2 minWorkshop Dimension TableGuide
- 1 minWorkshop Session Dimension TableGuide
- 1 minWork Tasks Dimension TableGuide
- 1 minFeedback Dimension TableGuide
- 1 minGift Card User Dimension TableGuide
- 4 minMembership User Dimension TableGuide
- 1 minProduct Batches Dimension TableGuide
- 1 minChallenge Level Metrics Dimension TableGuide
- 5 minHyperConnect Voice Call Log Fact TableGuide
- 11 minHyperConnect Voice Call Metrics Fact TableGuide
- 2 minHyperConnect Usage Fact TableGuide
- 2 minHyperConnect Reviews Fact TableGuide
Reports
Operational reports the analytics β amazon s3 relies on every day.
FAQ
Quick answers to common questions.
Support online
Can't find what you need?
Our support team is available 24/7. Drop us a message, submit a request, or check live system status β we usually reply within an hour.