DATA ANALYTICS APPLICATION AT WERT PHILIPPINES INC.

[Audio] Good afternoon Professor Marites Fontanilla, I Edwin Villa together with my partner Christian Bumatay will report about Data Analytics Application at Wert Philippines in relation to business performance and sales performance analysis of each medical representatives..

[Audio] To begin with our introduction. introduction.

[Audio] Data analytics has a wide range of potential applications in business. It can be used to improve customer service, target marketing campaigns, understand customer behavior, develop new products and services, optimize operations, and much more. Businesses like Wert Philippines Inc. are in need of using data analytics to improve their operations and drive growth: 1.) Targeted marketing campaigns: Data analytics can be used to identify customer segments most likely to respond to a particular marketing campaign. This information can then be used to design and target marketing campaigns specifically at those segments, resulting in increased return on investment. 2.) Improved product development: Data analytics can be used to understand how customers use and interact with a product. This information can then be used to improve the product design and development process, resulting in better products that better meet customer needs. 3) Optimized operations: Data analytics can be used to understand and improve business processes. This information can be used to streamline operations, improve efficiency, and reduce costs. 4.) Improved decision making: Data analytics can be used to provide insights that help business leaders make better decisions..

[Audio] This information can be used to improve strategic planning, resource allocation, and risk management. Data analytics is a powerful tool that can be used in a variety of ways to improve business operations and drive growth..

[Audio] One of the challenges of Wert Philippines Inc. is to, how can the company monitor each medical representatives based on their monthly, quarterly and yearly performances. Each medical representative is being measured based on the following: sales target per team: (Figure 1) Operational effectiveness which includes the following Call reached Call volumes Call concentration Marketing program implementation Potential profiling This figure represents the 2023 monthly target per product per medical representatives, this is being issued at the end of the previous year, as basis of their sales target on the following year..

[Audio] The main objective to use data analytics tools and the methods is to resolve the following questions: How to consolidate data provided by different accounts (ex. MDC, TGP, Watson, etc.) and analyze which branch generated more sales and what product contributes to sales? From the consolidated data, how to generate sales per product, per territory and per sales representatives? How to generate target vs actual sales report and analyze forecast? How to analyze product trends per month, quarter and year? How to generate sales incentives based on the criteria set to each medical representative and analyze performances?.

[Audio] APPLICATION OF DATA ANALYTICS Analytic applications are a type of business application software, used to measure and improve the performance of business operations..

[Audio] As the process of analyzing raw data to find trends and answer questions, the definition of data analytics captures its broad scope of the field. However, it includes many techniques with many different goals. This study is designed to answer the 5 stated questions which aims to provide solutions and be able to generate data that will provide accurate result in order to give the correct monthly incentives to all medical representative of the company. The data analytics process has some components that can help a variety of initiatives. By combining these components, a successful data analytics initiative will provide a clear picture of where they are now as compare to their monthly sales target..

[Audio] Sources of Information Key account or Wert customers like Mercury Drug, TGP, Watson, and other drugstore clients provides the monthly extracted report from their system and forwarded the data to Wert Philippines..

[Audio] In this study, sources of information is defined as the primary data given by each of the key account customers, generated from their system and extracted in the following: Mercury Drug - .SP file, also known as simplexety file extension or SignPlot format. A file extension is the set of three or four characters at the end of a filename; in this case, .sp. File extensions tell you what type of file it is, and tell Windows what programs can open it. Windows often associates a default program to each file extension, so that when you double-click the file, the program launches automatically. A .sp file extension can be open using excel application..

[Audio] 2. TGP, WATSON, SOUTH START, ONCO CARE - .xlsx file format Microsoft Excel provides several means and ways to analyze and interpret data. The data can be from various sources. The data can be converted and formatted in several ways. It can be analyzed with the relevant Excel commands, functions and tools - encompassing Conditional Formatting, Ranges, Tables, Text functions, Date functions, Time functions, Financial functions, Subtotals, Quick Analysis, Formula Auditing, Inquire Tool, What-if Analysis, Solvers, Data Model, PowerPivot, PowerView, PowerMap, etc.

[Audio] SAP and iDox's – extracted data from .SQL file SQL (Structured Query Language) is a programming language designed for managing data in a relational database. It's been around since the 1970s and is the most common method of accessing data in databases today. SQL has a variety of functions that allow its users to read, manipulate, and change data. SQL is great for performing the types of aggregations that you might normally do in an Excel pivot table..

[Audio] Thanks you listening, Mr. Christian Bumatay will continue our report..