I'd like to merge sales from our BI with transactions from Google Analytics to show trends over time and investigate, over / under-reporting of both tools.
I'm using a transaction ID as common dimension to associate both tables.
As part of the analysis, I'd like to visualize which transactions were reported in either of the tables and show commons and discrepancies alongside those.
Assuming that, merging two different tables is a common thing:
Is there any out of the (no coding, but using the GUI functionality to get a brief overview of the data?
Thanks,
Moritz