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!