Case Study: Universal Export

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.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.