Clicks vs Sales Conversion Calculation - Modeling large datasets
New to Domo and have seeking best practice or options for modeling. I have 2 tables - Clicks and Sales. We look at clicks for a given day divided by sales for a given day to measure conversion. The clicks table is very large and approximately 558GB uncompressed, to update data we append. The sales table is smaller around 9GB, to update data we overwite.
What's the best way to model this data? I'm assuming we can't use Data Fusion because of the volume of data. We also want to avoid creating a flatten view of Clicks+Sales prior to data ingestion, as Domo being a BI tool we expect it can handle the calculation.
Open to ideas/feedback - Thanks!
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board