Doctors Potentiality Project

full project done in 3 months in a good reputable pharmaceutical company in Egypt.

any pharmaceutical company gets many benefits from such projects like this as:

fine tuning for each doctors' list

accurate classification for all doctors

get the descending order of doctors for each item separately

each rep faces the real number of prescriptions written by each doctor in his list

This project should be updated at the end of each year to update the data regularly.

تجميعه حوالي 80 شيت بفورمات مختلف مع اصلاح المشاكل اللي في كل شيت.

PIVOT and Power PIVOT tables were used in this project.