[Calculated fields] Analysis vs Data Prep
at which stage do you recommend inserting Calculated fields ?
in other words, what are the benefits of each level?
Here is a high-level comparison of using calculated fields at the analysis level vs data prep level in Amazon QuickSight:
|Data Prep Level
|Tailored to specific analysis/visual
|Reusable across analyses
|Can change often during exploration
|Compute on aggregated data
|Affect raw dataset
|Can leverage other analysis fields
|Referenced in analysis calculated fields
|Interactive analytical workflow
|Efficient for large data
|Ad hoc analytics
|Early data preparation
Analysis level calculated fields enable flexible analytics tailored to the needs of a given analysis.
Data prep calculated fields allow governed transformations reusable across analyses for efficiency.
Using calculated fields at both levels together provides benefits across the analytics workflow.
Hope it helps,
Very much so.
Thank you for your clear and prompt response