Introduction

KPiSync is a Mobile Application to help users "Visualize your Key Business Metrics on any device in real time". The CONNX KPiSync solution was designed with the purpose of providing users with a quick and easy method of delivering Key Performance Indicators from all facets of a business to users via a smart phone or tablet. The KPiSync solution will report key performance indicators from any business server to a mobile device (Windows 8 Phone or Tablet, an iOS Phone or Tablet, and others).  There are three components to the CONNX KPiSync solution, the Administrator, the Store Application and the Mobile Application.  The Store and Mobile Applications display key performance indicators to the user that is sent from the administrator server.  

 

A sample business use case for the CONNX KPiSync application for reporting sales key performance indicators (using the CONNX Sample data):  

Company A has just launched a product called "Steeleye Stout" and the head of marketing wants to track the sales growth in real-time.  Using the KPiSync Administrator a key performance indicator is created, {the SQL for the performance indicator is a SUM of all the quantities from all the orders of that product.  "SELECT SUM(PRODUCTQUANTITY) FROM Orders_sqlserver WHERE PRODUCTID=35"} This SQL statement returns the total amount of the new product that has been ordered.  Then the KPiSync administrator gives the key performance indicator a description so the user knows what the number represents and also puts in target levels for the sales so a user can quickly determine the growth or drop in sales based on the color coding used on the Key Performance indicator.  Once the key performance indicator is created it can be scheduled to execute on an interval and sent to all users.

 

A user of a Windows 8 phone or tablet, that has downloaded the CONNX KPiSync app and logged in will start receiving key performance indicators.  Once logged in, the mobile device will contact the server and pull the key performance indicators that are assigned to that user.  The KPiSync App will then display the data graphically to the user and color code the result based on the targets set initially.  When the replication server has a new key performance indicator or an update, it will send a message to all the devices that are logged in.  This notification is displayed to the user(s) and the new key performance indicator will be automatically downloaded and displayed to the user.  Any time the user wants to stop receiving notifications, they just log out and the next time they log in they will get the latest key performance indicators.