ABC Superstore Victoria is a medium-sized retailer of furniture, technology and office supplies. It is selling
its products to consumers, smaller businesses and corporate houses through its three stores around
Melbourne and Geelong. The company’s founder, Mr David Scott, like all business owners, is always
interested in finding ways to increase revenues and decrease expenses.
Mr Scott has recently hired you as a business analyst and poses some operational-level questions about
the performance of his business. He is also eager to hear your thoughts and ideas on how to improve the
business and requires you to make recommendations on how to improve the company’s performance,
especially in relation to the following business objectives:
- Improving the sales strategy;
- Improving internal efficiencies and effectiveness; and
- Building strong lasting relationships with its customers
Mr. Scott has provided you with last year’s sales information in the “ITECH1005-Assignment-data-S1-
2017.xlsx” file. The data needs to be analysed and visualised to help observations related to the business
operation and its shortcomings.
The data worksheet “Sales” contains collected information of the ABC Superstore’s sales in 2016. These
details include:
- Order ID
- Customer Name
- Customer Segment
- Product Name
- Product Category
- Order Quantity
- Unit Cost Price
- Unit Selling Price
0 comments