Table of Contents
Overview
Automatically sync your MarianaTek data into a dedicated analytics database for advanced reporting, integrations, and business intelligence.
Our ETL solution extracts data from MarianaTek, transforms it into analytics-friendly structures, and loads it into your preferred data warehouse.
Supported Destinations
We currently support:
- Google BigQuery
- PostgreSQL
During onboarding, we'll configure the destination platform based on your business requirements and existing analytics infrastructure
Data Refresh Schedule
Data is automatically synchronized from MarianaTek on a scheduled basis.
Available refresh options include:
- Near real-time
- Hourly
- Daily
Refresh frequency will be configured during implementation
Available Datasets
We provide access to a wide range of MarianaTek data, including:
| Datasets | Columns |
|---|---|
| Sales | Orders,Transactions, Revenue, Taxes, Refunds, Product sales, Gift card sales |
| Memberships | Active memberships, Memberships purchases, Renewals, Cancellations |
| Customers | Profiles, Visits, History, Customer activity |
| Shifts | No shows, Late shows, Attendees, Capacity, Utilization |
Custom Data Models
In addition to standard MarianaTek datasets, we can create custom tables designed specifically for your reporting requirements.
Examples include:
- Executive KPI tables
- Customer Lifetime Value tables
- Membership retention models
- Revenue summary tables
- Multi-location performance datasets
- Instructor scorecards
Custom tables reduce reporting complexity and provide analytics-ready data structures.
Data Structure
Our data model is inspired by MarianaTek Insights while providing greater flexibility for advanced analytics.
Benefits include:
- Analytics-ready tables
- Consistent naming conventions
- Historical tracking
- Simplified querying
- Optimized reporting performance
Data Access
Once provisioned, your team can:
- Query data directly
- Connect BI tools
- Build custom dashboards
- Export data
- Integrate with internal systems
- Develop custom analytics workflows
You retain full control over how the data is utilized within your environment.
Screenshots
BigQuery Setup :
