Data clean up: Create a check that the quantity should not be below 1 unit Create a check that the Unit price should not be below $0 Please note that in order to apply the checks that have been mentioned above, you would need to use conditional formulas where the logic would state that if the conditions are met then the tool should exclude the data from analysis. You can also use data transformation methods to get rid of the bad data. Both these methods are provided in the resources. Once this is done, the data will be good to be used for further analysis. Please note that this data should be cleaned up before attempting any question. Create each visual on a separate tab with the name of the tab displaying the question number. Once the visuals are created, save the files and upload them below. For Tableau users, you would need to upload in .twbx format whereas Power BI files need to be saved in .pbix format. Instructions on how to save in these formats are provided in the resources below. Should you get stuck, please reference the Visuals Hints document in the resources. Question 1 The CEO of the retail store is interested to view the time series of the revenue data for the year 2011 only. He would like to view granular data by looking into revenue for each month. The CEO is interested in viewing the seasonal trends and wants to dig deeper into why these trends occur. This analysis will be helpful for the CEO to forecast for the next year