Introduction

It is a report for a pharmaceutical company called Forggith Pharmaceuticals. Forggith Pharmaceuticals (Forggith) is a Pharmaceutical Manufacturing company based in Germany. As a manufacturing company, they produce medical drugs that get to consumers through their distributors. This project is to analyze and derive insights into the performance of different sectors by various categories and time periods. It is to help the Sales Representatives track their performances throughout the period to plan their marketing activities. It is also to assist the Team Managers in tracking their teams' performances throughout the periods to plan their teams' activities, and it is also for the Executive team to use to be able to track revenue numbers to monitor alignment with the set targets to influence medium- to long-term strategies.

Problem Statement

Sales Performance Overview (Sliced by: Year, Month, Quarter, Team)

• Total Revenue

• Total Revenue Year To Date (YTD)

• Total Revenue Previous Year YTD

• Total Revenue Same Period Last Year (SPLY)

• Total Target

• Total Target YTD

• Actual Revenue Performance YTD vs Target YTD

• Revenue Month on Month Percentage Change

• Revenue Distribution by Location

• Revenue by Channel

• Revenue by Product Class

Marketing Performance (Slice by Year, Quarter, Month, Product Category and Team)

• Revenue Achieved vs Revenue Target

• Volume Achieved vs Volume Target

• Actual Revenue by Sales Representative

• Target Revenue Achievement % by Sales Representative

• Actual Volume by Sales Representative

• Target Volume Achievement by Sales Representative

• Actual Revenue Achievement by Sales Team

• Revenue and Volume Achievement by Product

Visualization

The report comprises of 3 pages:

1. Overview (Home)

2. Sales Report

3. Marketing Report