Revenue Analysis Dashboard for Medical Device Company

Based on raw data provided from one the leading medical device company, we developed periodic business reports to calculate various KPIs that includes volume, revenue, YTD sales etc. Comparison charts were created based on various time period.

Finally all these analysis are used to generate a presentation report. The data in the tool was refreshed monthly.

1. Monthly based report was prepared for Medtronics E-shop
2. Acquisition of revenue by channels such as Email/Phone/E-shop/Fax
3. Analysis of YTD sales, products and regions
3.Generating Excel embedded charts in ppt.