As BI products and services increasing, the cost for collecting data and storing data is reclined. Enterprises could get the data source from customer transactions, website logs and product reviews. BI technology is used in many fields, such as in manufacturing for order shipment and customer support, in financial services for claims analysis and fraud detection, in transportation for fleet management, in retail for user profiling to target grocery coupons during checkout, in utilities for power usage analysis, and health care for outcomes analysis. The profession of pharmacy will be more reliant upon the information that can be extracted from data analytics and BI tools. There is a great opportunity in pharmacy to develop an analytical platform to suit both business needs in retail and the delivery of patient care in pharmacy. This paper proposes a analytical platform to identify valuable interventions in retail pharmacies.