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.Explain any analysis and visualisation techniques that you use so they can fully to understand both the process and results.
