[ Sponsored Links ]

Advertise here »

Displaying sales in real-time

reply to message » post a new message » e-mail to a friend »
Subject:  Displaying sales in real-time
Author:   Alex Chudnovsky:   view profile | all posts by this author | add to favourites
Date:   16:39:15 2 December 2003
 
Martin, a simple and cheap solution is to use Excel's ability to pull data from database and chart it - this would do exactly what you want with expected delay of 2-3 seconds (likely to be less). You can then project this screen to whereever you want it to be.

Proper "real time" solution can update charts a lot more often than that, but unless you are dealing with extremely time sensitive data like exchange rates, share prices OR getting more than 12-18k orders a day (one order every 2-3 sec assuming 10 active hours) than you may find that paying a lot more for specialised fast reporting tool may not bring you many benefits because its the humans interpreting it who are likely to be the bottleneck anyway.

Hope it helps,

regards,

Alex
http://www.majestic12.co.uk
 
« Back to Internet Marketing Forum Previous Thread »  |  Next Thread »
  • Displaying sales in real-time, Martin Wright, 1 Dec 18:14
    My Client is looking for a simple real-time graphical representation of web sales. Their business is very fast moving and fluctuates with promotional activity. Ideally th ...
    • Displaying sales in real-time, Legionaire, 2 Dec 08:52
      Hi, We are in the process of developping such a tool for the UK national measurement laboratory. Maybe we have what you are looking for. If I can be of further assistance, conta ...
    • RE: Displaying sales in real-time, Ashley , 2 Dec 11:32
      Hi Martin Could you not use one of the real-time analytics solutions and just beam up the sales funnel onto the wall? I believe products like Hitbox (WebSideStory) could do t ...
      • RE: Displaying sales in real-time, Martin Wright, 2 Dec 22:16
        Thanks Ashley I will talk to them. Martin On 11:32:26 2 December 2003 Ashley wrote: >Hi Martin > >Could you not use one of the real-time analytics solutions >and just beam u ...
    • Displaying sales in real-time, Alex Chudnovsky, 2 Dec 16:39
      Martin, a simple and cheap solution is to use Excel's ability to pull data from database and chart it - this would do exactly what you want with expected delay of 2-3 seconds (like ...
      • Displaying sales in real-time, Martin Wright, 2 Dec 22:15
        Alex thanks for this. I assume you mean writing a macro in Excel to create and update a chart? As it happens this company does generate the volume of sales that would justify a ...
        • Displaying sales in real-time, Alex Chudnovsky, 2 Dec 22:29
          You do not need to actually program macro to retrieve data and create chart - all of that can be handled by Excel itself. There are 3 main parts in this task: 1) get data fro ...
          • Re: Displaying sales in real-time - expensive ways, Alex Chudnovsky, 2 Dec 22:35
            Right, more expensive solution: lots of possibilities here. Your client is probably using some of more or less standard reporting tools such as Business Objects, BRIO, Crystal Repo ...
    • Displaying sales in real-time, tsjerk, 8 Dec 18:12
      Hi Martin, Nedstat can capture sales information (like turnover) and integrate that with other reports online (real-time). It makes it very easy to see how emails/banners and se ...
« Back to Internet Marketing Forum Post a new message »
Subscribe for only €299