refined data preparation