The company wants to create a dedicated sales team of 4 employees with one of these employees promoted to Head of Sales. Analyse and create a visualisation to choose the new sales team and Head of Sales. Explain how you came to this conclusion.

Visualising and Analysing Data Effectively Assignment Produce a report that addresses all the questions listed below. Please submit your report in Microsoft Word (.docx) format and submit an Excel file (.csv) that can be used to verify any analysis. Case study information: You are working for the company “Universal Export” who are a small but established company that has been trading for over 20 years. They import plain garments that are then sold to customers in bulk for customisation. The increase in clients buying directly from overseas companies and importing the clothes themselves is a worrying trend for them. The CEO, Shelia Burns, wants to review the details of the transactions from 2021 so that they can take steps to streamline the business and increase profitability. The board of directors wants to start setting sales targets. They have proposed a target of a 10% increase in profits for the first quarter of 2022 compared to the first quarter of 2021 but they are not sure how realistic this is. There are also company policies that need reviewing in particular they have a smaller mark up on red items as they think these are more unpopular. You have been given data files for their 2021 sales and profits. They have requested that you to create an informative report that will be circulated to the board of directors. You are the first data analyst the company has hired so they want you to explain any analysis and visualisation techniques that you use so they can fully to understand both the process and results. Part 1 (40%): 1) Address any issues in the data set for all the variables. 2) Consider the context of the problem by formulating a big idea. Make assumptions where necessary. Part 2 (60%): 批注 [AC1]: Would it be better to separate tis into two bullet points so that it is clear that this is two separate questions? 批注 [LH2R1]: They need this more for the big idea question but yes good idea to space it out. 1) Create a monthly profit forecast for the first quarter of 2022 and make an appropriate visualisation. Comment on the accuracy of the forecast you provide. 2) The company wants further insights so that they can review their policy of having a lower mark up on products with the colour of red. Analyse the data and create a visualisation to show if this policy should still be in place. 3) The company wants to create a dedicated sales team of 4 employees with one of these employees promoted to Head of Sales. Analyse and create a visualisation to choose the new sales team and Head of Sales. Explain how you came to this conclusion. Your report should use tables and figures as appropriate as well as text to present your findings. You can use screenshots of your Excel book to help with any explanations. No appendices are required, and any material provided in appendices will not contribute to the final mark. The number of words in the Word file should not exceed 2500 words in total. The assignment does not require the use of academic literature. However, if students support their discussion using evidence or arguments from academic (or nonacademic) sources then the source of information should be acknowledged. In that case a “Reference list” should be included at the end of the coursework, using the University’s referencing guidelines. Weighted Marking Criteria Part 1 Report Presentation: 15% Identification and handling of data issues: 30% Discussion of missing data type/options: 20% Process and formulation of big idea: 35% Weighted Marking Criteria Part 2 Report presentation: 15% Explanation of analysis steps and justification: 25% Results and interpretation: 15% Visualisations: 20% Explanation of Visualisation choice and optimisation: 25% Data File: Universal Export Transactions 批注 [AC3]: It isn’t clear to me if the forecast is daily, monthly, or for the whole quarter? Maybe this is covered already in the lecture, but I haven’t look in detail. 批注 [LH4R3]: good point have changed it to monthly Excel Sheet: Transactions Transaction_ID Unique ID number of transaction Transaction_Date Date of transaction Salesperson ID Unique ID number of salesperson Shipment City City order will ship to Shipment_Country Country order will ship to Product_ID Unique ID number of the product Quantity Amount of a product ordered Product-Cost Cost of company to purchase each item Product_Salesprice The amount the company sells each item for Profit The total profit for the product item on the transaction Excel Sheet: Products Product_ID Unique ID number of product Product Clothing item Colour Colour of item Product_Cost Cost of company to purchase each item Product_Salesprice The amount the company sells each item for Excel Sheet: Salesperson Salesperson_ID Unique ID number of the salesperson Salesperson_Name Name of corresponding salesperson Assignments should be a maximum of 2500 words in length.