Head Office Analytics

Scenario:

A Group would like to aggregate information from their stores in realtime for the purpose of analyzing sales and inventory numbers.

Requirements:

• Sales and Inventory Data

• Real-Time

• Multiple POS Systems

• Stores have a variety of product SKU’s so the data can be messy

Approach:

• Utilize the RetailTransaction Message set and the Inventory Message Set

• Have each of the POS systems integrated into DataSync

  • This requires each pharmacy to log onto the PharmX portal and accept into a data-sharing agreement

  • Each pharmacy needs to agree to share Retail and Inventory data with the Head Office

• Setup a SQL Server Database at the head office

• Connect to the Azure Service Bus deserialize the messages, and insert them into a database

Topology:

Process:

• Once the datasharing agreement is complete, the head office will start recieving real-time messages each time a sale (e.g. POS or website sale) or inventory adjustment happens (e.g. recieving a new order from a supplier or completing a stock adjustment post-stocktake)

• These messages are in a rich-object format (see catalog), they will need to be converted into a relational format (if using a relational database) for persistence. PharmX can provide some assistance here, as we do have some templates to help speed up the process.

Potential Issues:

• In order to enrich some of the data being recieved, we would recommend subscribing to the CIS data specifically: Products, Prices, Promotions and Places. This will allow you to lookup and match fields based on the data that you recieve.