Usually, there is raw data in the data source and we want to analyse it from another view. However, sometimes it is not formatted consistently. As a result, it is not easily interpreted by business users. Before creating reports and visualizations, it is often necessary to clean up the data so that it is presentable and understandable.
Say we want to exclude Shipping City from our dataset in order to analyse the revenue and quantity of items by category. In addition, we want to reduce the dataset and improve performance. This can be done easily with the following steps: