This Sales Data Capturing and Sales BI Portal was implemented for one of the leading Foods and Beverages giant in India; a part of leading MNC. The company has various franchisee which are spread all across India and solutions was implemented to capturing sales data from various franchisee, validate the data at head office and then generate various BI reports. SharePoint Workflow allowed user to collaborate in capturing, vetting and approval of sales data. SQL Reporting Services Web part for BI reporting and Dashboard along with Excel Integrated reporting services were implemented. SharePoint was integrated with SAP to push and pull sales data.