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:
Click on Data->Edit Data Source or press Ctrl+Shift+E; the Edit Data Source window will appear:
Uncheck Shipping City and click on OK.
We will get the new dataset with only three columns.
Let's continue to learn how to prepare our data on another SQL query that returns much more data. Perform the following steps:
Click on File->New. Select Query with SQL.
From the Recently Used...