ANLY482 AY2017-18 T1 Group03/Project Overview

From Analytics Practicum
Jump to navigation Jump to search

Logo3.PNG

Home About Us Project Overview Midterm Progress Final Progress Project Management Documentation

 


Our Motivation

Willy: I want to understand the field of application for data analytics in the real world practice. I also want to know how past data will have a direct influence over a company’s current and future performances. Since I am pursuing a career path in this field, this project will definitely be useful to me to better understand the growing trend in data analytics and how companies can leverage on such method to add value to both themselves and their stakeholders.

Cass: Since big data is one of the upcoming trends in the market, I am motivated to pick up this skill and explore why it is becoming an essential in every industry. Undertaking this project will not only allow me to practice using analytical tools on real data, it will also give me insight with regards to pursuing a career in the analytics field.

Sohini: Working with real life data in the pharmaceutical sector is extremely interesting as I had a desire to work closely with big data in this field. I want to learn more about the field of data analytics and also apply the concepts and applications i have learnt previously during my analytics internship. I hope to learn a lot about the tools and skills needed in analytics and also have a better understanding of the healthcare sector in Singapore. Finally, I just want to work closely with an actual company to have a better understanding of the working world of analytics.

Jon: I want to be exposed to the field of analytics and to learn about what the current perceived uses of analytics as a tool is in our daily world. I hope to be able to be at the forefront of applying it as a skill or tool to other industry processes in operations management, some of which might not even have been conceived today.

Business Problem

From a business point of view, we aim to shed light on the following macro issue. We would like to find out which of the key resources (i.e. sales representatives, products, processes) drives sales and business performance for our client. Through this, we wish to help them gain a better insight on how they can allocate resources to maximise profit. This macro issue can be broken down into the following questions, which will aide us in providing a more comprehensive analysis for the client.

  • What is the best way to allocate limited resources, such as sales representatives, as compared to peddling via other channels such as telesales?
  • What is the optimal proportion, frequency and pattern of visits for various brands?
  • For different subcategories of channels, what is the optimal and required restock pattern?
  • What are the top 8-10 power brands that should be focused on in 2018 and through which channel are they best promoted?

These would help to provide a more focused sales effort for the client in 2018, and leading up to the industry trend of using big data to make better decisions to maximise revenue and provide better healthcare for the people (Healthcare 2020). To achieve the above business objectives, our analytical objectives are as follows:

  • To use analytical methods to discover product and process sensitivity to sales.
  • To formulate a robust and accurate framework of resource-to-resource relationship sensitivity, that will allow the client to better align business objectives to industry ecosystem relationships.

Lastly, from an industry point of view, it would be useful to understand if there are any difference in relationships within each subcategories defined by the industry. Some questions we feel would help are:

  • Do clinics participating in the Community Health Assist Scheme (CHAS) experience a higher restock rate?
  • Do clinics in matured estates have a higher restock rate?