How to format translate data before visualizing

Question

Can I just use unformatted data for analysis in quicksight? If not, how should I format & transform the data before visualizing?

Answer 1

Amazon QuickSight lets you prepare data that is not ready for visualization. Select the “Edit/Preview Data” button in the connection dialog. Amazon QuickSight supports various functions to format and transform your data. You can alias data fields and change data types. You can subset your data using built in filters and perform database join operations using drag and drop. You can also create calculated fields using mathematical operations and built-in functions such conditional statements, string, numerical and date functions.