Deskify is a retail store specializing in office supplies, technology (computer accessories), and furniture. With a diverse product range tailored to both individual and business customers, Deskify has experienced significant growth over the past four years. The company is dedicated to providing high-quality office essentials, technology accessories, and furniture, with a focus on reliability, efficiency, and customer satisfaction.
Deskify currently relies on Excel to compile, analyze, and report its monthly sales and transaction data. However, this process has become increasingly cumbersome and time-consuming due to the complexity of the data and the high volume of transactions processed each month. The reporting process involves manual data entry and consolidation from multiple sources, which introduces errors and inconsistencies.
The companies main database structure as seen below consists of six tables: Transaction Fact Table, Product Dimention Table, Location Dimention Table, Customer Dimention Table,Calender Dimention Table and Order Dimention Table with a consistently updating transaction table. A description of each table is as follows:
- Transaction
- Product
- Location
- Customer
- Calender
- Order
Over the 4 years that Deskify has been in business, it has achieved a profit margin of only 10.33%, which is significantly lower than the projected profit margin of 30%. With a revenue of £14.7 million, the total profit amounts to £1.52 million. The highest overall sales during this period occurred in January, September, and October. Binders generated the highest profit at £260,000, while copiers were the only products that incurred a loss of £16,000. All customer segments are contributing to substantial profits, with Copreta customers achieving the highest profit levels.
