ANLY482 AY2016-17 T2 Group19
Contents
Members
Project Background
Company Z is a medium-sized pharmaceutical product distributor and wholesaler in Singapore who caters to various healthcare institutes and clinics. Effective management of the supply chain and sales strategies is particularly important for Company Z as it deals primarily with large volume and high-value products at a rapid pace. Hence, even the smallest miscalculation in strategic management would result in significant losses. That said, there is huge potential for insights from the wealth of information that can be found in the sales data.
Motivation & Objective
Research and development efforts were motivated by the general sentiments of SMEs towards data analytics innovation across Singapore and the lack of professionals with deep computer language knowledge required to handle volume, variety, velocity of data. It aims to address the gap between research areas of institutes (e.g. University) and practical business needs through working closely with a local SME, in this case, specifically in the pharmaceutical field.
By building an interactive visual analytical tool that does not require advanced computing knowledge for data exploration, we can enable business professionals with domain knowledge to leverage on the wealth of data. With deeper understanding of how nuances between sales, customer types, products and geographic segmentation, businesses can help to drive business sustainability with greater focus.
In relevance to the business, the visual dashboard attempts to support decision making process by fulfilling the following analysis requirements:
1. To be able to display massive sales data cartographically.
2. To provide a graphical visualization framework that can display distribution of product mixes in relation to customer types over time.
3. To provide visual comparability between similar types of customers in a designated geographical context.
4. To derive insights into customer spending trends based on their respective types and geographical locations
Dashboard
Status: Completed. Refer to Methodology and Analysis to View.
Timeline with Process Flow
End of Project.
Submitted Final Conference Paper and Artifacts. Handover of deliverables to Client.
